nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Randall Fisher

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

All comments

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)?

Randall Fisher

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

Wruff GK

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-administration