Using mongoimport to read CSV into nested structure?

Question

I have a mongo document with a structure like: { "foo": { "bar1": "val1", "bar2": "val2"} } I'd like to import my data from a csv using mongoimport --type csv --headerline [...]

I am not sure how to format the field name in the csv to address the nested structure. For instance:

test.csv:

foo.bar1
example

returns { "_id" : ObjectId("4e9d9d25c5d8708e1f51cdbc"), "foo.bar1" : "example" } instead of the desired output:

{ "_id" : ObjectId("4e9d9d25c5d8708e1f51cdbc"), "foo: {"bar1" : "example"} }

The field name seems to be interpreted as a string regardless of its value. Things like foo[bar1] and foo: {bar1} are also used verbatim.

This may not currently be possible. From this thread: No way to do nesting with csv. Kind of a weird api. Suggestions/patches welcome — Jason Winget
– Jason Winget, Commented Oct 18, 2011 at 17:12

Andrew Nessin · Accepted Answer · 2018-11-22 14:33:23Z

9

This isn't supported in the current (v2.0) version of mongoimport, but it should be coming soon. You can check out the JIRA ticket here, scheduled for v2.1:

Dotted field names should produce nested objects in mongoimport

Until then, if you can translate your CSV data to JSON then you could use mongoimport --type json to import the nested data.

EDIT: This feature is released now, and available from 2.8.0-rc0

edited Nov 22, 2018 at 14:33

Andrew Nessin

1,2952 gold badges15 silver badges27 bronze badges

answered Oct 18, 2011 at 23:35

Chris Fulstow

42k10 gold badges91 silver badges114 bronze badges

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

Comments

Muhammad Tarique · Accepted Answer · 2021-03-10 09:54:10Z

1

You can add a column in CSV like parent_key.array_index.nested_key

CSV data example

JSON object image in mongo db after import

answered Mar 10, 2021 at 9:54

Muhammad Tarique

1,4371 gold badge14 silver badges18 bronze badges

Collectives™ on Stack Overflow

Using mongoimport to read CSV into nested structure?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related