I've tried as many combinations of date/time format as I can think of, and still get a parsing error on the time spent field.
Most recent attempt: 2015-03-10 08:00;auser;28800
Date format specified on the Setup screen: yyyy-mm-dd hh:mm
I'm willing to overlook the ridiculousness of converting all time to seconds if I can get this figured out.
see this example:
Summary,issue key,estimated time,Worklog,Worklog Original Summary,PRJCODE-1829,360000,Entry 1-1;2013-01-01 12:30:10;user1;4800,Entry 1-2;2013-01-02 12:30:10;user2;4800 Original Summary2,PRJCODE-1829,363600,Entry 2-1;2013-01-03 12:30:10;user1;3600,Entry 2-2;2012-12-12 12:30:10;user2;4800
Please Help!! i've spent a ton of time trying to import worklog entries with a date and time spent. I've tried the suggestion seen here to no avail:
Entry 1-1;2013-01-01 12:30:10;User1;4800
I replaced "User1" with my actual user name to see if it makes a difference. Ive even tried different date formats as i was importing the CSV.
The only thing that seems to work for me is l leave just the time spent(4800).
The error logs are useless as they just say "Unable to parse Time Spent"
Any help from someone who is successful at this in the cloud would be greatly appreciated!! - Josh
What works for me, that I use exactly the same date time format in my CSV, which is set in JIRA administration/User interface/Look and feel/Date time formats.
My date time format is: yyyy.MM.dd HH:mm
My CSV line is: RRIMPF03-10,RR-IMP-F03 RFP,software,RRIMPF03,Summary of the ISSUE,worklog entry description4;2017.11.09 12:30;mlipcsik;3600
Hope this helps.
If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot