包含联系方式的CSV文件:
Name,Address,City,State,ZIP
Jane Doe,123 Main St,Whereverville,CA,90210
John Doe,555 Broadway Ave,New York,NY,10010
运行这个不会向数据库添加文档:
$ mongoimport -d mydb -c things --type csv --file locations.csv --headerline
Trace说导入了1个对象，但是在MongoDB shell中运行db.things.find()不会显示任何新文档。
我错过了什么?
当前回答
我的需求是导入.csv(没有标题)到远程MongoDB实例。对于mongoimport v3.0.7，以下命令适用于我:
mongoimport -h <host>:<port> -u <db-user> -p <db-password> -d <database-name> -c <collection-name> --file <csv file location> --fields <name of the columns(comma seperated) in csv> --type csv
例如:
mongoimport -h 1234.mlab.com:61486 -u arpitaggarwal -p password -d my-database -c employees --file employees.csv --fields name,email --type csv
下面是导入后的截图:
其中姓名和电子邮件是.csv文件中的列。
其他回答
使用:
mongoimport -d 'database_name' -c 'collection_name' --type csv --headerline --file filepath/file_name.csv
I was perplexed with a similar problem where mongoimport did not give me an error but would report importing 0 records. I had saved my file that didn't work using the OSX Excel for Mac 2011 version using the default "Save as.." "xls as csv" without specifying "Windows Comma Separated(.csv)" format specifically. After researching this site and trying the "Save As again using "Windows Comma Separated (.csv)" format, mongoimport worked fine. I think mongoimport expects a newline character on each line and the default Mac Excel 2011 csv export didn't provide that character at the end of each line.
首先你应该跳出mongo shell，然后像这样执行mongoimport命令:
Manojs-MacBook-Air:bin Aditya$ mongoimport -d marketdata -c minibars
--type csv
--headerline
--file '/Users/Aditya/Downloads/mstf.csv'
2017-05-13T20:00:41.989+0800 connected to: localhost
2017-05-13T20:00:44.123+0800 imported 97609 documents
Manojs-MacBook-Air:bin Aditya$
奇怪的是，没有人提到——uri flag:
mongoimport --uri connectionString -c questions --type csv --file questions.csv --headerline
给定.csv文件，我只有一个列，没有标题，下面的命令对我有用:
mongoimport -h <mongodb-host>:<mongodb-port> -u <username> -p <password> -d <mongodb-database-name> -c <collection-name> --file file.csv --fields <field-name> --type csv
其中field-name指的是.csv文件中列的Header名称。
