If you want to export a Jira Filter to Excel or csv, you will face the 1000 issues limit so that the built-in export does not work.
I present here a nice Excel/VBA-based tool that make Jira filter export to Excel a one-click solution.
Problem/ Challenge description
From a Filter view, Jira provides some built-in functionality to export the issues list to different format.
What we want here is to get an export to a plain Excel file in a table format.
When you have a lot of issues in the filter - in fact more than 1000, the export function does not work but returns the following error:
To bypass this error you will have manually to append ?tempMax=1000&startPage=0-1000-2000 etc. as explained by Atlassian here.
Solution implementation
You can download the file in github/tdalon/tools/Jira_Export.xlsm
Gist for the main macro is available here.
It uses curl (available with Windows 10) and loop the csv export by 1000 batches.
The result is aggregated in a Table aka ListObject.
Usage
Download the file Jira_Export.xlsm.
From the ribbon, you can run the Export function. It runs the macro ExportFilter_Callback.
Prerequisite: you have your Windows password set under %temp%/password.txt (this file location is only accessible by the logged-in user. Feel free to adapt this part, delete the password file after usage)
In the Worksheet you run the macro, you need to have one Table defined. The first one in the current sheet will be used as target for the export.
If in the same sheet you have a named cell with the name "JiraFilterUrl", it will be used to store the filter exported.
The Table size and columns will be adapted automatically.
This is a one-way export without any merging of custom columns. You will get what you see in Jira.
No comments:
Post a Comment