Correcting Errors Offline

For a particular file load, you can export all party records with errors to a file for offline correction. The exported file contains only the records with errors, and the file header, if any exists in the original source file.

Each line in the exported file contains all the attributes for a party record, in the order that the attributes and records appear in the source file. The exported file uses the format that is defined for the source file, for example the same column delimiter. See: Defining File Loads.

Suggestion: To see which attributes to correct offline, you can view the errors that are correctable online by attribute. See: Correcting Errors by Attribute. The exported records, however, can contain errors that are not correctable online.

After you export for offline correction, the file load status is Partially Completed with Errors, Awaiting Reload. The file load is totally complete after you load the exported file with all errors resolved. If there are still errors after a reload, you can re-export and reload until you correct all errors.

Related Topics

Reloading Offline Corrected Records

Prerequisite

Single quotation marks are automatically added to the beginning and end of each record in the exported file. You must remove those marks before loading the file. See: Prerequisites.

Procedure

  1. Search for and select the original file load to load the corrected records for. See: File Loads Overview.

  2. Provide the location of the exported file with corrected party records.

  3. Review the load of the corrected records. This reload occurs with the same file load definition and mapping as the original source file. You also preview the corrected records to reload. See: Reviewing File Load Details.