JIRA Worklog Extractor

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