Import CSV
Feature Description
CSV (Comma Separated Values) is a file that records data in text form (usually with a comma as the delimiter). This format is often used for data exchange between different programs. The Import CSV tool can import a CSV file as an attribute table or spatial data.
Parameter Description
| Parameter Name | Parameter Interpretation | Parameter Type |
|---|---|---|
| Select File | Enter the path information of the data to be imported. | String |
| Character Set | Select the character set type of the file to be imported. The default is ASCII. | Charset |
| Result Datasource | Specify the datasource where the result dataset will be stored. | Datasource |
| Result Dataset | Specify the name of the resulting dataset. | String |
| Group | Supports importing data into a specified group. If no group is selected, the data is imported under the datasource. | String |
| Import Schema | Set the import mode when a dataset with the same name already exists. | ImportMode |
| Delimiter | Set the field delimiter in the CSV file. The default is English comma (,). Supports dot (.), tab (Tab), space, and user-definable single-character delimiters (including Chinese characters). Only single characters are supported, e.g., A or 中. Multi-character delimiters such as AA or 中国 are not supported. | String |
| 1st Row as Header | Set whether the first row of the source file is used as fields. Checked by default, meaning the imported fields are the field values from the first row of the source file. If unchecked, the imported fields will be: col0, col1, col2...colN-1. | Boolean |
| Auto Length | Set whether to automatically determine the field length during import. If checked, the system will read the longest field in each column and add 10 as the field length for that column. If unchecked, the default field length after import is 255. Checking this option may affect import speed when importing large amounts of data. | Boolean |
| Import Spatial Data | Set whether to import data as a spatial dataset or attribute data. Supports obtaining the geometry of data by specifying a WKT string field or coordinate fields. | Boolean |
| WKT String Field | Obtain the geometry of data by specifying a WKT string field. | Boolean |
| Coordinate Field | Obtain the geometry of data by specifying coordinate fields. These are X, Y or X, Y, Z fields respectively. If conditions are met, a point or 3D point dataset will be generated. | String |
Output Result
| Parameter Name | Parameter Interpretation | Parameter Type |
|---|---|---|
| Result Dataset | Result dataset | DatasetVector |