A Customer TTSTATS file, normally named using the TapeTrack Customer-ID, contains the statistics extracted from the TapeTrack Journal for a selected billing period.

Example filename:

US01.ttstats

The file is created by TMSS10LogStatsExtractDB and processed by TMSS10LogStatsProcess.

The TTSTATS file provides the operational quantities used to calculate billing items, including storage and movement activity. It does not contain the complete billing configuration. Customer descriptions, package assignments, rates, rounding and other calculations are supplied separately by the Customer Description Map, Package Map and Billing Rules.

The Customer TTSTATS file transfers customer activity from the TapeTrack Journal into the billing calculation process. Each Customer-ID has its own ttstats file, containing statistics for all activity within the set date range.

The Customer TTSTATS file is created by TMSS10LogStatsExtractDB. This utility reads the TapeTrack Journal database and creates an extract file for each Customer containing activity within the selected date range.

For example, an extraction containing the following Customers may create:

TTSTATS files should be generated from the Journal for the correct billing period. Reusing a file from another period may result in missing, duplicated or incorrect charges.

TTSTATS files can be stored in any directory accessible to the account running the billing process. For ease of administration, it is recommended that each billing period has a separate input directory.

Example Windows location:

C:\Program Files\TapeTrack\TapeTrack Framework Server\var\billing\2026-07\US01.ttstats

Example Linux location:

/var/tapetrack/billing/2026-07/US01.ttstats

A billing directory may be arranged as:

billing
├── config
│   ├── customer_map.txt
│   ├── package_map.txt
│   ├── default.ttsdef
│   └── tapetrack.xslt
├── input
│   ├── US01.ttstats
│   └── US02.ttstats
└── output
    ├── Billing_US01.xml
    └── Billing_US02.xml

The location of the TTSTATS file is supplied to TMSS10LogStatsProcess using the -i argument.

A TTSTATS file is a TapeTrack statistics extract generated from Journal activity.

The file may contain statistical records relating to:

• Storage quantities.
• Onsite and offsite activity.
• Volume movements.
• Deliveries and collections.
• Repository activity.
• Other operational events recorded in the Journal.

The exact records included depend on:

• The Customer being extracted.
• The selected date range.
• The Journal activity for that period.
• The installed TapeTrack version.
• The statistics processed by the Billing Rules.

TMSS10LogStatsProcess reads the statistics and applies the selected billing configuration.

The resulting XML may contain:

<?xml version="1.0" encoding="ISO8859-1"?>
<?xml-stylesheet type="text/xsl" href="tapetrack.xslt"?>
<tapetrack_data>
  <item>
    <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>

In this example:

TTSTATS files are generated processing files and should not normally be edited manually.

Manual changes can cause:

• Activity to be omitted.
• Quantities to be altered.
• Charges to be duplicated.
• Invalid statistics records.
• A loss of traceability to the Journal.
• Billing results that cannot be reproduced.

If the contents appear incorrect:

1. Confirm the extraction date range.
2. Review the Journal activity.
3. Correct the source data or extraction settings where appropriate.
4. Run TMSS10LogStatsExtractDB again.
5. Replace the incorrect extract with the newly generated file.
6. Reprocess the billing XML.

Check that:

• TMSS10LogStatsExtractDB completed successfully.
• The Customer had Journal activity during the selected date range.
• The output directory exists.
• The extraction account has permission to write to the output directory.
• The expected Customer-ID was included in the extraction.
• The file was not moved or archived after extraction.

Confirm that:

• The correct billing date range was selected.
• Journal records exist for the Customer.
• The correct Journal database was processed.
• The Customer-ID is correct.
• The Customer had billable activity during the period.

An empty file may be valid when the Customer had no relevant activity. It should be investigated before being excluded from billing.

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.

Check that:

• The extraction date range is correct.
• The Journal contains the expected activity.
• The correct TTSTATS file was processed.
• The Billing Rules select the intended statistics.
• Rounding or minimum-quantity rules are being applied correctly.
• The same TTSTATS file was not processed more than once.

The raw activity may be correct while the billed quantity differs because of a Billing Rule.

For example:

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.

Confirm that:

• The TTSTATS file was processed only once.
• The billing XML was imported into QuickBooks only once.
• The selected extraction date range does not overlap another billing period.
• Duplicate Billing Rules are not matching the same statistics.
• Previously processed files are moved to an archive directory.

• 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.
• 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.
• Archive completed billing files as read-only records.

A TTSTATS file does not normally contain passwords or authentication details. However, it may contain Customer activity and commercially sensitive operational statistics.

Access should therefore be restricted to:

• TapeTrack administrators.
• Authorized billing staff.
• The service account running TMSS10LogStatsExtractDB.
• The service account running TMSS10LogStatsProcess.

The file should not be publicly accessible or stored in an unsecured shared directory.

• TMSS10LogStatsProcess
• Customer-ID
• Customer Description Map
• Package Map
• Billing Rules
• TapeTrack XML Stylesheet
• Billing Process
• Billing XML
• XMLQuickBooks Mapping