Show/Hide All

 Overview

When importing from an external file, it may be necessary to ignore records that do not contain applicable information. You can define records that should be skipped (ignored), such as header records and marker records. You can define any number of skip records.

If you are importing into a data file that does not use multiple record types, you can define standard records to import. Standard records are the opposite of skip records in that you are identifying the records to import. Any record not identified as a standard record will be skipped. You can define any number of standard records.

Note The Standard Record type is used only if the data file does not contain multiple records.

 

To define skip records and standard records

1. Select Visual Integrator Main menu > Import Job Maintenance.

2. In the Import Job Selection window, enter a job name and table name, and then click Accept. For more information, see Import Job Selection - Fields.

3. In the Import Job Maintenance window, enter the appropriate information on the Configuration, Data, and Select tabs. Click the Records tab.

4. To define records to skip, perform the following steps:

1. In the Available Record Types list box, select the Skip Record option.

2. Click the Add button.

3. In the Record Properties window, enter the field position, relation, and value to identify the record to skip.  

4. Click Accept.

5. To define standard records, perform the following steps:

1. In the Available Record Types list box, select the Standard Record option.

2. Click the Add button.

3. In the Record Properties window, enter the field position, relation, and value to identify the record.

4. Click Accept.

You have defined skip records and standard records for the import job.