current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 4 down vote favorite
1

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.

share|improve this question

6 Answers 6

up vote 0 down vote accepted

To make it short: there is no such bulk insertion API available on the mongo console level.

share|improve this answer
1  
This answer is no longer valid, as you can see in the reply of Ida N (stackoverflow.com/a/12714881/1377224). –  philnate Apr 19 '13 at 21:24
up vote 11 down vote

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

share|improve this answer
up vote 2 down vote

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

share|improve this answer
up vote 1 down vote 
objs.forEach(function(obj) { db.test.insert(obj) });
share|improve this answer
up vote 1 down vote

Bulk is available in 2.6.6.

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

bulk.execute() ;
share|improve this answer
up vote 0 down vote

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.