Don't forget: Backup your data sources!
After Setting up an Import you can start importing actual records.
The import form shows 2 or 4 columns:
To see what records the source will provide and how will import will go, you can move back and forward (Move First, Move Back, Move Next, Move Last)
Hide unchanged fields - for those fields which are checked in one of the Setup tabs. The purpose of this feature is to only show data which the user considers relevant to reduce information overload with the user. Data that was not changed is considered likely not to be interesting.
This button can have three values:
The field(s) that prevent processing color orange. The cursor automatically jumps to that field, and the yellow box shows a message explaining what causes the failure:
You can fix the failure with a field's New Value by
If the Import Method (table row) turns orange this means you try to Add a record for which there already exists a record, and you didn't allow Replace.
If the number of fields is large, you can use the [!] button to find the first field with an error.
Pressing this button starts processing all values
Whenever you want to stop the processing, just press the button again [STOP]
Checkbox to determine if Process All will continue with the next record if pre-process validation fails (skip record). This allows you to process all records without having to be present.
The [yellow comments box] shows information on what prevents a record from being processed.
Pressing button [Find error] moves the cursor in the Transfer Pane to the first row that causes a problem. This is useful in case there are many fields involved in the import.
Processing goes faster if you check this when you click Process All Records. The speed is obtained because the fields for each record do no longer refresh with each processed record. The downside is that you no longer see exactly what is being processed, which may be confusing.
The progress bar shows the percentage of source records that has been processed. The numbers in the colored boxes indicate
Pressing button [Reset] calculates from fresh how many records are in the source table/query and sets the progress indicators to 0
The large textbox on the right helps seeing the content of larger fields, such as memo texts.
Copy New Value to Clipboard
|Tutorials on how to work with Import and Validate|