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/11 23:04] – [Ensure Server Utilities Are Installed] 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 [[here|http://mirror-us.tapetrack.com/Windows-x64/utils/setup.exe]] +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]]
-===== Select The report Required =====+ 
 +{{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}} 
 + 
 + 
 + 
 +===== Select The Report Required ===== 
 + 
 +Decide on the report required. 
 + 
 +In this example we are using TMSS10Inventory, for other report utilities available see [[cli/introduction#reporting-utilities|Server Utilities - Reports]] 
 + 
 +===== Create Batch File ===== 
 + 
 +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 ===== 
 + 
 +Open the batch file in Notepad or other plain text editor. 
 + 
 +{{tmss10inventory5.png}} 
 + 
 +==== Report Variables ==== 
 + 
 +Variables set different parameters relating to how the report is configured and what output gets written to or dropped from the report. 
 + 
 +^ Variable ^ Function ^ 
 +|''TMSSREPORTFORMAT''| Sets the report output to PDF| 
 +|''TMSSPDFORIENTATION''| Sets the orientation of the report, options are landscape or portrait| 
 +|''TMSSPDFPAGESIZE''| Sets the page size, options are letter, legal or A4| 
 +|''TMSSPDFOUTPUTPATH''| Sets the output directory and file name| 
 + 
 + 
 +Batch file code example: 
 + 
 + 
 + 
 +<code> 
 + 
 + 
 +set TMSSREPORTFORMAT=PDF 
 +set TMSSPDFORIENTATION=landscape 
 +set TMSSPDFPAGESIZE=letter 
 +set TMSSPDFOUTPUTPATH=./Inventory_Report_US01.pdf 
 + 
 +</code> 
 + 
 +{{tmss10inventory1.png}} 
 + 
 +=== Customize Report === 
 + 
 +^ Variable ^ Function ^ 
 +|''TMSSPDFCOLORHDR''| Sets the color of the report heading| 
 +|''TMSSPDFLOGOPATH''| Sets the path of the logo jpg image| 
 +|''TMSSREPORTTITLE''| Sets the report title| 
 + 
 +<code> 
 +set TMSSPDFCOLORHDR=FF0000 
 +set TMSSPDFLOGOPATH=./invoice_logo.jpg 
 +set TMSSREPORTTITLE100=US01 Inventory 
 + 
 +</code> 
 + 
 +{{tmss10inventory2.png}} 
 + 
 +=== Customize Columns === 
 + 
 +When outputting to PDF, as the report includes a lot of data, you may find columns overlap on the report.   
 + 
 +The reason there is to many columns for the space available in a PDF format is because the report is customizable, the choice of which columns to include or discard is left to the client to decide rather that make the choice for you. 
 + 
 +If all columns are required, outputting the report to text, CSV or EXCEL is advised. 
 + 
 +^ Variable ^ Function ^ 
 +|''TMSSREPORTCOLUMNDELETE''| Removes specified columns from the report| 
 +|''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.1670799876.txt.gz · Last modified: 2025/01/21 22:07 (external edit)