TapeTrack Documentation

Because there is more to tape management than you ever realized

User Tools

Site Tools

Trace: • find_customer • ttstats • add_volume • excel_import_container • trial_license • group_user_administration • evaluating-tapetrack • tools_search_volume • journal • billing_rules
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:12] – [Validation] Scott Cunliffebilling:ttstats [2026/08/19 02:00] (current) – Scott Cunliffe
Line 87: Line 87:
   * The statistics processed by the Billing Rules.   * The statistics processed by the Billing Rules.
  
-<WRAP note> +Record Types are:
-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''. +
-</WRAP>+
  
 +  * ''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>
  
-===== Processing Result =====+Breakdown of record data: **ILTO 20260816000446000015**
  
-''TMSS10LogStatsProcess'' reads the statistics and applies the selected billing configuration.+**I** Inventory **LTO** Media type  **20260816**  Date YYYYMMDD **000446** Inventory **000015** Inventory record count
  
-The resulting XML may contain:+Breakdown of record data: **MLTO LIBRSCRA20260816000003000010**
  
-<code xml> +**M** Movement **LTO** Media type **LIBR** To repository **OFFS** From repository **** Date **000003** Movement count **000010** Movement record count 
-<?xml version="1.0" encoding="ISO8859-1"?> + 
-<?xml-stylesheet type="text/xsl" href="tapetrack.xslt"?> +<WRAP note> 
-<tapetrack_data> +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]]. 
-  <item> +</WRAP>
-    <customer>US01</customer> +
-    <itemcode>New York STORAGE_OFFSITE</itemcode> +
-    <description>LTO Vault Storage Charge</description> +
-    <count>60</count> +
-    <cost>0.01</cost> +
-    <total>0.60</total> +
-  </item> +
-</tapetrack_data> +
-</code>+
  
-In this example: 
  
-^ Value ^ Source ^ 
-| Customer activity and quantity | ''US01.ttstats'' | 
-| Customer description | Customer Description Map | 
-| Billing package | Package Map | 
-| Item code, description and rate | Billing Rules | 
-| XML presentation | ''tapetrack.xslt'' | 
  
  
Line 142: 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 156: 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 175: Line 192:
 An empty file may be valid when the Customer had no relevant activity. It should be investigated before being excluded from billing. An empty file may be valid when the Customer had no relevant activity. It should be investigated before being excluded from billing.
  
-==== Incorrect Customer Is Processed ==== 
  
-Check that: 
- 
-  * The correct TTSTATS file was supplied using the ''-i'' argument. 
-  * The filename corresponds to the Customer-ID contained in the file. 
-  * The correct Customer Description Map was used. 
-  * The correct Package Map was used. 
-  * A file from another billing period or environment was not selected. 
  
 ==== Billing Quantities Are Incorrect ==== ==== Billing Quantities Are Incorrect ====
Line 203: 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 236: 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 254: 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 266: 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.1787022731.txt.gz · Last modified: 2026/08/18 03:12 by Scott Cunliffe