Search code examples
mongodbcompass

MongoDB Compass can't insert document by pasting json string

I'm using compass community v1.13.1 and have been trying to populate some sample data for couple of hours, but failed.

Found a similar issue here, I followed the first answer by @ktsangop but it didn't work.

Cant paste as a json object anyway, if I set type to string, it will be just blank string; if set type to object, can't paste the json string as a whole. image

Do I need to insert a valid json object one field by one field? or am I doing it wrong?

Solution

  • Can't believe that this is an actual issue.. for the first 2 minutes I though that something is wrong with me lol

    Anyhow, I do have a (hacky) solution:

    1. Select an item and click the Edit Document button
    2. Create a new field or select existing one for editing
    3. Enter a double-quote sign "
    4. Copy the json payload
    5. Seek to the beginning of the field and remove the double-quote sign (in step 3)
    6. Save document changes

    TADA!

    UPDATE:

    Seems like the copy-paste action will only take effect if the json is partial (valid jsons are ignored for some reason).. so I ended-up with an easier solution:

    1. Select an item and click the Edit Document button
    2. Create a new field or select existing one for editing
    3. Omit the last character from your json payload (for { "a": true } copy only { "a": true)
    4. Copy the partial json payload
    5. Seek to the end of the field add the missing character (in our sample })
    6. Save document changes