Unable to re-import value of timestamp from CSV file which has been exported from RTC client
I am using the RTC Eclipse Client version 4.0.1 to CSV Export and Import work items, using Korean Locales.
I am exporting timestamp attributes like due date, and found that I am unable to CSV re-import these values back into RTC. Steps I used: - set due date, and verified that my timestamp attribute has the expected Korean format (ex: 2013. 2. 4. 오후 12:00) - CSV Export my work items - CSV Import
|
One answer
yes - this issue has been identified as jazz.net defect CSV - unable re-import work items - issue with timestamp (due date) attribute when using Korean Locales (248311)
short story: CSV Import - uses com.ibm.icu.text.DateFormat CSV Export - uses java.text.DateFormat both format don't match for Korean locales, which causes the issue. verified in the CSV file: the format is different as missing a dot - 2013. 2. 4 오후 12:00 workaround: edit the CSV file, and add the missing dot (ex: 2013. 2. 4. 오후 12:00) Comments
vishnudharan manivannan
commented Jun 06 '15, 9:47 p.m.
Hi Eric,
I am using RTC 5.0.2 and via the eclipse client & I am unable to update the due date timestamp attributes for defect workitems.
Steps to reproduce :
1. create defect workitem in a normal scrum template and set due date to
29-Jun-2015, 12:00:00 PM as shown below.
Now export this workitem. The due date attribute is exported as
note : here though I chose the time as 12:00:00 PM, RTC exported as 08:30 AM. I am not sure why. (Server time zone may be ?)
Now when I modify the date in the excel to 20-05-2015 08:30 and import it back into RTC, then the value becomes unassigned in the RTC web client.
In the history and RTC eclipse client, it imports the value 05-Nov-25 8:30 am. Pls help. Vishnu M
You want top open a PMR with support or create a work item here: https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWelcome
|
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.