To use Cognos product documentation, you must enable JavaScript in your browser.

Modify Properties for the CSV Output Format

You can modify properties for the comma separated values (CSV) output format. For example, you can specify encoding and field delimiter characters to suit your environment.

The CSV properties are system-wide settings and cannot be specified for specific reports.

Note: Always set the CSV output format at the server administration level. Do not override CSV output format settings at lower levels.

Steps
  1. Start Cognos Connection.

  2. In the upper-right corner, click Launch, Cognos Administration.

  3. On the Status tab, click System.

  4. From the System drop-down menu, click Set properties.

  5. Click the Settings tab.

  6. Next to Environment, Advanced Settings, click Edit.

  7. Enter parameters and values from CSV Properties and Values, as required.

  8. Click OK.

After the 30 seconds required for your changes to take effect, your changes are reflected when reports are generated in CSV format.

CSV Properties and Values

The following table describes the CSV properties that you can modify. If a property is not specified or its value is empty, the default setting is used.

Parameter

Description

Default

RSVP.CSV.ENCODING

The encoding used for CSV output.

Enter one of the following:

a supported encoding value LOCALE Encoding is derived from the content locale.

utf-16le

RSVP.CSV.DELIMITER

The field delimiter character used for CSV output.

Enter one of the following:

a single character If you enter more than one character, only the first character is used. TAB (tab) LOCALE Delimiter is derived from the content locale.

TAB

RSVP.CSV.QUALIFIER

The string qualifier used for CSV output.

Enter a single character. If you enter more than one character, only the first character is used.

If the qualifier appears as part of your data, it is duplicated. For example, if the qualifier is a quotation mark and your data is ab"cd, the CSV output is "ab""cd".

" (quotation mark)

RSVP.CSV.TERMINATOR

The line terminator used for CSV output.

Enter one of the following:

a single character If you enter more than one character, only the first character is used. CR (carriage return) LF (line feed) CRLF (carriage return/line feed) LFCR (line feed/carriage return)

LF

RSVP.CSV.MIMETYPE

The MIME type attributed to the CSV output.

application/ vnd.ms-excel/

Supported Encoding Values

The following table shows encoding values that are supported and tested by Cognos.

Character set

Supported encoding value

UTF-8

utf-8

Western European (ISO 8859-1)

iso-8859-1

Western European (ISO 8859-15)

iso-8859-15

Western European (Windows-1252)

windows-1252

Central and Eastern European(ISO 8859-2)

iso-8859-2

Central and Eastern European (Windows-1250)

windows-1250

Cyrillic (ISO 8859-5)

iso-8859-5

Cyrillic (Windows-1251)

windows-1251

Turkish (ISO 8859-9)

iso-8859-9

Turkish (Windows-1254)

windows-1254

Greek (ISO 8859-7)

iso-8859-7

Greek (Windows-1253)

windows-1253

Japanese (EUC-JP)

euc-jp

Japanese (ISO-2022-JP)

iso-2202-jp

Japanese (Shift-JIS)

shift_jis

Traditional Chinese (Big5)

big5

Simplified Chinese (GB-2312)

gb2312

Korean (EUC-KR)

euc-kr

Korean (ISO 2022-KR)

ISO 2022-KR

Korean (KSC-5601)

ksc_5601

Thai (Windows-874)

windows-874

Thai (TIS-620)

tis-620