Bulk Loading a File¶
Completed Bulk Load XLS sheets can be loaded immediately, ensure that:
The file has a valid file extension
.xlsx. An error message will display on the user interface to indicate that the file does not have a valid file extension.Any configuration templates that are referenced, are available.
Any comments that your spreadsheet application allows you to add (for example showing as a marker in the cell with a pop-up) have been removed. Otherwise, an error message is shown:
“An error occurred while opening the workbook. For possible resolution, please remove all comments from the worksheets and try again. If the problem persists, contact your administrator for support.”
To send empty values for a file, type a space in the cell of the value column on the sheet.
Click Choose to open the file upload dialog.
Click Bulk Load on the button bar to carry out the bulk load.
Inspect the bulk load in the transaction log if necessary. The Execute Bulk Load sub-transaction list shows the transaction for each row of the sheet.