This readme provides information about the Quest® InTrust® 11.3.1 Knowledge Pack for Microsoft Excel release.
Quest InTrust Knowledge Pack for Microsoft Excel includes a utility that logs changes to Excel files as they occur, an InTrust task that lets you collect the logged data, and a report based on the data.
To install the Knowledge Pack (in case you did not select it during InTrust setup), run its setup file (named EXCEL_KP.<build_number>.msi) on the InTrust Server computer. This file installs predefined InTrust objects. The installation should take place automatically. The installed objects should appear in InTrust Manager when you refresh the treeview after installation. In case the objects do not show up, try restarting InTrust Manager.
Working with the Knowledge Pack is made up of the following steps:
The utility gathers information about changes made to Microsoft Excel files. Excel 2000, Excel XP (2002) and Excel 2003 files are supported. Track Changes mode must be enabled in the files, otherwise no data will be gathered. To enable Track Changes mode for an individual Excel file, open it in Excel and select Tools | Track Changes | Highlight Changes.
The utility reads logging parameters from an INI file specified in the command that runs the utility. If no file is specified, it looks for the default excelTrackChangesCollector.ini file in the same folder as itself. If this file is not available, the utility processes all *.xls files on all fixed disks and writes the log to the log.txt file in the same folder as itself.
The INI file includes one section: [excelTrackChangesCollector].
Table 1: INI Fil
Location = <folder>
Folder in which to look for Excel files.
Include = [<mask>]
Mask for files to be processed, for example *2005*.xls. If the mask contains backslashes (\), it is treated as a masked full path, otherwise it is treated as a masked file name. The default is *.xls.
Exclude = [<mask>]
|Mask for files to be ignored, for example *temp*.xls. If the mask contains backslashes (\), it is treated as a masked full path, otherwise it is treated as a masked file name.|
Timestamp = [<file>]
|File into which the utility writes the last modification time for processed files. The default file is timestamp.dat.|
Log = <file>
|File into which the utility logs its operation and any possible errors. The default file name is log.txt|
Output = <folder>
|Folder where the utility puts the resulting Excel file change logs.|
If you specify relative paths, they are relative to the folder in which the utility resides.
You can specify multiple Include, Exclude and Location parameters. Each recurring parameter must be a separate line in the INI file.
The output file contains the following tab-separated fields:
Cell value after the change—Only for types 1 and 3, for other types this field is empty
The log also includes information about insertion and deletion of lines, columns and sheets. In the field that shows the cell value before the change, the following appears:
If a line is inserted or deleted, the column number is shown as -1. If a column is inserted or deleted, the line number is shown as -1. If a sheet is inserted, the line and column numbers are shown as -1.
The name of the output file is constructed as follows:
The file contains records of changes to those files whose change date (not the change time) precedes than the last gathering, or those files that were processed for the first time.
However, change time is stored as local time, so the utility always gathers all changes for the current date, even if they have been gathered previously. Thus, it makes sense to run the utility no more often than once a day.
The Quest InTrust Knowledge Pack for Microsoft Excel contains the following components:
excelTrackChangesCollector.ini configuration file