Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,365,310
Community Members
 
Community Events
168
Community Groups

Export Event type from JIRA to CSV

Deleted user Apr 20, 2018

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

5 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. 

Hi Guy, this did not work for me. Not sure what am I doing wrong! JavaScript function is not getting added to the URL field on bookmarks. It throws invalid url.

The easiest way to get data from the Reports Burndown Chart is to just copy all the columns and paste it in a spreadsheet. It copies everything including the hyperlinks, as good as exporting the Burndown chart itself. :)

Comment

Log in or Sign up to comment
TAGS

Atlassian Community Events