Excel dashboard for the bugs in JIRA Studio

[Deleted user]

Hello,

Is there any excel dashboard kind of thing present for JIRA Studio users? I'm being asked to create certain reports on our JIRA Data which should be emailed to the team.

Right now, I've a filter in JIRA, from where I import the data into an excel and run pivots on the same. I was just thinking, if it were possible to automatically update the excel sheet rather than importing the data daily.

Please let me know if there is any way to make it possible?

[Deleted user · Accepted solution]

This is an open request on JIRA Studio - I searched JST open issues and found this.

https://studio.atlassian.com/browse/JST-5151

Please vote on this issue if anyone else is also waiting or looking for such a functionality.

[Raimonds Simanovskis]

The other solution you might try is eazyBI data analysis and reporting application which has standard integration with JIRA. After initial import it will schedule automatic daily import of specified JIRA projects issues. It comes with some predefined sample reports and charts as well as it provides easy way to create your own reports. If necessary you can export data from eazyBI reports to Excel as well. But also you can embed eazyBI reports in other web pages and see up to date information about your JIRA project status.

[Raimonds Simanovskis]

eazyBI JIRA integration now also supports import of JIRA custom fields as well as issue labels. eazyBI can import data both from private JIRA installations as well as from JIRA Studio or OnDemand.

[Andrew D]

I know this is old but maybe this will help, a little bit of VBA that can be used to get data from Jira.

Just paste this code into a VBA module and run it. Might need a little tweeking/debugging since I just copied this out of a more detailed macro and didn't test it but it should work.

Sub GetJiraData()

'get jira data

Dim TmFl As Workbook
Dim ThisSht As Worksheet
Dim DataSource As String

'error catching for debugging
'On Error GoTo Errorcatch

' Prevents screen refreshing.
Application.ScreenUpdating = False

Set ThisSht = ActiveSheet
'set the data source we want to open here: in this case it's a link to Jira

'(Note, if we go over 1000 lines of exported data we have to adjust tempmax in URL)

DataSource = "URL link goes here" 'put the proper URL link for your filter in quotes here

'Get the URL by clicking to view your filter as excel but right click it and copy the link location

'The link will most likely need to have a username and password appended to the end.

'This is done like so: "examplelink.com&os_username=<Username>&os_password=<Password>"

Set TmFl = _
Workbooks.Open(DataSource)

'Copy whatever range you want out of the jira book here, in this case it's a4: i2000
TmFl.Sheets("General_Report").Range("A4:I2000").Copy

'Activate the RawData Tab in current workbook
ThisWorkbook.Sheets("RawData").Activate

'Paste into cell A1 of the RawData tab
Sheets("RawData").Range("A1").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Sheets("RawData").Range("A1").Select
TmFl.Close False

'error catching for debugging
'Errorcatch:
'MsgBox Err.Description

' Turn screen updating back on
Application.ScreenUpdating = True

End Sub

Basically this should open a new book based on your filter URL and then paste out of it into your current workbook. Everytime you run the macro it will rerun the filter and paste your data in Excel.

Might need to include an additional step to clear any data from the RawData tab first though.

[Matthew Hunter]

Hi Nikhil,

Unfortunately there isn't any way to directly connect excel to JIRA Studio - normally you could connect excel directly to the database, but that isn't an option in the Studio infrastructure for security reasons.

As an alertnative though you could try using the JIRA Reports within a Confluence page (here's how to add the gadgets) to look after the reporting for you.

Cheers,

Matt

[Deleted user]

Thanks Matthew,

This was helpful. But this might not work completely for us since the management is looking for reports that are different than the default one's on JIRA. Also, another requirement is to get the reports emailed to users frequently. I was palying around the xml export of a filter into Excel sheet but have not been able to get much forward on that as well since there is no defined schema on the xml. Any help there?