Differences

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

--- technote:cgi [2026/02/19 04:26] – [TapeTrack utility works in CMD but not in browser] 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 132: / Line 132: @@
 TapeTrack utilities can output different formats depending on environment variables.
-To force CSV output, the variable may be required:
+To force CSV output, the variable may be required, in a command prompt:
 <code> TMSSREPORTFORMAT=CSV </code>
@@ Line 138: / Line 138: @@
 Other formats are text (default), PDF & Excel.
-===== Option A: Set TMSSREPORTFORMAT Globally for Apache =====
+Using CGI, to set the report format locally, use the variable RPT
+<code> http://localhost/tapetrack/TMSS10Inventory.exe?S=user:-pass@localhost &RPT=CSV</code>
+Or if the report format stays as CSV, you can set the value globally.
 Add the following to Apache configuration (inside global scope):
@@ Line 148: / Line 152: @@
 This forces TapeTrack utilities run via Apache CGI to output in CSV format.
-===== Example: Generate CSV Inventory Report =====
+===== Report Variables =====
-Once TMSSREPORTFORMAT is set, run:
+All report [[variable:start|Variables]] can be used similar to the command line interface, with the exception of syntax.
-<code> http://localhost/tapetrack/TMSS10Inventory.exe?user:-pass@localhost </code>
+A command line example of calling TMSS10Inventory, with access details, customer filter and CSV output.
-The browser should display the CSV output, or prompt to open it in Excel.
+<code> set TMSSREPORTFORMAT=CSV
+TMSS10Inventory -S user:-pass@localhost -V UK01.*.* </code>
-===== Troubleshooting =====
+Apache/CGI
+<code> http://localhost/tapetrack/TMSS10Inventory.exe?S=user:-pass@localhost&V=UK01.*.*&RPT=CSV</code>
-==== Output is blank ====
+===== Example: Generate CSV Inventory Report =====
-Possible causes:
+Once TMSSREPORTFORMAT is set, run:
+<code> http://localhost/tapetrack/TMSS10Inventory.exe?user:-pass@localhost </code>
+The browser should display the CSV output, or prompt to open it in Excel.
-The TapeTrack executable is writing output to a file instead of stdout
-TapeTrack is failing due to permissions (Apache service account)
-Missing environment variables (example: TMSSREPORTFORMAT)
-TapeTrack cannot connect to the TapeTrack server
-Check Apache logs:
-<code> C:\Apache24\logs\error.log </code>
@@ Line 186: / Line 190: @@
   * Only allow execution in a controlled folder
+{{tag> reports utils cgi apache technote cli}}