Reusing the Error File for Bulk Create Import

If the Bulk Create import process completes with errors, the system generates an error file (.xls or .xlsm) that contains a list of the erroneous records. You can resolve the errors and reuse the error file to import the records again.

Note:

You must have the Allow Bulk Creation permission to import or re-import BP records by using a Microsoft Excel spreadsheet (.xlsx or .xlsm) from the Master Log grouping node.

By default, the generated error file uses the Error File Format for the 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 column, select Update for 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 Importing the Excel File for Bulk Creating BP Records.