python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - export-to-csv

Trouble executing SQLPS or PowerShell from T-SQL script using xp_cmdshell

I had originally created a set of scripts to extract the results from a system of dynamic queries to CSV using SQLCMD. However, due to large text fields in the datasets containing a large amount of fo...
test-img

Tom

sql-server

powershell

tsql

export-to-csv

sqlps

Votes: 0

Answers: 1

Latest Answer

Well, after much research into my crazy process, which I should definitely rewrite to be a PowerShell script (and not use xp_cmdshell), I found the solution, which is to escape the " (double-quo...
test-img

Tom

How do I export my django model into custom csv?

I have a Django app in which I maintain products for a webshop. Since many products have multiple variations and working in Excel is not optimal, I thought Python could help me and make the work easie...
test-img

sokolata

python

django

export-to-csv

django-excel

Votes: 0

Answers: 2

Latest Answer

As I understand correctly you have to generate CSV file from Django database values? To be able reproduce code without real Django model I created Item that has same fields as your model. CSV generati...
test-img

rzlvmp

List Response Group agent participation from csv file

I`m trying to import a csv list of skype for business on-prem users and to run the "Get-CsRgsAgentGroup | Where {$_.AgentsByUri -Like “risual.user” | FT Name" command for each user in the cs...
test-img

ADK

powershell

foreach

export-to-csv

Votes: 0

Answers: 1

Latest Answer

If finally worked... See the edit below: $users = import-csv -Path "C:\Users\<MY_USER>\Desktop\Users.csv" -Delimiter '~' foreach ($user in $users) { $user=$user.User $csuser= 'sip:...
test-img

ADK

How to efficiently export 3 million documents from MongoDB Atlas collection to CSV file using NodeJS

we have a collection in MongoDB Atlas with 3 million documents and using NodeJS we need to export them to CSV. We cannot use MONGOEXPORT or MONGODUMP, it is a process that must be developed as an API....
test-img

Alejandro XPi

node.js

mongodb

performance

csv

export-to-csv

Votes: 0

Answers: 1

Latest Answer

I personally would NEVER recommend using .toArray() to query an indefinite/very large no. of documents, as you're asking nodejs to fetch 3milllion documents from your db and store the whole thing in o...
test-img

Anuj Pancholi

Posts

Questions

Blogs

Jobs