I tried mongo import like this mongoimport -d test -c foo importfile.json mongoimport --host localhost --db local --collection lecturer --type json --file temp.json --headerline --upsert and I've got same error message "Syntax Error: missing ; before statement (shell):1" what's wrong with my code & how to import if my data stored in C:\Documents and Settings\User\Desktop ?? please help, thank's in advance

user1052073

Reputation: 521

Cannot import mongodb

I tried mongo import like this

mongoimport -d test -c foo importfile.json
mongoimport --host localhost --db local --collection lecturer --type json --file temp.json --headerline --upsert

and I've got same error message "Syntax Error: missing ; before statement (shell):1" what's wrong with my code & how to import if my data stored in C:\Documents and Settings\User\Desktop ?? please help, thank's in advance

Upvotes: 20

Answers (8)

Himanshu

Reputation: 7373

1.) Download the MongoDB Database Tools from MongoDB official Website and Unzip the folder

2.) Copy the json file which contains the data to be imported in the same folder as mongoimport.exe

3.) For Windows open the command prompt and run cd (path to folder with mongoimport.exe)

4.) run command .\mongoimport.exe import_data.json -d database_name -c collection_name --jsonArray

example

Upvotes: 0

Kriti Singh

Reputation: 31

mongoimport is to be run on the terminal and not inside the mongo shell. To run mongoimport in terminal, you will need to install the same. On ubuntu, you can do : apt-get install mongo-tools Hope this helps :)

Upvotes: 3

Rahi Javaid

Reputation: 1

Open a new terminal or command prompt within the location of the file you want to import and it should work. It will not work on MongoDB shell

Upvotes: 0

Sakthikanth

Reputation: 139

Open the "Mongo/Server/3.4/bin" folder of mongo db in another command window and try again.It Will work.

Upvotes: 0

Yas

Reputation: 5481

One solution is:

First, in cmd, change to the directory containing mongoexport.exe file, then type your command.

C:\Program Files\MongoDB\Server\3.2\bin> .\mongoexport.exe -d foo -c bar -o output.json

Upvotes: 3

Kindson The Genius

Reputation: 67

I had the same problem and was able to figure it out after a brief struggling and googling. 1. Navigate to the bin directory in command prompt (cd c:..\bin) 2. Run the mongoimport command but you have to specify the full path of your json file. That solves the problem

Upvotes: 2

Krit Pakarat

Reputation: 19

try to use CSV is a good.

mongoimport -d mydb -c things --type csv --file locations.csv --headerline --upsert

You can convert by ms excel.

Upvotes: 1

user1295798

Reputation: 1034

mongoimport is intended to run in command prompt and not in the mongo shell. Try exiting out of the shell and running the command.

Upvotes: 90

Cannot import mongodb

Answers (8)

Related Questions