A simple console application created for my own needs. It allows to create work logs in Jira issues from Excel records (or from any similarly formatted text).
For the records in the image above, it creates the following work logs in Jira issues:
- MBC-23: Jan 2 -> 8h
- MBC-23: Jan 3 -> 3h
- MBC-23: Jan 4 -> 7h
- MBC-24: Jan 2 -> 4h 30m
- MBC-24: Jan 3 -> 8h
- MBC-24: Jan 4 -> 6h
Follow instructions here: https://support.atlassian.com/atlassian-account/docs/manage-api-tokens-for-your-atlassian-account/#Create-an-API-token
cd ./src/JiraWorkLogger
dotnet user-secrets set "app:baseUrl" "https://<your-site-name>.atlassian.net/"
dotnet user-secrets set "app:username" "[email protected]"
dotnet user-secrets set "app:apiToken" "XYZ.........."- Run console application
- Copy cell range from Excel similar to the image above
- The first column contains Jira issue key
- The first row contains dates
- Value in the other cells contains time in hours to log
- Alternatively you can copy text directly from any editor
- For the sample above it should looks like this
\t2.1.\t3.1.\t4.1. MBC-23\t8\t3\t7 MBC-24\t4,5\t8\t6
- For the sample above it should looks like this
- Paste text from Excel (or the direct text) into console when asked by the application
- Press Enter
- Check recapitulation of parsed data
- You can check summary per issue key
- Press Enter
- Watch console and enjoy as you work is logged in Jira issues 🎉
If any record cannot be processed and API call gets error result, processing is stopped and error message with details is shown. You can choose to continue to process other records or stop with Ctrl + C
