Skip to main content
Skip table of contents

Output Formats - SuperCROSS

To save a table use the File > Save or File > Save As menu options. 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.

Available Output Formats

FormatDescription
SuperCROSS (.SCS)The native SuperCROSS table 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:

  • One Record Per Tabular Value. A separate record for every non-zero cell with the row/column/wafer headers, and the data value.
  • Enumerated Axis Item Numbers. For example where instead of writing the full axis header, a column number beginning at 1 is written.
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:

  • The number and name of fields used in each axis of the table,
  • The values included in recodes.
  • How both derivations and User Defined Files (UDFs) were created.
  • Table file name.
  • User Name.
  • Computer Name.
  • Server user name (if saved via the server).
  • Server application name (if saved via the server).
  • Tabulation start time.
  • Axis derivations.
  • Ranges for individually added items (if medium number). 
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:

  • Spanner labels.
  • Groups.
  • Summation options.
  • Field and cell values.
  • Annotation data.
  • Field derivations.
  • Axis derivations.

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.

  • Tables must be tabulated prior to saving out to XML format.
  • If you want to display the XML file in a web browser you will need to attach the SuperCROSS XSL style sheet (available in the SuperCROSS\XML Style Sheets directory located in the SuperCROSS Program Files directory).  
XML - Structural Model (.XML)

This is a structured model XML file.

  • Tables must be tabulated prior to saving out to XML format.
  • The table can not contain a Block Percent.
  • This format is only available for SXV4 databases.
XML - CALS Model (.XML)

This is a statistical table model that is based on the CALS table model.

  • Tables must be tabulated prior to saving out to XML format.
  • The table can not contain a Block Percent.
  • This format is only available for SXV4 databases.
Excel 97-2003 (.XLS) and Excel 2007 or 2010 (.XLSX)

For opening in Microsoft Excel.

  • By default the table header displays left justified.
  • The .xls file format (Excel 97-2003) is limited to 65.536 rows.  
  • The .xlsx file format (Excel 2007/2010) is limited to 16,384 columns and 1,048,576 rows.

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.

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:

  • Simple tables.
  • Totals.
  • Mathematical functions applied to summations.
  • Non-default summation options.
  • Percentages.
  • Cell annotations.
  • Field annotations.
  • DAG classification hierarchies.
  • Derivations.
  • User defined functions.
  • Table language set to another language.
  • Survey dates.
  • Recodes.

Items that are not saved to the SDMX download file include:

  • Hidden fields.
  • Axis derivations.
  • Grand totals.

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.

PC-Axis (.PX) and PC-Axis 2000 (.PX)

For use in the PCAxis and PC-Axis 2000 software.

  • The .PX file format can be saved as Production Utility output and as an output format when the application is operating in server mode.
  • All table cells are saved to the PC-Axis and PC-Axis 2000 format regardless of what is currently selected.
  • A maximum of two table axes can be saved to PC-Axis and PC-Axis 2000 file format.
  • Tables containing wafer fields are nested in the row axis.
  • Axis derivations are not saved.
  • Table meta information is available from the Footnote section of the PC-Axis/PC-Axis 2000 window.  
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.

Output Encoding

Some of the text-based output formats from SuperCROSS give you the option to select the encoding of the output file:

By default, SuperCROSS will encode the output in UTF-8 (Unicode). This provides full support for any characters in any language that might need to be included in the file.

However, depending on what you are going to do with the saved file, you may need to select an alternative encoding. For example, if you need to use the saved file with some other system or application that does not fully support Unicode. The following encodings are available:

Unicode (UTF-8)The default. This will be used if you do not specifically select one of the other options. It provides full support for all languages and characters.
Unicode (UTF-8 with BOM)

UTF-8 with a Byte Order Mark (BOM) at the start of the file to identify the encoding used. This is recommended if you are saving CSV files to load into Microsoft Excel, which may assume the wrong encoding if the BOM is not included.

Some very old applications may not support UTF-8 files with a BOM, and may show the following three characters at the start of the file:

CODE


If this happens, you should probably use ANSI/System Locale instead.

ANSI/System Locale

Use the current system locale. You may need to use this option if you are going to load the saved file into a system or application that does not support Unicode.

Do not use this option unless the current system locale supports all the characters that have been used in the table.

You can change the default encoding by editing the option in Edit > Options > Configuration > Output Encoding Type.

Order of Output Formats

If you wish, you can configure the order in which the output formats appear in the drop-down list. See SuperModule.ini for more details about this configuration adjustment.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.