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 for help with creating tables in SuperCROSS. Once you have designed a table that you want to process with Production System:
- Select File > Save As.
- 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 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,
<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.
-pwoptions. 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="EnablePCAxis2KOutput" 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.
- Open a Command Prompt.
If necessary, use the
cdcommand 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.
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
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
Run Production System on Linux
If you are using Linux then you will need to source the SuperSERVER environment variables before starting Production System. The environment variables are specified in the env.sh file located in the SuperSERVER_SA directory.
For example, run the following command before starting Production System: