TapeTrack Documentation

Because there is more to tape management than you ever realized

User Tools

Site Tools

Trace: • group_user_administration • demonstrations • upgrade • case_filters • find_customer • tools_search_volume • ttstats • evaluating-tapetrack • journal • location_swap
billing:ttstats

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
billing:ttstats [2026/08/18 03:14] – [Incorrect Customer Is Processed] Scott Cunliffebilling:ttstats [2026/08/19 02:00] (current) – Scott Cunliffe
Line 86: Line 86:
   * The installed TapeTrack version.   * The installed TapeTrack version.
   * The statistics processed by the Billing Rules.   * The statistics processed by the Billing Rules.
 +
 +Record Types are:
 +
 +  * ''C'' : TapeTrack Customer-ID
 +  * ''I'' : Inventory Total of Media-ID
 +  * ''S'' : Storage Total - Number of Media in that Repository
 +  * ''H'' : High Water Mark
 +  * ''M'' : Volume Movement to the Repository ( to Repository-ID:from Repository-ID)
 +
 +<file text US01.ttstats>
 +CUS01
 +ILTO 20260816000446000015
 +SLTO LIBR20260816000425000015
 +HLTO LIBR20260816000000000015
 +MLTO OFFSLIBR20260816000003000010
 +SLTO OFFS20260816000018000015
 +HLTO OFFS20260816000277000015
 +SLTO SCRA20260816000003000015
 +HLTO SCRA20260816000000000015
 +MLTO LIBRSCRA20260816000000000010
 +ILTO 20260817000446000016
 +SLTO LIBR20260817000425000016
 +HLTO LIBR20260817000000000016
 +MLTO OFFSLIBR20260817000000000011
 +SLTO OFFS20260817000018000016
 +HLTO OFFS20260817000277000016
 +SLTO SCRA20260817000003000016
 +HLTO SCRA20260817000000000016
 +MLTO LIBRSCRA20260817000000000011
 +ILTO 00000000000446000017
 +SLTO LIBR00000000007300000017
 +HLTO LIBR00000000000000000017
 +MLTO OFFSLIBR00000000000016000012
 +SLTO OFFS00000000000236000017
 +HLTO OFFS00000000000277000017
 +SLTO SCRA00000000000046000017
 +HLTO SCRA00000000000000000017
 +MLTO LIBRSCRA00000000000001000012
 +</file>
 +
 +Breakdown of record data: **ILTO 20260816000446000015**
 +
 +**I** Inventory **LTO** Media type  **20260816**  Date YYYYMMDD **000446** Inventory **000015** Inventory record count
 +
 +Breakdown of record data: **MLTO LIBRSCRA20260816000003000010**
 +
 +**M** Movement **LTO** Media type **LIBR** To repository **OFFS** From repository **** Date **000003** Movement count **000010** Movement record count
  
 <WRAP note> <WRAP note>
-A TTSTATS file contains activity statistics, not final invoice lines. The final descriptions, rates and totals are produced when the file is processed by ''TMSS10LogStatsProcess''.+A TTSTATS file contains activity statistics, not final invoice lines. The final descriptions, rates and totals are produced when the file is processed by [[cli:TMSS10LogStatsProcess]].
 </WRAP> </WRAP>
  
Line 112: Line 159:
   - Review the Journal activity.   - Review the Journal activity.
   - Correct the source data or extraction settings where appropriate.   - Correct the source data or extraction settings where appropriate.
-  - Run ''TMSS10LogStatsExtractDB'' again.+  - Run [[cli:TMSS10LogStatsExtractDB]] again.
   - Replace the incorrect extract with the newly generated file.   - Replace the incorrect extract with the newly generated file.
   - Reprocess the billing XML.   - Reprocess the billing XML.
Line 126: Line 173:
 Check that: Check that:
  
-  * ''TMSS10LogStatsExtractDB'' completed successfully.+  * [[cli:TMSS10LogStatsExtractDB]] completed successfully.
   * The Customer had Journal activity during the selected date range.   * The Customer had Journal activity during the selected date range.
   * The output directory exists.   * The output directory exists.
Line 165: Line 212:
 | 11 | Round up to the next 10 | 20 | | 11 | Round up to the next 10 | 20 |
  
-==== No Billing XML Is Produced ==== 
- 
-Check that: 
- 
-  * The ''-i'' argument specifies a valid TTSTATS file. 
-  * The process account has permission to read the file. 
-  * The Customer exists in the Customer Description Map. 
-  * The Customer exists in the Package Map. 
-  * The assigned package exists in the Billing Rules. 
-  * The statistics match at least one Billing Rule. 
-  * ''TMSS10LogStatsProcess'' completed without errors. 
- 
-Redirect diagnostic messages to an error file. 
- 
-Windows example: 
- 
-  TMSS10LogStatsProcess -i US01.ttstats -M customer_map.txt -P package_map.txt -c default.ttsdef > Billing_US01.xml 2> Billing_US01_error.txt 
- 
-Review ''Billing_US01_error.txt'' for file, mapping and configuration errors. 
  
 ==== Charges Are Duplicated ==== ==== Charges Are Duplicated ====
Line 198: Line 226:
  
   * Generate a new TTSTATS file for every billing period.   * Generate a new TTSTATS file for every billing period.
-  * Use the Customer-ID and billing period in the filename. 
-  * Store each billing period in a separate directory. 
   * Do not manually edit generated TTSTATS files.   * Do not manually edit generated TTSTATS files.
-  * Record the extraction start and end dates. 
-  * Review extraction logs before processing billing. 
-  * Prevent the same file from being processed twice. 
-  * Retain the TTSTATS file with its billing XML and invoice reference. 
   * Restrict write access to authorized billing administrators.   * Restrict write access to authorized billing administrators.
-  * Archive completed billing files as read-only records.+  * Archive completed billing files as read-only records if required.
  
 ===== Security ===== ===== Security =====
Line 216: Line 238:
   * TapeTrack administrators.   * TapeTrack administrators.
   * Authorized billing staff.   * Authorized billing staff.
-  * The service account running ''TMSS10LogStatsExtractDB''. +  * The service account running [[cli:TMSS10LogStatsExtractDB]]. 
-  * The service account running ''TMSS10LogStatsProcess''.+  * The service account running [[cli:TMSS10LogStatsProcess]].
  
 The file should not be publicly accessible or stored in an unsecured shared directory. The file should not be publicly accessible or stored in an unsecured shared directory.
Line 228: Line 250:
   * [[billing:package_map|Package Map]]   * [[billing:package_map|Package Map]]
   * [[billing:billing_rules|Billing Rules]]   * [[billing:billing_rules|Billing Rules]]
-  * [[billing:tapetrack_xslt|TapeTrack XML Stylesheet]]+  * [[billing:stylesheet|TapeTrack XML Stylesheet]]
   * [[billing:billing_process|Billing Process]]   * [[billing:billing_process|Billing Process]]
   * [[billing:billing_xml|Billing XML]]   * [[billing:billing_xml|Billing XML]]
billing/ttstats.1787022879.txt.gz · Last modified: 2026/08/18 03:14 by Scott Cunliffe