Import CSV
Instructions for use
CSV (Comma Separated Values) is a file format that records data in text form, typically using 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 Interpretation | Parameter Type |
|---|---|---|
| Select File | Enter the data path information that needs to be imported. | String |
| Character Set | Select the character set type of the file to be imported, default is ASCII. | Charset |
| Result Datasource | Specify the datasource where the result dataset is stored. | Datasource |
| Result Dataset | Specify the resulting dataset name. | String |
| Group | Supports importing data into a specified group; when no group is selected, data is imported under the datasource. | String |
| Import Schema | 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 dot (.), tab (Tab), and space. It also supports user-definable characters recognizable by text (including Chinese characters). | String |
| 1st Row as Header | Set whether the first row of the source file is a field. By default, it is checked, meaning the fields after import are the values from the first row of the source file; if unchecked, the fields after import will be: col0, col1, col2, ... colN-1. | Boolean |
| Auto Length | Set whether to auto length during import. If checked, the import will read the longest field in each column and add 10 to it 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 data as spatial data or attribute data. Supports obtaining the geometry of data by specifying a WKT string field or coordinate field. | 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. Specify fields for X, Y, or X, Y, Z coordinates respectively; if conditions are met, it will generate a point or 3D point dataset. | String |
Output Result
| Parameter Name | Parameter Interpretation | Parameter Type |
|---|---|---|
| Result Dataset | Result Dataset | DatasetVector |