Document toolboxDocument toolbox

Enlarge Your Excel Export for Jira (Deprecated)

2023 Important Note (End of Jira Server): Enlarge Your Excel Export App is Deprecated:

The feature continues in the App Support Admin Tools for Jira Datacenter

General Information

 

 

Environment

Server (Deprecated)

Price

Free

(Deprecated: The feature continues in Support Admin Tools for Jira Datacenter)

Goal

In large instances, the list of issues in the search view should be limited by the Administrator, as a consequence, the Excel export is limited too... but don't worry! with this add-on you will export more than ever!


Description

In large instances, the list of issues in the search view should be limited by the Administrator, as a consequence, the Excel export is limited too... but don't worry! with this add-on you will export more than ever!With this plugin, a new option is shown to export up to 10000 issues in the Jira Issue Search View ( or filter view ).Very easy to install, no configuration is needed only adjust variables of Jira standard (* See Release Notes section for more info). Plug'n'play

PROJECT DISCONTINUED IN Jira 7.2.X. SEE DETAILS

PROJECT CONTINUED IN Jira 7.4.X with the new option Export Excel HTML Current Fields :)

PROJECT DISCONTINUED IN Jira 9.5.1 (End of Jira Server)

PROJECT CONTINUED IN Support Admin Tools for Jira Datacenter

Install addon

Follow the classic way to install using the Find new apps, as shown below

 

General Configuration

No General Configuration is needed. Just use it

(* See Release Notes section for more info)

Usage

Just create a export for more than 10,000 issues as shown in following GIF:

As we see, a new entry is present in Export menù. After select own issues, well we can select this new entry and extract own Excel. Html format can be managed both with browser and Excel.


Release Notes

(*) JIRA can be configured to increase the limit or bypass it altogether.

Here is a brief explanation of each configuration property:

  • jira.search.views.default.max - This is the maximum value of issues exported by default when exporting/requesting a search result.

  • jira.search.views.max.limit - This defines the maximum limit for all users, regardless of modifications on the referred URL. (or with the plugin Enlarge Excel Export)

  • jira.search.views.max.unlimited.group - This property sets up a group that will be able to request an unlimited number of issues on a search result. 

You can use these configuration properties to override the default behavior. This is done by editing a file in your JIRA Home Directory, "jira-config.properties".

  1. First, if the jira-config.properties file does not exist in your JIRA Home Directory then create it.

  2. Add the override properties to the config file. Example: 

    jira.search.views.default.max=2000 jira.search.views.max.limit=10000 jira.search.views.max.unlimited.group=jira-administrators
    1. Restart JIRA.
      The example configuration increases the default result limit to 1500 issues. Users can modify URLs to export up to 2000 records. Members of the jira{{-administrators}} group can modify URLs to export an unlimited number of records