Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Update A Date Field Via CSV file

Questions
Tags
Users
Badges
Kristie Carpenter
(6●1) 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.

0 votes

1 answer
3,674 views
0 votes

One answer

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.6k●3●36●49) Jun 09 '17, 12:28 a.m.

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

0 votes

Comments
Kristie Carpenter
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
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jun 09 '17, 9:51 a.m.

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 log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jun 08 '17, 4:11 p.m.

Question was seen: 3,674 times

Last updated: Jun 09 '17, 9:51 a.m.

Confirmation Cancel Confirm