mongoexport csv输出数组值

我正在使用mongoexport将某些集合导出到CSV文件中,但是当我尝试将作为数组成员的字段作为目标时,我无法正确导出它。

我正在使用的命令:

mongoexport -d db -c collection -fieldFile fields.txt --csv > out.csv 

和fields.txt的内容类似

 id name address[0].line1 address[0].line2 address[0].city address[0].country address[0].postcode 

BSON数据将是:

 { "id": 1, "name": "example", "address": [ { "line1": "flat 123", "line2": "123 Fake St.", "city": "London", "country": "England", "postcode": "N1 1AA" } ] } 

导出数组内容的正确语法是什么?

    你几乎是正确的,试试这个:

     id name address.0.line1 address.0.line2 address.0.city address.0.country address.0.postcode 

    我把你的示例文件插入数据库test收集bar ,然后像这样运行导出:

     ./mongoexport --port 31000 -d test -c bar -fieldFile fields.txt --csv > out.csv 

    然后检查结果,这对我来说很好:

     cat out.csv id,name,address.0.line1,address.0.line2,address.0.city,address.0.country,address.0.postcode 1.0,"example","flat 123","123 Fake St.","London","England","N1 1AA"