Running an Import

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:

  1. Destination: the table+field into which the data will be added or replaced.
  2. New Value: the values to be imported in the corresponding Destination Field
  3. Old Value: - only if import method is Replace (& Add) - shows the data in the record with the same key as the New Value, if it already exists
  4. Use Old Value (checkbox): check if you decide to keep the Old Value for a specific record. Hidden in case purpose is 'Add'

MoveFirst MoveBack MoveNext MoveLast No Changes - Next Process All Records Hide Fields If Unchanged Copy ToProcess ProcessOk ProcessFailed Find error Continue if errors Turbo Reset Comments

Navigation buttons

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 Fields If Unchanged (only visible for Replace)

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.

Process Record / No Changes - Next / Skip Record 

This button can have three values:

  1. Process Record: this is a new record, or in case of Replace the record contains changes  FF
  2. No Changes - Next: this value only occurs with Replace if no differences between field values have been found. Usually this means the user can press the button to move to the next record without much further thought.
  3. Skip Record: the values in the record prevent it from being processed. Either you have to manually change the field value(s) that prevent processing, or you can Skip the Record.
F

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

  1. typing a New Value for that field - or
  2. selecting one from the New Value's combo box - or
  3. checking Use Old Value

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.

Process All Records

Pressing this button starts processing all values

Whenever you want to stop the processing, just press the button again [STOP]

Continue if errors

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.

Comments

The [yellow comments box] shows information on what prevents a record from being processed.

Find error

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.

Turbo

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.

Progress bar and progress indicators

The progress bar shows the percentage of source records that has been processed. The numbers in the colored boxes indicate

Reset

Pressing button [Reset] calculates from fresh how many records are in the source table/query and sets the progress indicators to 0

New Value textbox

The large textbox on the right helps seeing the content of larger fields, such as memo texts.

Copy

Copy New Value to Clipboard

Tutorials on how to work with Import and Validate