Insert json file in mongodb

Question

I am new to mongodb. After installing mongodb on windows, I try to insert a simple json file using the following command:

C:\>mongodb\bin\mongoimport --db test --collection docs < example2.json 

I get the following error:

 connected to: 127.0.0.1 Fri Oct 18 09:05:43.749 exception:BSON representation of supplied JSON is too large: code FailedToParse: FailedToParse: Field name expected: offset:43 Fri Oct 18 09:05:43.750 Fri Oct 18 09:05:43.750 exception:BSON representation of supplied JSON is too large: code FailedToParse: FailedToParse: Expecting '{': offset:0 Fri Oct 18 09:05:43.751 Fri Oct 18 09:05:43.751 exception:BSON representation of supplied JSON is too large: code FailedToParse: FailedToParse: Field name expected: offset:42 Fri Oct 18 09:05:43.751 Fri Oct 18 09:05:43.751 exception:BSON representation of supplied JSON is too large: code FailedToParse: FailedToParse: Expecting '{': offset:0 Fri Oct 18 09:05:43.751 Fri Oct 18 09:05:43.752 exception:BSON representation of supplied JSON is too large: code FailedToParse: FailedToParse: Field name expected: offset:44 Fri Oct 18 09:05:43.752 Fri Oct 18 09:05:43.752 exception:BSON representation of supplied JSON is too large: code FailedToParse: FailedToParse: Expecting '{': offset:0 Fri Oct 18 09:05:43.752 Fri Oct 18 09:05:43.752 check 0 0 Fri Oct 18 09:05:43.752 imported 0 objects Fri Oct 18 09:05:43.752 ERROR: encountered 6 error(s)s 

---

example2.file

 {"FirstName": "Bruce", "LastName": "Wayne", "Email": "[e-mail]"} {"FirstName": "Lucius", "LastName": "Fox", "Email": "[e-mail]"} {"FirstName": "Dick", "LastName": "Grayson", "Email": "[e-mail]"} 

---

What do i need to do to import a new json file into mongodb?

Answer 1

Use

 mongoimport --jsonArray --db test --collection docs --file example2.json 

It is probably ruined due to newline characters.

Answer 2

The below team worked for me

 mongoimport --db test --collection docs --file example2.json 

when I removed the extra newline before the Email attribute in each of the documents.

example2.json

 {"FirstName": "Bruce", "LastName": "Wayne", "Email": "[e-mail]"} {"FirstName": "Lucius", "LastName": "Fox", "Email": "[e-mail]"} {"FirstName": "Dick", "LastName": "Grayson", "Email": "[e-mail]"} 

Answer 3

This worked for me - (from mongo shell)

 var file = cat('./new.json'); # file name use testdb # db name var o = JSON.parse(file); # convert string to JSON db.forms.insert(o) # collection name 

Answer 4

Use the command below when importing a JSON file

 C:\>mongodb\bin\mongoimport --jsonArray -d test -c docs --file example2.json 

Answer 5

 mongoimport --jsonArray -d DatabaseN -c collectionName /filePath/filename.json 

Answer 6

The following two methods work well:

 C:\>mongodb\bin\mongoimport --jsonArray -d test -c docs --file example2.json C:\>mongodb\bin\mongoimport --jsonArray -d test -c docs < example2.json 

if the collections belong to a specific user, you can use -u -p --authenticationDatabase

Answer 7

On MS Windows, the mongoimport command should be run on a regular Windows command line, and not on the mongodb command line.

Answer 8

It happened to me a couple of weeks ago. The mongoimport version was too old. After I upgraded to the latest version, it successfully completed and imported all the documents.

Link: http://docs.mongodb.org/master/tutorial/install-mongodb-on-ubuntu/?_ga=1.11365492.1588529687.1434379875

Answer 9

This solution is applicable to a Windows machine.

1. MongoDB needs a data directory to store data. The default path is C:\data\db . If you do not have a data directory, create it on the C: drive. (PS: data \ db means that inside the directory 'data' there is a directory named 'db')

2. Put the json you want to import into this path: C:\data\db\ .

3. Open a command prompt and enter the following command

   mongoimport --db databaseName --collections collectionName --file fileName.json --type json --batchSize 1

Here

• database_name: the name of your database
• collectionName: the name of your collection
• fileName: the name of your JSON file, which is located in the path C: \ data \ db
• batchSize can be any integer as you wish

Answer 10

In MongoDB Insert Json array data from a file (from a specific location on the system / PC) using the mongo shell command. When executing the command below, it should be on one line.

var file = cat ('I: /data/db/card_type_authorization.json'); var o = JSON.parse (file); db.CARD_TYPE_AUTHORIZATION.insert (o);

JSON file: card_type_authorization.json

 [{ "code": "visa", "position": 1, "description": "Visa", "isVertualCard": false, "comments": "" },{ "code": "mastercard", "position": 2, "description": "Mastercard", "isVertualCard": false, "comments": "" }]