Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,299,122
Community Members
 
Community Events
165
Community Groups

How to export "Log Work" fields to Excel

I'm working on creating an Excel report to show employees what tasks they logged time to in the last payroll cycle and how much time was logged.  I've identified the columns (aka fields) that I want in this as the "Log Work" columns.  This is a column that grows in number in an export, depending on the tasks that have the most work entries logged.

I found the forum thread that shows how to specify which columns to include in your "Selected Fields" for an export.  When I go to the list view and begin typing "Log Work", this is not a field that I can chose from.

I'm trying to avoid having to go through the "Export all Fields" process and get right to what I need - any thoughts on how I can do this?

4 answers

1 accepted

6 votes
Answer accepted

I don't find a way to do it purely in Jira but there are tens of add-ons that can handle that.

Clockwork Automated Timesheets Pro allows getting a report (in your case grouped by users, issues, worklogs) and next export it to Excel. 

Clockwork Free can do it as well.

Below is an example screenshot:

clockwork.png

I hope it helps.

Cheers,
Jack

Thanks for looking into this, Jack.

 

I agree with you - I don't think that this can be done without outside assistance (aka add-ons).

@Jack Hunter [HeroCoders] this free version of the app is exactly what I was looking for, thanks so much!

You're welcome @Joan Suchoski

We make a living from delivering Pro versions of the apps, but we also want to give something to the community, hence the Free versions. 

Cheers,
Jack

2 votes

Select the Original Estimate, Spent Time and Remaining Estimate fields then use the "Selected fields" export option.

Or you can export each worklog (that is not a field, so the "selected fields" approach will not work) as explained here:

jira-issues-selected-fields-with-worklogs

This has to be done on a task-by-task basis, correct?

Not necessarily.

It works with any number of issues, which can be one or more. You can input the issues using JQL.

If you look at the screenshot, the values in the Created column (K) are the creation dates of individual issues. In other words, my shot was taken about multiple issues, some issue having a single worklog (row 2), some having more (row 9-13), some having zero worklog (row 14).

I suggest you give this a try as it is more difficult to explain that to use.

Hi Paul,

I agree with Aron here. Have a deeper look at JQL. It is very powerfull to filter your results down to the issues you really need to export, you will find a great intro to JQL by a blog entry done by Dan.

Like Akash MK likes this

As an additional resource, read our blog about how to export Jira worklogs to Excel >>

2 votes
Mikael Sandberg Community Leader Apr 12, 2018

The fields you are looking for is Time Spent.

Mikael Sandberg Community Leader Apr 12, 2018

The time tracking consist of three fields, Original Estimate, Time Spent and Remaining Estimate.

Like Elena Kupinic likes this

Sorry, but this is not the field I'm looking for - this one just sums up the entirety of all work logged against the task.  The fields that I want are the "Log Work" fields - I've only been able to find them when exporting all fields.  Each column contains a single entry of time against the subject and includes the description, the date/time, user who logged the work, and number of seconds they logged.

Like Tomasz Duda likes this

I'm sure Paul would have discovered this by now but for anyone reading this looking for answers....

When exporting all fields, the field "ALL_LogWork" doesn't contain the date specified by the user when the logging the work. It contains the date stamp of when the user creates the log.

Why it works like this is a complete mystery to me. I'm trying to find a fix but it looks like this behaviour has been classified as a bug from 2017 and still hasn't been fixed.

Did you ever find an answer for this? I'm having the same issue, and don't want to just export all fields.

Ashley, unfortunately I did not find a native solution.  There appear to be a lot of add-ons that could do this, but I am not in a position to go this route (I have no budget and no authority to have my Confluence Admin team "just put it in" for me).

 

The other problem that I ran into before I gave up on this was that the data that is included in the export is the date & time that the time entry was made, not the date & time that the time entry is for.  That is, if I update my time entry in Jira on Friday, the export will show that I worked 40 hours on Friday (since that is when I entered all of my time for the entire week).

 

Fortunately (haha) for me, the project I was attempting this for was cancelled, so now we are back to not caring who is working on what when.

Like # people like this

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you