Importing data into excel.

Neeta Dubey

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!

Boris Georgiev [Appfire]

Symptoms

From the Issue Navigator, users are unable to export to Excel more than 1000 rows.

Cause

This is a default, configurable limitation.

Resolution

Icon

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.

4.4 and Later

Changing the Default Limit

Icon

It's possible to change this setting permanently. Make sure to heed the note above regarding potential performance impact.

Information

Icon

If 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:

• jira.search.views.default.max - this is the max that will always show up by default when a user clicks export
• jira.search.views.max.limit - this is the max for all users, you can export up to this number, but you need to change the&tempMax=XXXX URL parameter to override the default
• jira.search.views.max.unlimited.group - the group that can export an unlimited amount of issues in excel (the group cannot have a space in it due to this bug:JRA-26088 - Configurations in jira-application.properties breaks if the group name has spaces. VERIFIED )

1. From <a href="https://confluence.atlassian.com/display/JIRA/JIRA+Home+Directory" rel="nofollow noopener noreferrer"><jira-home></a>/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.

   Icon

   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>

   Icon

   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.

4.3 and Before

Changing the Limit on an Individual Request

1. 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

2. Paste that URL into a different browser tab.
3. Modify tempMax=1000 to the number of preferred rows.
   Note that the jira.search.views.max.limit value in jira-application.properties must be set at least as high as the desired value.

Changing the Default Limit

Icon

It's possible to change this setting permanently. Make sure to heed the note above regarding potential performance impact.

1. From <a href="https://confluence.atlassian.com/display/JIRA/JIRA+Installation+Directory" rel="nofollow noopener noreferrer"><jira-install></a>/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

2. Modify the number from 1000.

3. For JIRA 4.4 and above, add this parameter in <a href="https://confluence.atlassian.com/display/JIRA/JIRA+Home+Directory" rel="nofollow noopener noreferrer"><jira-home></a>/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.

OnDemand

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.