The general import function can be used to import data in different formats. The import is started on the NET tab in the ‘Edit features’ group.
The following dialogue opens:
Several data formats are available as source types:
After selecting the source type, the source file must be loaded. The import settings are adjusted depending on the source type.
Source type: CSV
If ‘CSV’ was selected as the source type, a corresponding file must be opened.
After selecting the file, you must specify which characters were used as delimeter or quote.
Depending on the data, further settings are displayed which must be selected:
1. The source type ‘csv’ was selected in the selection list.
2. The source file has been loaded.
3. The separator 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. This can also be specified via a selection list:
6. The localisation is displayed as it is recognised from the file. However, this can also be specified via a selection list:
7. It must be ticked whether the file contains a header line or not.
8. The number of data records found is displayed.
9. 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’
10. 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 storage location must be specified here.
11. 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:
12. The object type into which the data is to be imported must be selected as the target object class.
13. Once all settings have been defined, the ‘Continue’ button can be clicked to go to the next page of the settings dialogue.
14. The dialogue can be closed with the ‘Close’ button. This cancels the import.
The attribute assignments are defined in the import settings (2/3):
The target attributes can be assigned to the source attributes here. A data preview can also be displayed.
Once all settings have been defined, the ‘Continue’ button can be clicked to go to the next page of the settings.
Filter conditions can be defined in the import settings (3/3):
These can be both spatial and attributive filters:
The import is started with the ‘Import’ button:
The result is displayed in an info window:
Source type: Excel
If ‘Excel’ was selected as the source type, a corresponding file must be opened.
After selecting the file, you can specify which worksheet is to be imported if there are several in the file:
Depending on the data, further settings are displayed which must be selected:
1. The source type ‘xls’ was selected in the selection list.
2. The source file has been loaded.
3. The selected worksheet is indicated.
4. The table can be selected.
5. The range can be copied directly from Excel into the field.
6. It must be ticked whether the file contains a header row or not.
7. If there is a header line, its number must be specified.
8. The number of data records found is displayed.
9. 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’
10. 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 storage location must be specified here.
11. 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:
12. The object type into which the data is to be imported must be selected as the target object class.
13. Once all settings have been defined, the ‘Continue’ button can be clicked to go to the next page of the settings dialogue.
14. The dialogue can be closed with the ‘Close’ button. This cancels the import.
The attribute assignments are defined in the import settings (2/3):
The target attributes can be assigned to the source attributes here. A data preview can also be displayed.
Once all settings have been defined, the ‘Next’ button can be clicked to go to the next page of the settings.
Filter conditions can be defined in the import settings (3/3):
These can be both spatial and attributive filters:
The import is started with the ‘Import’ button:
The result is displayed in an info window:
Source type: GeoJSON
If ‘GeoJSON’ was selected as the source type, a corresponding file must be opened.
Depending on the data, further settings are displayed which must be selected:
1. The source type ‘xls’ was selected in the selection list.
2. The source file has been loaded.
3. The number of data records found is displayed.
4. 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 storage location must be specified here.
5. The object type into which the data is to be imported must be selected as the target object class.
6. Once all settings have been defined, the ‘Continue’ button can be clicked to go to the next page of the settings dialogue.
7. The dialogue can be closed with the ‘Close’ button. This cancels the import.
The attribute assignments are defined in the import settings (2/3):
The target attributes can be assigned to the source attributes here. A data preview can also be displayed.
Once all settings have been defined, the ‘Next’ button can be clicked to go to the next page of the settings.
Filter conditions can be defined in the import settings (3/3):
These can be both spatial and attributive filters.
The import is started with the ‘Import’ button:
The result is displayed in an info window:
Source type: Shape
If ‘Shape’ was selected as the source type, a corresponding file must be opened.
Depending on the data, further settings are displayed that must be selected:
1. The source type ‘Shape’ was selected in the selection list.
2. The source file has been loaded.
3. The number of data records found is displayed.
4. 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 storage location must be specified here.
5. The object type into which the data is to be imported must be selected as the target object class.
6. Once all settings have been defined, the ‘Continue’ button can be clicked to go to the next page of the settings dialogue.
7. The dialogue can be closed with the ‘Close’ button. This cancels the import.
The attribute assignments are defined in the import settings (2/3):
The target attributes can be assigned to the source attributes here. A data preview can also be displayed.
Once all settings have been defined, the ‘Next’ button can be clicked to go to the next page of the settings.
Filter conditions can be defined in the import settings (3/3):
These can be both spatial and attributive filters.
The import is started with the ‘Import’ button:
The result is displayed in an info window: