Customer,Category in Tempo xls report

[Test comp]

Hi,

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

Thanks.

[Susanne Götz [Tempo] · Accepted solution]

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]

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

[Susanne Götz [Tempo]]

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

[Susanne Götz [Tempo]]

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. 

[M_ Ahl]

Hi Susanne,

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

Regards,
Moritz

[Susanne Götz [Tempo]]

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

[M_ Ahl]

Any progress on this issue?

[Test comp]

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!