Exporting and importing data with Excel

Exporting to Excel

An export to an Excel spreadsheet can be done “directly” or with the “form data”:

mceclip0.png

Export directly

With the “Export directly”, all controls/attributes present in the feature class can be exported.

mceclip5.png

mceclip7.png In the table, the columns are named in addition to the attribute name with the designation of the respective control.
mceclip10.png Row 1: Control designation
Row 2: Control/attribute
Row 3/4: Example
mceclip8.png All controls can be activated.
mceclip9.png All controls can be deactivated.

 

Export form data

With “Export form data”, all controls/attributes displayed in the form can be exported.

mceclip6.png

The exported data can then be edited and shared or re-imported.

Importing from Excel

The import on an Excel spreadsheet can be done as an import “directly” or as an “update”:

mceclip15.png

Excel import

With an Excel import, new data can be imported into a project. The names of the columns must correspond to the controls of the feature class into which the data is to be imported. This is easiest to understand if data was previously exported from this feature class.

If records already exist in the feature class, the query appears as to whether the existing records should be deleted. When importing additional records, this question must be answered in the negative. If there were no records before and the same records are imported again and again for testing purposes, these may of course be deleted before a new import.

mceclip14.png

After the import, the following message will appear:

mceclip13.png

If no coordinates are included in the data, a geometry must subsequently be assigned to the objects.

If these are feature classes that have both a line/point form and a detailed form, the import must be carried out in the respective line/point form. A query is then made as to which attribute feature is involved.

Excel update

The Excel update is used for faster processing of many records and their re-import into the project. The FIDs of the records must remain unchanged so that the attributes can be assigned to the correct record. After editing the data in Excel, the records can be updated during import.

The following query will appear:

mceclip11.png

The update could still be canceled here with “No”.

If the update is confirmed with “Yes”, then the update is completed with this message:

mceclip12.png