I am having a problem using mongoimport when the data value is a full stop.
It appears the full stop "." is translated to 0 during the insert
Example file
"name","value"
"Hello","."
Import command
mongoimport --db test --collection dottest --type csv --headerline --file world.csv
Result on MongoDB
> db.dottest.find();
It seems like the "." is being treated as two fields, the first having value 0 and the second "e\""
I don't have this problem if I insert from a Mongo session
db.dottest.save(
);
works fine
Or if I use mongoimport and the full stop appears with other text "Hello","Mr." will load fine
- is related to
-
SERVER-1097 mongoimport / export should adhere to CSV spec
- Closed