====== 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}}