Export to Excel for multiple filters

[AlanR]

One of our JIRA users has created dashboards to give an overview of (aspects) of a project.

These dashboards are presentations of the results of 5 or 6 saved filters.

This works well as a dynamic list.

The question now is how they can export this overview to PDF, Word or Excel as a snapshot at certain milestone events.

Is there any way of doing this?

(Opening each filter individually, exporting and then combining the multiple documents into one is an option - but this is awkward)

[Christian Czaia [Decadis AG] · Accepted solution]

I'd suggest writing a VBA macro. It should be pretty easy importing the filters into seperate XLS files (adressing the filter URL) and combining them to a single sheet (Assuming that the filter names don't change)...

[Renjith Pillai]

Another possibility is to use firefox in command mode and save as pdf . Remember doing it once, it requires an add on to be put into firefox. Probably chrome also can do it.

[AlanR]

Renjith, Thanks for the suggestion.

(What do you mean with 'command mode'?)

I've been looking into printing to pdf - but so far no satisfactory way of doing this. The only Firefox mechanisms for saving to pdf that I can find use external websites that - unsurprisingly - return a message that they cannot access our internal corporate JIRA site. Chrome does have a 'print to pdf' option but the text is saved too large for the text boxes resulting in text and whole issues and even lists of issues being truncated.

[Renjith Pillai]

http://www.abeel.be/content/command-line-printing-firefox

The was what I used, ages back. That add-on is not maintained any more in Firefox.

[Midori]

Export JIRA dashboards to PDF documents with the PDF View Plugin!

Although the list of supported gadgets is somewhat limited (it is growing though!), the Filter Results gadget is already supported. As you mentioned, you'd do this at regular milestones, you should consider making this totally automatic!

Here is the tutorial for dashboards and another one for automating the exports.