mongoexport --fields --csv will only output the first field when working with subdocuments

mongodb mongoexport
Cilvic picture Cilvic · Sep 22, 2013 · Viewed 17.3k times · Source

Working:

 .\mongoexport.exe --db mydb --collection slideproof_user_event_date_count --csv --out 
events.csv --fields '_id,first_day'
 .\mongoexport.exe --db mydb --collection slideproof_user_event_date_count --out 
events.json --fields '_id._p,first_day'

Not working (only first field/column has content) written, :

 .\mongoexport.exe --db mydb --collection slideproof_user_event_date_count --csv --out 
events.csv --fields '_id._p, first_day'

How can I enable correct output for .csv with subdocument fields?

Answer

Cilvic picture Cilvic · Sep 22, 2013

The solution is to avoid spaces in the --fields argument:

this works: 

--fields '_id._p,value.count'

This does not:

--fields '_id._p, value.count'

Related questions

mongoexport aggregate export to a csv file

I want to save the result from an aggregation into a csv file. Using the mongo cmd line tool I can do this to get the results I want: db.compras.aggregate({ $group : { _id : "$data.proponente", total : { $sum : "$price" } }} How …

Read More
MongoDB - can't get data exported with mongoexport due to auth failed

I have a Mongo DB database and I trying to export couple "records" from one of the collections present in this database. Here is the command I am trying to use and the error I am getting: mongoexport --collection my_…

Read More
MongoDB - mongoexport all objects in nested array

I'm using MongoDB version 2.6.x. And I need to export documents from a specific collection. mongoexport is the tool which serves the need. However, I do not know how to export all the objects under a nested array. Below is …

Read More