Import CSV
Instructions for use
CSV (i.e., Comma-Separated Values) is a file that records data in text format, usually with commas as separators. This format is often used for data exchange between different programs. The Import CSV tool can import CSV files as attribute tables or spatial data.
Parameter description
parameter name | Parameter Description | Parameter Type |
---|---|---|
Select File | Enter the path information of the data to be imported. | String |
Charset | Select the character set type of the file to import, default is ASCII. | Charset |
Result Datasource | Specify the data source where the result dataset is stored. | Datasource |
Result Dataset | The name of the specified result dataset. | String |
Import Mode | Set the import mode when a dataset with the same name exists. | ImportMode |
Separator | Used to set the separator in the CSV file, default is English comma (,). Other optional separators include period (.), tab (Tab), and space. It also supports user-defined characters recognizable by text (including Chinese characters). | String |
1st Row as Header | Set whether the first row of the source file is the field name. By default, it is checked, meaning the field names after import are the values from the first row of the source file. If unchecked, the field names after import will be col0, col1, col2, ..., colN-1. | Boolean |
Auto Length | Set whether to automatically calculate field length during import. If checked, it reads the longest field in each column and adds 10 as the field length for that column. If unchecked, the field length defaults to 255 after import. Checking this option may affect import speed when importing large amounts of data. | Boolean |
Import Spatial Data | Used to set whether to import the data as a spatial dataset or attribute data. Supports obtaining spatial information by specifying a WKT string field or coordinate fields. | Boolean |
WKT String Field | Obtain spatial information by specifying a WKT string field. | Boolean |
Coordinate Fields | Obtain spatial information by specifying coordinate fields. Specify fields for X, Y, or X, Y, Z coordinates. If conditions are met, it generates point or 3D point datasets. | String |
Output Result
parameter name | Parameter Description | Parameter Type |
---|---|---|
Result Dataset | Result dataset. | DatasetVector |