nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Exports from Jira/Confluence

Michael Bluschke

Hi all, is it possible to Export Backlog Data from Jira and confluence to e.g. Excel or some other file Format? Background for the question is the Goal to realize a joint reporting for several projects that are using different project tools (i.e. some are using Jira/Confluence and some are using different tools). It should mainly be possible to report the User Stories' actual status in comparison to the plan ...

Accepted answers

All comments

Kian Stack Mumo Systems

Michael,

You can only export issues by searching for tickets and exporting the result. If you have a backlog you want to pull data from, please search for the tickets that are pulled into the backlog and, if desired, exclude tickets that are already placed into a sprint.

Once you've properly searched for your tickets, you can export them by following the steps found here

Michael Bluschke

Thx Kian! Sounds like it's not an appropriate way to achieve our Goal. Is it perhaps possible to get the necessary data directly from the Jira/Confluence database?

Best

Michael

Nic Brough -Adaptavist-

You could, but it's a hideous way to do it. Reading a single simple issue is 15+ joins to different tables.

Please use the method Kian suggests, it's far easier and works. If you don't like it, try REST instead.

Michael Bluschke

Hi Nic, thank you for your Input! What is REST? Is it sort of a plug-in to Jira?

Michael Bluschke

PS: My understanding of Kian's method was that I can only get User Stories in that manner that already "produced" tickets!?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

jira

export