Output Formats - Production System
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 |
|---|---|
| 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. |
| SXV4 | The proprietary Space-Time Research 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. |
| XML | A Space-Time Research defined XML format. The XML file contains the dimensional cube structure and associated data. |
| CALS | An XML format based on the CALS table model. |
| Record View | A CSV file containing the underlying unit records that contribute to the table. |
| 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. |
See Configuration File - Production System 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