It's all about the answers!

Ask a question

Work item export file encoding


Harry Koehnemann (30125238) | asked Nov 16 '10, 12:06 a.m.
What is the encoding for the Work Item export (File Export)? While Excel and my text editor read it OK, Java and less both have issues. Looking at the bytes, I see the encoding looks a little goofy (see the bytes inteh otal dump below). Many thanks
<pre>
C:\Users\harry\Desktop&gt;more export.csv
&quot;Children&quot; &quot;Type&quot; &quot;Id&quot; &quot;Summary&quot; &quot;Owned By&quot;

C:\Users\harry\Desktop&gt;od -c export.csv | more
0000000 377 376 &quot; \0 C \0 h \0 i \0 l \0 d \0 r \0
0000020 e \0 n \0 &quot; \0 \t \0 &quot; \0 T \0 y \0 p \0
0000040 e \0 &quot; \0 \t \0 &quot; \0 I \0 d \0 &quot; \0 \t \0
0000060 &quot; \0 S \0 u \0 m \0 m \0 a \0 r \0 y \0
</pre>

2 answers



permanent link
Patrick Streule (4.9k21) | answered Nov 16 '10, 6:08 a.m.
JAZZ DEVELOPER
What is the encoding for the Work Item export (File Export)? While
Excel and my text editor read it OK, Java and less both have issues.
Looking at the bytes, I see the encoding looks a little goofy (see the
bytes inteh otal dump below). Many thanks

It is using UTF-16 Little Endian with BOM. This is the only format that
Excel will open automatically and render correctly if Non-Latin
characters are used.

In 3.0, there is the option to choose the encoding and the separator:

http://dl.dropbox.com/u/2663305/ScreenShots/2010-11-16_1206.png

--
Regards,
Patrick
RTC Work Item Component Lead

permanent link
Work Item &amp; UI Commons Team (1.3k1) | answered Dec 23 '10, 10:55 a.m.
You can pick the encoding from the RTC Eclipse client. By default its
UTF-16 but can be changed
to UTF-8.

I am not sure about the Web UI export though.

On 16.11.2010 6:08, harryk wrote:
What is the encoding for the Work Item export (File Export)? While
Excel and my text editor read it OK, Java and less both have issues.
Looking at the bytes, I see the encoding looks a little goofy (see the
bytes inteh otal dump below). Many thanks

C:\Users\harry\Desktop&gt;more export.csv
&quot;Children&quot; &quot;Type&quot; &quot;Id&quot;
&quot;Summary&quot; &quot;Owned By&quot;

C:\Users\harry\Desktop&gt;od -c export.csv | more
0000000 377 376 &quot; \0 C \0 h \0 i \0 l \0 d \0
r \0
0000020 e \0 n \0 &quot; \0 \t \0 &quot; \0 T \0 y
\0 p \0
0000040 e \0 &quot; \0 \t \0 &quot; \0 I \0 d \0
&quot; \0 \t \0
0000060 &quot; \0 S \0 u \0 m \0 m \0 a \0 r \0
y \0

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.