Import a data base file.json into robo3T (robomongo)

Question

I have a file named services.json containing a data base that I exported from a windows mongodb, and I want to import that file into robomongo (connected to mongodb installed by npm) on Ubuntu.

I'm a beginner and I don't know how to proceed, which terminal use (robomongo or Ubuntu)?

Robomongo — is a shell-centric crossplatform MongoDB management tool. Provides nice GUI — Mayuri, Apr 11 '14 at 10:54

score 16 · Answer 1 · edited Jan 17 '17 at 18:24

16

to import data for a collection in Robomongo:

Right click on collection.
Select 'insert Document'.
Paste your json data
Click validate.
Click save.

edited Jan 17 '17 at 18:24

Maximilian Ast

3,369
12
36
47

answered Jan 17 '17 at 14:07

Varun Sukheja

6,170
5
51
93

The only problem with this method is how unresponsible the UI becomes when parsing large JSON files. – David Gourde Aug 18 '17 at 17:49
6

This method create a single document with 500 child parameters, instead create 500 documents... – Bartolomeu S. Gusella Oct 14 '20 at 19:24
Just as @BartolomeuS.Gusella said, this inserts only 1 document in the database. In order to add multiple documents, this doesn't work. Probably [this](https://stackoverflow.com/questions/19441228/insert-json-file-into-mongodb?answertab=votes#tab-top) would do it – Zap Dec 04 '20 at 13:48
This method does not work for very big collections – KaraNyyan Dec 22 '21 at 09:35

score 10 · Answer 2 · edited Jan 29 '18 at 07:08

10

Ok, I found the answer. In shell Mac OS X or Unix type:

$ mongoimport -d your Database Name -c your Collection Name --file /path/to/my/fileThatIwantToImport.json

edited Jan 29 '18 at 07:08

jsingh

1,256
13
24

answered Apr 15 '14 at 10:26

user2981029

584
1
5
17

Do you know how to import s.th. with Robomongo/ Mac Shell if the database is outside of your local environment. E.g. on a server without accessing the server shell? – Andi Giga Apr 03 '15 at 06:56
1

@AndiGiga I provided an answer showing how to import to a remotedb – toddg Sep 20 '16 at 21:36
1

Tried it on windows and it works fine The mongoimport.exe is present in the bin folder where MongoDb is installed. The above answer worked just fine for me.. Just imported a 5 GB Json file. Took some time though – Vishweshwar Kapse Mar 26 '18 at 12:21

score 7 · Answer 3 · answered Sep 20 '16 at 21:35

For anyone wishing to use mongoimport with a remote db (@andi-giga), here's what I did to make it work:

mongoimport -h  xxx.mlab.com --port 2700  -d db_name -c collection_name -u user_name -p password  --type json --file  /Path/to/file.json

Arguments should be self-explanatory.

-h hostname

More information at this link

panzerstadt · Answer 4 · 2020-08-26T00:27:34.130

5

I don't have enough points to comment on Varun's answer, but if you use export jsonArray and then import using Robo3T (Robomongo), make sure to remove the commas in between the objects, as well as remove the square brackets.

It's not really a JSON format that ROBO 3T accepts, but rather bunch of JSON objects separated by newlines.

(if you use export Standard, then it's already formatted for document insert)

edited Aug 26 '20 at 00:27

answered Aug 26 '20 at 00:19

panzerstadt

53
1
2

Note that while you can't comment on answers just yet, you can suggest an edit to a post if you have additional information to add. You can do this by clicking the "edit" link just below the posts' text. – Hoppeduppeanut Aug 26 '20 at 04:37

score 3 · Answer 5 · edited May 23 '17 at 12:26

3

if this is not a bson, and only json, you can use mongoimport --jsonArray . refference Insert json file into mongodb

edited May 23 '17 at 12:26

Community

1
1

answered Jan 20 '15 at 09:39

Deck Pope

231
3
10

score 3 · Answer 6 · answered Oct 19 '17 at 04:45

RoboMongo is just the UI for your mongod which is the primary daemon process for the MongoDB system.

The only option to import from RoboMongo is

Right Click on Collection -> Insert Document

Apart from this you can import using the mongoimport command from terminal.

Open terminal and type mongo
Now in mongo interactive shell
Use the following command to import the json file as collection

mongoimport -d database_name -c collection_name --file < path to the json file

score 2 · Answer 7 · edited Jan 29 '18 at 08:01

2

Tested :

mongoimport --jsonArray -d <DataBase Name> -c <Collection Name> --file /path/to/my/fileThatIwantToImport.json

It works very well!

edited Jan 29 '18 at 08:01

jsingh

1,256
13
24

answered Jul 24 '15 at 08:45

K78

29
1

I would like to point out that I visted the man page to figure out csv files, and this can be done with the --type csv flag in place of --jsonArray – Jason V Apr 28 '20 at 19:31

score 0 · Answer 8 · answered Nov 05 '19 at 11:45

0

Insert Document will insert all the JSON file data under a single document. Apparently the tool does not support JSON import.

answered Nov 05 '19 at 11:45

mantzouric

1
3

score 0 · Answer 9 · answered Sep 13 '20 at 16:52

There are two ways to import the database into MongoDB. one is with robomongo/Robo 3T and one is with a shell command. I always choose the second method due to fewer and easy steps.

FIRST METHOD

Install MongoDB on your machine. Also, check it was installed properly or not by using mongod command on your terminal. So, for importing a new DB on your MongoDB write this command on your terminal

mongostore -host <HostIp | 127.0.0.1> -port <mongoPort | 27017> -db <DBname> <Directory-path>

So, for example you’re running MongoDB on local machine with default port i.e 27017 and your DB files are store at /usr/library/userDatabase then write this command and check DB is imported in your MongoDB

mongostore -host 127.0.0.1 -port 27017 -db userDatabase /usr/library/userDatabase

For more details check this article. Import MongoDB using shell and robomongo/Robo 3T

Import a data base file.json into robo3T (robomongo)

9 Answers9