Reusing the Error File for the Bulk Update Import Process

If the bulk update import process completes with errors, the system generates an error file (.xlsx) that contains a list of erroneous records. You can resolve the errors and reuse the error file to import the records again.

Note:

You must have the Allow Bulk Edit permission to import or re-import BP records by using a Microsoft Excel file (.xlsx) from the Logs grouping node.

By default, the generated error file uses the Error File Format of Bulk Create and Update Import Process.

To reuse the error file for import:

1. In the Main Form worksheet, resolve the errors for each BP record.
2. In the relevant Line Items worksheets, if any, resolve the errors for the BP record in the Main Form worksheet.
3. In the Action field, select Update each record.

   Otherwise, the line item is not updated when the field is blank

4. After you resolve all errors, delete Column A in the Main Form worksheet and the relevant Line Items worksheets to clear the identified errors.
5. Save the modified error file.
6. Import the error file as described in Updating BP Records in Excel for Bulk Update from the Business Process Logs Node.