Hello
Is there a way to get worklogs out from tempo via an API?
Eg: get logged hours for each day, between start and end date for user X.
edit: I've tried the tempo-getWorklogReport rest api, but that needs (?) a billing key as an input, which I don't have, and would like to avoid.
Community moderators have prevented the ability to post new answers.
That s right, Tempo worklogs are stored in the same table as JIRA so you will received all worklogs within the selected period.
Hi
You don t need to add an Account (Billing key) as a parameter for using the Tempo API.
All reports can be exported to Excel directly from Tempo report view. This blog explains how you can export and pivot your data in excel
http://blog.tempoplugin.com/2012/pivoting-tempo-and-jira-reports-using-excel/
You can also use the Tempo API to export all data on a high level permissions as documented on this page:
http://blog.tempoplugin.com/2012/creating-excel-reports-using-high-level-permissions-api-export/
Hope this helps
Sverrir Tynes
Tempo support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What if I also have worklog data before tempo?
As far as I know tempo also stores worklog data into the jira worklog table.
Could I just create a JQL query to get worklogs out of the worklog table, and get both old jira worklog data, and new tempo worklog data at the same time?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Marco,
the worklog attributes are stored in a Properties table and are not easily accessed as they are kept in XML format. Moving them to AO tables is in our backlog.
It is recommended that you use the Tempo servlet instead of accessing the tables directly. The information added to worklogs using the Worklog attributes are included in the XMl and the Excel export.
Kind regards,
Susanne
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Susanne Götz [Tempo], is there any official documentation related with this topic?
I'm asking because i'm working on a project where we are extracting data from the JIRA Database and we are having dificulties in retriving tempo information.
I would appreciate your help.
Best Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pablo
here is a link to the documentation of the servlet.
https://tempoplugin.jira.com/wiki/display/TEMPO080/Tempo+servlet+manual
Please note that this will export all worklogs for the given period, independent if they were logged in JIRA or Tempo, as the worklogs are stored in the same database table. It is possible to filter this export by adding the parameter projectKey=YOUR_PROJECT_KEY. This export includes also the worklog attributes if you are using any.
To get information about the worklog attributes (in Tempo Timesheets 8), please take a look at http://tempo.io/doc/core/api/rest/latest/. This is a private API and subject to change
Regards,
Susanne
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Susanne Götz [Tempo] thank you for your quick reply. Reading your answer I assume that its still not possible to access this information through database? Is this correct?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We do not recommend accessing the database directly, but the tables for all installed plugins are listed in JIRA Administration, System, Advanced, Plugin Data Storage.
The Worklog attribute tables are listed in the Tempo Core section ( for Tempo Timesheets 8)
The worklogs are stored in the JIRA worklogs table
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
I've got an additional question:
It's easy to add custom fields to the Tempo Worklog. But I can't find them in de Jira worklog-table.
Can you tell me, where I can find them. We want to retrieve these Date to import them into our ERP system. We work with a SQL-Server database.
Thank You very much and
best regards
Marco Schauer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Community moderators have prevented the ability to post new answers.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.