For some Show commands, openFT offers output in CSV format. CSV (Character Separated Values) 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:
ftshw
ftshwa
ftshwact
ftshwatp
ftshwc
ftshwe
ftshwk
ftshwl
ftshwlic
fshwm
ftshwo
ftshwp
ftshwptn
ftshwr
ftshws
ftshwsuo
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 data output by the above commands.
The output fields are described in the chapter “Structure of CSV outputs”.
Every record is output as a line, and each record contains information on an object. If data is present, the first line always contains the header with the field names of each of the columns. Only the field names are guaranteed, not the order of fields in a record. In other words, the order of fields is determined by the order of the field names in the header line. Fields within an output line are separated by semicolons (;).
One example of a possible evaluation procedure is supplied as a reference template in the Microsoft Excel format in the following file:
/opt/openFT/samples/msexcel/ftaccnt.xlt (Unix systems)
openFT installation directory\samples\msexcel\ftaccnt.xlt (Windows systems)
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 users.