There is a new version of my Jira Backlog Google Sheet available. It will now handles multi choice fields like labels correctly, and defaults to display name or name fields for fields if they exist.
If you're new to the script you can find out more details here.
...After 3 years of doing Scrum, and trying lots of tweaks to try make the Stand Up more effective, the Retro Up has, by far, had the biggest impact. We just may need to work on the name...Read More
I've updated the Trello Import spreadsheet to version 2.2 as the api it was using to create checklists is being deprecated.
The Trello Backup Script has been updated to version 3.4.
This update adds support for Consumed Points in the excellent Scrum For Trello.
I've had a few requests to improve the Google spreadsheet that allows you to import data into Trello, and this has culminated in Version 2.0 of the spreadsheet.
The new version has the following improvements:
When I created the original Trello Backup a little over 2 years ago, it was primarily to ensure that we had a copy of our data, in the event that Trello was ever unavailable, but I've copied and customised it many times since then for a variety of reasons...
Read More...my Trello Backup Script just got a whole lot more flexible...
Read More...This worked well until the team decided that they wanted to try using Jira - it worked well for them, but not for me as I had a good setup with the spreadsheet which gave me the exact information I needed, and had the burndown chart working exactly as I wanted - it took into account variations of hours available during the sprint (Some days were meeting heavy for example), which made it much more useful for checking the team's progress, and seeing if corrective action was required...
Read More...you can give read-only access to your Jira projects to the whole world (without requiring a login), but you might run into problems if your competitors got hold of the url, so that didn't seem like a great solution.
I therefore decided to use the Jira Rest API to import the backlog into a Google Spreadsheet, which could then be shared with just our organisation...
Read More... a month ago I released a Google Apps Script that allowed you to Pimp your Trello cards by automatically adding checklists, descriptions and Google Docs (based on a template card), and assigning cost estimates to cards. I received some excellent feedback on what would improve the script and am pleased to announce that Pimp your Trello 2.0 is now available...
Read More...whether it's because I've experienced a natural disaster or because I spent some of my formative years in the Boy Scouts I'm not sure, but events half a world away this week have re-enforced the notion that it's good to "be prepared"...
Read More...As well as constantly backing up the boards, I use the spreadsheet regularly to create the story cards we use during sprint planning...
Read MoreBut what if you already have an existing backlog, and don't want to spend time re-keying the entries? Well luckily, like most things in 2012, there's an App for that.
Before you get too excited, I should mention that "The App" in this case is a Google Spreadsheet, with a Google Apps Script that leverages the Trello API to import the data. It's simple, effective, and in true agile fashion, it does just enough to get the job done without unnecessary bells and whistles.
Read MoreAs a follow up to my search for an Online Scrum Board, I thought I'd also document my search for an Online Product Backlog, looking at the different experiences of the two Scrum Teams that I'm part of.
Read MoreRead MoreWhilst my current passion remains iOS development, I have found that much of my spare time of late has been dominated by a search for online Scrum tools to use in my new role as a Scrum Master for 2 Scrum teams at work.