Bulk insert from Array in mongodb JavaScript console

Question

I'm trying to make a bulk insert from the MongoDB console of an array into a collection.

I'd like to do something similar to this.

obj1 = {_id:ObjectId(),blabla:1};

obj2 = {_id:ObjectId(),blabla:2};

objs = [obj1, obj2];

db.test.insert(objs);

db.test.find()

> {"_id": ObjectId("xxxx"), "blabla": 1} > {"_id": ObjectId("xxxx"), "blabla": 2}

But, instead of inserting two objects on the collection, it stores one list with the two objects.

db.test.find()

> {"_id": ObjectId("xxx"), "0":{"_id": ObjectId("xxxx"), "blabla": 1}, "1":{"_id": ObjectId("xxxx"), "blabla": 2} }

That functionality appears to present on other drivers (like pymongo), but I can't find a way of doing that from the mongodb console, in JavaScript code.

Ida N · Accepted Answer · 2012-10-03 18:48:44Z

13

The feature to insert multiple documents into a collection has been added to Mongo command shell version 2.1+. Now You can insert and array of documents into your collection.

Example:

db.users.insert([{name:'Jon', email:'[email protected]'},{name:'Jane', email:'[email protected]'}])

For more information look at these jira closed feature request:

https://jira.mongodb.org/browse/SERVER-3819

https://jira.mongodb.org/browse/SERVER-2395

answered Oct 3, 2012 at 18:48

Ida N

1,96122 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sridhar · Accepted Answer · 2011-03-03 18:16:34Z

2

There is an existing feature request for this. http://jira.mongodb.org/browse/SERVER-2429

answered Mar 3, 2011 at 18:16

Sridhar

2,6301 gold badge15 silver badges3 bronze badges

Comments

tedeh · Accepted Answer · 2011-06-16 11:22:17Z

1

objs.forEach(function(obj) { db.test.insert(obj) });

answered Jun 16, 2011 at 11:22

tedeh

3682 silver badges8 bronze badges

Comments

julienc · Accepted Answer · 2014-12-14 17:52:32Z

1

Bulk is available in 2.6.6.

var bulk=db.posts.initializeUnorderedBulkOp() ;
bulk.insert(obj1) ; bulk.insert(obj2);...

bulk.execute() ;

edited Dec 14, 2014 at 17:52

julienc

20.4k19 gold badges87 silver badges86 bronze badges

answered Dec 14, 2014 at 17:33

Eliedaat

111 bronze badge

Comments

Michael Yagudaev · Accepted Answer · 2012-08-29 18:30:52Z

0

You cannot do a bulk insert through the interactive command shell. But there is a commandline tool that ships with Mongo that allows you to import multiple records as either JSON (your best option), CSV or Binary.

> mongoimport -h <host> -d <database> -c <collection> -u <user> -p <password> --file <input file> --jsonArray

The jsonArray flag will allow you to insert multiple records when you use the json array file. Another important note is to make sure you have the file ending with a new line character. Otherwise the last line will not be parsed.

edited Aug 29, 2012 at 18:30

answered Aug 29, 2012 at 17:51

Michael Yagudaev

6,1393 gold badges51 silver badges55 bronze badges

Collectives™ on Stack Overflow

Bulk insert from Array in mongodb JavaScript console

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related