Simple Example

This section contains a simple generic example of cross reference, map, and configuration workbooks that are used for the import and export operations. It shows how the columns in the different workbooks work together.

Start by looking at the cross reference workbook shown in Table 1. The example Import worksheet controls an import operation that imports data into the following database tables:
DB_TABLE_1
The column names for this table are defined in the MapSheet1 worksheet of the map workbook shown in Table 2. The actual configuration data rows to be imported are in the WsName1 worksheet of the configuration data workbook shown in Table 3.
DB_TABLE_2
The column names for this table are defined in the MapSheet2 worksheet of the map workbook shown in Table 2. The actual configuration data rows to be imported are in the WsName2 worksheet of the configuration data workbook shown in Table 3.
Notice that the worksheets in the configuration data workbook are using the descriptive column names that come from the map workbook.

The Export worksheet shown in Table 1 is similar to the import operation. It uses the same map and configuration data worksheets as the import operation. It also works on the same database tables, as can be seen by looking at the Query SQL column of the export worksheet.

Table 1. Example Cross Reference Workbook
Worksheet Name Worksheet Columns
Import Import Sheet Name Import Mode Map Sheet Name Database Table Name Update Key
WsName1 Y InsertUpdate MapSheet1 DB_TABLE_1 DB_COL1, DB_COL2
WsName2 Y InsertUpdate MapSheet2 DB_TABLE_2 DB_COL20
             
Export Export Sheet Name Export Map Sheet Name Query SQL    
WsName1 Y MapSheet1 SELECT * FROM DB_TABLE_1    
WsName2 Y MapSheet2 SELECT * FROM DB_TABLE_2    
Table 2. Example Map Workbook
Worksheet Name Worksheet Columns
MapSheet1 Column1 Column2 Column3
DB_COL1 DB_COL2 DB_COL3
       
MapSheet2 Column20 Column21 Column22
DB_COL20 DB_COL21 DB_COL22
Table 3. Example Configuration Data Workbook
Worksheet Name Worksheet Columns
WsName1 Column1 Column2 Column3
Row1DataValue Row1DataValue Row1DataValue
Row2DataValue Row2DataValue Row2DataValue
       
WsName2 Column20 Column21 Column22
Row1DataValue Row1DataValue Row1DataValue
Row2DataValue Row2DataValue Row2DataValue