If ‘CSV’ was selected as the source type, a corresponding file must be opened.
After selecting the file, the characters used as separators or quotation marks, the encoding and the date format are automatically recognised.
Depending on the data, further settings are displayed that must be selected:
1. The source type ‘csv’ was selected in the selection list.
2. The source file has been loaded.
3. The delimiter used in the source file is specified.
4. The quote used in the source file is specified.
5. The encoding is displayed as it is recognised from the file. However, this can also be specified via a selection list:
6. The date format can be defined via a selection list:
7. It must be ticked whether the file contains a header line or not. The number of data records found is displayed accordingly.
8. you must select how the geometry columns are contained in the file.
a) Selection of the format
b) Selection of the column for ‘X’
c) Selection of the column for ‘Y’
9) Information on the import template can be stored:
a) A previously saved import template can be loaded.
b) You can specify whether the settings should be saved as a template.
c) If the settings are to be saved as a template, the save path must be specified here.
10) The category of the coordinate system must be selected:
This results in the list for the source coordinate system, which must then be selected from the list:
Note: The coordinate system defined in the current module is set as the default source coordinate system.
11. The object type into which the data is to be imported must be selected as the target object class.
12. Once all settings have been defined, the ‘Continue’ button can be clicked to go to the next page of the settings dialogue.
13. the dialogue can be closed with the ‘Close’ button. This cancels the import.
In the import settings (2/4), you first specify whether data records are to be imported from the source file or updated.
Import
When importing, no further specifications need to be made on this page; instead, the process continues directly via the button.
The attribute assignments are defined in the import settings (3/4):
Here, the target attributes can be assigned to the source attributes. A data preview can also be displayed using the button .
The target object class can be opened using the button .
Once all settings have been defined, click the ‘Next’ button to proceed to the next page of settings.
Filter conditions can be defined in the import settings (4/4):
These can be both spatial and attributive filters:
The import is started with the ‘Import’ button:
The result is displayed in an info window:
Information about the import can be saved in a log.
Update
The ‘Update data records’ option can also be selected in the import settings (2/4).
Further attribute assignments can be defined:
Filter conditions can be defined on the next page of the import settings: These can be geometric or attributive filters:
The import is started with the ‘Import’ button:
The result is displayed in an info window:
Once the import/update is complete, a query appears asking whether the import settings should be saved in a template file.