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.
There is a new version of my Trello Scrum Backlog spreadsheet available. It will now add lists if they don't exist, and can be used to just add empty lists to a board.
If you're new to the script you can find out more details here.
There are times, however, were we decide that unit testing in RPGUNIT is just too hard, and we fall back to manual testing.
But I don’t like to be beaten….
Read More...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:
The Trello Backup Script has been updated to version 3.1:
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...it's obviously going to be more challenging getting RPG unit tests to run that fast, but hopefully what you can see from this post that you can write automated unit tests in RPG, quickly, efficiently, and perhaps most importantly, have fun whilst you're doing it...
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...one was a feature request for emails to be unsnoozed at a specified time, rather than at midnight. I thought it was such a good idea I implemented it straight away...
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...so how do you go about updating a Google Apps Script that you’ve copied? Well it depends on the situation, but basically you have 2 options: kill your copy and start again with the new version, or update your existing script....
Read More...I posted last year about backing up the Trello Boards that we were using for our Scrum backlogs. There's been a fair amount of interest in the post, and some requests for the data to not be displayed in such as Scrum-centric manor...
Read More...I therefore turned to Google Apps Script, and the Trello API to come up with the Pimp Your Trello Cards spreadsheet which has the following features:
...I therefore hatched a plan to use the current date and time as the first 12 digits of an EAN13 barcode, and then automatically calculate the check digit to put on the end, and this is the result...
Read More... I've been using Rational to edit CLLE and RPGLE source for some years now, but if I wanted to quickly view a specific source member I would often fall back to a Client Access session, and use one of our custom commands, DS (Display Source) to quickly display the member in SEU. Our DS command determines the source library, file, and member used to create an object, and then opens it, so it's a really fast way to view the source for any object. That being said, viewing source in Rational is so much better than using SEU, so I wanted to find a quick way of opening a member that I was interested in...
Read More