How to define delimeter to import mongodb

mongodb csv mongoimport
Shashika picture Shashika · Nov 25, 2013 · Viewed 11.5k times · Source

I have a data collection, which is separated by | character. I am going to add the data collection to mongodb. So I need to separate data through | character. how my mongoimport command looks like?

Previously, I'm successfully import csv file through the following command.

$ mongoimport -d mydb -c things --type csv --file locations.csv --headerline

Answer

Derick picture Derick · Nov 25, 2013

mongoimport supports either JSON, CSV (comma separated values) or TSV (tab separated values). The | character is not a valid delimiter for either CSV or TSV, so you will need to change your input files' | to , or a tab, and specify --type accordingly.

Related questions

How to use mongoimport to import csv

Trying to import a CSV with contact information: Name,Address,City,State,ZIP Jane Doe,123 Main St,Whereverville,CA,90210 John Doe,555 Broadway Ave,New York,NY,10010 Running this doesn't seem to add any documents to the database: $ mongoimport -d mydb …

Read More
How to import data containing double quotes into mongodb using mongoimport?

I'm using mongoimport to import a csv file. The csv file contains text with imbedded double quotes on the 2nd line. "id","text" "1","This is text" "2","\"This is quoted text\"" This should import as two lines with the 2nd line …

Read More
`fields cannot be identical: ' ' and ' '` mongoimport error

i'm trying to import a csv into mongodb on my local machine. I used the following commmand from the shell: mongoimport -d mydb -c things --type csv --file /Users/..../agentsFullOutput.csv --headerline I get the following error: Failed: fields cannot …

Read More