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

[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!? 

[Nic Brough -Adaptavist-]

You can get any issues you want from Kian's download, and from REST (REST is an interface for computers to interact with systems, three is a REST interface built into Jira)

[Michael Bluschke]

Sorry for the possibly kiddish question: What it meant by "issues" in this case? Do you both mean that I can get "any Information" desired from the Export or do you mean  issues in the projectmanagement sense (from "risks and issues")?

[Nic Brough -Adaptavist-]

Jira uses the word "issue" to describe its core reason for existing - issue tracking.  Issues are of many types - bugs, risks, issues, stories, epics, tasks, etc.  Or even penguins if you decide you have a use for an issue described as a penguin (I'm not kidding - I've seen a zoo inventory system done in Jira.  Penguin was a valid issue type)

[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