TapeTrack Documentation

Because there is more to tape management than you ever realized

User Tools

Site Tools


technote:report:windowspdf

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
technote:report:windowspdf [2022/12/12 00:12] Scott Cunliffetechnote:report:windowspdf [2025/02/05 01:29] (current) Scott Cunliffe
Line 15: Line 15:
  
 Ensure TapeTrack Server Utilities are installed on the computer you want to run the report on. Ensure TapeTrack Server Utilities are installed on the computer you want to run the report on.
 +
 +<note>The directory ''tapetrack/reports'' has been created to illustrate the report process.  Set the directory structure on your computer to suit where you want to run and/or write the report to.</note>
  
 Methods to check: Methods to check:
  
 Open a command prompt and run the command ''TMSS10Inventory'', the output will show the utility options starting with  Open a command prompt and run the command ''TMSS10Inventory'', the output will show the utility options starting with 
- ''TMSS10Inventory (c) GazillaByte 1998-2020'' if Server Utilities have been installed.+ ''TMSS10Inventory (c) GazillaByte 1998-2020'' if Server Utilities have been installed.  
 + 
 +{{tmss10inventory7.png}}
  
 If the output shows ''TMSS10Inventory is not recognized as an internal or external command, If the output shows ''TMSS10Inventory is not recognized as an internal or external command,
-operable program or batch file.'' you will need to install the Server Utility package, available for download [[http://mirror-us.tapetrack.com/Windows-x64/utils/setup.exe|here]].+operable program or batch file.'' you will need to install the Server Utility package, available for download [[https://mirror-us.tapetrack.com/Windows-x64/utils/setup.exe|here]]. 
 + 
 +{{tmss10inventory8.png}} 
 + 
 +Look under the TapeTrack installation folder (default C:\Program Files\TapeTrack\) to see if there is a directory ''TapeTrack Server Utilities'' 
 + 
 +{{tmss10inventory6.png}} 
  
  
Line 33: Line 44:
 ===== Create Batch File ===== ===== Create Batch File =====
  
-Create a batch file in the desired location and name it with a descriptive name, eg C:\tapetrack_reports\run_InventoryReport.bat+Create a batch file in the desired location and name it with a descriptive name, eg C:\tapetrack\run_InventoryReport.bat 
 + 
 +{{tmss10inventory4.png}}
  
 ===== Coding The Report ===== ===== Coding The Report =====
  
 Open the batch file in Notepad or other plain text editor. Open the batch file in Notepad or other plain text editor.
 +
 +{{tmss10inventory5.png}}
  
 ==== Report Variables ==== ==== Report Variables ====
Line 47: Line 62:
 |''TMSSPDFORIENTATION''| Sets the orientation of the report, options are landscape or portrait| |''TMSSPDFORIENTATION''| Sets the orientation of the report, options are landscape or portrait|
 |''TMSSPDFPAGESIZE''| Sets the page size, options are letter, legal or A4| |''TMSSPDFPAGESIZE''| Sets the page size, options are letter, legal or A4|
-|''TMSSPDFOUTPUTPATH''|Sets the output directory and file name|+|''TMSSPDFOUTPUTPATH''| Sets the output directory and file name|
  
  
 Batch file code example: Batch file code example:
 +
 +
  
 <code> <code>
Line 68: Line 85:
 ^ Variable ^ Function ^ ^ Variable ^ Function ^
 |''TMSSPDFCOLORHDR''| Sets the color of the report heading| |''TMSSPDFCOLORHDR''| Sets the color of the report heading|
-|''TMSSPDFLOGOPATH''|Sets the path of the logo jpg image| +|''TMSSPDFLOGOPATH''| Sets the path of the logo jpg image| 
-|''TMSSREPORTTITLE''|Sets the report title|+|''TMSSREPORTTITLE''| Sets the report title|
  
 <code> <code>
 set TMSSPDFCOLORHDR=FF0000 set TMSSPDFCOLORHDR=FF0000
-set TMSSPDFLOGOPATH=+set TMSSPDFLOGOPATH=./invoice_logo.jpg
 set TMSSREPORTTITLE100=US01 Inventory set TMSSREPORTTITLE100=US01 Inventory
  
 </code> </code>
 +
 +{{tmss10inventory2.png}}
  
 === Customize Columns === === Customize Columns ===
Line 87: Line 106:
  
 ^ Variable ^ Function ^ ^ Variable ^ Function ^
-|''TMSSREPORTCOLUMNDELETE''|Removes specified columns from the report| +|''TMSSREPORTCOLUMNDELETE''| Removes specified columns from the report| 
-|''TMSSUNQUALIFIEDVOLUME''|Removes Customer-ID and Media-ID, displaying [[concepts:qualified_barcode|unqualified barcode]]+|''TMSSUNQUALIFIEDVOLUME''| Removes Customer-ID and Media-ID, displaying [[concepts:qualified_barcode|unqualified barcode]]
 + 
 +<code> 
 +set TMSSREPORTCOLUMNDELETE=1,5,8,9,10 
 +set TMSSUNQUALIFIEDVOLUME=true 
 +</code> 
 + 
 +{{tmss10inventory3.png}} 
 + 
 +==== Final Batch File ==== 
 + 
 +<code> 
 +:: Final batch file code 
 +:: PDF Inventory Report 
 +:: Output to file Inventory_Report_US01.pdf 
 +:: Custom Title with logo 
 +:: Columns 1,5,8,9,10 removed from report 
 +:: Volumes displayed unqualified volume-ID 
 +:: Report limited to Customer-ID US01 
 + 
 +set TMSSREPORTFORMAT=PDF 
 +set TMSSPDFORIENTATION=landscape 
 +set TMSSPDFPAGESIZE=letter 
 +set TMSSPDFOUTPUTPATH=./Inventory_Report_US01.pdf 
 +set TMSSPDFCOLORHDR100=FF0000 
 +set TMSSPDFLOGOPATH=./invoice_logo.jpg 
 +set TMSSREPORTTITLE100=US01 Inventory 
 +set TMSSREPORTCOLUMNDELETE=1,5,8,9,10 
 +set TMSSUNQUALIFIEDVOLUME=true 
 + 
 +TMSS10Inventory -S user:-password@serveraddress -V US01.*.* 2> err.txt 
 + 
 +</code>
  
  
 +{{tag> technote report pdf cli}}
technote/report/windowspdf.1670803951.txt.gz · Last modified: 2025/01/21 22:07 (external edit)