Work item export file encoding
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>more export.csv
"Children" "Type" "Id" "Summary" "Owned By"
C:\Users\harry\Desktop>od -c export.csv | more
0000000 377 376 " \0 C \0 h \0 i \0 l \0 d \0 r \0
0000020 e \0 n \0 " \0 \t \0 " \0 T \0 y \0 p \0
0000040 e \0 " \0 \t \0 " \0 I \0 d \0 " \0 \t \0
0000060 " \0 S \0 u \0 m \0 m \0 a \0 r \0 y \0
</pre>
<pre>
C:\Users\harry\Desktop>more export.csv
"Children" "Type" "Id" "Summary" "Owned By"
C:\Users\harry\Desktop>od -c export.csv | more
0000000 377 376 " \0 C \0 h \0 i \0 l \0 d \0 r \0
0000020 e \0 n \0 " \0 \t \0 " \0 T \0 y \0 p \0
0000040 e \0 " \0 \t \0 " \0 I \0 d \0 " \0 \t \0
0000060 " \0 S \0 u \0 m \0 m \0 a \0 r \0 y \0
</pre>
2 answers
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
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:
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>more export.csv
"Children" "Type" "Id"
"Summary" "Owned By"
C:\Users\harry\Desktop>od -c export.csv | more
0000000 377 376 " \0 C \0 h \0 i \0 l \0 d \0
r \0
0000020 e \0 n \0 " \0 \t \0 " \0 T \0 y
\0 p \0
0000040 e \0 " \0 \t \0 " \0 I \0 d \0
" \0 \t \0
0000060 " \0 S \0 u \0 m \0 m \0 a \0 r \0
y \0