It's all about the answers!

Ask a question

Update A Date Field Via CSV file


Kristie Carpenter (61) | asked Jun 08 '17, 4:11 p.m.

 We created a new attribute using the date attribute type. I would like to populate this field via a CSV file. However, when I import, it doesn't give me any errors but it doesn't update it either.


I have tried the following formats:
6/8/17
June 7, 2017, 12:00:00 PM

Is there a certain format that has to be used for updating dates via CSV.

One answer



permanent link
Ralph Schoon (63.3k33646) | answered Jun 09 '17, 12:28 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

 What format do you see, if you export a value?


Comments
Kristie Carpenter commented Jun 09 '17, 8:37 a.m.

  The exported format is June 7, 2017, 12:00:00 PM.


I tried that format in my import file with no success.


Ralph Schoon commented Jun 09 '17, 9:51 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

I have tried/tested the import with the work item commandline. Not sure If I tested the built in import. Since no version number has been provided there is no way to test it either. 

Your answer


Register or to post 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.