How to report Jira queries outputs in excel via automation

Hi,


Our team has migrated from Quality Center to Jira tool. We have installed Jira plugin Zephyr for execution.


But issue is we need to macro in excel where we can generate report automatically for bugs and executions. We have the jira queries in UI. From database putting sql queries is getting difficult as database is not well organized in Jira.


Can anybody tell me how can we automate excel having jira queries results like (total reopened bugs, critical bugs, total execution count of daily)?

3 answers

1 accepted

1 vote
Accepted answer

Haha, when you're looking for JIRA Excel automation, you should try the Excel Automation Plugin for JIRAsmile

It basically automates the generation and emailing, saving or attaching Excel reports using highly customizable templates rendered to a final XLSX file by the Better Excel Plugin. Based on your description, this sounds as it is exactly what you need.

The automation tutorial is here, and the customization tutorial is here.

 

Thanks Ferenc to share this information. Let me do some trail on it.

Hi, 

Please take a look at eazyBI report creation add-on for JIRA. With eazyBI you can create custom reports based on JIRA data. eazyBI also supports Zephyr specific custom fields, see more details here https://docs.eazybi.com/display/EAZYBIJIRA/Zephyr+Test+Management.

Let me know if you have any questions regarding eazyBI!

Kind regards,
Lauma / support@eazybi.com 

Hi Lauma,

 

We are trying to cut the budget of project. That's why we switch to Jira. So, we cannot afford it.

eazyBI is something I reach for when I can't do the reporting in plain JIRA.

0 votes

The JIRA database is not "not well organised", it's designed to store the application data efficiently.  It's absolutely not intended for reporting.

Atlassian can't know what every different client might want from a spreadsheet, so the software can only really give you the data in a usable formula.

If you want to use functions on it, you have two options

  1. Take the download and add the functions to it, or paste the data from the download into a preprepared sheet with the functions you want
  2. Create your own download - you could take the code for the current excel download and base your own add-on on it, one that embeds all the formulae you want in it (I've done this a couple of times.  It has the disadvantage that it can render spreadsheets limited to one type, which can be an issue when half of your users are on LibreOffice, and the other half on Microsoft.  So think about it if you do go this route)

There is a third option - report inside JIRA instead - it can answer all the questions you've posed in your question (but I suspect you have more)

 

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in United States

Topic Tuesday: What's your favorite topic?

Good morning All, Our goal is to get you into the habit of while enjoying your favorite morning drink you are checking the NOVA "space" for topics and comments. Your input is really needed and...

60 views 4 0
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