I share in this post a way to add multiple links to Jira issues using R4J Excel Add-In and additional VBA macros. This post is a DRAFT/WIP quick version. If you have questions about it, please leave a comment to let me know and I will update it.
Step-by-step tutorial
- Import the issues you want to edit in Excel using the R4J Excel Add-In-> Load Data
- select the 'Issues Links' Field to be imported.
- Format the Data as Table for easy filtering
- Filter for the issues you want to add links to
- You can add a new e.g. 'Selected' Column for manual selection
- Run the Macro
- It will create a copy of the 'Issue Links' column named 'New Issue Links'
- Filter for the issues you want to synchronize back, by adding for example a calculated "Diff" column
- Remove unfiltered issues to only write back modified issues example using a macro included below
- Replace the original 'Issue Links' column by the 'New Issue Links' (make a backup to document; delete 'Issue Links' Column, rename 'New Issue Links' into 'Issue Links')
- Upload data using the Excel Add-In function
The Macro to Add Links looks like below:
No comments:
Post a Comment