Import Work Log items (Planned/Estimate/ToDo) via CSV

hi

I want to import the work log items corresponding to Estimated effort/Time Spent(Logged)/Remaining Time into JIRA via CSV file. I could not find any field name applicable for the CSV for these fields (except Time Spent).  After import, I would like to see these 3 fields populating against the fields as displayed in the below image.

The JIRA documentation only says this (only one field - Worklog/Logged) -

Importing worklog entries

Your CSV file can contain worklog entries. For example:

 

Summary,Worklog
Only time spent (one hour),3600
With a date and an author,2012-02-10 12:30:10;wseliga;120
With an additional comment,Testing took me 3 days;2012-02-10 12:30:10;wseliga;259200

 

To track time spent, you need to use seconds.

Please help.  

worklog.png

 

2 answers

1 accepted

1 vote
Accepted answer

Hello,

please mind that JIRA has two CSV Importers:

  • non-admin CSV Importer available under Issues top menu
  • admin CSV Importer available under External System Import in System settings

The second is available for administrators only and by default can import to any JIRA field. The first one is meant for non-administrator users and can only import to fields that are present on Create Issue Screen (a way of bulk-create issues).

All fields that you are looking for should be available under the second importer.

hi 

I am trying to update an existing issue with 'Total Effort Estimate' value through External System Import. Please note that there is no values set for Original Estimate or Remaining Estimate for this particular artifact. My csv looks like the following:

Issue key, Summary,Issue Type,Total Effort Estimate

1, "hello world", Bug, 3600

After the import, I do not see any updates in the work log section (no work log section at all actually !).  

Can we add a total effort estimate to any artifact if there is no original/remaining estimate set ?

Please help.

Thanks

Rashmi

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in United States

Topic Tuesday: What's your favorite topic?

Good morning All, Our goal is to get you into the habit of while enjoying your favorite morning drink you are checking the NOVA "space" for topics and comments. Your input is really needed and...

62 views 4 0
View post

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