Details
The Detail panel summarizes the setup info which was collected by the Import Wizard. Before proceeding, there are additional fields in the Destination Table section below which should be reviewed.
You must specify additional Database import operation and Unique target fields below before saving the import app.
Source Connection
This section contains the (optional) Data Connection, Library and Filename used to fetch the file.
The displayed fields will vary depending on the type of source file method was used (upload, fetch, POST).
Destination Table
The Target Table chosen during the wizard is displayed. The following additional items should be provided:
| Field | Notes |
|---|---|
| Database Import operation | Update The row will be updated if it can be found Append The row will be inserted |
| Select Unique Target Field | When Updating, chose one or more target fields which solve for uniqueness of the incoming data (e.g. Code) |
Our design pattern for User Tables is to use Code as the unique identifier for items, and Description as the general name or description. However, certain entries may require the combination of two fields, such as Code and TransactionDate as in the case of a balance or other date-sensitive data.
Failure to properly set the Unique Target Field can result in duplicating or orphaning data. Be sure to review the this value in after completing the Mapping section later to insure you are selecting the correct fields.