Trello Import From Google Spreadsheet - V2.0

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:

  1. It has been converted to use the new Google Sheets.
  2. You can specify Label names, rather than colours.
  3. There is the ability to import any number of checklists.

Trello Backup 3.1

The Trello Backup Script has been updated to version 3.1:

  1. To convert it to the new Google Sheets (which was supposed to have been done in version 3.0, but somehow wasn't!)
  2. To improve the matching between column headings and card properties. This means that you can now add an attribute like "Date Last Activity" to your backlog template column headings, and this attribute will be included in the backup.

Trello Backup 3.0

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 RPG Unit Test Journey'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

Get More Accurate Burndown Chart For Jira

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

Automatically Import Jira Backlog Into Google Spreadsheet 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

Add Enhanced Workflow To Trello

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

Updating Google Apps Scripts 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

Automatic Trello Backups Using a Google Spreadsheet

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

Pimp Your Trello Cards

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

  • Runs immediately (Using Webhooks) to pimp any new cards added to a board.
  • Runs hourly to re-pimp all cards on the board, in case any webhooks failed, or if the pimping requirements have changed.
  • The pimping of a card involves:
    • Adding  a "cost" to a card title based on the story points on the card (If you're using Scrum For Trello) - This also happens immediately if you change the card description.
    • Creating (in specified folders) and then attaching multiple Google Docs.
    • Adding a description (based on a template card) if it's missing (e.g. "As a I want to so that").
    • Adding any missing (based on name) checklists that appear on a template card.
    • Adding missing checklist items that appear on an identically named checklist on a template card.
    • Removing identical checklist items that are "checked" on the template card.
Read More

Quickly Open Source Members In Rational

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

Geofences and AppleScript: The Automators Dream Team

...I stumbled upon this great article which shows how to use the geofence feature in Find My Friends to control a home heater. I had no idea it had the ability to send an email to any address when you arrive or leave a location, but it was exactly what I needed to trigger my automated security system...

Read More

Control Onkyo Receiver With Applescript

...with this initial script working, it now allows my Mac mini to switch on the receiver, select itself as the source, and play any audio I want when a particular event occurs, and that opens up all sorts of automation possibilities for the future....

Read More

Speed Up Web Form Testing With Bookmarklets

... I was recently watching a colleague trying to recreate a bug that involved filling out a 20 field form, and after his 3rd effort, I thought "Wouldn't it be awesome if there was a quick way of pre-populating the form to speed up testing?"...

Read More

Gmail Snooze Without MailboxApp

...Assuming that there were probably other people who would like to snooze (Desktop Gmailers or members of the tinfoil-hat-wearing-brigade not wanting to hand over control of their email to a 3rd party) , I hacked together Gmail Snooze v1.0. My aim was to make it as simple to implement and use as possible: I did consider publishing it as a web app, but I felt it was important that the script be visible so that people could see what was happening to their Gmail....

Read More