export all issues and all related fields for each issue type from Jira Server to Excel

[vcatl2020]

Our management is asking for exporting of all 100,000+ issues with all related fields including comments or activities associated to each issue type (100+) from all projects into an excel/csv/html spreadsheet. Is there is a feasible way through native Jira, Sql query/view or addon that would help to accomplish the exporting of this data?

[Mohamed Benziane · Accepted solution]

Hi,

The first question is why do they need to export all theses issues ? 

You could use REST API and play with the startat maxresults parameter to achieve this.

https://confluence.atlassian.com/jirakb/filter-export-only-contains-1000-issues-in-jira-server-191500982.html

https://developer.atlassian.com/server/jira/platform/jira-rest-api-examples/#searching-for-issues-examples

Hope this helps

[vcatl2020]

Hi @Mohamed Benziane

Well it is still a million dollar question on why do they need ALL issues w/ fields :(

Meanwhile, I tried exporting first 1000 issues w/ ALL fields by adding &tempMax=1000 to the URL and the data view looks so odd, as it added 1024 columns in the export file for each issue, lol,lol...

I will run this by our management to find out if it makes any sense and keep you posted.