Background
Large uploads from the Wizard can be slow depending on the structure of the data to be uploaded. The slowest data structure to load is where there is a one header to one child.
When uploading large amounts of data, background processing is recommended to prevent timeout. This option works the same as uploading a single or range of Bill of Materials.
This option will perform validation but will create a concurrent request to upload the Bill of Materials.
Every validated Bill of Material is processed in this request. To view the request, click on the ‘View Concurrent Request’ icon on the ribbon. Once the request has ‘Completed’ click ‘Refresh API Status’ on the ribbon and the upload messages will return to the worksheet.
Note – If this option is not available on your version of the Wizard, then you will need to download the latest version and packages from the website.
Pros/Cons
Cons:
Return results requires an extra step.
Return results rely on sheet data not being manipulated.
Pros:
Loads large data sets more quickly.
Separates API server processing from wizard processing.
On the Bill of Materials ribbon select ‘Validate Concurrent’ from the ‘Validate Option’, and then click the ‘Upload’ icon and select ‘Upload Selected’ or ‘Upload All’.
After running a concurrent Upload, the Status columns on the sheet will show ‘Pending’ indicating which Bills of Materials were uploaded, or ‘Error’ indicating which Bills of Materials were not included in the upload due to the Bills of Materials Wizard validation finding an issue.
The next step is to view the Concurrent Request form to determine the Phase and Status of the request.
Click the ‘View Concurrent Request’ icon on the Bill of Materials ribbon to open the Concurrent Request form. This determines the Phase and Status of the request.
View Concurrent Request
Request ID: Optionally enter the Request ID from row 6 (look under the Logo) on the sheet to show only the needed Request.
Refresh: Update the concurrent form to show the latest Phase and Status.
Log: If the Request errors, select ‘log’ to view the request logfile.
Refresh API Status
Once the request has been completed, click ‘Refresh API Status’ on the Concurrent tab on the Routing Wizard ribbon to return the results to the sheet.
Notes:
· Keep uploads to less than 10,000 rows.
If larger uploads are required split them into multiple uploads of 10,000 on different sheets.
· Don't delete or add rows or manipulate the sheet when it is in the pending state. This will cause the return results to be returned to the wrong rows.
· Do not interrupt excel during the upload process or the refresh process. If need to use excel during this time do so in a new/different excel session.
· Uploads (on different sheets) can be performed while waiting for the concurrent job to finish.
Do not perform multiple uploads on one sheet - unless you performed a successful refresh.
· Data can be refreshed later.
· You will not be prompted to load attachments. This can be done manually AFTER the concurrent request has completed and you have refreshed the sheet.
To load attachments, click the ‘Attachments’ icon and select ‘Upload All Attachments’ or ‘Upload Selected Attachments’.
· The client PC may be subjected to significant resource use. We have seen RAM usage of 3-6GB and CPU usage up to 60%.
Refer to section:
