Creating Custom Export Format for Action Items

The list of action items raised by Squore according to the triggers configured in your decision model can be exported out of Squore so it is reused and managed in any third-party application you use to track defects or issues. By default, Squore supports exporting in these formats:

This list can be expanded by adding custom export formats to your configuration.

Before making a new export available, you need to understand the information that is available to export. In order to see the full export, export action items from Squore using the XML export to dumps all the information available to an xml file. Creating a new format is as simple as creating a stylesheet to manipulate the contents of the full export to your liking.

Let's first look at what an export configuration looks like. On Squore Server, go to <SQUORE_HOME>/Configuration/scripts/export. Each export format is specified in its own folder. Each export format is defined by two files: transform.xsl and export.properties. The file file transform.xsl is a stylesheet to define what information gets exported, and the file export.properties defines the extension and charset of the export file.

Note: The export.properties file is optional. If omitted, Squore will create a file with a ".xml" extension using the UTF-8_BOM character set, as if using the file below:

charsetName = UTF-8_BOM
extension = .xml

For more information about available charsets, consult http://docs.oracle.com/javase/6/docs/api/java/nio/charset/Charset.html

After you to define your stylesheet, create a new folder called MyCustomExport in Squore's configuration folder and create the two definition files needed by saving your stylesheet as transform.xsl and specifying the desired extension and charset for the report file . The new export format will be available in Squore the next time you refresh your dashboard.