Importing data into excel.

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!

3 answers

1 accepted

This widget could not be displayed.

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

    (warning) 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

    (info) 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.
    (warning) 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 <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
  2. Modify the number from 1000.
  3. For JIRA 4.4 and above, add this parameter in <jira-home>/jira-config.properties; the parameter is jira.search.views.default.max = 1000
    (warning) 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.

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.

Yes, the excel data is stored in String ?!? :), so you'll need a really big heap in order to export so many records...

This page is curently under maintenance. Is there any other KB available that i access quickly?

It's opening at my side but I'll post its contents here in case you've got troubles accessing it

This widget could not be displayed.

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.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

172 views 1 3
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you