Getting Started - Production System

Production System has two modes: local and remote. It is typically run in remote mode, where it connects to a SuperSERVER to process the cross tabulations.

Step 1 - Create your TXD Files

You will need to use SuperCROSS to design your tables and save them in TXD format.

See Getting Started - SuperCROSS for help with creating tables in SuperCROSS. Once you have designed a table that you want to process with Production System:

1. Select File > Save As.
2. In the Save as type option, choose the Textual table Definition (.TXD) (*.txd) file type, and save your TXD file.

Step 2 - Set your Default Options in the Production System Configuration File

The next step is to configure your Production System settings.

Although it is possible to specify all settings on the command line if you wish, Production System also has a configuration file (located at C:\ProgramData\STR\SuperSERVER SA\sa2ps.config.xml by default). It is generally easier to set most of the settings that you are going to use most of the time in the configuration file. This way you will only need to specify a few command line options if there are any settings you want to override for a specific table.

See Configuration File - Production System for a full list of all the possible options, but at the very least you will want to set the connection type to REMOTE_SUPERADMIN. You may also need to set the correct hostname and port for connecting to your SuperSERVER (although if you are running Production System on the same machine as the SuperSERVER and are using the default port then you can leave these set to the defaults, localhost and 9230).

<CONFIG>
    <KEY name="ProductionSystem">
        <KEY name="Connection">
            <STRING name="ConnectionType">REMOTE_SUPERADMIN</STRING>
            <STRING name="DatabasePath">svdatabase.xml</STRING>
            <STRING name="LocalLegacySXV4Codepage"></STRING>
            <STRING name="HostName">localhost</STRING>
            <NUMBER name="Port" value="9230" />
            <STRING name="User">user1</STRING>
            <STRING name="Password">user1</STRING>
        </KEY>
        ...

You may also want to update the configuration file setting to include the username and password of the user account for connecting to SuperSERVER. This user account must have permission to access all the databases on the SuperSERVER that you will be using with Production System.

If you do not want to include the user credentials in the configuration file (where they will be stored in plain text) you can leave the default values in the configuration file and set the real username and password on the command line instead using the -un and -pw options. Anything you set on the command line overrides the settings from the configuration file.

Change any other settings you want to change in the configuration file. For example, you might want to enable some of the other output formats (by default the configuration only enables CSV output):

<KEY name="OutputFormats">
    <BOOL name="EnableCharSepOutput" value="true" />
    <BOOL name="EnableTXDOutput" value="false" />
    <BOOL name="EnableSXV4Output" value="false" />
    <BOOL name="EnableXMLOutput" value="true" />
    <BOOL name="EnableCALSOutput" value="false" />
    <BOOL name="EnableRVOutputCSV" value="false" />
</KEY> 

When you have finished making changes, save the configuration file.

Step 3 - Run Production System

You are now ready to run Production System.

1. Open a Windows Command Prompt.

2. If necessary, use the cd command to navigate to an appropriate directory.

   You can run Production System from any directory, but by default the output will be saved to the current directory (unless you use the command line options to set an output directory).

   You may want to change to the directory that contains your input TXD file.

3. If you have defined all your required settings in the configuration file, then you can run Production System using a command similar to the following:

   CODE

   sa2ps -tn AgeByArea

   In this example, Production System will process a TXD file called AgeByArea.txd that is located in the current directory and the output will be saved in the current directory.

Changing the Output Directory

By default, Production System will save the output to the current directory. It is also possible to set the output directory using the -op option.

For example, the following command saves all the output files to a subdirectory called output within the current directory:

sa2ps -tn AgeByArea -op output

This directory must already exist. Production System will not create the directory if it does not already exist.

Setting the Username and Password

If you chose not to include the correct username and password in the configuration file, then you will need to specify them on the command line. For example:

sa2ps -tn AgeByArea -op output -un user1 -pw user1

Processing a TXD from the Server

You can process a TXD file that has been saved to the SuperSERVER (using the SuperADMIN cat command) rather than a local TXD from disk. Use the -ff option to specify the name of the TXD file on the server and the folder it has been added to:

sa2ps -ff TXDs\AgeByArea