Reusing the Error File Spreadsheet For Bulk Create Import Process

If the bulk create import process is Completed with Errors, an error file (.xls or .xlsm) is generated with a list of erroneous records identified by the import process. You can resolve these errors and reuse the error file to re-import the records.

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

The generated error file adheres to Error File Spreadsheet Format of Bulk Create Import Process by default.

To reuse the error file for re-import:

In the Main Form tab, resolve the errors identified for each BP record.
In the relevant Line Item tabs, if any, resolve errors corresponding to the BP record identified in the previous step.
In the Action column, select Update for each record. Otherwise, by default, the line item will not be updated when set to a Blank value.
After resolving all errors, delete Column A to clear all errors identified in the Main Form tab and relevant Line Item tabs.
Save the modified error file to prepare for import.
Import the error file as described in Importing the Excel File for Bulk Creating BP Records.

Related Topics