If ‘Excel’ was selected as the source type, a corresponding file must be opened.
After selecting the file, you can specify which worksheet should be imported if there are several in the file:
According to the data, further settings are displayed that must be selected:
1. The source type ‘xls’ has been selected from the drop-down list.
2. The source file has been loaded.
3. The selected worksheet is specified.
4. The table can be selected.
5. The range can be copied directly from Excel into the field.
To do this, select the range in the Excel table, right-click in the context menu and select ‘Get data from table/range’.
The following window appears, from which the range can be copied:
The range can then be copied into this line (5).
6. You must tick whether the file contains a header or not. If there is a header, its number must be specified.
7. The number of records found is displayed.
8. You must select how the geometry columns are contained in the file.
a) Selection of the format
b) Select the column for ‘X’
c) Select the column for ‘Y’
9. A previously saved import template can be loaded.
10. The source coordinate system can be selected.
a) The category of the coordinate system must be selected:
b) 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, click the ‘Next’ button to proceed to the next page of settings.
13. Click the ‘Close’ button to close the dialogue box. This will cancel the import.
In the import settings (2/4), you must first specify whether records from the source file should be imported or updated.
Import
When importing, no further specifications need to be made on this page; simply click the button to continue.
The attribute mappings 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 information window:
Information about the import can be saved in a log.
Update
The option ‘Update records’ can also be selected in the import settings (2/4).
Further attribute assignments can be defined:
Filter conditions can be specified 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 information window:
Once the import/update is complete, a prompt appears asking whether the import settings should be saved in a template file.