mongoimport syntaxerror unexpected identifier

You command is correct. Use it from the terminal and not inside the mongo shell. However, I would make a small tweak to your mongoimport as below just to make it generic: On the terminal :

mongoimport --db test --collection restaurants --drop --file /<complete-path>/primer-dataset.json

So, if file is in /myimports folder then it would be :

mongoimport --db test --collection restaurants --drop --file /myimports/primer-dataset.json

You should quit() mongo.exe at first.

Second input mongoimport --db test --collection restaurants --drop --file D:/MongoDB/data/dataset.json.

I faced the same issue. Although, none of the above solutions helped. After trawling the internet, I have finally found the solution.

In my case, the problem was the absence of the mongoimport.exe file in the bin directory.

So, follow the next steps:

1. Download the MongoDB Database Tools https://www.mongodb.com/try/download/database-tools.
2. Copy all files from the bin directory to the following directory - MongoDB\Server\4.4\bin.

Now, the mongoimport has to be working.

Ran into same issue, the instructions in the online documentation you listed are good as long as you change the case of your Downloads folder (Windows is not case sensitive but Linux is) in your command. If yours is like mine, you have to change

mongoimport --db test --collection restaurants --drop --file ~/downloads/primer-dataset.json

to

mongoimport --db test --collection restaurants --drop --file ~/Downloads/primer-dataset.json

Also as anish mentioned you do have to run this in the terminal (not inside mongo shell) the mongoimport connects to the a mongod instance running on localhost on port 27017

quit() mongo.exe because it shouldn't be written in mongo terminal

type

.\mongoimport --db test --collection restaurants --drop --file primer-dataset.json

This should work!

You don't run mongoimport from mongo shell, run it directly from your OS terminal

This is what I tried and it works well !!

What you can do is just convert your json object to an array using any editor and then use --jsonArray and --legacy at the end of your uri. Will Work fine .

mongoimport --db test --collection restaurants --drop --file primer-dataset.json --jsonArray --legacy

Remember to convert your json Object to an array before tyring this

1. Download mongotools, then copy files to your /bin folder.
2. Make sure you have a right PATH in windows to /bin folder and mongo is working.
3. Open CMD and paste: mongoimport --db yourDbName --collection nameOfCollection ^ --username <user> --password <password> ^ --drop --file filePath
4. Test with MONGOSHELL: db.nameOfCollection.find()

I solved this problem by eliminating the spaces from the json file. Let's say your json file looks like this:

    {
"created_at": "01/01/2021",
"id": 1050118621198921720,
"text": "To make room for more expression”
"user": {
"id": 6253282,
"name": "Bertrand",
"location": "San Francisco",
"followers_count": 613
}
}
{
"created at": "29/03/2021",
"id": 1050118621198921729,
"text": "salut Tunisie”
"user": {
"id": 6253559,
"name": "Jhon",
"location": "London",
"followers_count": 89
}
}
{
"created at": "25/10/2021",
"id": 1050118621198921721,
"text": "Essai”
"user": {
"id": 6253553,L’énoncé de l’examen est clair, aucune clarification n’est permise au cours de l’épreuve !
"name": "Philippe",
"location": "Paris",
"followers_count": 6133636
}
}
{
"created_at": "29/03/2021",
"id": 1050118621198921728,
"text": "test”
"user": {
"id": 6253284,
"name": "Patrick",
"location": "Marseille",
"followers_count": 33636
}
}

It must look like this:

{"created_at": "01/01/2021","id": 1050118621198921720,"text": "To make room for more expression","user": {"id": 6253282,"name": "Bertrand","location": "San Francisco","followers_count": 613}}{"created at": "29/03/2021","id": 1050118621198921729,"text": "salut Tunisie","user": {"id": 6253559,"name": "Jhon","location":"London","followers_count": 89}}{"created at": "25/10/2021","id": 1050118621198921721,"text": "Essai","user": {"id": 6253553,"name": "Philippe","location": "Paris","followers_count": 6133636}}{"created_at": "29/03/2021","id": 1050118621198921728,"text": "test","user": {"id": 6253284,"name": "Patrick","location": "Marseille","followers_count": 33636}}

Here is the process:

1. Download Mongo tools
2. Move all the .exe files in the tools folder to the bin folder of your MongoDB in the the location where you installed MongoDB
3. Open a CMD and move the address to the bin folder of MongoDB (cd C:\Program Files\MongoDB\Server\5.0\bin)
4. Execute your import command (mongoimport --db databaseName --collection collectionName --drop --file filePath)