Tab "Default settings"


This index contains exactly the same Options as the dialogue "Edit connection". When a new connection is created, the default settings entered here are adopted by default for the Options tab. You can change these settings at any time and for each individual connection, using the Options tab of the dialogue for "Edit connection".
 
The Tab "Options" controls the behavior of the GISconnector for Excel with respect to the creation and deletion of columns and rows and the management of GCEX_IDs on a separate basis for each transfer direction. Only the transfer direction of "Excel to ArcGIS" is described here; the direction of "ArcGIS to Excel" functions in an analogous manner, except for the following difference:
 
From Excel to ArcGIS, with version 1.2 of the GISconnector for Excel it is only possible to transfer new rows for associated ArcGIS tables.
 
 
Tab "Default settings"
1

Create columns in ArcGIS

that exist only in Excel

1. Create columns in ArcGIS
that exist only in Excel
Activate this function to create new columns in Excel and to transfer them rapidly and efficiently to ArcGIS using the GISconnector for Excel.
2

Delete columns in ArcGIS

that do not exist in Excel

2. Delete columns in ArcGIS
that do not exist in Excel
When you activate this option you can delete columns when transferring from Excel to ArcGIS using the GISconnector for Excel. The columns to be deleted either do not exist, or no longer exist in Excel and they must be managed by GISconnector for Excel on the ArcGIS target side.
3

New columns will be

managed by the GISconnector for Excel

3. New columns will be
managed by the GISconnector for Excel
If you add a new column in Excel and this option is activated, the column is automatically activated under Columns/fields or managed by GISconnector for Excel.
4

Create rows in ArcGIS

that exist only in Excel

4. Create rows in ArcGIS
that exist only in Excel
This setting only works for standalone tables (pure attriubute tables). Within feature-classes you can not create new features from Excel to ArcGIS in the version 1.2 of the GISconnector for Excel.
5

Delete rows in ArcGIS

that do not exist in Excel

5. Delete rows in ArcGIS
that do not exist in Excel
When you activate this option you can delete  features in ArcGIS and data sets (ArcGIS tables) when transferring from Excel to ArcGIS using the GISconnector for Excel. If you wish to delete features in ArcGIS through the transfer from Excel to ArcGIS, you must additionally deactivate the so-called ‘safety setting’ in the Settings dialogue in the "Advanced" tab for deleting features in ArcGIS.
6

Configure the behavior for

empty GCEX_IDs on the Excel side

6. Configure the behavior for
empty GCEX_IDs on the Excel side
If you create new features in Excel and you transfer these new features to ArcGIS, the GISconnector corrects the GCEX_ID for the new features in Excel and in ArcGIS so that after transferring, all GISconnector fuctions will be available for these new features. You can prevent the GISconnector from correcting GCEX_IDs if you transfer from Excel to ArcGIS by deactivating this option. Furthermore, if the GCEX_ID-correction for empty GCEX_IDs (in most cases new rows) is switched off, new rows in Excel will not be transferred anymore to ArcGIS. As a standard configuration, we recommend to activate this option.
7

Configure the behavior for

multi-occuring GCEX_IDs on the Excel side

7. Configure the behavior for
multi-occuring GCEX_IDs on the Excel side
If you transfer from Excel to ArcGIS and there are rows in Excel with identical GCEX_IDs, the GISconnector replaces those identical GCEX_IDs by new GCEX_IDs. If there was a corresponding feature with the same GCEX_ID of the ArcGIS side, the connection to the feature will be broken. As a standard configuration, we recommend to deactivate this option.