Cause, Solution, Languages – IBM 51 User Manual
Page 85: Other, Than, English, Text, Reports, Imported, Microsoft
For
more
information,
refer
to
the
DB2
product
documentation
available
at
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
file
in
Notepad,
and
then
save
it
as
Unicode,
renaming
it
to
.
2.
Open
the
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
file
in
Notepad,
and
then
save
it
as
ANSI,
renaming
it
to
.
2.
Open
the
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