Microsoft Excel Format for Creating BP Records

The following applies to all business Processes where BP records can be created, in bulk, by way of CSV import.

Note: The Request for Bid business process (RFB BP) does not support bulk creation of records through CSV.

The following does not apply to managers such as Space Manager, Portfolio Manager, Configurable Managers, Code and Records-based Configurable Managers, and Code-based Configurable Managers that allow the creation of records by way of CSV import.

To create BP records, in bulk, through Microsoft Excel:

  1. In your Shell go to the Logs grouping node (BP Logs) node and select a BP to open the BP log.
  2. From the toolbar options, click Actions, and click Export Microsoft Excel Template. This option is only available for the users with View permission, to the log.

To be able to download your Excel template the integration interface must be defined for the BP record. If the BP record does not have a defined integration interface, the entire import will be aborted and no BP records or BP line items will get created. In such scenario, Unifier displays the following error message: "Import could not be completed. There are errors in this template file. These errors can be seen in the Import Data Template worksheet. Do you want to download the file and fix the errors? Click 'Yes' to download the file and 'No' to upload a different template file."

MS Excel Template File

When you export your template file, the name of the exported template file will have the following format: <BPName>_Template

Note: The name will always be the source string without spaces.

Example

If the BP name is Daily Reports, then the template file name will be: DailyReports_Template.

MS Excel Template File Worksheets

The exported template file will have the following worksheets:

Instructions worksheet

This worksheet is generated automatically, and you cannot change the name of this worksheet. The Instructions worksheet contains all of the relevant information about entering the BP record and line item information data. The content of the instructions worksheet will depend on the type of business process.

Imported Data Template worksheet

This worksheet is generated automatically, and you cannot change the name of this worksheet. Always set by Unifier as the second worksheet in the template file, this worksheet contains the Unifier data needed for creating BP record and line item.

Note: The name of this worksheet will be translated according to the user's language preference.

The top section of this worksheet is dependent on the business process type.

<Other User-Defined> worksheet

A user may insert additional sheets for their reference. These sheets will not be processed by Unifier at the time of import.

This worksheet will not be processed by Unifier. An end-user (you) can add multiple worksheets.

Note: The content of this worksheet will be ignored at the time of import.

Entering Data in the Microsoft Excel Template File

The following explains the general rules for entering data in the Excel template file.

You need to use the Import Data Template option in order to be able to enter data and ultimately create records, or to create records with line items.

Note: Review the information on the Instructions worksheet to minimize the import errors.

When entering data, you can:

For all data types, Unifier will only process the data and not the format, when importing.

Example

A user may have entered -999.99 and the format on the cell may have been (999.99), and the user will see the data in Excel as (999.99). When Unifier processes this data, -999.99 will get processed and not (999.99).

Creating BP Records by way of Importing a Microsoft Excel Template

To create BP Records by way of Importing MS Excel Template, click the Import option (Actions > Import), select the Data From Microsoft Excel File sub-option, and follow the prompts.

The Import option has the following sub-options:

Note: These options are displayed for users who can create new BP records.

Uploading

When you upload an Excel file, in the Upload Microsoft Excel File window (similar to the CSV), you can select the Excel file (using the Select File option) and click Next to proceed with your upload. See below for information about adding attachments.

Validating Microsoft Excel File Content

There are multiple levels of validations that take place during the file import process. These include:

After the initial validation ends, the file is processed further. At this stage, all validations pertaining to system-level rules as well as user-defined form-level validations are performed. In the event of a failure, an email notification with the reason for failure is sent to users and groups identified in the business process setup.

Errors and Corrections

When an error is encountered in any of the rows, the entire import will be aborted and no BP records or line items will get created. As mentioned earlier, when the import file contains errors, Unifier will alert the user with the following message: "Import could not be completed. There are errors in this template file. These errors can be seen in the Import Data Template worksheet. Do you want to download the file and fix the errors? Click 'Yes' to download the file and 'No' to upload a different template file."

Additional Information Regarding Importing a Microsoft Excel Template File

The name of a downloaded file is identical to the name of the imported Excel template file. If you decide to download a file with errors, the Import Data Template worksheet displays errors in the following format:

Adding Attachments

Similar to the CSV file import, you can add attachments. You can upload all the referenced attachments in the Add Attachments section. You can use the Upload Microsoft Excel File window (in the 'Add Attachments' step) to add attachments to your BP record, or line item, during your import. The review section on the screen enables you to see the files that have been uploaded and the files with upload pending.

For example, when you upload the Microsoft Excel file, all attachments listed in the Excel file display in the Files to be Uploaded section. When, you upload each file, the status of the file changes from Waiting for File to Ready to be uploaded.

In the Review section, you can perform sort operations on the Status column.

When you click Upload, Unifier uploads the attachments onto the respective BP record, or line item, as required.

Validating Added Attachments

When you upload your attachments, Unifier performs validations and:

For validating a BP record level Excel import:

When creating BP records by way of using Excel file import from the BP log, Unifier does not retain the Attachment option that was used in the validation form of the integration interface. If you decide to import the attachments while using Excel import, Unifier will allow the import action. If there are files that have been referenced in the Attachments column of the Excel file and Unifier cannot find the files in the attachment payload (attachment missing), the Attachments table will provide the following informational text: Some files are still waiting to be uploaded. Do you want to proceed without uploading those files? If you click OK, Unifier will ignore the missing attachments (from the Excel file) and creates BP records, or line items, without any attachments. If you click Cancel, you will be returned back to the 'Upload Attachments' step of the upload process.

If the Status value for some of the files in the review section states Waiting for the file, and you click Upload, then the Attachments table will provide the following informational text: Some files are still waiting to be uploaded. Do you want to proceed without uploading those files? If you click OK, Unifier will ignore the missing attachments (from the Excel file) and creates BP records, or line items, without any attachments. If you click Cancel, you will be returned back to the 'Upload Attachments' step of the upload process.

For validating a line item level Excel import:

When you proceed with a line item import, from a Line Item tab, if the option Upload documents from My Computer is not selected in the design, then you cannot add attachments, and the Attachments table will provide the following informational text: Uploading of Attachments is not allowed.

If there are files that have been referenced in the Attachments column of the Excel file and Unifier cannot find the files in the attachment payload (attachment missing), the Attachments table will provide the following informational text: "Some files are still waiting to be uploaded. Do you want to proceed without uploading those files?" If you click OK, Unifier will ignore the missing attachments (from the Excel file) and creates the line items, without any attachments. If you click Cancel, you will be returned back to the Upload Attachments step of the upload process.

If there are files uploaded in the attachment payload, but the uploaded files are not present in the Files to be Uploaded section of the Excel, Unifier will not upload those files. In this scenario, the Status value will not change in the review section, for the files.

Audit Log

Each BP record created through Microsoft Excel import will be audited. The following is the audit attributes:



Last Published Thursday, June 5, 2025