Parse and import json files into mongodb

Question

I have some json files formatted in the following way

{
  <collection_name> : [
    {object}, 
    {object}
  ]
}

Is there any mongo script I can use to import this kind of files or a preparsing to pass in the correct format to mongoimport?

Update: Using philshem's command line my input gives me the following error:

exception:BSON representation of supplied JSON array is too large: code FailedToParse: FailedToParse: Date expecting integer milliseconds: offset:264

The date in question is

"uploadDate": {
  "$date": "2015-02-17T10:36:34.881Z"
}

Community · Accepted Answer · 2017-05-23 11:45:48Z

4

The standard import line is:

mongoimport --db dbName --collection collectionName --file fileName.json

For an array of json objects, add this flag:

--jsonArray

If you tried this and it didn't work, please edit your question to include the error message.

Update: Based on the error message, check out this question/answer and this documentation.

CommunityBot

11 silver badge

answered Apr 13, 2015 at 11:22

philshem

25.5k8 gold badges67 silver badges136 bronze badges

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

Comments

Donald Duck is with Ukraine · Accepted Answer · 2017-01-23 13:06:25Z

0

You need to explicitly de format of date

Try this:

"uploadDate": {
  "$date": **ISODate(**"2015-02-17T10:36:34.881Z"**)**
}

9,00223 gold badges82 silver badges106 bronze badges

answered Jan 23, 2017 at 12:24

Jhonatan

918 bronze badges