Harry Bailey

Harry Bailey helps agency leaders fix the planning, ownership, and delivery issues behind overruns, rework, and delivery friction. With more than twenty years of experience in project delivery, agency leadership, and operational change, he supports growing agencies to make delivery clearer, less reactive, and easier to manage.

Backup Postbox email profile

To backup your Postbox email profile browse to

Mac:
/Users/[username]/Library/Application Support/Postbox/Profiles

Vista:
Users\[username]\AppData\Roaming\Postbox

XP:
Documents and Settings\[username]\Application Data\Postbox

And copy the folders named xxxxxx.default to your backup location.
If you have created a new profile then your folder may also be called xxxxx.yourprofilename.

If you just want to backup your email and not your preferences or settings then go into your profile folders and backup the Imap, Mail and sometimes Local Mail folders.

OS X Hotkeys

Increased productivity comes in many flavours, but a favourite of mine is learning new hotkeys which save me time. There is also nothing quite like the reaction you get from a person who has been doing something the hard way and you show them a hotkey to jump right to it.

Continue reading →

Playing Your Spotify Top list

When you first open Spotify you are offered two tabs ‘What’s new’ and ‘Top lists’. If you select ‘Top lists’ you are then shown two columns which contain a list of the top rated artists, albums and tracks for everywhere, your country or just you.

So you can select to see what tracks, albums or artist you listen to most, or see what are the most popular with others.

As far as the tracks list goes, you can also play it. Choose ‘Tracks’ from the drop down menu on the left, and choose ‘everywhere’ from the drop down menu on the right. You now have a list of Spotify’s top tracks for the whole world. There is no simple ‘play’ button, but these steps aren’t too taxing…

Continue reading →

Sending To Multiple Twitter Accounts From One Device using SMS (text message)

Update: You can now signup and help in testing. ~~http://bucket.harrybailey.com~~

I have been working on something recently to make my Twitter life a lot easier.

I don’t have an iPhone and I’m not planning one getting on in the near future, so I send sms messages to Twitter to update my status. Simple enough when you have one Twitter account. You just add your device ( phone ) to Twitter, tell it when to send you sms messages, and what to send you and off you go.

Sadly you can only apply a device to one Twitter account and can only send updated to one account from your device via sms.

Until now!

Continue reading →

MySQL Multiple Primary Key Columns In A Table

Some database management tools refuse to admit you can add multiple primary key columns to one table, so you might have to do it with direct sql syntax ( deep intake of breath ).

Multiple primary keys make ‘ON DUPLICATE KEY UPDATE column = column + 100’ type queries a shed load more flexible.

Anyway, on with the code:

ALTER TABLE tablename ADD PRIMARY KEY (column_one, column_two)

And there you have it. Robert’s your fathers brother.