TapeTrack Documentation

Because there is more to tape management than you ever realized

User Tools

Site Tools


lite:function_excel_import

This is an old revision of the document!


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.

Managing Volumes

Once logged into TapeTrack Lite, select Excel Import from the drop-down menu.

Select the Excel file to import the data from

In the TapeTrack Excel import tool select the: * Customer you wish to import the data into * Media type if the volumes all belong to one media type * Set skip first row to true if there are headings presents.

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/function_excel_import.1498657941.txt.gz · Last modified: 2025/01/21 22:07 (external edit)