Export to Excel for multiple filters

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)

3 answers

1 accepted

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

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.

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.

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.

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.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted 13 hours ago in Featured Groups

Are you managing your users efficiently?

Hi everyone, I am Marek, a Senior Product Manager for Crowd   Server and Data Center   here at Atlassian. I would like to spark a discussion about challenges you have with managing use...

86 views 1 2
View post

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you