Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Exporting Data from Jira Agile

Is there a way to export data from Jira Agile?

I need to be able to display all Velocity and Burndown charts on one report. I can manage Burndown via the dashboard gadgets, but Velocity is proving elusive.

I've tried to export all issues from Jira into a spreadsheet and manage it from there, but info about sprint start dates/duration seems to be stored elsewhere.

Any suggestions for how I can either: a) embed muliple velocity reports in a single document (without copying and pasting each individual report); or b) export sprint start/end dates to a spreadsheet?

Thanks!

6 answers

1 accepted

1 vote
Answer accepted

Hello Matthew,

I'm afraid there is no way to export the data in that way right now. You can only gather the info from the selected board's reports (velocity and burndown).

From the looks of what you intend to do, I believe that could be a very specific job for our team of experts, who would be happy to help you out! :)

Best regards,

Benito Picarelli

Thanks for the swift response Benito - your definitive answer will save me hours of frustration!

Kind regards

Matt

Is there still no way to export agile data from ondemand to hosted?

An update to this request would be good. 

Seem's completely bizarre that we can't export data into excel! Really strange!!!!

It just blows me away-- all of the ink dedicated to this one simple and fundamental ask, including all the gyrations we have to go through (thanks to those who've figured it out).  Just give me an export option for details in a Sprint report.  Please???  How difficult can this be?

They want you to spend more time on their platform haha

This is such a basic feature that has been asked for nearly 7 years (that's how far back I found a request for this)

Our apps provide the following exporting capabilities for Jira Agile (now Jira Software) data.

1. PDF View Plugin can export any issue, also from the backlog, from sprints, from Kanban / Scrum boards to custom PDF documents. Via scripting you should be able to do your own calculations. We even have an old template for team velocity reports that you could as starting point:

jira-burn-down-chart

2. The same app can export all Jira Software gadgets, so you can get burndown charts, sprint health or complete boards at a single click:

jira-dashboard-agile-sprint-report

 

3. Better Excel Plugin can export any issue (backlog, sprints, Kanban / Scrum boards contexts are fully supported) to custom Excel spreadsheets, if this is your preferred tool. You can use functions, formulas, charts on any Jira Software managed value (in this case, to get the Velocity chart):

 jira-agile-report-epic-pivot-chart

I am sure one of these 2 can solve your use case. 

(Disclaimer: these are paid and supported apps, and I am a developer.)

Hi,

 

Why doesn't this plugin export sprint data already closed?

It does, but not from the Sprint Report screen.

Instead, run a JQL query like this in the Issue Navigator

sprint = "Your already closed sprint"

It produces the list of the issues you're asking for. Then export this issue list. That's it.

Hi,

 

It is possible, but inefficient. It does not export all data (columns) to the sprint.

{ 
 "id": 34,
 "self": "https://fake.site.com/rest/agile/1.0/sprint/34",
 "state": "closed",
 "name": "EQUIPE 1 Sprint  3 - 20/10/20",
 "startDate": "2020-10-20T08:53:00.000-03:00",
 "endDate": "2020-10-27T08:53:00.000-03:00",
 "completeDate": "2020-10-27T09:03:21.083-03:00",
 "activatedDate": "2020-10-20T08:55:48.159-03:00",
 "originBoardId": 143,
 "goal": ""
}

And it is not possible through the Better Excel plugin.

Hi,

I am using Jira as a user in our sub-contractors account. The deal with the sub-contractor is about to expire and we'd like to have all our issues and agile board in our new account. Is there a way to get all the necessary data to the new account?

Thanks in advance!

Hi,

I am using Jira as a user in our sub-contractors account. The deal with the sub-contractor is about to expire and we'd like to have all our issues and agile board in our new account. Is there a way to get all the necessary data to the new account?

Thanks in advance!

0 votes
AgentSmith Atlassian Team Mar 27, 2015

You might want to take a look at these existing suggestions:

 

https://jira.atlassian.com/browse/GHS-8804 

https://jira.atlassian.com/browse/GHS-6135

 

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you