Relationship Between Import and Export

For every table being loaded through the import process, there should to an associated export control. In other words, for every line in the Import worksheet there needs to be a counterpart in the Export worksheet.

Though the DSU will function without this relationship, the detail auditing capabilities will be forfeited. To perform the update audit, the DSU uses the Query SQL from the Export worksheet (which by itself retrieves the entire table) and combines it with the Import's Update Key along with the map worksheet's settings (row 2) to construct a query that will produce one and only one record. This is used to request the record from the database prior to the actual update to know exactly which fields are being changed.

The are two settings that connect the import control with the export control: the configuration worksheet and the name of the database. On the Import worksheet, these come from the "Import sheet name" and "Database Table Name" columns. On the Export worksheet, they come from the "Export sheet name" and the "Query SQL".