Customer,Category in Tempo xls report


How can I add Customer and Category information to Tempo xls report. I only see custom fields to check.


7 answers

1 accepted

1 vote
Accepted answer

I can see what you mean, this information is not included if you use format=excel. It is included in the XML export. I will talk to the development team about this. As a workaround you can use the XML export and import it to Excel.

Thank you. I use xml format and now I see the necessarry informations.


please take a look at If you add "addBillingInfo=true" to your URL (parameter g) you get both category and client and some more information about the account.

Kind regards



Thank you for your fast response.

I have two problems:

1. I use this link: http://jira.mydomain/plugins/servlet/tempo-getWorklog/?dateFrom=2013-12-01&dateTo=2014-01-16&format=excel&diffOnly=false&addBillingInfo=true&tempoApiToken=my-token

I got new fields but I don't see Customer and Category.

2. Despite of th default (false) values I see a lot of fields:

Worklog Id,Issue Id,Issue Key,Issue Summary,Hours,Work Date,Username,Staff Id,Account Key,Account Desc,Worklog Attributes,Activity Id,Activity Name,Component Id,Component NameVersion Id,Version NameWork Description,Parent Key,Reporter,External Date,External Id,External Hours,External Result,Project Key,Project NameProject Category,Issue Status,Issue Status NameIssue Type,Issue Type Name,Issue Original Estimate,Issue Remaining Estimate,Issue Priority,Issue Priority Name,Issue Created,Issue Updated,Issue Due Date,Issue Resolution,Issue Resolution Name,Issue ResolvedUser Full Name,Actual Account

I tried False values but i experineced the same.
I would like to see hours, Billing informations(Acocunt,Customer,Category,etc.), username.
Could you please recommend an URL to me?

Thank you in Advance!

Any progress on this issue?

the URL you are using should return you the Category and Customer (Client). At the end of each worklog information you should get the Account Information.

I attach an example from our Test database, the URL used is:

http:// jira.mydomain/plugins/servlet/tempo-getWorklog/?dateFrom=2015-02-01&dateTo=2015-02-28&format=xml&diffOnly=false&addBillingInfo=true&tempoApiToken=mytoken

and the result returned shows:

<activity_name>Core Modules</activity_name>
<Billing project_key_list="10130" key="201500" name="Tango OnDemand" category_code="300" category="Development" client="100100" client_name="GreenCloud" project_owner="John Steel" responsable="Robert Penn"enabled="3" global="false" monthly_budget="750" account_id="11"/>

Hope this helps.


Hi Susanne,

sorry I was unclear. I was referring to the excel version of the report. 


This is not possible in the current version of Tempo, but it has been requested in We value feedback and comments on how we can make Tempo better, so if you'd like to contribute to this request, please vote on it. 


Suggest an answer

Log in or Sign up to answer
Community showcase
Published Feb 07, 2019 in Marketplace Apps

A Timeless Love Story

It started as any story starts, on a normal, rainy day.   Admin meets App, and her name was Klok2, and like any first relationship we were both trying to make it work but neither one knew what...

439 views 8 26
Read article

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