Hi All,
I have around 11k tickets in my JIRa instance. I want to export that data into excel however will i export it to excel only top 1000 tickets only get imported. Can anyone help me in getting all 11k ticket in a single excel sheet so I can have my data consistent?
thanks!
From the Issue Navigator, users are unable to export to Excel more than 1000 rows.
This is a default, configurable limitation.
Attempting to export a large number of search results can result in performance issues. See OutOfMemory or Poor Performance due to XML View of a Filter for a discussion on performance problems.
It's possible to change this setting permanently. Make sure to heed the note above regarding potential performance impact.
Information
IconIf the jira-config.properties
does not exist under root of the JIRA home directory, please create the file.
The parameters we'll be using below work as per the following:
From <jira-home>/jira-config.properties
, add the following to increase the number of allowed rows exported to 2000:
jira.search.views. default .max = 2000 jira.search.views.max.limit = 2000 |
Note that the jira.search.views.max.limit value in jira-application.properties
must be set at least as high as the desired value.
This was tested on JIRA 5.2.8
Regardless of the above, users in this group will be able to request search requests that are unlimited. This MUST be a valid group with no spaces JRA-26088 - Configurations in jira-application.properties breaks if the group name has spaces. VERIFIED
jira.search.views.max.unlimited.group = <groupname> |
When using the unlimited group option, the default max will still be observed. It is the default which is meant to keep the request count down to not overload the system. If you want to export more than the default you will need to modify the URL of the string.
Copy the link of the View option you're trying to use then paste into a new browser window. Change the value at the end to reflect how many entries you'd like to export.
See Limiting the number of issues returned from a search view such as an RSS feed.
Right-click the URL for export (either "All Fields" or "Current Fields") and select Copy Link Location. The URL should be similar to:
http: //localhost:8080/sr/jira.issueviews:searchrequest-excel-current-fields/temp/SearchRequest.xls?query=ER%5C+&summary=true&description=true&tempMax=1000 |
It's possible to change this setting permanently. Make sure to heed the note above regarding potential performance impact.
From <jira-install>/atlassian-jira/WEB-INF/classes/jira-application.properties
, find this section:
## # The maximum number of results to issue navigator will request from a query # - set this to zero or negative to be unrestricted (note that the server may forbid this , see below) ## jira.search.views. default .max = 1000 |
For JIRA 4.4 and above, add this parameter in <jira-home>
/jira-config.properties; the parameter is jira.search.views.default.max = 1000
Note that the jira.search.views.max.limit value in jira-application.properties must be set at least as high as the desired value.
It is not possible to make the customizations above in OnDemand due to the Restricted Permissions. Please see an alternative resolution which involves exporting the data in batches in this documentation.
Please note that 11,000 is unlikely to work no matter what you set the limit to, unless you really do have a very powerful server with the memory to handle it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, the excel data is stored in String ?!? :), so you'll need a really big heap in order to export so many records...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
JIRA Command Line Interface has getIssueList which will produce a csv file. You can also subset the queries and build up a larger csv file using the --append parameter.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This Knowledge base article should help:
https://confluence.atlassian.com/display/JIRAKB/Export+More+Than+1000+Results+to+Excel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This page is curently under maintenance. Is there any other KB available that i access quickly?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It's opening at my side but I'll post its contents here in case you've got troubles accessing it
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.