Fairbanks InterAct FB3000 Series - Manual (Page 84)

50772 84 12/04 Issue # 2
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
The Import/Export Utility can be invoked from a command line. As an example, the following
command line will start Import/Export and execute routines Import001, Import002 and Import003:
ImpExp.exe Autogo Import001 Import002 Import003
There may be situations where if Import001 fails, then the remaining imports should not be
attempted. Check this box to force this condition. This option applies to import routines only.
Force unimported fields to default values
Errors will occur when an imported field has no data (blank or empty) in the text file and the
database requires a value. Check this box to force the value of required fields to the default
specified in the database when no data is present in the import text file.