Mongoimport of json file

Question

I have a json file consisting of about 2000 records   Each record which will correspond to a document in the mongo database is formatted as follows    jobID  2597401   account  XXXXX   user  YYYYY   pkgT   pgi 7 2-5   libA   libpgc so   flavor   default           startEpoch  1338497979   runTime  1022   execType  user binary   exec   share home 01482 XXXXX appker ranger NPB3 3 1 NPB3 3-MPI bin ft D 64   numNodes  4   sha1  5a79879235aa31b6a46e73b43879428e2a175db5   execEpoch 1336766742  execModify  new Date  Fri May 11 15 05 42 2012    startTime  new Date  Thu May 31 15 59 39 2012    numCores  64   sizeT  bss  1881400168  text  239574  data  22504       Each record is on a single line in the JSON file  and the only line breaks are at the end of every record   Therefore  each line in the document starts with   jobID       I am trying to import these into a mongo database using the following command   mongoimport --db dbName --collection collectionName --file fileName json   However  I get the following error   Sat Mar  2 01 26 12 Assertion  10340 Failure parsing JSON string near   execModif 0x10059f12b 0x100562d5c 0x100562e9c 0x10025eb98 0x10000e643 0x100010b60 0x10055c4cc 0x1000014b7     0x100001454   0   mongoimport                         0x000000010059f12b  ZN5mongo15printStackTraceERSo   43  1   mongoimport                         0x0000000100562d5c  ZN5mongo11msgassertedEiPKc   204  2   mongoimport                         0x0000000100562e9c  ZN5mongo11msgassertedEiRKSs   12  3   mongoimport                         0x000000010025eb98  ZN5mongo8fromjsonEPKcPi   1576  4   mongoimport                         0x000000010000e643                                                     ZN6Import8parseRowEPSiRN5mongo7BSONObjERi   2739  5   mongoimport                         0x0000000100010b60  ZN6Import3runEv   7376  6   mongoimport                         0x000000010055c4cc  ZN5mongo4Tool4mainEiPPc   5436  7   mongoimport                         0x00000001000014b7 main   55  8   mongoimport                         0x0000000100001454 start   52 Sat Mar  2 01 26 12 exception BSON representation of supplied JSON is too large  Failure parsing         JSON string near   execModif Sat Mar  2 01 26 12  Sat Mar  2 01 26 12 imported 0 objects Sat Mar  2 01 26 12 ERROR  encountered 1941 errors   I do not know what the problem is  Can someone recommend a solution

User · Answer

A bit late for probable answer  might help new people  In case you have multiple instances of database   mongoimport --host  lt host name gt   lt host port gt  --db  lt database name gt  --collection  lt collection name gt   --file  lt path to dump file gt  -u  lt my user gt  -p  lt my pass gt    Assuming credentials needed  otherwise remove this option

User · Answer

If you try to export this test collection    gt  db test find       id    ObjectId  5131c2bbfcb94ddb2549d501     field     Sat Mar 02 2013 13 13 31 GMT 0400      id    ObjectId  5131c2d8fcb94ddb2549d502     field    ISODate  2012-05-31T11 59 39Z      with mongoexport  the first date created with Date      and the second one created with new Date       if use ISODate      will be the same as in the second line   so mongoexport output will be looks like this       id        oid     5131c2bbfcb94ddb2549d501      field     Sat Mar 02 2013 13 13 31 GMT 0400        id        oid     5131c2d8fcb94ddb2549d502      field        date    1338465579000       So you should use the same notation  because strict JSON doesn t have type Date   lt date gt      Also your JSON is not valid  all fields name must be enclosed in double quotes  but mongoimport works fine without them   You can find additional information in mongodb documentation and here

User · Answer

this will work      mongoimport --db databaseName --collection collectionName --file filePath jsonFile json   2021-01-09T11 13 57 410 0530    connected to  mongodb   localhost  2021-01-09T11 13 58 176 0530    1 document s  imported successfully  0 document s  failed to import   Above I shared the query along with its response

User · Answer

Your syntax appears completely correct in     mongoimport --db dbName --collection collectionName --file fileName json   Make sure you are in the correct folder or provide the full path

User · Answer

