Skip to content

Instantly share code, notes, and snippets.

@jwalgran
Last active May 31, 2018 20:45
Show Gist options
  • Save jwalgran/32d1017a15aec4f2141c to your computer and use it in GitHub Desktop.
Save jwalgran/32d1017a15aec4f2141c to your computer and use it in GitHub Desktop.
Format the third and fourth columns of a waffle.io board as tab-separated text
// 1. Browse a waffle.io board where "Queue" and "In Progres" are the 2nd and 3rd columns.
// 2. Run this code in the developer console.
// 3. Copy the tab-separated data and paste into your spreadsheet of choice.
// Thanks to https://github.com/rajadain for the initial implementation
var rows = [];
$('#page > div > div.ng-scope > div > ui-view > div > div.board.js-board > span.ng-scope > div.board-body > div > div:nth-child(3) .card,#page > div > div.ng-scope > div > ui-view > div > div.board.js-board > span.ng-scope > div.board-body > div > div:nth-child(4) .card').each(function() {
var card = $(this),
url = card.attr('data-waffle-url').replace('api.github.com/repos', 'github.com'),
points = card.find('span.size-count').first().text(),
cols = [url, points];
rows.push(cols.join('\t'));
});
console.log(rows.sort().join('\n'));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment