TapeTrack Documentation

Because there is more to tape management than you ever realized

User Tools

Site Tools


lite:function_excel_import

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
lite:function_excel_import [2017/06/26 16:58] Scott Cunliffelite:function_excel_import [2025/01/21 22:07] (current) – external edit 127.0.0.1
Line 1: Line 1:
 ====== Excel Import ====== ====== 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}} {{: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}} +
- +
-{{: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.eoffsite to OFFS) +
  
-<- lite:function_scsi_console|SCSI Media Console ^ lite:starting|Getting Started ^ ->+<- lite:function_scsi_console|SCSI Media Console ^ lite:advanced|Advanced ^ ->
lite/function_excel_import.1498496321.txt.gz · Last modified: 2025/01/21 22:07 (external edit)