Import Worksheet Format

Each cross reference workbook has an import worksheet. It identifies the database tables into which data is imported and the order in which the data is imported. The worksheet also contains other attributes for the import operation.

Table 1 shows the import worksheet columns that are present for each row in the worksheet. The user should only modify the import and mode columns. Consult IBM® Support before modifying any of the other columns.
Table 1. Cross Reference Import Worksheet Columns
Column Description
Import Sheet Name The name of the worksheet in the configuration data workbook that contains the actual configuration data to be imported.
Import Indicates if the data should be imported.
The valid values are:
Y
The configuration data associated with this cross reference row is imported.
N
The configuration data associated with this cross reference row is not imported.
Mode The mode to use when the configuration data is imported. The valid values are:
Insert
Uses the database insert operation to add the configuration data records to the associated database table. If the data being inserted is already present in the database table, a duplicate record exception occurs and the import operation stops.
Update
Uses the database update operation to update existing database table records with the configuration data records. For more information about this mode, see Update Mode.
InsertUpdate
Uses the database insert operation to add the configuration data records to the associated database table. If the insert operation fails with a duplicate record exception, the existing database table record is updated with the data from the configuration data record that caused the duplicate record exception.
Replace
Uses the database delete operation to delete all records from the associated database table. Then, the database insert operation is used to add the configuration data records to the associated database table.
Map Sheet Name The name of the map workbook worksheet to use with the worksheet specified in the import sheet name column.
Database Table Name The name of the database table into which the configuration data is imported.
Update Key The names of the database columns that are used as the key fields when performing the database update operation.