How do you export time worked our of JIRA?

[Randall Fisher]

We have all this time logged in JIRA issues, but what is the best way to extract that for reporting back to accounting?  We have someone querying the tables, but when Atlassain changes the schema, those break.  There never seems to be the correct fields exposed in JQL to make this work.  Any suggestions? 

[Randall Fisher · Accepted solution]

Unfortunately, we have someone in management who is querying the data directly out of the tables.

[Michel Mathia]

Has anyone tried this to export time log in excel? Is it good?

https://marketplace.atlassian.com/apps/1218992/timesheet-export-for-jira?hosting=cloud&tab=overview

[James Foster]

Hi Michel,

I encourage you to give it a try if you haven't already.

I hope it's good for you. If it's not, email us your feedback and we'll make it good. :-)

Regards,

James Foster

[pkirkeby]

Have you considered using reports from JIRA?

• https://confluence.atlassian.com/display/JIRA/Time+Tracking+Report

Or a plugin that provides additional functionality for this like https://marketplace.atlassian.com/plugins/jira-timesheet-plugin

[Randall Fisher]

We have the Timesheet plug-in, which helps greatly for the users to log there time, but getting that time back out of JIRA has always been a struggle. Most all of those reports are for reporting metrics that we really do not care about (ex. Estimated/Actual, How many hours did Bob Smith log vs. Cathy Jones, how much time was spent on release x.y.z). How can we create the reports we need? Reports that pull data on different aspects of different projects (Capex, Maintenance, etc.) with possible references to linked issues (uncovered by, blocked by)?