Differences

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

--- cookbook:billing [2017/08/03 00:08] – [The Extract Module] Gerard Nicol
+++ cookbook:billing [2025/01/21 22:07] (current) – external edit 127.0.0.1
@@ Line 11: / Line 11: @@
 ===== The Extract Module =====
-The purpose of the Billing Extract module [[cli:TMSS10LogStatsExtractDB|TMSS10LogStatsExtractDB]] is to read through the TapeTrack history tables and create a billing extract file for each of the TapeTrack Customers that correspond to the requested date range.
+The purpose of the Billing Extract module [[cli:TMSS10LogStatsExtractDB|TMSS10LogStatsExtractDB]] is to read through the TapeTrack history tables and create billing extract files within the date range specified when the program is called.
+At the completion of the program you will have one .ttstats (TapeTrack Statistics) file for each TapeTrack customer.
+===== The TTSTATS File =====
+Each record of the TTSTATS file starts with a control character, which is then followed by additional data.
+The first record will always be a ''C'' type record, which indicates the TapeTrack Customer the file has been created for.
+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)
 <code>
-C:\Windows\system32>TMSS10LogStatsExtractDB -R "M-1:m-1" -h "C:\Program Files\TapeTrack\TapeTrack Framework\Server\var\db" -o "c:\tmss\billing"
+C1009
-ZBT001N-19:06:40 TMSS10LogStatsExtractDB (c) GazillaByte 1998-2017
+ILT  20170701000870000000
-ZBT002N-19:06:40 Compiled Jun  5 2017 at 10:55:19
+SLT  100920170701000225000000
-ZBT010I-19:06:40 this program will create an Extract file for each Customer from the Journal database
+HLT  100920170701000000000000
-ZBT006N-19:06:40 Running Under Windows Server 2008 R2 (build 7601 6.01 Service Pack 1) on platform x64
+SLT  FBTW20170701000015000000
-ZBT000N-19:06:40 Host is Little Endian
+HLT  FBTW20170701000000000000
-ZBT000N-19:06:40 Host is ASCII
+MLT  OFFSLIBR20170702000002000003
-ZBT000N-19:06:40 Binary is 64 bit
-ZBT000N-19:06:40 Current Working Directory is C:\Windows\system32
-ZBT004N-19:06:40 Today is Wednesday, August 02, 2017
-ZBT005N-19:06:40 Running on vt-tapetrack
-ZBT006N-19:06:40 Process ID 42468
-ZBT000N-19:06:40 Parsing and validating command arguments
-ZBT000N-19:06:40 Explicit date range requested as: M-1:m-1
-ZBT000N-19:06:40 Start date interpreted as: Saturday, July 01, 2017
-ZBT000N-19:06:40 End date interpreted as: Monday, July 31, 2017
-ZBT000N-19:06:40 Days apart: 31
-ZBT000N-19:06:40 Checking for Environment Variable 'ESPDATERANGEOFFSETFILE'
-ZBT002N-19:06:40 Program Options:
-ZBT002N-19:06:40        (C) Customer Map File=
-ZBT002N-19:06:40        (H) Bill for Daily HighWater=false
-ZBT002N-19:06:40        (R) Date Range=M-1:m-1
-ZBT002N-19:06:40        (c) Customer Filter=*
-ZBT002N-19:06:40        (h) Database home directory=C:\Program Files\TapeTrack\TapeTrack Framework Server\var\db
-ZBT002N-19:06:40        (m) Bill for multiple locations in one day=false
-ZBT002N-19:06:40        (o) Output directory=c:\tmss\billing
-ZBT002N-19:06:40        (p) Seconds between progress markers=5
-ZBT002N-19:06:40        (v) Verbose Output=false
-ZBT000N-19:06:40 Arguments parsed and validated with 0 errors
-ZBT000N-19:06:40 Opening Database Environment
-ZBT000N-19:06:42 Database Environment Open Status: BDB0062 Successful return: 0
-ZBT000N-19:06:42 Journal Database Database Open Status: BDB0062 Successful return: 0
-ZBT000N-19:06:42 Journal Date Database Database Open Status: BDB0062 Successful return: 0
-ZBT000I-19:06:42 Looking up record number for fast forward
-ZBT000I-19:06:42 Looking for date/time: Saturday, July 01, 2017 - 02:00:01
-ZBT000I-19:06:42 Record 18632561 found with date/time of Friday, October 11, 2013 - 13:50:25
-ZBT000I-19:06:48 Progress Point: 2013-10-21 16:43:22 (11 days processed)
-ZBT000I-19:06:54 Progress Point: 2013-11-04 09:45:52 (25 days processed)
-ZBT000I-19:07:00 Progress Point: 2013-11-19 06:23:21 (40 days processed)
 </code>
+===== The Billing Calculation Module =====
+The Billing Calculation Module [[cli:tmss10logstatsprocess|TMSS10LogStatsProcess]]
+==== See Also ====
+[[cookbook:billing_process|Cookbook: The Billing Process]]
+<- ^ :cookbook:introduction|Cookbook ^ ->
+{{tag> cookbook billing}}