How to use mongoimport to import csv

by

Your example worked for me with MongoDB 1.6.3 and 1.7.3. Example below was for 1.7.3. Are you using an older version of MongoDB?

$ 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 }

More Related Contents:

  1. How to use mongoimport to import CSV files?
  2. import csv file to sql database in c# window application without header row [duplicate]
  3. Importing CSV data using PHP/MySQL
  4. How to import load a .sql or .csv file into SQLite?
  5. Import .csv file to Sqlite in Android
  6. Mongoimport of JSON file
  7. What’s the difference between findAndModify and update in MongoDB?
  8. Populate Android Database From CSV file?
  9. Count array elements that matches condition
  10. How can I import a .sql file into my Heroku postgres database?
  11. Storing Images in DB – Yea or Nay?
  12. What is the best place for storing uploaded images, SQL database or disk file system? [closed]
  13. Can we update primary key values of a table?
  14. How do I output the results of a HiveQL query to CSV?
  15. Where does mongodb stand in the CAP theorem?
  16. Import SQL dump into PostgreSQL database
  17. Can I do transactions and locks in CouchDB?
  18. Elasticsearch query to return all records
  19. How to login and authenticate to Postgresql after a fresh install?
  20. What are the differences between B trees and B+ trees?
  21. What is the default Precision and Scale for a Number in Oracle?
  22. What is caching?
  23. How to make a UUID in DynamoDB?
  24. What is the difference between id and _id in mongoose?
  25. SQL DataType – How to store a year?
  26. Maximum number of rows in a sqlite table
  27. Process very big csv file without timeout and memory error
  28. Any example of a necessary nullable foreign key?
  29. How to return only value of a field in mongodb
  30. Mysql service won’t start, InnoDB init function error

Leave a Comment