How to import csv files into mongodb?

Question

I am not able to import csv file into mongodb database. I am using windowsXP 32-bit machine. I am using mongoimport --db IPL --collection matches --file C:\Users\Todkar\Desktop\Cambium Networks Full Stack Hiring Challenge\matches.csv

I am getting error cannot find path specified in OS shell. see screenshot for more clarification.

enter image description here

Is file exists on that directory?

Saravana
– Saravana

2018-01-20 08:44:56 +00:00
Commented Jan 20, 2018 at 8:44 — Saravana
– Saravana, Commented Jan 20, 2018 at 8:44
@Saravana yes it is imgur.com/a/RrWrd

stone rock
– stone rock

2018-01-20 08:51:47 +00:00
Commented Jan 20, 2018 at 8:51 — stone rock
– stone rock, Commented Jan 20, 2018 at 8:51

Robot · Accepted Answer · 2018-01-20 08:50:54Z

1

case is where the path involves the use of white space characters, for example, when you need to access the app xyz which location is :

C:\Program Files\ab cd\xyz.exe.

To run this from windows cmd prompt, you need to use

C:\"Program Files"\"ab cd"\xyz.exe

OR

"C:\Program Files\ab cd\xyz.exe"

answered Jan 20, 2018 at 8:50

Robot

1,0017 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

stone rock Over a year ago

I need to use this command from OS shell I need to navigate to C:\ProgramFiles\MongoDB\bin where mongoimport utility is there am I right ?

Robot Over a year ago

you want to use file specified in --file C:\Users\Todkar\Desktop\Cambium Networks Full Stack Hiring Challenge\matches.csv that contains space. but in screenshot your using it without space that does not exists --file C:\Users\Todkar\Desktop\CambiumNetworksFullStackHiringChallenge\matches.csv

Collectives™ on Stack Overflow

How to import csv files into mongodb?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related