Customer,Category in Tempo xls report

Hi,

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

Thanks.

7 answers

1 accepted

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.

Hi,

please take a look at https://tempoplugin.jira.com/wiki/display/TEMPO/Tempo+Servlet+Manual. 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

Susanne

Hi,

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:

<worklog>
<worklog_id>14775</worklog_id>
<issue_id>10802</issue_id>
<issue_key>TO-24</issue_key>
<hours>8.0</hours>
<billed_hours>8.0</billed_hours>
<work_date>2015-02-04</work_date>
<username>Jessie</username>
<staff_id>78987987987</staff_id>
<billing_key>201500</billing_key>
<billing_attributes/>
<activity_id>c10100</activity_id>
<activity_name>Core Modules</activity_name>
<work_description>ggh</work_description>
<parent_key/>
<reporter>robert</reporter>
<external_id/>
<external_tstamp/>
<external_hours>0.0</external_hours>
<external_result/>
<hash_value>4f87c4fdcce3d02eabe37298bf556b0aab4b278e</hash_value>
<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"/>
</worklog>

Hope this helps.

Regards,
Susanne

Hi Susanne,

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

Regards,
Moritz

This is not possible in the current version of Tempo, but it has been requested in https://tempoplugin.jira.com/browse/TT-1207. 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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Jul 10, 2018 in Marketplace Apps

If you’re an Atlassian app developer, you’ll want to know about Atlas Camp!

This September 6-7, hundreds of Atlassian App developers will flock to Barcelona Spain to build skills, discover product roadmaps, meet face-to-face with the Atlassian team, and learn how to extend t...

160 views 0 4
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