Export collection in mongodb using shell command

Question

I want to export collection in mongodb using shell command: I try the following command but fields with ":" (number:phone, number:fax) are not exported.

mongoexport --csv -d schemaName -c collectionName -q "{typeName:'user'}" -f "name, surname, e-mail, number:phone, number:fax" -o export.csv

Can you post an example of the document that you're trying to export? — Jenna
– Jenna, Commented Jul 31, 2012 at 14:33
This is the example document. {'path': '/users/sarahperez', 'name':'Sarah', 'surname':'Perez', 'e-mail':'[email protected]','number:phone':'00421236523','number:fax':'004215377853'} {'path': '/users/ericeldon', 'name':'Eric', 'surname':'Eldon', 'e-mail':'[email protected]','number:phone':'00421276823','number:fax':'0042165928725'} @Jenna — turankonan
– turankonan, Commented Jul 31, 2012 at 14:38
Hmm, I think the issue may have to do with the fact that the field name has a colon in it. I can export the fields of an embedded document such as {number: {fax: 123, cell: 345}} using the dot notation. I'll keep investigating. — Jenna
– Jenna, Commented Jul 31, 2012 at 14:52

Gates VP · Accepted Answer · 2012-07-31 16:17:06Z

2

I think that you have found a legitimate bug. The mongoexport tool is rarely used and the colon means something very specific when parsing JSON, so the tool is probably confused.

You can file the bug here: http://jira.mongodb.org/

answered Jul 31, 2012 at 16:17

Gates VP

45.3k11 gold badges108 silver badges108 bronze badges

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

Collectives™ on Stack Overflow

Export collection in mongodb using shell command

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related