Differences

This shows you the differences between two versions of the page.

--- technote:excel_import_container [2018/10/22 23:16] – created Scott Cunliffe
+++ technote:excel_import_container [2025/01/21 22:07] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-====== Excel Import Container Table ======
+====== Excel Import - Container Table ======
+The Excel Import - Container Table utility is [[master:excel_import_container|invoked through TapeMaster]]
+<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}}
+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:
+  * ''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.
+{{technote:technote_excel_container_reset.png}}
+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}}
+  * ''Vertical'' : Containers listed in rows and assigned volumes in columns \\ {{technote:technote_excel_container_vertical.png}}
+In the fields under the heading **Defaults**, set Customer and media defaults for the volumes if they are not listed in the spreadsheet as fully qualified barcodes.
+Click ''Load'' to load data from the spreadsheet.
+{{technote:technote_excel_container_load_file.png}}
+Checking volume quantities assigned to each container are correct.  If required, you can view each container's listed assigned volumes by clicking the ''+'' on the left of each container.
+{{technote:technote_excel_container_confirm.png}}
+Click ''Apply'' to upload data to the TapeTrack Server Database and ''Yes'' to commit the data upload.
+{{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.
+Click in the inventory window and press F5 to update display.
+{{tag>technote import container}}