Is there a way to export all items from Ideation to Excel?

Chad Evans
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 5, 2021

We have over 300+ items listed in ideation, but are looking for an easy way to provide a readout.  Is there a way to export these items to a spreadsheet?

2 answers

0 votes
Rodrigo Cortez
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 5, 2021

Hi @Chad Evans !

Exporting ideas from the Ideation portal is not yet supported by Jira Align.

However, there are currently two open ideas on that matter:

I'd encourage you to subscribe and upvote these ideas, to raise awareness on that demand along the Product Management team.

Sam Tsubota
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 5, 2021

Jira Align Enterprise Insights (EI) data warehouse has tables with all the idea, ideation groups and ideation form custom fields. You can get an EI instance for your Jira Align instance and connect a data visualization/BI software like Tableau or Power BI and build a report or dashboard and export the data to Excel. You will also have all of your data in your Jira Align instance to build custom reports and metrics. You can reach out to your Atlassian Enterprise Advocate for more information and even request a 45 day trial.

0 votes
Allan Maxwell
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 5, 2021

I don't think a direct export to Excel format exists, but you can use the Jira Align API 2:  GET {{base_JA_url}}/Ideas

 

The results are returned in JSON format.

 

{
"id": 4,
"ownerId": "Allan.Maxwell",
"createdBy": "Allan.Maxwell",
"createDate": "2017-12-21T08:50:39Z",
"lastUpdatedDate": null,
"title": "As a system admin I would like ...",
"groupId": 3,
"productId": null,
"status": 0,
"isExternal": 0,
"description": "blah, blah, blah",
"companyId": 1,
"categoryId": 1,
"isPublic": 0,
}

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events