Import CSV with semicolon separator into MongoDB database

Question

I've just try to import a CSV file (with semicolon ; separator) into a MongoDB database. I managed import with mongoimport -d mydb -c things --type csv --file files.csv --headerline but the result is not what I'm expecting. The files have that form:

And I get the following result:

But I want to have something like:

{

   "_id": ObjectId("57b6e2654bf4a357b679305"),

   "geom_x_y" : "48.87792844925 , 2.3664591564",

   "circonfere" : "25.0",

   "adresse" : "PARIS 10E ARRDT - QUAI DE JEMMAPES",

   "hauteurnm" : "5.0",

   "espece" : "Acer platanoides",

   "varieteouc" : "'Schwedleri'",

   "dateplanta" : "31/12/2014"

}

Answer 1

mongoimport unfortunately doesn't allow you to specify your separator character. But it does work automatically with tabs as well as commas. If you know you won't ever have tabs in your input, you could replace all semicolons with tabs and that should then import correctly.

tr ";" "\t" < file.csv | mongoimport --type tsv ...