EIS Command File

This is a file used to specify the case data to be extracted, and the format to be output to a csv file for display by the EIS Data Viewer.

It is used with the SWDIR\util\swcdata utility as an alternative to defining an EIS Report object.

It is an ASCII file consisting of lines of commands each consisting of a keyword separated by white space from parameters as shown below. Most commands are optional and default as indicated. Keywords are case insensitive and the commands may be in any order in the file.

Command

Description/Valid Values

TYPE CSV

File output type: csv is the only currently supported format and is the default.

CASETYPE

ALL, TERMINATED or ACTIVE.

COLUMNS

This command is obligatory and should be followed by a newline and then a list of the fieldnames to be extracted, one per line and terminated by a line consisting of a single tilde character, ~. Any of the user-defined fields may be used plus certain special fields - see Special Fields for EIS Report Columns.

FIELDSEP

The string of characters to be used to separate each field item on a line (default is a comma). Leading white space is ignored (and the SPACE character is not allowed). The following special character sequences may be used:

\r carriage return
\n newline
\t tab
\f form feed
\\ backslash

RECORDSEP

The string of characters to be used to separate each line of field items (corresponding to a Case) - default is \n (newline). Leading white space is ignored (and the SPACE character is not allowed). The same special character sequences may be used as for FIELDSEP above.

QUOTE

The character to be placed at each end of non-numeric fields. The default is a double quote character (").

HEADER

YES or NO: specifies whether to include the names of the fields to be extracted (as quoted strings) as the first line of the file (default is YES).

SERVERFILE

The simple filename of the output csv file. This command is obligatory. The file is placed in the SWDIR\tsys\reports\host.n directory where host is the procedure hostnode.

OWNER

The required owner of the csv file. (Default - the user who is running the utility.)

PERMISSIONS

File permissions of the csv file according to the UNIX convention, rwxrwxrwx with a:

•

- where a parameter is missing

•

r = readable

•

w = writable

The first 3 characters refer to the owner, the second 3 the group and the last 3 all users. (The default is the user default file permissions.)

Special Fields for EIS Report Columns

The following special fields can be used in EIS columns:


Field	Description
SW_CASEDESC	Case Description
SW_CASENUM	Case Number (numeric)
SW_CASEREF	Case Reference in the form pp-nn
SW_DATE	Date of data extraction: DD/MM/YYYY
SW_DATETIME	Date and time of data extraction, separated by a space: DD/MM/YYYY HH:MM
SW_PRODESC	Procedure Description
SW_PRONAME	Procedure Name
SW_STARTER	Username of the case starter
SW_STEPDESC	EIS Report object description
SW_STEPNAME	EIS Report object name
SW_TIME	Time of data extraction: HH:MM