our customer demands all Issues from their Project in an Excel or CSV file. We know this is a bad idea but in our position we have no choice. We have tried setting up the jira.search.views.default.max = 50000 in the /atlassian-jira/WEB-INF/classes/jira-application.properties but when we change the tempMax value in the URL the 403 Error is shown:
If you are using jira 4.4.x, should create a file in jira-home and add entries there too.
I can view maximum 5000 Issues and I edited as follows.
jira.search.views.max.limit = 5000
jira.search.views.default.max = 5000
Don't forget to restart JIRA
The bad news is that even if you change that, unless you're running Jira on some really powerful hardware, it's still unlikely to work. The excel export is resource intensive and I doubt it will cope with 50,000
There's no harm in trying (although I'd wait until a quiet time, outside working hours, so you don't cripple Jira while others are using it), but I think I'd be asking your customer to come up with a more sane request and think about doing it some other way.
I am sharing the solution I have implemented in VBA for overcoming this problem:
at the end of the post, you can download an excel file that includes the VBA source code.
I hope it would help,
Learn how to use two new reports for next-gen projects in Jira Cloud: Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events