Differences

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

--- technote:excel_import_container [2018/10/22 23:48] – 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 ======
-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]]
-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.
+<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>
-Set ''Reset Containers'' to true if you want container allocation purged before assigning volumes in the spreadsheet to their respective containers.
+Select Excel file by clicking in the ''Excel File'' field and clicking the more button (''...'') to select the Excel file.
-Select orientation of data in the excel sheet:
+{{technote:technote_excel_container_select_file.png}}
-  * **Horizontal** : Containers listed in columns and assigned volumes in rows
-  * **Vertical** : Containers listed in rows and assigned volumes in columns
-Set Customer and media defaults for the volumes if they are not listed in the spreadsheet as fully qualified barcodes.
+Select the required Excel sheet by clicking the ''Sheet'' field and then clicking on the drop box arrow and selecting from the presented options.
-Click ''Load'' to load data from the spreadsheet, 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_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.
-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.
+Click in the inventory window and press F5 to update display.
+{{tag>technote import container}}