Solution -  mongoimport --db databaseName --collection tableName --file filepath json   Example -   Place your file in admin folder -  C  Users admin tourdb places json   Run this command on your teminal -  mongoimport --db tourdb --collection places --file   tourdb places json   Output -  admin admin-PC MINGW64     mongoimport --db tourdb --collection places --file   tourdb places json 2019-08-26T14 30 09 350 0530 connected to  localhost 2019-08-26T14 30 09 447 0530 imported 10 documents   For more link

User · Answer

Using mongoimport you can able to achieve the same  mongoimport --db test --collection user --drop --file   downloads user json   where    test - Database name user - collection name user json - dataset file   --drop is drop the collection if already exist

User · Answer

console   mongoimport -d dbName -c collectionName dataFile js

User · Answer

In windows you can use your Command Prompcmd  cmd   in Ubuntu you can use your terminal by typing the following command   mongoimport  -d  your database name  -c  your collection name   path to json file json file name json   then when you open your mongo shell  you will find to check  your database name when running this command   show databases

User · Answer

I was able to fix the error using the following query   mongoimport --db dbName --collection collectionName --file fileName json --jsonArray   Hopefully this is helpful to someone

User · Answer

I have used below command for export DB  mongodump --db database name --collection collection name   and below command worked for me to import DB  mongorestore --db database name path to bson file

User · Answer

This works with me when db with usrname and password  mongoimport --db YOUR DB --collection MyCollection --file  your path my json file json -u my user -p my pass   db without username password please remove -u my user -p my pass  My sample json           id    ObjectId  5d11c815eb946a412ecd677d          empid    NumberInt 1         name     Rahul             id    ObjectId  5d11c815eb946a412ecd677e          empid    NumberInt 2         name     Rahul

User · Answer

This command works where no collection is specified    mongoimport --db zips   MongoDB 2 6 Standard mongodb zips json    Mongo shell after executing the command  connected to  127 0 0 1 no collection specified  using filename  zips  as collection  2014-09-16T13 56 07 147-0400 check 9 29353 2014-09-16T13 56 07 148-0400 imported 29353 objects

User · Answer

Run the import command in another terminal   not inside mongo shell    mongoimport --db test --collection user --drop --file   downloads user json

User · Answer

Import JSON CSV file in MongoDB  wait wait first check mongoimport exe file in your bin folder C  Program Files MongoDB Server 4 4 bin  if it is not then download mongodb database tools https   www mongodb com try download database-tools  copy extracted unzip  files inside unzipped bin  to bin folder C  Program Files MongoDB Server 4 4 bin  copy your json file to bin folder C  Program Files MongoDB Server 4 4 bin  Now open your commond prompt change its directory to bin  cd  quot C  Program Files MongoDB Server 4 4 bin quot    Now copy this on your commnad prompt  mongoimport -d tymongo -c test --type json --file restaurants json   where d- database tymongo-database name   c-collection test-collection name   FOR CSV FILE  mongoimport -d tymongo -c test --type csv --file database2 csv --headerline

User · Answer

Number of answer have been given even though I would like to give mine command   I used to frequently  It may help to someone   mongoimport original json -d databaseName -c yourcollectionName --jsonArray --drop

User · Answer

try this    mongoimport --db dbName --collection collectionName  lt fileName json   Example   mongoimport --db foo --collection myCollections  lt   Users file json connected to          Sat Mar  2 15 01 08 imported 11 objects   Issue is because of you date format    I used same JSON with modified date as below and it worked    jobID  2597401   account  XXXXX   user  YYYYY   pkgT   pgi 7 2-5   libA   libpgc so   flavor   default           startEpoch  1338497979   runTime  1022   execType  user binary   exec   share home 01482 XXXXX appker ranger NPB3 3 1 NPB3 3-MPI bin ft D 64   numNodes  4   sha1  5a79879235aa31b6a46e73b43879428e2a175db5   execEpoch 1336766742  execModify    date    1343779200000   startTime    date    1343779200000   numCores  64   sizeT  bss  1881400168  text  239574  data  22504      hope this helps

User · Answer

I tried something like this and it actually works   mongoimport --db dbName --file D  KKK NNN 100YWeatherSmall data json

User · Answer

Just copy path of json file like example  C  persons json   go to C  Program Files MongoDB Server 4 2 bin open cmd on that mongodb bin folder and run this command   mongoimport --jsonArray --db dbname--collection collectionName--file FilePath  example mongoimport --jsonArray --db learnmongo --collection persons --file C  persons json

[json] Mongoimport of json file

Examples related to json

Examples related to mongodb

Examples related to import

Examples related to mongoimport