Export an array in csv from MongoDB

Question

I'm exporting documents of collection called team in MongoDB as csv file. For example I have this MongoDB document:

{
    "_id" : "149",
    "official_name" : "yaChAaoiqn",
    "common_name" : "VMlEXjTOZE",
    "country" : "YSpbYyPWSo",
    "championship" : "rwSbupqsln",
    "uniform" : [ 
        "first_colour", 
        "second_colour", 
        "third_colour"
    ]
}

I use the following command to export documents in csv:

Z:\Program Files\MongoDB\Server\3.0\bin>mongoexport --db paul --collection team
--type=csv --fields _id,official_name,common_name,country,championship,"uniform[0]","uniform[1]","uniform[2]" --out "C:\path\to\outputFile\output.csv"

This is the csv I have in output:

_id,official_name,common_name,country,championship,uniform[0],uniform[1],uniform[2]
149,yaChAaoiqn,VMlEXjTOZE,YSpbYyPWSo,rwSbupqsln,"","",""

The csv file tells me there are some problems with uniform.
How must I set the uniform field in the command to export from MongoDB rightly an array?

Please look at this post: stackoverflow.com/questions/26378769/… — user2941651
– user2941651, Commented Aug 17, 2015 at 20:30

robjwilkins · Accepted Answer · 2015-08-17 20:17:08Z

2

I dont think this is currently possible. I think your best bet is to use the uniform field without referring to the element index. All values from the array will then be written to the csv file, and you could correctly reformat them post-export.

mongoexport --db paul --collection team --type=csv --fields _id,official_name,common_name,country,championship,uniform --out "C:\path\to\outputFile\output.csv"

answered Aug 17, 2015 at 20:17

robjwilkins

5,7127 gold badges48 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

harry-potter Over a year ago

Ok, I wrote a java program to change that portion of csv file. Thank you

Collectives™ on Stack Overflow

Export an array in csv from MongoDB

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related