New Customer and I need to export logged work data to excel

Cody Reeves July 9, 2015

I was told that we could export ALL data from JIRA to Excel but I can't find a way to get the 'logged work' data. I need the date, time spent and by whom. Please help!

 

image2015-7-9 8:22:57.png

 

Thanks

3 answers

0 votes
Nicolas Werle _Decadis AG_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 6, 2016

Hey,
we released an add-on "xPort - Custom Worklog Export for JIRA" on the Atlassian Marketplace including the following functions:

  • Create individual templates using your own corporate identity with optional project information, formats and your own images
  • Export worklogs & JIRA project information instantly
  • Generate automated performance records for your employees
  • Send reports automatically via email (in predefined time frames)

Please click here for more information: https://marketplace.atlassian.com/plugins/com.decadis.jira.xport/server/overview or contact us directly via email to atlassian-marketplace(at)decadis(dot)de

With kind regards

Nicolas Werle
(Decadis AG)

0 votes
Midori
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 18, 2016

Use the worklog-analysis.xslx template of the Better Excel Plugin. It does exactly what you wanted, exporting worklogs from Issue Navigator using the current column configuration ("visible fields") or all columns ("all fields").

0 votes
Christian Czaia _Decadis AG_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 9, 2015

I would have a look at the worklog table in the database! (or if you are using JIRA cloud: https://answers.atlassian.com/questions/113088)

Cody Reeves July 9, 2015

Should have qualified, we are using the Cloud version. Is it possible to access the tables directly? 

Christian Czaia _Decadis AG_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 9, 2015

In that case please look at this answer: https://answers.atlassian.com/questions/113088/exporting-worklog-report-of-the-month You need a separate add-on I guess...

Suggest an answer

Log in or Sign up to answer