Appending to tables during subsequent imports


During subsequent imports, you can optionally append to files listed as “Reloaded each import” in the “Subsequent imports” column of the e-timecard master files table. This means that e-timecard updates existing data rather than replacing it.

To select this option, you click the Append to Table check box on the Import from Third Party screen. When you import all master files at once, you cannot selectively apply this option to specific files. Your setting for the Append to Table check box applies to all applicable master files for that import.

The following table shows different scenarios during a subsequent import, depending on whether you choose to append to tables.

Append option checked?

Program finds duplicate entry

Before importing, you set status of a record to inactive

Yes

Replaces it with imported data.

Updates the status.

No

Generates a duplicate error message.

Does not update the status.

The import program automatically appends to any files listed in the e-timecard master files table as “Synchronized” in the “Subsequent imports” column. If you import any of these files individually, then the Append to Table check box does not appear.