Error File Format for the Bulk Create and Update Import Process

When the Bulk Create or Bulk Update import process completes with errors, the system generates a Microsoft Excel error file (.xls) that contains a list of erroneous files.

Use one of the following methods to download the error file:

  • In the Import Data History Details window, download the error file.
  • In the email notification that you receive when the import process completes with errors, download the error file.

For more information, see Viewing Bulk Update Import Data History Details.

The error file contains the following worksheets/tabs:

  • Instructions:Unifier generates this worksheet automatically. Depending on the BP types included in the error file, this worksheet describes how to resolve errors in the BP records and line item data.
  • Main Form: This worksheet contains a list of erroneous records that did not import into Unifier. It is generated automatically as the second worksheet in the error file. Do not rename or reorder this worksheet.
    • Column A of the Main Form describes the error for each erroneous record.

      Note:

      Line items associated with an erroneous record in the Main Form worksheet are not validated. As a result, the error file might not show all errors for those line items.
    • The following fields and data elements (DEs) in the worksheet are read-only:
      • Record Status
      • Record Status
      • Creator
      • Creation Date
      • Currency ID
      • Due Date
      • Status in WF
      • BP
      • Formula Data Elements
      • DEs that auto-populate from the sum of all line item DEs in the Integration Validation Form
    • The line item tab order matches the order of the selected records.
    • Custom date formats are supported.
    • The worksheet name is translated according to the user's language preference.
  • Line Items worksheets: Line Items worksheets with erroneous records are color-coded orange. Each Line Items worksheet is organized as follows:
    • Column A describes the error for each line item record.
    • Line item records and the DEs for each tab appear in the same order as in the user interface.
    • Each line item record begins with the following read-only fields in this order: Record ID,Line Item ID, Record number, and Line No. These fields cannot be renamed, reordered, duplicated, or removed from the file.
    • Formula DEs and auto-populated DEs are read-only.
    • Worksheet names do not support the following special characters: \ / ? * : [ or ]