mongoexport csv output array values
Posted
by
9point6
on Server Fault
See other posts from Server Fault
or by 9point6
Published on 2012-12-18T14:55:03Z
Indexed on
2012/12/19
5:04 UTC
Read the original article
Hit count: 480
I'm using mongoexport to export some collections into CSV files, however when I try to target fields which are members of an array I cannot get it to export correctly.
command I'm using:
mongoexport -d db -c collection -fieldFile fields.txt --csv > out.csv
and the contents of fields.txt is similar to
id
name
address[0].line1
address[0].line2
address[0].city
address[0].country
address[0].postcode
where the BSON data would be:
{
"id": 1,
"name": "example",
"address": [
{
"line1": "flat 123",
"line2": "123 Fake St.",
"city": "London",
"country": "England",
"postcode": "N1 1AA"
}
]
}
what is the correct syntax for exporting the contents of an array?
© Server Fault or respective owner