Fail import issues from Jira projects (Excel Add-In)

Owned by Pooja Vedwal
Last updated: Jan 21, 2024 by Bernhard Doleschel
1 min read

Problem

After loading data from any Jira project, no issues are imported and only the header/columns are displayed in Excel.

Cause

The default maximum number of issues to return from Jira search results may have been configured to 0. In fetching issues to be imported, Excel add-in calls Jira API GET /rest/api/2/search which is affected by the maximum allowable value configuration.

Solution

  1. As JIRA Administrator, go to System > General Configuration > Advanced Settings.

  2. Search for the jira.search.views.default.max key.

  3. Set value from 0 to the minimum count of issues (e.g. 1000).

    • See image for reference:

  4. Load data from a project in Excel add-in.