====== Importing Volumes And Volume Data From Excel Spreadsheets ======

The Excel Import utility is invoked through [[master:tools_excel_import|TapeMaster]] or [[lite:function_excel_import|Lite]]

Once the Excel Import window is open:
  * Select the [[object:customer|Customer]] you wish to import the data into.
  * Select the Excel sheet to import the data from.
  * Select the [[object:media|Media]] type if the [[object:volume|Volumes]] all belong to one [[object:media|Media]] type.
  * Set Skip First Row to true if there are headings present.
  * Map the Excel columns to the TapeTrack [[object:volume|Volume]] Attributes.
  * Insert any translations required to match the data to the correct format for TapeTrack.

{{:lite:lite_excel_import_data.png}}

**__Notes__**

  * **A** Excel .xls file being imported.
  * **B** [[object:customer|Customer]] and [[object:media|Media-ID]] ([[object:media|Media-ID]] can be mapped from Excel file or set here).
  * **C** Skip first row if headings are present.
  * **D** Excel sheet data.
  * **E** Excel sheet column headings.
  * **F** TapeMaster Attributes.
    * ''Container-ID'' Container ID to assign [[object:volume|Volume]] to.
    * ''Date (Expiry)'' Expiry date of [[object:volume|Volume]] .
    * ''Date (Last Write)'' Date the [[object:volume|Volume]] was last written to.
    * ''Date (Next Move)'' Date for [[object:volume|Volume's]] next move (i.e. return date from [[object:repository|Repository]]).
    * ''Description'' [[object:volume|Volume]] description.
    * ''Media-ID'' [[object:media|Media-ID]] [[object:volume|Volumes]] belong to (can also be set on left window if all [[object:volume|Volumes]] are same [[object:media|Media]] type).
    * ''Repository Slot (Target)'' Target slot to assign [[object:volume|Volume]] to.
    * ''Repository-ID (Scanned)'' [[object:repository|Repository]] [[object:volume|Volume]] is to be scanned in at.
    * ''Repository-ID (Target)'' Target [[object:repository|Repository]] [[object:volume|Volume]] is to be placed in a move to.
    * ''Volume-ID'' [[object:volume|Volume's]] [[concepts:barcode|Barcode]].
  * **G** Translations of Excel data to TapeMaster format (i.e. offsite to OFFS). 
  * **H** Forward and back buttons allow you to scroll through the Excel data rows to check data input.
  * **I** Load Excel data into Import Verification window.

Once all the data columns are mapped and any translations required are entered (press enter first if focus is still in translations field to update) click ''Load Rows'' to import data from the Excel sheet.  

{{:lite:lite_excel_import_data_load.png}}

In the window that opens select all [[object:volume|Volumes]] to add or update from the displayed list.

Select [[object:volume|Volumes]] from the list by
  * left-click for a single [[object:volume|Volumes]].
  * Shift + click to select a range of sequential [[object:volume|Volumes]].
  * Control + click to select non sequential range.
  * Right-click and from the menu select all.

Any new [[object:volume|Volumes]] (not present in TapeTrack) will be highlighted by the [[object:volume|Volume-ID's]]  displayed in red.  These [[object:volume|Volumes]] must be added to TapeTrack before any updates can be applied.  To add the [[object:volume|Volumes]], once selected, right-click the [[object:volume|Volumes]] and from the popup menu select ''Add''.  Once the [[object:volume|Volumes]] have been added the [[object:volume|Volumes-ID's]] will now display in black.

{{:lite:lite_excel_import_data_load_add.png}}

To update the [[object:volume|Volumes]] Attributes (Description, [[object:repository|Repository]], next move etc.) select the required [[object:volume|Volumes]], right-click and select ''Update''.

{{:lite:lite_excel_import_data_load_update.png}}

During the Add or Update phases you may see a popup showing you the progress of selected operation.

{{:lite:lite_excel_import_progress.png}}

Once this has closed itself you may continue on with the next phase or close the import window if finished.
Select ''X'' to close.

{{tag>technote update-doco import tapemaster lite excel}}