Filter
Top Products
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