Bill of Materials Wizard

×
Menu

Upload Options

 
 
Upload Selected
 
Once you have selected the relevant validation options you can upload a single or range of Bills of Materials in the worksheet.
 
 
Use the cursor to select your single or range of Bill of Materials to upload, making sure you have included the first line of each Bill of Materials to be uploaded.
The columns selected are NOT important.
 
The Wizard looks through the spreadsheet only between the top and bottom of the range you have indicated. 
If you have selected a range and only included the first line of the last Bill of Materials to be uploaded, the Bill of Materials Wizard will continue past the end of the selected range if necessary, to include the entire last Bill of Materials.
 
Check that the relevant Validate option is selected in the ribbon.  Click the ‘Upload’ icon on the Bill of Materials ribbon and select ‘Upload Selected’.
 
The Wizard will validate all the details in the worksheet for the selected Bills of Materials (including Components, Substitute Components, Reference Designators and Assigned Operations), and upload where upload actions exist.    
 
Upload All
 
To upload all records on your worksheet, check that the relevant validation option is selected on the ribbon.  Click the ‘Upload’ icon and select ‘Upload All’ in the Bill of Materials ribbon.
 
 
This upload option ignores the cursor location and goes straight to row 11 to begin uploading the entire worksheet.  It skips Bills of Materials with the Accepted status in the ‘Upload Result’ column.
 
Refer to section: