| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| technote:excel_import_container [2018/10/23 02:02] – 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 ====== |
| |
| Select Excel file by clicking on the right of the ''Excel File'' field | The Excel Import - Container Table utility is [[master:excel_import_container|invoked through TapeMaster]] |
| |
| {{technote:technote_excel_container_select_file.png?400}} | <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 the required excel sheet by clicking on the right of the ''Sheet'' field and then clicking on the drop box arrow and selecting from the presented options. | 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}} |
| | |
| | Select the required Excel sheet by clicking the ''Sheet'' field and then clicking on the drop box arrow and selecting from the presented options. |
| | |
| | {{technote:technote_excel_container_sheet.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}} |
| |
| Select orientation of data in the excel sheet: | From the field ''Orientation'' select orientation of data in the Excel sheet: |
| * ''Horizontal'' : Containers listed in columns and assigned volumes in rows \\ {{technote:technote_excel_container_horizontal.png}} | * ''Horizontal'' : Containers listed in columns and assigned volumes in rows \\ {{technote:technote_excel_container_horizontal.png}} |
| * ''Vertical'' : Containers listed in rows and assigned volumes in columns \\ {{technote:technote_excel_container_vertical.png}} | * ''Vertical'' : Containers listed in rows and assigned volumes in columns \\ {{technote:technote_excel_container_vertical.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}} |
