Excel plugin exports multiple sprint values in the sprint field.

unknown

Hi Lovely JIRA community.

 

In our Company we use excel reports to work with planning of future sprints based on remaining work estimate. In this process we are very fond users of the Jira Excel plugin that imports data directly from Jira.

 

We have hit a snag that is annoying our PM's a lot is the fact that the jira table imported for sprints some times contain multiple sprint values (e.g. Sprint21;Sprint19;Sprint3). In order to use sprint in a Pivot table this data needs to be manually changed and only reflect the latest sprint. 

 

This occurs if a tasks was in a sprint that was completed and the task moved to next sprint or when a task is reopened and added to a sprint.

 

Our current workaround we would like to avoid in excel:

1. Filter on column on ;
2. Manually delete the old values for each line with more than one sprint
3. Remove filter

I hope someone knows a nice workaround or notice what we are doing wrong.

 

Nic Brough -Adaptavist-

I'm afraid this is by design, and there's nothing you can do about it in the export process.

Sprint is a field that contains the list of all sprints the issue has been a part of.  In Jira, there is code that works out "latest sprint" and "active sprint(s)" from that, and the sprint data, when they're needed, but it's not available as a field.

So the exporter has nothing to to get a hold of, and when you tell it to export the sprint, it simply gives you the content of the field, which is the list of all sprints for the issue.

You have two options here - write something that works out the sprint you're interested in for any given issue, and makes it available for the exporter to get hold of, or manipulate the data after you've exported (which is exactly what you are already doing)