Import csv to mogodb collection- Invalid UTF-8 character detected

Asked Jul 30 '15 at 01:21

Active Jul 30 '15 at 01:21

Viewed 857 times

I am trying to import csv file into mongodb collections by following command

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

it is giving

exception:Invalid UTF8 character detected

command file locations.csv is showing ASCII character with CR lines i have tried

iconv -f ASCII -t utf8 -c locations.csv

to remove invalid character but getting the same error in importing the file

asked Jul 30 '15 at 01:21

Ammar Hayder Khan

could you check if this helps?? iconv -f ISO-8859-1 -t utf8 -c locations.csv – anish Jul 30 '15 at 02:12
i have tried..not helpful – Ammar Hayder Khan Jul 30 '15 at 02:36
Ammar - Are you able to resolved this error? Regards, neha – PAA Sep 16 '15 at 18:04

0 Answers0