How to use mongoimport to import csv

Question

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 -c things --type csv --file locations.csv --headerline

Trace says imported 1 objects, but firing up the Mongo shell and running db.things.find() doesn't show any new documents.

What am I missing?

Answer 1

By following the way you can use mongoimport to import 

csv$ cat > locations.csv 

Name,Address,City,State,ZIP 

Jane Doe,123 Main St,Whereverville,CA,90210 

John Doe,555 Broadway Ave,New York,NY,10010 

Ctrl-d

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

connected to: 127.0.0.1 

imported 3 objects 

$ mongo MongoDB shell version: 1.7.3 

connecting to: test 

> use mydb 

switched to db mydb 

> db.things.find() 

{ "_id" : ObjectId("4d32a36ed63d057130c08fca"), "Name" : "Jane Doe", "Address" : "123 Main St", "City" : "Whereverville", "State" : "CA", "ZIP" : 90210 } 

{ "_id" : ObjectId("4d32a36ed63d057130c08fcb"), "Name" : "John Doe", "Address" : "555 Broadway Ave", "City" : "New York", "State" : "NY", "ZIP" : 10010 }