Rice Lake TransAct 5.0 - Installation & Operation Manual User Manual

Page 161

Advertising
background image

150

Field Descriptions

Duplicate Record Processing

You can select which behavior the program should use when it encounters a record in the
import text file that is already in the database.

Update

Always update the database with data from the import
text file.

Add Only

Ignore duplicate records in the import text file.

Ask

Ask the operator on a case by case basis what to do with
duplicate records. The operator will be presented with a
list of duplicate records and can choose which ones to
accept or reject.

Merge Only

This is the opposite of the Add Only option. Only import
records that already exist in the database will be
processed.

Case Insensitive Compare

The Import/Export Utility considers a record as duplicate when every field in the
imported record equals the corresponding field in the database record. When checked, the
compare for a duplicate record is case insensitive for text fields. In other words, ABC
equals abc.

Import Change Log

Normally, only statistics and error messages are placed in the log file. You can choose to
include the following additional information:

Duplicate Reject Log

Include the list of duplicate records that were
rejected.

Criteria Reject Log

Include the list of records that were rejected
because they didn't meet all selection criteria.

No Change Log

Do not include additional information in the log
file.

Import depends on previous Import Success

Advertising