Planned as a Jira assistant does some checks on every Sprint planning and notifies team members via Slack.
Given an Excel sheet that is used by Scrum Master as template during the planning of the next Sprint...
Epic | Priority | PBI | PBI Definition | Sprint | Assignee | Note | Story Point |
---|---|---|---|---|---|---|---|
Deployment | 1 | IMA-17 | New Deployment | Sprint53 | Sam | - | 3 |
Development | 2 | IMA-18 | New Development | Sprint53 | Herald | - | 5 |
Analysis | 3 | IMA-19 | New Analysis | Sprint53 | Anna | - | 8 |
Design | 4 | IMA-20 | New Design | Sprint53 | Benedict | - | 13 |
...planned Sprint can be checked by using checkJira()
method on JiraApi.java
whether if it's planned on Jira properly according to the Excel planning sheet.
Edit Story Points of 1 PBI(s) on Jira according to the Sprint Planning Excel sheet? (y/n)
Upon finding a mismatch between the Excel sheet and the content on Jira, it prompts the user to agree editing Jira content.
Story Point of IMA-20 has been changed to 13
If the user wishes, a notification to the team members will be sent on Slack.
Would you like to notify the user(s) about the recent change on Jira? (y/n)
resources/credentials.properties
must be filled with necessary information such asemail
,api_token
, andjira_link
for Jira configuration andwebHookURL
andchannelId
of target channel/member for Slack configuration.- The Excel sheet used for planning must be located in
src/main/resources/
folder and the path must be specified inreadExcel()
method onReadExcel.java
. - If the target field on Jira to be changed is a custom field such as "Story Points" its name must be found on the response body using below code.
response.getBody()
- Run the main method of
Run.java
- More fields can be checked on Jira if everything is going according to the plan.