Insert json file into mongodb

Question

I am new to MongoDB  After installing MongoDB in Windows I am trying to insert a simple json file using the following command   C   gt mongodb bin mongoimport --db test --collection docs  lt  example2 json   I am getting 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 json    FirstName    Bruce    LastName    Wayne     Email    bwayne Wayneenterprises com     FirstName    Lucius    LastName    Fox     Email    lfox Wayneenterprises com     FirstName    Dick    LastName    Grayson     Email    dgrayson Wayneenterprises com       What do I need to do to import new json file into mongodb

User · Answer

Open command prompt separately and check   C  mongodb bin mongoimport --db db name --collection collection name lt  filename json

User · Answer

Use   mongoimport --jsonArray --db test --collection docs --file example2 json   Its probably messing up because of the newline characters

User · Answer

Below command worked for me mongoimport --db test --collection docs --file example2 json  when i removed the extra newline character before Email attribute in each of the documents  example2 json   quot FirstName quot    quot Bruce quot    quot LastName quot    quot Wayne quot    quot Email quot    quot bwayne Wayneenterprises com quot     quot FirstName quot    quot Lucius quot    quot LastName quot    quot Fox quot    quot Email quot    quot lfox Wayneenterprises com quot     quot FirstName quot    quot Dick quot    quot LastName quot    quot Grayson quot    quot Email quot    quot dgrayson Wayneenterprises com quot

User · Answer

This solution is applicable for Windows machine     MongoDB needs data directory to store data  Default path is C  data db  In case you don t have the data directory  create one in your C  drive   P S   data db means there is a directory named  db  inside the directory  data   Place the json you want to import in this path  C  data db    Open the command prompt and type the following command  mongoimport --db databaseName --collections collectionName --file fileName json --type json --batchSize 1   Here     databaseName   your database name collectionName  your collection name fileName  name of your json file which is in the path C  data db batchSize can be any integer as per your wish

User · Answer

In MongoDB To insert Json array data from file from particular location from a system   pc  using mongo shell command  While executing below command  command should be in single 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

User · Answer

the following two ways work well   C   gt mongodb bin mongoimport --jsonArray -d test -c docs --file example2 json C   gt mongodb bin mongoimport --jsonArray -d test -c docs  lt  example2 json   if the collections are under a specific user  you can use -u -p --authenticationDatabase

User · Answer

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

User · Answer

Use below command while importing JSON file  C   gt mongodb bin mongoimport --jsonArray -d test -c docs --file example2 json

User · Answer

It happened to me couple of weeks back  The version of mongoimport was too old  Once i Updated to latest version it ran successfully and imported all documents   Reference  http   docs mongodb org master tutorial install-mongodb-on-ubuntu   ga 1 11365492 1588529687 1434379875

User · Answer

In MS Windows  the mongoimport command has to be run in a normal Windows command prompt  not from the mongodb command prompt

User · Answer

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

[mongodb] Insert json file into mongodb

Examples related to mongodb