jpastoor/jira-worklog-extractor

Helper to extract worklog entries from JIRA using their REST API

dev-master 2020-03-07 13:26 UTC

Requires

• php: >=7.3.0
• ext-json: *
• chobie/jira-api-restclient: dev-master@dev
• mk-j/php_xlsxwriter: ~0.22
• monolog/monolog: ~2.0
• symfony/console: ~4.4

Requires (Dev)

• phpunit/phpunit: ~9.0

MIT

• Joost Pastoor

• rest
• api
• jira
• worklog

README

Tool to help extract worklogs from JIRA. The native UI and REST interface for dealing with worklogs is a bit clunky so I wrote this little tool to help with it.

Currently outputs a CSV table with the projects on the rows, authors on the columns and worked hours in the cells.

Usage with docker

Make sure you have docker and docker-compose installed on your machine.

Clone or download the source code and install dependencies

git clone https://github.com/jpastoor/jira-worklog-extractor.git
cd jira-worklog-extractor
docker-compose run php-cli composer install --prefer-dist

Copy the config.json.template to config.json and alter the values.

Then you can run the commands using:

docker-compose run php-cli php app.php

Example command:

docker-compose run php-cli php  app.php load-project-totals 2016-01-01 2016-03-31

Example output:

project;matthijs;jeroen;chris;ernst;joost
WGF;52;0;1;20;7
WATSAFEGBS;0;0;9;0;0
WAT;119;0;0;7;39

License

MIT License

Thanks to

Marius Storm-Olsen for his code sample on https://answers.atlassian.com/questions/87961/how-to-get-list-of-worklogs-through-jira-rest-api