Differences

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

--- technote:report:windowspdf [2022/12/12 00:28] – [Report Variables] Scott Cunliffe
+++ technote: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.
+<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:
 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.
+{{tmss10inventory7.png}}
 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 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 =====
 Open the batch file in Notepad or other plain text editor.
+{{tmss10inventory5.png}}
 ==== Report Variables ====
@@ Line 47: / Line 62: @@
 |''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|
+|''TMSSPDFOUTPUTPATH''| Sets the output directory and file name|
 Batch file code example:
 <code>
@@ Line 68: / Line 85: @@
 ^ Variable ^ Function ^
 |''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>
@@ Line 89: / Line 106: @@
 ^ 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}}