Automates the creation of reports for managers using Atlassian Jira and Tempo plugin with export to Excel table.

Go to Jira API Tokens page at https://id.atlassian.com/manage-profile/security/api-tokens and create new token.

Go to Tempo API Integration page https://<COMPANY>.atlassian.net/plugins/servlet/ac/io.tempo.jira/tempo-app#!/configuration/api-integration and create new token with read permissions.

Copy TemplateAppConfig.yaml to your own, for example MyCompanyAppConfig.yaml and change it according to your preferences.

Template config:

jira:
  url: https://<COMPANY>.atlassian.net
  user_email: <USER_EMAIL>
  user_token: <USER_TOKEN>
  tempo_token: <TEMPO_TOKEN>
files:
  project_config: <COMPANY>ProjectConfig.xlsx
  report: <COMPANY>Report.xlsx

Placeholders:

• <COMPANY> - your company name.
• <USER_EMAIL> - email which is used for login to Jira.
• <USER_TOKEN> & <TEMPO_TOKEN> - tokens created before.

In general, tool can be run this way:

• Open console.

• Go to folder with reporter.

For example:

cd ~/Downloads/tempo-worklog

• Execute command:

./tempo-worklog <APP_CONFIG> <PROJECT_LIST> <START_DATE> <END_DATE>

• where:
  • <APP_CONFIG> - configuration file.
  • <PROJECT_LIST> - project keys in Jira (comma separated without whitespaces).
  • <START_DATE> and <END_DATE> - start & end dates for report respectively.

• When execution finished, two new files will be created:
  • <COMPANY>ProjectConfig.xlsx - where employee's Position and Rate should be filled.
  • <COMPANY>Report.xlsx - actually, result report.

For example:

./tempo-worklog MyCompanyAppConfig.yaml PRJ1,PRJ2 2023-01-01 2023-01-31

After the first run the project config file will be created. It is required to fill Rate column there to obtain valid calculations in report. After that, run reporter again with the same parameters and report file will be updated.

The new employee will be added to the project config file automatically.

go mod tidy && go mod vendor

To make a cross-build, please see available platforms:

go tool dist list

For example, for linux run this command to create a binary file for linux/amd64 architecture:

GOOS=linux GOARCH=amd64 go build

For batch build use Makefile and run:

make build

It will create builds directory with compiled binary files according to preconfigured set of platforms.