| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| technote:excel_import_container [2018/10/23 02:26] – Scott Cunliffe | technote:excel_import_container [2025/01/21 22:07] (current) – external edit 127.0.0.1 |
|---|
| ====== Excel Import - Container Table ====== | ====== Excel Import - Container Table ====== |
| |
| <note tip>This utility can be [[master:excel_import_container|invoked through TapeMaster]]</note> | The Excel Import - Container Table utility is [[master:excel_import_container|invoked through TapeMaster]] |
| |
| Select Excel file by clicking in the ''Excel File'' field and clicking the more button (''..'') to select the Excel file. | <note important>Container barcodes must be either [[concepts:qualified_barcode|fully qualified]], or be distinguishable from all other barcodes and have a corresponding [[subsystem:barcode|barcode rule]] established in TapeMaster</note> |
| | |
| | Select Excel file by clicking in the ''Excel File'' field and clicking the more button (''...'') to select the Excel file. |
| |
| {{technote:technote_excel_container_select_file.png}} | {{technote:technote_excel_container_select_file.png}} |
| Set ''Reset Containers'' to: | Set ''Reset Containers'' to: |
| * ''True'' : (Default) Purges containers contained in the Excel sheet before assigning volumes. | * ''True'' : (Default) Purges containers contained in the Excel sheet before assigning volumes. |
| * ''False'' : leaves current volumes in the container and adds volumes in Excel sheet. | * ''False'' : Leaves current volumes in the container and adds volumes in Excel sheet. |
| |
| {{technote:technote_excel_container_reset.png}} | {{technote:technote_excel_container_reset.png}} |
| Click ''Apply'' to upload data to the TapeTrack Server Database and ''Yes'' to commit the data upload. | Click ''Apply'' to upload data to the TapeTrack Server Database and ''Yes'' to commit the data upload. |
| |
| When finished uploading, the *Failed Operations** window will be displayed with any errors encountered. Close this window by either clicking ''OK'' or the ''X'' at the top right. | {{technote:technote_excel_container_apply.png}} |
| | |
| | When uploading has finished, the **Failed Operations** window will be displayed with any errors encountered. Close this window by either clicking ''OK'' or the ''X'' at the top right. |
| | |
| | {{technote:technote_excel_container_failed_ops.png}} |
| |
| Close the import utility window by clicking ''Cancel'' or or the ''X'' at the top right. | Close the import utility window by clicking ''Cancel'' or or the ''X'' at the top right. |
| |
| | Click in the inventory window and press F5 to update display. |
| |
| | {{tag>technote import container}} |
