mongodb - `fields cannot be identical: ' ' and ' '` mongoimport error -
i'm trying import csv mongodb on local machine. used following commmand shell:
mongoimport -d mydb -c things --type csv --file /users/..../agentsfulloutput.csv --headerline
i following error:
failed: fields cannot identical: '' , ''
i can't find on means. doing wrong? csv file, way, result of mongoexport.
here column headers , data:
_id build_profile company_address company_name company_website created_at device _token downloaded_app email first_name last_name is_proapp modified_at mobile_phone terms_accepted_at license_number broker_id join_unique_url linkedin_profile_id billing_customer_id billing_zip mobile_phone office_phone vendors_count clients_count app_client objectid(52ab245b763f4aec448b6763) 0 california lateral test 2014-01-01t08:19:05.470z test test test 2015-04-18t05:16:37.155z (123) 123-1234 zip (123) 123-1234 10 5 objectid(52b46bfc763f4ad9198b45ab) 7928 test test 2014-01-01t08:19:05.470z jennifer chase 2015-04-15t17:05:17.114z 5551112 jennifer-chase test 7071 22 64
i had exact same issue. opening csv file in excel massage , saving out again. while trying import mongo using "mongoimport" command getting same error message had identical values. checked columns headings on , on make sure there weren't identical values.
i tried re-saving file excel using "windows comma separated (.csv)" option format dropdown menu instead of default "comma separated values (.csv)" found in "common format" section.
worked perfectly.
Comments
Post a Comment