Extending Jira - alternatives to Excel export ...

[Louis Mehr]

Hi,

In the past we have exported bug lists to Excel, performed processing on these lists offline & then taken the results into our Scrum meetings.

We used a rather involved VBA script for this processing and it is now time to re-evaluate this approach.

What we want

-Group and prioritise tickets and then determine which to fix, using various rules like "which fixes will liberate the greatest amount of blocked test effort?",  "which features are blocked by which tickets?" etc.  

-Graphical view of progress to end date/burndown of test effort (i.e. not just dev effort)

-Ideally an online approach that everyone can see anytime.

-If an offline approach, then use C# for interface to Jira and generating graphics.

So, what approaches are available and preferred?

Thanks!

[Louis Mehr · Accepted solution]

Use R and the Rest API.  Works nicely.  Still stuck with the 1000 response limit though.

httr::GET( ...

Took a while but now sorted.

Better than csv export.

[Louis Mehr]

Hi Warren,

No, I have not got this working yet.  I will try again tomorrow but so far:

1/ The code from Codeproject gives me - 

***

System.ServiceModel.EndpointNotFoundException occurred

 HResult=0x80131501

 Message=There was no endpoint listening at…  This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details.

***

An aside,  I had to modify this line- and I am not certain as to  what it should be.  Its accompanying text shows it written slightly differently, including a "?".

IEnumerable<Atlassian.Jira.Issue><atlassian.jira.issue> jiraIssues = jiraConn.GetIssuesFromJql(jqlString , 999);

***

2/ Your snippet fails on this - WebRequest.Create

I assume that I am not forming the URL correctly.  (I added our cloud URL as the prefix to the JQL query).

Thanks!

[Warren]

Hi Louis

This is the REST API  document for cloud, there is an equivalent one for server. Using C# or any other language, you can extract any data out of Jira and then manipulate it and graph it.

My reply in this question gives some sample C# code to connect to Jira and use any of the calls in the first link.