How to export more than 1000 issues?

David Holshouser
Contributor
January 10, 2020

The documentation says you can export all of the issues in a project. I have a project with 41,000 issues. The Issue Navigator is limited to 1000 issues and using Better Excel Exporter I've only been able to export the 1000 issue max, just like JIRA's internal export.

I can't find anything in the documentation saying how to do it, but it's supposed to be able to, so I'm missing something.

1 answer

0 votes
Mohamed Benziane
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 11, 2020

Are you on server or cloud ? You can try to export data using google sheet, there is a feature that refresh all data in the gsheet.

You can also use the jira rest api to download all the data you need using some loop (look at startat and maxResults parameter)

Take a look to this page you will find interesting info if you're on server 8.2 or more.

David Holshouser
Contributor
January 13, 2020

We're on server 8.4.

I did a lot more Googling and found the settings where the 1000 issue max is set.

The memory leak that was causing out of memory errors was fixed in server 8.2 and JIRA successfully exported my 41,000 issue project with no issues, including an export with all fields.

I no longer see any reason to limit issue search/view/export to 1000 issues and have permanently adjusted my limit.

Modify <atlassian-home>/Application Data/JIRA/jira-config.properties:

jira.search.views.default.max=5000
jira.search.views.max.limit=5000
jira.search.views.max.unlimited.group=jira-administrators

Also, modify <atlassian-home>/JIRA/atlassian-jira/WEB-INF/classes/jpm.xml to match in multiple places.

Like Mohamed Benziane likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events