Creating the Excel File for Bulk Creating BP Records

When you use Bulk Create or Bulk Update, you start by exporting the BP design structure to a Microsoft Excel or CSV file and then populating the required fields. If you leave a Data Picker Data Element (DE) field blank that is configured to Auto Populate, the system completes the field when you run a Bulk Create; however, it does not complete the field when you run a Bulk Update. To reduce confusion and maintain consistency for both Bulk Create and Bulk Update, the system uses the Excel or CSV file to populate the Data Picker field if the field is excluded from the Integration Form for the BP design.

You must have Allow Bulk Creation permission to complete this task.

To bulk create business process records across projects/shells in the Excel spreadsheet:

Click the Home () tab.
In the left Navigator, select the Master Log - Business Processes node and select a specific business process.
Open the Business Process log in the right pane. For example, open the Action Item BP log.
Download a Shell Details Excel file to identify the projects/shells that will contain the new BP records you plan to create:
1. From the Actions menu of the business process log in the right pane, select Download and then select Shell Details.
2. Download and open the ShellDetails.xlsx file.
  For more details on the file contents, see Microsoft Excel File Format of Shell Details File.
  
  Note: The ShellDetails.xlsx file contains a list of all active projects/shells you can use to create BPs across projects/shells.
Download the template for creating BP records:
1. From the Actions menu in the right pane, select Download and then select Template for Record Creation.
2. Locate the downloaded file.
Open the downloaded <Selected BP Log Name>_bulkcreate.xlsx file. For example, open the ActionItem_Bulkcreate.xlsx file.
For more details on the downloaded file format, see Microsoft Excel File Format for Bulk Creating BP Records in the Master Log.
Add BP records in the Excel file as follows:
1. In the Main Form tab of the Excel file, enter the details of each BP record.
  Note: The combination of the Shell Number and Record Sequence Number must be unique for each BP record.
2. (Optional) To add line items to a BP record:
  1. Select the Line Item tab or any additional tab that may display based on the BP design in the Excel file.
  2. Copy the Shell Number and Record Sequence Number values from the Main Form Tab.
    To add multiple line items to the same BP record, use the same combination of Shell Number and Record Sequence Number, but with sequential values in the Line No. field.
  3. In the Line No. field, enter a sequence number for each line item.
  4. Enter details for each line item.
3. Repeat the previous step as needed to add multiple line items to the same BP record.
Repeat previous step to add BP records in multiple projects/shells.
Note:
- Use the unique combination of the Shell Number and Record Sequence Number specified in the Main Form tab in all subsequent tabs.
- If you rename any tabs with line items, the data in those tabs will not be processed.
Save the Excel file (.xlsx or .xlsm).
Import the data created in the Excel spreadsheet into Unifier.
For more details, see Importing the Excel File for Bulk Creating BP Records.

Related Topics