CSV output functionality

The CSV output functionality can be used to save the management information and logs of a connection destination on the PC where the HULFT Manager is installed in CSV format.

There are two methods for generating the CSV format: one is from the HULFT Manager Management Console and the other is to call the program from the command line. Either method can be used to operate the same function. (From the HULFT Manager main screen, the HULFT Manager System Environment Settings cannot be output to CSV format.)

Management information and logs acquired in CSV format can be reused by generating reports using spreadsheet software on a PC.

= Remarks =

When the destination host is HULFT Ver.8.4 or higher, it is recommended that you use the Management Information Export function.

For details on the Management Information Export function, refer to Management Information Export and Import functions.

Figure 3.3 CSV Output Functionality

 

Note

  • The maximum number of data items that can be output to a file at a time by the CSV output function is 999. A warning is displayed when the number of data items to be output exceeds 999. If the number of items to be output exceeds 999, perform the operation multiple times by specifying the appropriate CSV output conditions.

  • When you output records of management information or logs in CSV format, if double quotation marks (") are included in the records, the CSV file will not be recognized correctly because all the set values are enclosed within double quotation marks and output as they are. The output file will not be handled as CSV properly if set values in the following fields include double quotation marks (").

    [Target Fields]

    Management information:

    ID, Host Name, Comment

    Log:

    ID, Host Name

    Below is an example of the output for a record of the Send Management Information, in which the file ID was set to '"AB"':

    Output example)

    ""AB"","C:\data\send",0,......

    (The underlined portion is the relevant file ID.)

    To prevent this problem, you can open the file in a text editor or other tool to replace the double quotation marks ("), which are used as delimiters, with a different appropriate sign.

    For details about delimiter settings, refer to CSV format settings.