Import/Export .CSV file in MongoDB

Import:
We can import .csv data in mongodb using mongoimport, please see following example.

Syntax:

Without authentication


mongoimport --db <DBNAME> --collection <COLLECTION_NAME> --type csv --headerline --file  /path/to/Import.csv


--db : here we have to give database name.
--collection: here we have to give Collection name.
--type: file type like csv, json etc.
--file: Path of file will be import into mongodb.
--headerline: It means first row is field name.

With authentication


mongoimport –<host_ip> --port 27012 --username <user> --password <pass> --collection <collection_name>--db <db_name>--file <file path>



Example: Suppose we have a csv file which contains data of Employee like NAME, ADDRESS, PHONE etc. And we have to import data in mongodb.











Run the following command


>mongoimport --db TEST1 --collection myCol --type csv --headerline --file  D:/MDB/Import.csv


Result



Export:

We can export mongodb data in csv using mongoexport.

Syntax:


mongoexport --db <users> --collection <Collection_Name> --type=csv --fieldFile fields.txt --out /opt/backups/contacts.csv


Example: Now above imported data going to export using following command.


{ "_id" : ObjectId("57834347fbe91e1b53e67dca"), "NAME" : "Dilip", "ADDRESS" : "Delhi", "PHONE" : NumberLong(9018878876) }
{ "_id" : ObjectId("57834348fbe91e1b53e67dcb"), "NAME" : "Vipul", "ADDRESS" : "Ghazibad", "PHONE" : NumberLong(4444499870) }
{ "_id" : ObjectId("57834348fbe91e1b53e67dcc"), "NAME" : "Swati", "ADDRESS" : "Noda", "PHONE" : NumberLong(8998009986) }


We can export the above data into csv file to run the following command.


mongoexport --db TEST1 --collection myCol --csv --fields NAME,ADDRESS,PHONE --out D:/MDB/Export.csv


Result:



Exported csv data


No comments:

Post a Comment

PostgreSQL: How to change the password of the user

This article will teach you to change the password of the user in PostgreSQL. To change the password, we use the ALTER ROLE, its uses are ...