5.9.3 CSV format
- Organization of this subsection
(1) CSV data output format
CSV data is output in the order of data header 1st section, data header 2nd section, and then data 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.
(2) 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, UTF-16LE, Shift_JIS, EUC-JP, EUC-JP-LINUX, and MS932.
The default setting is UTF-8.
- Note:
-
If the characterCode value set in config.xml is not one of the above character sets, or the specified value is not defined on the platform, an error is output to the log file during initialization and the default value is used.
(3) 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.
(4) File end code
After the last data is output, <EOF> is output.
(5) 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.
(6) Date format
Dates are displayed in the format corresponding to the locale. For details, see the chapter describing installation and setup in the JP1/Performance Management Planning and Configuration Guide.