Robomongo: Inserting multiple documents from UI
I would like to have an ability to insert multiple documents from "Insert Document" window.
Use case: I query collection and get the results. I want to copy some documents (in json), edit them and insert to another collection (maybe on another server).
I would like to
1) copy json (from text view)
2) right-click on another collection
3) choose "Insert Document"
4) paste my json (multiple documents)
5) edit json
6) click "Insert"
Like this (in the same format as result in a text mode)
Right now we can only insert documents one at a time
gavruk
All 59 comments
Please test.
topilski
on 11 Sep 2013
verified in 0.8.3 beta 1
stmoroz
on 13 Sep 2013
but it's weird that it does not support comma between records !! well, i might be talking about different functionalities, I was hoping to have a import Documents from JSON array :) , similar to http://zaiste.net/2012/08/importing_json_into_mongodb/
windmaomao
on 7 Mar 2015
I had to manually remove all the commas. Robomongo should have a import functionality to import stuff from JSON, CSV etc.
Ghost---Shadow
on 29 Aug 2016
@Ghost---Shadow thanks for suggestion! That's a good idea, so I have create a feature ticket https://github.com/paralect/robomongo/issues/1176 . Let me offer you to track progress within this card. Stay tuned!
juliashibalko
on 31 Aug 2016
totally need this feature during dev cycles
clearride
on 20 Dec 2016
+1
abhipanda
on 5 Feb 2017
Commas are there by default in say an api pull, so supporting them seems like a necessity. Please add this feature.
karissame
on 8 Feb 2017
this feature is totally need.. It will be really usefull if you can insert many documents using an array of objects like in mongo.insertMany:
[
{ "name": "John", "surname": "Type" },
{ "name": "Master", "surname": "Freez" },
{ "name": "Top", "surname": "Cat" },
]
I tried like this since the json validator didn't complain and resulted in 1 object with inside all the stuff.
codekraft-studio
on 12 Apr 2017
+1
kaushalye
on 31 May 2017
Adding my voice, this feature would be very helpful.
JasonMFry
on 7 Jul 2017
+1
marko823
on 11 Jul 2017
This would be really helpful to me as well.
+1
eyadh
on 24 Jul 2017
+1!!!
sarumanplaysguitar
on 3 Aug 2017
+1
tfoxcroft
on 4 Aug 2017
+1
vtaneka
on 8 Aug 2017
+1
it is adding it in one object
sombek
on 8 Aug 2017
+1
pr3mar
on 11 Aug 2017
+1
Gerdinand
on 11 Aug 2017
+1
lakshmanpasala
on 19 Aug 2017
+1
JaviDoubleOK
on 28 Sep 2017
+1
Ferouk
on 17 Oct 2017
+1
virtual
on 17 Oct 2017
+1
DryTaste
on 25 Oct 2017
+1
janes
on 5 Nov 2017
+1
krsnv
on 6 Nov 2017
+1
rossthedevigner
on 10 Nov 2017
+1
bnetter
on 14 Nov 2017
+1
domeniconappo
on 17 Nov 2017
+1
Vitegor
on 19 Nov 2017
I'd also like to have that feature 馃檪
cristianelias
on 20 Nov 2017
This seems like a common-sense approach; Hence a good UI idea :)
We should not need to manually remove so many commas in 2017. If the insert interface detects you are inserting an array, it should also not by default assume you are wrapping every single item with an integer key (that kind of makes no sense). One of the key features of JSON is simplicity between identifying iterable collections of things (arrays) or simple data structures (Object Literals).
As much as I like this GUI tool, it almost makes more sense to not rely on RoboMongo at all when we need to import a JSON file as a simple array (which is a very common use-case for MongoDB-centric data collections).
rob2d
on 22 Nov 2017
+1
NicciWill-Solutions
on 3 Jan 2018
+1
crawc
on 15 Jan 2018
+1 Is this any closer to being implemented?
EndaMolloy
on 2 Feb 2018
+1
jcga82
on 7 Feb 2018
While it would be nice to be able to paste an array of JSON documents into the collection using the UI editor, it's not that difficult to open a new editor tab on the collection in question and execute the equivalent .insertMany:
db.getCollection('foo').insertMany([{},{},{}])
humblepie
on 4 Mar 2018
+1
Kulboi
on 13 May 2018
+1
duanyukai
on 16 May 2018
+1
lydiali9
on 5 Jun 2018
+1
icarustechdev
on 8 Jun 2018
+1
mehulmpt
on 27 Jun 2018
+1
0xdeafcafe
on 3 Jul 2018
+1
thian4
on 7 Jul 2018
+1
markkuhar
on 9 Jul 2018
+1
Yliu12
on 9 Jul 2018
+1
rarajeshks
on 11 Jul 2018
+1
suchaaver-chahal
on 14 Jul 2018
+1
theminer3746
on 19 Jul 2018
+1
erfling
on 24 Jul 2018
+1
polotto
on 6 Aug 2018
+1
MrGRA
on 4 Sep 2018
+1 (wanted to do this right now, and I'm surprised I couldn't)
wfigueiredo
on 26 Sep 2018
+1
maxmzd
on 19 Feb 2019
+1 for GUI feature. I'm using this approach!
> mongo
>
> use test
switched to db test
>
> user = db.user
test.user
>
> user.insertMany([{"full_name": "User 01", "email": "[email protected]"}, {"full_name": "User 02", "email": "[email protected]"}])
{
"acknowledged" : true,
"insertedIds" : [
ObjectId("5c6fb64f8e54693b95a2daec"),
ObjectId("5c6fb64f8e54693b95a2daed")
]
}
>
> user.find({})
{ "_id" : ObjectId("5c6fb64f8e54693b95a2daec"), "full_name" : "User 01", "email" : "[email protected]" }
{ "_id" : ObjectId("5c6fb64f8e54693b95a2daed"), "full_name" : "User 02", "email" : "[email protected]" }
>
nvtuan305
on 22 Feb 2019
I have try Insert Document feature with many records at once and it's working! The JSON will be:
{
"full_name" : "User 01",
"email" : "[email protected]"
}
{
"full_name" : "User 02",
"email" : "[email protected]"
}
Good to know it is possible now, but the input format of the JSON is weird. Adding commas should be acceptable, IMHO
dalvarezsmiet
on 11 Sep 2019
@dalvarezsmiet adding commas is JSON 馃檭
rob2d
on 26 Nov 2019
Sorry, I tried to add an array of objects and added the entires array to the collection. Is it possible in Robot 3t to add multiple items?
elioscordo
on 16 Oct 2020
Related issues
murshid1988
路
3Comments
perlun
路
4Comments
OmisNomis
路
3Comments
mayask
路
3Comments
ghost
路
3Comments
Most helpful comment
While it would be nice to be able to paste an array of JSON documents into the collection using the UI editor, it's not that difficult to open a new editor tab on the collection in question and execute the equivalent .insertMany:
db.getCollection('foo').insertMany([{},{},{}])