MongoDB’s import utility – mongoimport – introduced a new parameter that allows you to import CSV data as an array.
The --useArrayIndexFields parameter interprets natural numbers in fields as array indexes when importing CSV or TSV files.
Category: Database Tools
How to Delete a SQL Server Agent Job in Azure Data Studio
If you’ve installed the SQL Server Agent extension in Azure Data Studio, you will be able to see a list of SQL Server Agent jobs, as well as create, edit, view history, etc.
But you may be wondering how to delete a job.
If so, read on.
Continue readingHow to Merge Documents when Importing a File into MongoDB
When you use mongoimport to import files into MongoDB, you have the option of merging existing documents with the ones that you’re importing.
In this case, if an imported document has the same _id value as an existing one in the collection that you’re importing into, the existing document will be merged with the one being imported.
You can also specify another field (other than the _id field) to be the matching field if required.
How to Replace Existing Documents when Importing a File into MongoDB
When you use mongoimport to import files into MongoDB, you have the option of replacing existing documents that match the ones you’re importing.
By this I mean, if an imported document has the same _id value as an existing one in the collection you’re importing into, the existing document will be replaced with the one being imported.
You can also specify another field (other than the _id field) to be the matching field if required.
The way to replace existing documents when using mongoimport is to use upsert mode.
Import a CSV File into MongoDB with mongoimport
When using MongoDB, you can use mongoimport to import documents into a collection. mongoimport is a command line utility that imports content from an Extended JSON, CSV, or TSV file. The import file could have been created by mongoexport or some other export utility.
This article presents examples of importing a CSV file into MongoDB.
Continue readingImport a JSON File into MongoDB with mongoimport
When using MongoDB, you can use mongoimport to import documents into a collection. mongoimport is a command line utility that imports content from an Extended JSON, CSV, or TSV file. The import file could have been created by mongoexport or some other export utility.
This article presents examples of importing a JSON file into MongoDB.
Continue readingThe Import Modes of mongoimport
When using mongoimport to import files into MongoDB, you have the option of specifying a mode to use. These modes determine what happens if there’s already matching documents in the collection that you’re trying to import into.
By default, mongoimport uses insert mode, but there are other modes you can use. The mode you use will depend on what you’re trying to do.
Below is an overview of each mode along with examples.
Continue readingHow to Export MongoDB Query Results to a CSV File
The MongoDB Database Tools include a utility called mongoexport that enables you to export MongoDB data to a CSV or JSON file.
One of the things you can do with this utitlity is export query results. This article shows you how to use mongoexport to export MongoDB query results to a CSV file.
How to Export MongoDB Query Results to a JSON File
The MongoDB Database Tools include a utility called mongoexport that enables you to export MongoDB data to a CSV or JSON file.
One of the things you can do with this utitlity is export query results. This article shows you how to use mongoexport to export MongoDB query results to a JSON file.
Export a MongoDB Collection to a JSON File
The MongoDB Database Tools include a utility called mongoexport that enables you to export MongoDB data to a CSV or JSON file.
This article shows you how to use mongoexport to export a MongoDB collection to a JSON file.