Differences

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

--- technote:cgi [2026/02/19 04:27] – [Setting Report Format] Scott Cunliffe
+++ technote:cgi [2026/02/19 04:51] (current) – [Report Variables] Scott Cunliffe
@@ Line 124: / Line 124: @@
 spaces are replaced with +
-To avoid using your password in plain text in the URL, create a file C:\tapetrack\pw\user where user is the username and the contents of the file is the users password.  The -S arg only needs to specify _s user@locahost and the password will be looked up by the process.
+To avoid using your password in plain text in the URL, create a file C:\tapetrack\pw\user where user is the username and the contents of the file is the users password.  The -S arg only needs to specify -S user@locahost and the password will be looked up by the process.
 Attributes are separated using the & symbol
@@ Line 138: / Line 138: @@
 Other formats are text (default), PDF & Excel.
-Using CGI, to set the report format, use the variable RPT
+Using CGI, to set the report format locally, use the variable RPT
-<code> ?RPT=CSV<code>
+<code> http://localhost/tapetrack/TMSS10Inventory.exe?S=user:-pass@localhost &RPT=CSV</code>
-===== Option A: Set TMSSREPORTFORMAT Globally for Apache =====
+Or if the report format stays as CSV, you can set the value globally.
 Add the following to Apache configuration (inside global scope):
@@ Line 150: / Line 151: @@
 This forces TapeTrack utilities run via Apache CGI to output in CSV format.
+===== Report Variables =====
+All report [[variable:start|Variables]] can be used similar to the command line interface, with the exception of syntax.
+A command line example of calling TMSS10Inventory, with access details, customer filter and CSV output.
+<code> set TMSSREPORTFORMAT=CSV
+TMSS10Inventory -S user:-pass@localhost -V UK01.*.* </code>
+Apache/CGI
+<code> http://localhost/tapetrack/TMSS10Inventory.exe?S=user:-pass@localhost&V=UK01.*.*&RPT=CSV</code>
 ===== Example: Generate CSV Inventory Report =====
@@ Line 159: / Line 174: @@
 The browser should display the CSV output, or prompt to open it in Excel.
-===== Troubleshooting =====
@@ Line 175: / Line 190: @@
   * Only allow execution in a controlled folder
+{{tag> reports utils cgi apache technote cli}}