The output of some SHOW commands in openFT and openFT-AC can be optionally requested in CSV (Character Separated Values) format. CSV is a popular format in the PC environment in which tabular data is defined by lines. Output in CSV format is offered for the following commands:
SHOW-FILE-TRANSFER
SHOW-FILE-FT-ATTRIBUTES
SHOW-FTAC-ENVIRONMENT
SHOW-REMOTE-FILE-ATTRIBUTES
SHOW-FT-ADMISSION-SET
SHOW-FT-KEY
SHOW-FT-LOGGING-RECORDS
SHOW-FT-MONITOR-VALUES
SHOW-FT-OPTIONS
SHOW-FT-PARTNERS
SHOW-FT-PROFILE
SHOW-FT-RANGE
Many programs such as spreadsheets, databases, etc., can import data in CSV format. This means that you can use the processing and presentation features of such programs on the CSV outputs of the command listed above.
The field names of the CSV outputs are described in the appendix.
The first line is the header and contains the field names of the respective columns. Only the field names are guaranteed, not the order of fields in a record. In other words, the order of columns is determined by the order of the field names in the header line.
One example of a possible evaluation procedure is supplied a template in the Microsoft Excel format under the name $SYSFJAM.FTACCNT.XLT. You will need to first make a binary copy of this template on your PC. The template evaluates a CSV log file by means of an automatically running macro. The result shows the number of inbound and outbound requests and the Kilobytes transferred in each case for all BS2000 users.