jpastoor / jira-worklog-extractor
Helper to extract worklog entries from JIRA using their REST API
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
This package is auto-updated.
Last update: 2024-12-07 23:49:38 UTC
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