Customer,Category in Tempo xls report

Test comp January 15, 2014

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

1 vote
Answer accepted
Susanne Götz [Tempo]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 15, 2014

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.

Test comp January 16, 2014

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

1 vote
Susanne Götz [Tempo]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 15, 2014

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

0 votes
Susanne Götz [Tempo]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 16, 2015

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. 

 

0 votes
M_ Ahl February 13, 2015

Hi Susanne,

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

Regards,
Moritz

0 votes
Susanne Götz [Tempo]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2015

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
0 votes
M_ Ahl February 13, 2015

Any progress on this issue?

0 votes
Test comp January 15, 2014

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!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events