CODEWITHSUNDEEP
jsonmongodbmongodb-compass
Gilles Heinesch
Gilles Heinesch

Reputation: 2990

Unexpected end of JSON input with MongoDB Compass

I exported my local MongoDB Collections using the JSON file type on my pc. Then I wanted to import these Collections on my root server using MongoDB Compass.

Everytime when I try to export the Collection, it throws the following error: Error

That's how my JSON file looks like: 

{..."settings":{"inventory":{"crate":{"$numberInt":"0"},"cratekey":{"$numberInt":"0"},"pickaxe":{"$numberInt":"0"},...}

(I don't know if it's relevant to answer this question but this JSON line is just 1/142000)

How can I fix this error?

Upvotes: 1

Views: 6738

Answers (3)

Devtician
Devtician

Reputation: 81

TL;DR
You need to have 1 empty line at the very bottom of the json file.

Long version
I don't know if this will help your case, but I ran into a similar issue when trying to import json data. I had 1 document per line, but something was still wrong. I then exported a similar piece of data as json, and tried playing around with it to see what was causing the issue. It turns out that the json must have an empty line at the bottom. So let's say you have 1 document to import. You place the entire document onto the first line. Then you just hit enter and create the second line at the bottom. After this, my data was imported without a problem.

Upvotes: 3

Ch Asjad
Ch Asjad

Reputation: 1

So the problem is you need to minify your json document. That is it should be in one line. So here's link to website where you will paste your json document on the left and get the minified document on the right. It worked for me. I hope this also helps you. https://codebeautify.org/jsonminifier

Upvotes: 0

varunpatil
varunpatil

Reputation: 823

I had exact same problem, apparently their should be one document per line. However use https://studio3t.com/ it'll work fine.

Upvotes: -1

Related Questions