mirror of https://github.com/CrimsonTome/tldr.git
29 lines
1.1 KiB
Markdown
29 lines
1.1 KiB
Markdown
|
# mongoimport
|
||
|
|
|
||
|
|
> Imports content from a JSON, CSV, or TSV file into a MongoDB database.
|
||
|
|
> More information: <https://docs.mongodb.com/database-tools/mongoimport/>.
|
||
|
|
|
||
|
|
- Import a JSON file into a specific collection:
|
||
|
|
|
||
|
|
`mongoimport --file={{path/to/file.json}} --uri={{mongodb_uri}} --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}} --db={{database_name}} --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`
|