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

Export Event type from JIRA to CSV

Hello,

 

I have to export event type from issues in order to calculate a rate of disturbance (issues added to sprint after its start or issues removed while the sprint is in progress).

 

How can I specify this criteria in my request to export in CSV ?

 

Best regards,

Christophe CHALIGNE

4 comments

Could you explain what you mean by "event type"?  Is it a field on your issues?

Do you mean the sprint events like "sprint start", "burndown" and "scope change" that are fired while the Jira Software sprint was running?

If so, that's not easily available -- as those are calculated on the fly by the logic that renders the Burndown Chart.

One thing you could eventually try is exporting the sprint to PDF like this one: http://www.midori-global.com/downloads/jpdf/jira-burndown-report-with-data-table.pdf

You can do that with the PDF View Plugin.

Then extract the text from the PDF (programatically) and process that plain text content.

I'm also interested in a method to export or extract data from closed sprint burn down charts related to "sprint start", "burndown" and "scope change" and other event types that are tied to specific JIRA cards in that burn down. Any other suggestions how to do this?

PDF View plugin is not available to Cloud users so is not an option for me.

Thanks!

  • Create a new bookmark on your chrome. 
  • Set its name to "download burndown data"
  • Change the URL of the bookmark to

javascript:(function(){
var csv = $('table.aui tr').toArray().slice(3).map((row) => $(row).find('td').map((index, cell) => $(cell).text()).toArray().join(',')).join('\n');
csv = 'data:text/csv;charset=utf-8,' + csv;
data = encodeURI(csv);
link = document.createElement('a');
link.setAttribute('href', data);
link.setAttribute('download', 'data.csv');
link.click();
})()

 

  • Open your burndown page with the table that you want to export. 
  • Click the bookmark. 

 

You should see a download prompt with the data. 

Tested on Chrome and Jira Cloud. 

Might break between different Jira versions. 

 

Enjoy. 

Comment

Log in or Sign up to comment
Community showcase
Published in Jira Software

[New] Jenkins for Jira Software Cloud and a way to connect your hosted apps

Jenkins is the leading open-source automation server used by startups and enterprise teams to build, test and deploy code to production.   We are excited to announce an official integration betw...

1,210 views 1 15
Read article

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