how to import json file in mongodb?

Question

While creating an application in which data is stored as a JSON file, I need it to be imported into MongoDB. I tried to use the following command but got the error --> Failure parsing josn near: } my command is:

mongoimport -d mydb -c mydb --type json --file glossary.json --headerline

My file is located in C:\mongodb\bin\glossary.json.
Here is the content of my file:

{
    "glossary": {
        "title": "example glossary",
        "GlossDiv": {
            "title": "S",
            "GlossList": {
                "GlossEntry": {
                    "ID": "SGML",
                    "SortAs": "SGML",
                    "GlossTerm": "Standard Generalized Markup Language",
                    "Acronym": "SGML",
                    "Abbrev": "ISO 8879:1986",
                    "GlossDef": {
                        "para": "A meta-markup language, used to create markup languages such as DocBook.",
                        "GlossSeeAlso": ["GML", "XML"]
                    },
                    "GlossSee": "markup"
                }
            }
        }
    }
    }

s.d · Accepted Answer · 2016-03-14 11:27:41Z

29

Your JSON seems to have only a single object. Format like {..},{..} is expected.

So, use --jsonArray option:

 mongoimport -d mydb -c mycollection --jsonArray < glossary.json

The other option is to format the source document as mongodb expects it to be. This will make loading much faster.

edited Mar 14, 2016 at 11:27

answered Aug 25, 2013 at 6:09

s.d

29.4k3 gold badges82 silver badges133 bronze badges

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

3 Comments

s.d Over a year ago

@user2511142 I used --jsonArray option, it worked for your file. Updated in answer.

arglee Over a year ago

can you please tell me what is the way to see imported json file's data ?

s.d Over a year ago

@user2511142 open mongo shell, run use mydb, then db.mycollection.find().pretty().

teo van kot · Accepted Answer · 2015-02-01 14:35:16Z

6

If you have a large collection, --jsonArray takes a very long time to import. I was getting about 10 documents/second. If you have a properly formatted .json file you can just use --file instead. I'm getting about 6000 documents/second now.

Good thing I didn't settle for the first option!

edited Feb 1, 2015 at 14:35

teo van kot

12.5k10 gold badges41 silver badges73 bronze badges

answered Feb 1, 2015 at 13:10

Jas

83413 silver badges23 bronze badges

3 Comments

Gustavo Basso Over a year ago

what is the "properly formatted .json file"? Can you reference or show an example, please?

Jas Over a year ago

this has been quite a while, but I think I was just referencing something that is valid json - so maybe try pasting your json text somewhere like here: jsonlint.com to verify its correct

Dylan Smith Over a year ago

The file may need to be formatted with a single json object per line (as in, all of it on the same line, not spread over several lines). I have also seen some comments that there can be no white space. So this is well formatted: {"foo":"bar"} But this is not: { "foo" : "bat" }

Collectives™ on Stack Overflow

how to import json file in mongodb?

2 Answers 2

3 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related