Home > other >  Studio 3T for MongoDB unable to insert multiple object at once in json document in a collection
Studio 3T for MongoDB unable to insert multiple object at once in json document in a collection

Time:05-31

In Studio 3T i have created the collection in which i am adding a document after which popup window appears Titled >>Insert JSON Document<< to add the data in the document then i wrote these items.

{
    "_id" : "5c18e1892998bdb3b3d355bf",
    "title" : "REST",
    "content" : "REST is short for REpresentational State Transfer. IIt's an architectural style for designing APIs."
}


{
    "_id" : ObjectId("5c139771d79ac8eac11e754a"),
    "title" : "API",
    "content" : "API stands for Application Programming Interface. It is a set of subroutine definitions, communication protocols, and tools for building software. In general terms, it is a set of clearly defined methods of communication among various components. A good API makes it easier to develop a computer program by providing all the building blocks, which are then put together by the programmer."
}


{
    "_id" : ObjectId("5c1398aad79ac8eac11e7561"),
    "title" : "Bootstrap",
    "content" : "This is a framework developed by Twitter that contains pre-made front-end templates for web design"
}


{
    "_id" : ObjectId("5c1398ecd79ac8eac11e7567"),
    "title" : "DOM",
    "content" : "The Document Object Model is like an API for interacting with our HTML"
}


{
    "_id" : "5c18f35cde40ab6cc551cd60",
    "title" : "Jack Bauer",
    "content" : "Jack Bauer once stepped into quicksand. The quicksand couldn't escape and nearly drowned.",
    "__v" : 0
}

after that when i click the button add document, another popup appears which is Titled >>JSON Validation<< under which "Orphan character detected at line 8, col 1" shows. And i am not able to insert these documents at once.

How could i insert all these object at once in the document ?

CodePudding user response:

It's a limitation, unsupported till the date. You could run a insertMany query

 db.collection.insertMany([{doc1}, {doc2}])

Github link

Alternatively you can import documents if you don't want to run a direct query.

CodePudding user response:

Copy your JSON documents to the clipboard, then go to your collection and Control/Command V to paste the clipboard into the collection. You'll be prompted "Import documents from clipboard" - click OK and when done, refresh your view to see the newly imported documents.

Background: The Insert JSON Document, is, as it says, for single JSON documents. The error you see is because it is detecting a second JSON document beginning. Multiple JSON Document insertion is better handled by import, and if you paste JSON documents into a collection, it automatically triggers an import from clipboard.

  • Related