Output Formats
Production System supports a number of different output formats. You can turn them on or off by changing the relevant setting in the OutputFormats section of the Configuration file to true or false.
| Format | Description |
|---|---|
| CALS | An XML format based on the CALS table model. |
| Character Separated | A text based format where columns are separated by a configurable character. Typically the separator will be a comma (this is referred to as Comma Separated Values, or a CSV file), although you can choose a different character to act as the separator by changing the configuration setting. Production System allows you to configure which tables axes are output, the order of the output and whether the header and footer are included. |
| Record View | A CSV file containing the underlying unit records that contribute to the table. |
| SXV4 | The proprietary SuperSTAR database format. SXV4 files can be added to a SuperSERVER and loaded into SuperCROSS. The SXV4 output will be a summary database (also known as a cube), containing only the summary data for the fields that were included in the table in the TXD (not the whole database). Production System does not currently support field or axis derivations in SXV4 output. If a TXD has field or axis derivations, and the output format is SXV4, no derivations will be included in the SXV4 output file. |
| TXD | Textual Table Definition format. This option is included for testing purposes only. Please note that when running in remote mode any user defined fields in the TXD will be removed when the TXD output is generated by Production System. |
| XML | A SuperSTAR-specific XML format. The XML file contains the dimensional cube structure and associated data. |
See Configuration File for details about the available options you can configure for each output format.
Unicode and the System Codepage
From SuperSTAR version 9.0 onwards, Production System will generate output in unicode by default.
For character separated (CSV) and Record View output, you can optionally set a specific system codepage for output if you need to. You can set this in the configuration file by setting the value of the <STRING name="CodePage"></STRING> element in the CharSep and RecordView sections.
You can also override the codepage for these output formats if necessary on the command line. You will need to use the -cs command line option and specify the full path to the relevant CodePage setting. For example:
sa2ps -tn TableName -cs TableManager/Output/CharSep/CodePage 1251 -cs TableManager/Output/RecordView/CodePage 1251