Job Management Partner 1/Performance Management User's Guide

5.9.3 CSV format

(a) CSV data output format

CSV data is output in the order of data header 1st, data header 2nd, and data sections. This subsection describes the display format for each section.

Data header 1st section
One blank row + report name + one blank row are displayed.

Data header 2nd section
A field header is output.
A field schema name is output as a field column header. However, if Display name is set for a field in definition, the Display name is displayed.

Data section
This is output as one row per record.

(b) Character set of text used for exporting

Set as characterCode in config.xml^#. Available character sets are US-ASCII, windows-1252, ISO-8859-1, UTF-8, UTF-16, UTF-16BE, and UTF-16LE.

The default setting is US-ASCII.

(c) Linefeed code

Set as lineSeparator in config.xml^#. The default setting is CRLF in Windows, LF in UNIX.

If the linefeed code is CRLF, 0D0A is output. If it is LF, 0A is output.

Note:

If the setting is other than CRLF or LF, an error is output to the log file during initialization, and CRLF is used as the setting value.

(d) File end code

After the last data is output, <EOF> is output.

(e) Delimiter between items

The delimiter between items is represented by a comma (,). If either a comma, double quotation mark ("), or linefeed is in the data value, the data value itself is surrounded with double quotation marks.

[Contents][Back][Next]

[Trademarks]