I got very large issues to be export as excel, and it's very slow. How can I improve it?

I got very large issues to be export as excel( more than 20 000 issues), and it's very slow. How can I improve it? Is there any way to make it export as text file?

1 answer

1 accepted

1 vote
Accepted answer

by default jira will limit to 1000 issues, check here to know how to increse limit

https://confluence.atlassian.com/display/JIRAKB/Export+More+Than+1000+Results+to+Excel

Yea, I already changed limit to 30000. But, it takes long time to process to excel.

because my user wanna export all the closed issues, which contains 23k issues.

Is there any way I can export it as text file?

if you made it to the 30k then it will become very slow, i am not sure why you want to export so many issue to excel!

check this

https://answers.atlassian.com/questions/57288/how-can-i-use-the-export-to-excel-functionality-for-more-than-1000-issues

No, and you've found out why there is a 1000 limit by default - the process is heavy on the system and slow.

Rambanam has a very good point - why does someone thing a 23k export is needed? It's no good saying "because they do", the question is what are they trying to achieve? There's almost certainly a much better, faster, cleaner and more functional way to get what they want. Ask them why they're wasting your time and the server resources...

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,306 views 12 19
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you