I am trying to export all the jira into a excel spreadsheet. I realised it can only export 1000 rows even if there are more than 1000 in the issue navigator. Is there a work around?
I can apply a filter on creation date to limit the size of the result set. But is there a better solution?
Please refer to the following KnowledgeBase article:
Please let me know if I can be of further assistance.
Atlassian - San Francisco
1000 is a number judged low enough to avoid the performance problems a large export causes. If you need it changed, you'll need to talk to your Studio provider. They're unlikely to increase it because of those problems.
A far better question might be to ask why you're exporting 1000s of issues - Most of the time, it usually means someone doesn't know how to use Jira and a little training will get them working far more efficiently than messing around with spreadsheets (that are obsolete as soon as they're downloaded). In some cases where it's valid, you'll find there are better ways of getting there as well.
I agree that I might not be as expert in JIRA as you are and would welcome any training coming my way which can make me an "expert".
We are using JIRA Studio (provided by Atlassian themselves) and they have restrictions on developing our own styles of reports. They have restrictions about using other plug-ins as well. So, the easiest way for us was to fall back on Excel sheets to get the reports. I agree that the report might not be dynamic (and can be obsolete as soon as it is created), but it is proving helpful to us.
The data that I've been exporting to the report has been less than 1000 till date except for once and that was when I realized about this limit.
The question was just a normal enquiry and we can actually live with this limitation for the time being.
Hello @Nic Brough - I will give you an example of why it is needed to provide more than 1000 lines returned.
Companies that are publicly traded are required to follow and maintain SOC guidelines. We are audited annually to ensure these guidelines are followed. Auditors require us to provide them a list of customer opened tickets. Since we have more than 17000 tickets a year it is pertinent that Jira allow us to provide this information. In addition to the results we need to provide screenshots of the query used to derive the said results. I see that this issue has been ongoing now for well over 8 years. When is Atlassian going to provide a solution to it?
Yes, this is a very real requirement. Atlassian is unlikely to go down this path due to the high risk of degraded performance at a sizable segment of their customers. Clearer communication or more accessible documentation would be welcome, but folks usually are able to solve this by following instructions found in community posts like this.
By the way, I recently posted a somewhat similar use case story where the team (finance industry) needed to comply with SOC1, by exporting the complete records of all their customer transactions to PDF format out of Jira. That wasn't a small feat, either.
the url of excel export looks like this: http://xxxxx.xxx.xx/sr/jira.issueviews:searchrequest-excel-all-fields/temp/SearchRequest.xls?&pid=10170&status=5&sorter/field=issuekey&sorter/order=DESC&tempMax=1000
tempMax=1000 is the parameter you have to change. you wana change it at one query or wana make it permanent?
This may be an old post; however we see this limit is still in place. (running on JIRA 6.0.7 at the moment)
I have tried to update the
jira-config.properties and added these rows:
This seems to have no effect because the limit at exporting is still 1000 rows (even after restarting JIRA and rebooting the server and emtying the browser cache )
After updating the jira.config.properties the export button also still has the
&tempMax=1000 at the end. Changing the url to &tempMax=2000 returns a 403 error (forbidden)...
Found it: there's also a jpm.xml with the values of jira.search.views.default.max and after updating the values there to 2000 the default is now set to 2000 and exporting goes well.
Found it in this link: https://confluence.atlassian.com/display/JIRAKB/Export+More+Than+1000+Results+to+Excel
With ImpEx, you can export more than 1000 issues.
You can find it on the Atlassian Marketplace:
(And it is also available for Data Center!) :)
Best regards, Mark
I collect a filter that produces 2500+ rows of records.
I split them by appending the following to my csv url:
Then I append them in Excel.
Introducing Jira Cloud for Excel Here at the product integrations team at Atlassian, we are thrilled to announce the new Jira Cloud for Excel add-in! This add-in lets you export Jira data directly ...
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