Thursday, May 8, 2008

Logging Transactions in halFILE

You can turn halFILE transaction logging on from the Tools-Options menu of the halFILE Administrator. Select the Transactions tab and check the "Use halFILE Transaction Logging" option.

Once the option is selected, halFILE will begin logging transactions to the HFTransactions table in the HFWParams database. On the set up screen is a Generate Transaction Report that lists transactions. This runs the Crystal Report HFTransactions.rpt. Note that you may need to update this report to point to qualify your database before it will run properly.

Also on the screen is a Purge Transactions button which purges transactions based on the options selected to the left of the button.

The transaction table includes the following fields:
Application = halFILE Application ID
DocType = halFILE Document Type ID
UserId = halFILE User ID
Station_ID = halFILE Station ID (doc prefix letter)
Module = halFILE Module ID (HFSearch32, HFIndex32, HFBasket32, etc.)
Basket = halFILE Basket name (if applicable)
Doc_Number = halFILE Document Number (if applciatble)
Transaction_Type = code for transaction type being performed

The Transaction Type Codes include the following:
1 = add record to halFILE database
2 = update existing halFILE database record
3 = view record (search)
4 = delete record from halFILE database
5 = search for documents
6 = delete record from basket
7 = move document to another basket
8 = Execute tools-move images
9 = Execute tools-image utility
10 = Execute tools-process images
11 = Execute tools-Associated Import
12 = Save in halFILE Administrator
13 = Execute File-Import
14 = Scan document
15 = Execute Archive (non-Auto archive)

16 = Change Basket Status
17 = Index verify a record in halFILE database
18 = Index verify mismatch (when verify logging feature is enabled)

Transaction logging can be very useful in identifying when changes are made to your system and analyzing throughput.