It's all about the answers!

Ask a question

Unable to re-import value of timestamp from CSV file which has been exported from RTC client

Eric Jodet (6.3k5111120) | asked Jan 28 '13, 5:53 a.m.
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
  • expected: due date is set as exported in the CSV file
  • observed: due date is unassigned
Is this a defect?

One answer

permanent link
Eric Jodet (6.3k5111120) | answered Jan 28 '13, 5:56 a.m.
yes - this issue has been identified as defect CSV - unable re-import work items - issue with timestamp (due date) attribute when using Korean Locales (248311)

short story:
CSV Import - uses
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)

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

Ralph Schoon commented Jun 08 '15, 2:49 a.m.

You want top open a PMR with support or create a work item here:

I am not sure we can solve this here.

Your answer

Register or to post your answer.