Data Import from apsaradb for MongoDB

1.The content of the Data user.csv file imported into the csvformat is as follows: _ id, name, ageObjectID (4eed9f9ca939118694cf05e4), ming, 10 ObjectI

1. The contents of the user.csv file for importing CSV data are as follows: _ id, name, age ObjectID (4eed9f9ca939118694cf05e4), ming, 10 ObjectI

1. Import CSV data

The content of the user.csv file is as follows:

_ Id, name, age
ObjectID (4eed9f9ca939118694cf05e4), "ming", 10
ObjectID (4ef1f3cf3bd18218e6bdfa31), "lisi", 20

You can import the data in user.csv to the user set of the localdb database in the following way:

>Export Import-d localdb-c user -- type csv -- file user.csv -- headerline -- upsert

2. import data in json format

The data in the user. dat file is in json format and the content is:

{"_ Id": "ObjectID (4eed9f9ca939118694cf05e4)", "name": "ming", "age": 10}
{"_ Id": "ObjectID (4ef1f3cf3bd18218e6bdfa31)", "name": "lisi", "age": 20}

You can import the data as follows:

>Export Import-d localdb-c user. dat

3. Parameter meaning

-D: Specifies the database to which the data is imported.

-C: Specifies the collection to which the data is imported.

-- Type specifies the imported data type

-- File: Specifies the file from which data is imported.

-- Headerline is only applicable to importing csv and tsv data, indicating that the first line in the file is used as the data header.

-- Upsert: import data by adding or updating data.