HiveBrain v1.2.0
Get Started
← Back to all entries
snippetbashTip

mongoimport — Imports content from a JSON, CSV, or TSV file into a MongoDB database. More information: <https://ww

Submitted by: @import:tldr-pages··
0
Viewed 0 times
importscommandfromcontentclijsoncsvmongoimport

Problem

How to use the mongoimport command: Imports content from a JSON, CSV, or TSV file into a MongoDB database. More information: <https://www.mongodb.com/docs/database-tools/mongoimport/>.

Solution

mongoimport — Imports content from a JSON, CSV, or TSV file into a MongoDB database. More information: <https://www.mongodb.com/docs/database-tools/mongoimport/>.

Import a JSON file into a specific collection:
mongoimport --file {{path/to/file.json}} --uri {{mongodb_uri}} {{[-c|--collection]}} {{collection_name}}


Import a CSV file, using the first line of the file to determine field names:
mongoimport --type {{csv}} --file {{path/to/file.csv}} {{[-d|--db]}} {{database_name}} {{[-c|--collection]}} {{collection_name}}


Import a JSON array, using each element as a separate document:
mongoimport --jsonArray --file {{path/to/file.json}}


Import a JSON file using a specific mode and a query to match existing documents:
mongoimport --file {{path/to/file.json}} --mode {{delete|merge|upsert}} --upsertFields "{{field1,field2,...}}"


Import a CSV file, reading field names from a separate CSV file and ignoring fields with empty values:
mongoimport --type {{csv}} --file {{path/to/file.csv}} --fieldFile {{path/to/field_file.csv}} --ignoreBlanks


Display help:
mongoimport --help

Code Snippets

Import a JSON file into a specific collection

mongoimport --file {{path/to/file.json}} --uri {{mongodb_uri}} {{[-c|--collection]}} {{collection_name}}

Import a CSV file, using the first line of the file to determine field names

mongoimport --type {{csv}} --file {{path/to/file.csv}} {{[-d|--db]}} {{database_name}} {{[-c|--collection]}} {{collection_name}}

Import a JSON array, using each element as a separate document

mongoimport --jsonArray --file {{path/to/file.json}}

Import a JSON file using a specific mode and a query to match existing documents

mongoimport --file {{path/to/file.json}} --mode {{delete|merge|upsert}} --upsertFields "{{field1,field2,...}}"

Import a CSV file, reading field names from a separate CSV file and ignoring fields with empty values

mongoimport --type {{csv}} --file {{path/to/file.csv}} --fieldFile {{path/to/field_file.csv}} --ignoreBlanks

Context

tldr-pages: common/mongoimport

Revisions (0)

No revisions yet.