File types

The typical spreadsheet report consists of an XML file defining the data to extract, and optionally, an Excel spreadsheet template file which determines how the output will be formatted. To install a new custom report in aPriori, you can either:

• Compress these files into a .zip file and install it with
Tools>Spreadsheet Reports>Install Spreadsheet Reports

• Simply copy the files into
user\apriori\version\watchpoint-report-defs

The output files will be either an Excel spreadsheet, or a comma-separated values (CSV) file, or an XML file.

Report Definition Files

.xml -- Required. Specifies what data to extract from aPriori. Name MUST end in ".watchpoints.xml" or the report will be ignored when you try to run it from the UI (the restriction is not enforced when running from the command line).

.xls (or .xlsx or .xlsm) -- Optional. Specifies how to format the data. The convention used by Tools>Spreadsheet Reports>Install Spreadsheet Reports is to end the name in ".template.xls", and to place this file in a "template" sub-folder under the reports (.xml) folder. The template file must be specified with the templatePath attribute to the <report> tag in the .xml file, or it will be ignored.

.zip -- The .xml file and the .xls (if defined) must be bundled into a .zip file to be recognized by the aPriori Tools>Spreadsheet Reports>Install Spreadsheet Reports command.

Report Output Files

.xls (or .xlsx or .xlsm) -- The default spreadsheet output file.

.csv -- A text output file containing comma-separated values. (Specified with a generateCsv="true" attribute to the <reports> tag in the XML definition file.

.xml -- A text output file containing XML. (Specified with a generateXml="true" attribute to the <reports> tag in the XML definition file.

For more information about the <report> tag and its attributes, See "Elements of Report Files" on page 1.

Note: Custom reports are installed locally and are only available to the user who installs them. They are not available to other users even though they may share the same aPriori database server.