Dialogue "Edit connection"


The dialogue "Edit connection settings" is the most important one of the GISconnector for Excel. Please read carefully through this chapter to understand the functionality of GISconnector for Excel.
 
This dialogue consists of the following indexes:
 
 
 
 
This dialogue can be opened through Excel as well as through ArcGIS by clicking on this button .
 
What do we mean when we say that the GISconnector for Excel is managing columns?
 
If the check box of a column is activated or selected in the menu "Columns/Fields", this column is managed by the GISconnector for Excel, This means that the selected column is taken into consideration for the  transfer. What do we mean by "taken into consideration"? If the column represents a data source for a transfer, "taken into consideration" means that the column will be transferred.
 
If the column does not yet exist on the target side and the settings were configured that "Those columns not available on the other side are to be created", an activated respectively managed column is newly created on the target side and the content of the source column is transferred to the target column.
 
Does it have a meaning when a column on the target-side is activated or is managed by the GISconnector for Excel?
 
Yes! If a column on the target-side is activated or managed by the GISconnector for Excel, this column can be deleted when transferring. The prerequisite for this is to have configured the settings such that columns that are not available on the source-side but which do exist on the target-side may be deleted there. If a column on the target-side is activated or managed by the GISconnector for Excel and if this column either never existed or no longer exists on the source-side, then this column will, subject to the settings, be deleted on the target side in case of transferring.
 
In summary
An activated column, or a column that is managed by GISconnector for Excel, can, in accordance with the transfer direction, be either a data source or a transfer target. If a column is to be newly produced on the other side, or if data are to be transferred for the column, the column must be activated on the source-side or managed by the GISconnector for Excel. Whether the column on the trarget-side is either activated or whether it is managed by GISconnector for Excel has no effect on the data transfer.
Whether a column on the target-side is activated or managed by GISconnector for Excel is only significant in the case when this column is not available on the source-side and should be deleted on the target-side in the course of the transfer. To put it another way: If a column is not available on the source-side and should be deleted on the target-side then this column must be activated on the target-side meaning managed by the GISconnector for Excel.