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> |
2 answers
What is the encoding for the Work Item export (File Export)? While 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: What is the encoding for the Work Item export (File Export)? While |
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.