Differences

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

--- lite:function_excel_import [2017/06/28 14:13] – Scott Cunliffe
+++ lite:function_excel_import [2025/01/21 22:07] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ====== Excel Import ======
-The Excel import task allows you to import volume data from an excel xls file by mapping the Excel values to TapeTrack attributes.
+The Excel Import task allows you to import [[object:volume|Volume]] data from an Excel .xls or .xlsx file by mapping the Excel columns to [[object:volume|Volume]] values and Attributes.
-===== Managing Volumes =====
+===== Excel Import Process =====
-Once logged into TapeTrack Lite, select Excel Import from the drop-down menu.
+==== Select Excel Import ====
+Select ''Excel Import'' from the **Task Menu** and click ''Next'' to continue.
 {{:lite:lite_excel_import.png}}
-Select the Excel file to import the data from
+Detailed information on this function can be viewed in the [[technote:excel_import|technotes section]].
-{{:lite:lite_excel_import_xls.png}}
-In the TapeTrack Excel import tool select the:
-  * Customer you wish to import the data into
-  * Select the Excel sheet to import the data from
-  * Media type if the volumes all belong to one media type
-  * Set skip first row to true if there are headings presents.
-  * Map the excel columns to the TapeTrack 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** Customer and Media ID (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
-  * **G** Translations of Excel data to TapeMaster format (i.e. offsite to OFFS)
-{{:lite:lite_excel_import_data_load_add.png}}
+<- lite:function_scsi_console|SCSI Media Console ^ lite:advanced|Advanced ^ ->
-<- lite:function_scsi_console|SCSI Media Console ^ lite:starting|Getting Started ^ ->