Output Formats - SuperCROSS
To save a table or chart, use the File > Save or File > Save As menu options. The following formats are available:
Format | Description |
---|---|
SuperCROSS (.SCS) | The native SuperCROSS project file format. |
SuperTABLE Dissemination (.SCS) | For use in SuperTABLE. |
Tab-delimited Table (.TXT) | A tab-delimited text file format representing the table structure. |
Comma-separated Table (.CSV) | For import into programs like Excel. The file will include:
|
Lotus 1-2-3 (.WKS) | For import into Lotus 1-2-3. Supports multiple sheets spanning multiple cells. |
Tabular Macro-data (.CSV) | Designed for loading multiple tables into data warehouses. SuperTABLE tables with tabular metadata can be saved in comma-separated format. Table macro-data can be dumped into a sparse comma-separated format with minimal metadata. The default textual format separator can be changed to a character other than the comma (this is controlled by the Microsoft Windows locale settings). |
Tabular Meta-data (.TXT) | The table metadata. This includes the database, table subject population, table fields, and structure of enumerated axes (blank items are used to indicate spanners, and space indentation are used to indicate the hierarchy). |
Parameter Log (.TXT) | A textual description of the table and tabulation. Parameter logs can be used for manually checking how a table was created or for reference. The output text file includes:
|
HTML - Single File (.HTM) | The entire table saved as a single HTML file. If there are multiple wafers in the table they are displayed one after the other on the page. There are a number configuration options you can set for saving to HTML. See super.ini for more information. |
HTML - Multiple Files (.HTM) | Each wafer is saved to its own individual HTML file. There are a number configuration options you can set for saving to HTML. See super.ini for more information. |
XML - Display Model (.XML) | An XML file format containing data elements and table metadata. The XML file contains the following:
These elements are tagged for identification. Table wafer data is generated as a separate section of the XML output. However, hierarchical levels are not tagged, and nesting of levels is not supported.
|
XML - Structural Model (.XML) | This is a structured model XML file.
|
XML - CALS Model (.XML) | This is a statistical table model that is based on the CALS table model.
|
Excel 95 or 2003 (.XLS) and Excel 2007 or 2010 (.XLSX) | For opening in Microsoft Excel.
If SuperCROSS is set up with multilingual metadata, you can use this option to export to Excel with table and field titles in two languages. Learn more. There are a number configuration options you can set for saving to Excel. See super.ini for more information. |
PC-Axis (.PX) and PC-Axis 2000 (.PX) | For use in the PCAxis and PC-Axis 2000 software.
|
SuperCUBE (.SRD) | A 'Summary Record Database' for distributing to other users of SuperCROSS and SuperTABLE. For more information about the SuperCUBE output format, see SuperCUBE. |
Textual Table Definition (.TXD) | A textual description of a table. TXD files do not contain table data, they only describe the table structure. The TXD must be loaded back into an application like SuperCROSS to view the table it describes. For a full description of the TXD format, see: TXD Reference If you save a table containing an annex file in TXD format, the annex file is saved in the same folder as the TXD file, with a RTF file extension. A reference to the RTF file is made in the TXD file. If you move or copy the TXD file you must also move or copy the RTF associated RTF annex information file. There are a number configuration options you can set for saving to TXD. See super.ini for more information. |
SDMX Structure Definition (.xml) | The SDMX (Statistical Data and Metadata eXchange) Technical Standards Version 2.0 format. This output format saves the structure definition only. Items that can be saved to the SDMX download file include:
Items that are not saved to the SDMX download file include:
SDMX output cannot be saved from tables with concatenated fields. For more information on SDMX, see http://sdmx.org/ or SDMX - SuperCROSS. |
SDMX Archive (.zip) | The SDMX (Statistical Data and Metadata eXchange) Technical Standards Version 2.0 format. This output format creates a ZIP archive containing both the SDMX data set and the SDMX structure definition, both in XML format. The limitations are the same as those of the Structure Definition listed above. |
To save the entire table you must have either nothing highlighted/selected or the entire table highlighted/selected.
If SuperCROSS displays a progress bar during the save process, you can cancel the save at any time by pressing Esc.