MongoDB Compass can't insert document by pasting json string

Question

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.

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

Answer 1

For future visitors: this answer might help.

Just switch the view to JSON (the two curlies button - a feature that was added after this question was raised it seems like), hit "Edit Document" upon hovering a document, and then you will be editing the JSON directly which gives you a lot of flexibility and speed.

Answer 2

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