IBM 51 manual Cause Solution

For more information, refer to the DB2 product documentation available at http://www.ibm.com/software/data/db2/udb/support/manualsv8.html.

For languages other than English, the text in CSV reports imported in Microsoft Excel is garbled

Tivoli Intelligent Orchestrator reports that are exported to Comma Separated Values (CSV) file format can be afterwards imported in spreadsheet applications such as Microsoft Excel. When trying to import CSV reports into Excel in languages other than English, the text gets garbled.

Cause

The CSV files are written in UTF-8 format (abbreviation for Universal Transformation Format). UTF-8 converts 16-bit Unicode characters into 8-bit ASCII characters. Microsoft Excel does not currently support UTF-8 in CSV format. For more information about this known defect, you might also want to refer to http://support.microsoft.com/default.aspx?scid=kb;ja;821863.

Solution

CSV files are written in UTF-8 format to support multiple language scripts in a single report. CSV can be imported into spreadsheet applications, but can also be imported into the database using custom applications. The following solutions that have been tested for various languages are provided. In addition to these solutions, there are operating system and Excel requirements that must be met, in order for the characters to be displayed properly.

Solution 1

1.Open the <Report_name>.csv file in Notepad, and then save it as Unicode, renaming it to <Report_name>_unicode.csv.

2.Open the <Report_name>_unicode.csv file in Excel. The Text Import Wizard is displayed:

a.In the first step, select Delimited and ensure that all other options are clear.

b.In the second step, clear Tab and select Comma.

c.Click Finish before going to step 3.

After performing the steps described above, the CSV report can be opened in Excel with all characters displayed properly.

Solution 2

1.Open the <Report_name>.csv file in Notepad, and then save it as ANSI, renaming it to <Report_name>_ansi.csv.

2.Open the <Report_name>_ansi.csv file in Excel. The characters are properly displayed.

Solution 3

You can convert the CSV file from UTF-8 to native encoding using a code conversion tool. You can use the native2ascii command line utility that is provided with the Java JDK toolkit. The tool can be found in the %WAS_HOME%/AppServer/java/bin directory.

1.Open a command prompt window, and change directories until you reach the location of the native2ascii tool. Alternatively, you can set the value of Path, the system variable for the operating system, to include the location of the Java JDK toolkit.

2.Type the following command:

Chapter 7. Common problems and known limitations in Tivoli Intelligent Orchestrator 73