What is the proper format for importing Time Spent?

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.  

 

3 answers

This widget could not be displayed.

Hi Brian

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

In that example, what does the date/time format need to be on the Setup screen of the import?

my example above was only the Time Spent component of my import...my full import record looks like this:

 

INT-1,Paid Time Off,2015-03-10 08:00;auser;28800

 

Where INT-1 is the issue key, "Paid Time Off" is the Issue Summary

This widget could not be displayed.

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.

yyyy-MM-dd h:mm:ss

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

This widget could not be displayed.

Hi

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.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

196 views 3 0
Join discussion

Atlassian User Groups

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!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you