Error File Format of Bulk Update Import Process
When the Bulk Update import process is Completed with Errors, a list of erroneous files is generated in a Microsoft Excel file (.xls).
Use any of the following methods to download the error file:
- Download the error file from the Import Data History Details window.
For more information, see Viewing Bulk Update Import Data History Details.
- Download the error file from the email notification you receive when the import process is Completed with Errors.
The error file contains the following worksheets/tabs:
- Instructions worksheet
The Instructions worksheet is generated automatically. Depending on the type of business processes included in the error file, this worksheet describes how to resolve errors identified in the BP records and line item data.
- Main Form worksheet
The Main Form worksheet contains a list of erroneous records that did not get imported into Unifier. It is generated automatically as the second worksheet in the error file. It is recommended to not rename or reorder this worksheet.
- Column A of the Main Form describes the error for each erroneous record.
Note: All line items associated with the erroneous record in the Main Form tab will not be validated. Therefore, the error file may not show all errors related to the line items for the erroneous record.
- The following fields/data elements in the worksheet are read-only: Record Status, Creator, Creation Date, Currency ID, Due Date, Status in WF, BP, Formula Data Elements.
- Data elements that are set to auto-populate from the sum of all line items data elements from the Integration Validation Form.
- The line item tab order is identical to the order in the selected records.
- Custom date formats are honored.
- The name of the worksheet is translated according to the user's language preference.
- Column A of the Main Form describes the error for each erroneous record.
- Line Item Tab Worksheets
Line Item tab worksheets with erroneous records are color-coded orange.
Each Line Item tab worksheet is organized as follows:
- Column A describes the error for each line item record.
- The line item records and the data elements of each tab display in the same order as in the user interface.
- Each line item record displays begins with read-only fields in the following order: Record ID, Line Item ID, Record number, and Line No. These fields cannot be renamed, reordered, duplicated, or removed from the file.
- The formula data elements and auto-populated data elements are read-only fields.
- Worksheet names do not support the following special characters: \ / ? * : [ or ]
Last Published Friday, April 11, 2025