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
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
- expected: due date is set as exported in the CSV file
- observed: due date is unassigned
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)
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
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
I am not sure we can solve this here.