How I edit podcasts

I do much of the post-production editing for the two podcasts that I’m on: Worst Case Scenario with Baz Taylor and David Sims, and Atlantic 302 with Pat Carroll. Some people have been kind enough to compliment the production quality of the podcasts but I’m still frustrated when I hear how good some of my favourite podcasts sound. I’m still learning about this stuff, and I know I have a long way to go, but I thought I would document my current method. Critiques welcome!

I’m indebted to Jason Snell of SixColors who wrote a very detailed guide on how he edits his podcasts. Much of this guide is based on Jason’s recommendations. Like Jason, I use Logic Pro X for editing, specifically for its Strip Silence function which isn’t available in GarageBand. I add an extra pre-production step of noise reduction in Audacity, as an unacceptable level of hiss was creeping into the recordings without this.

Recording

We sometimes record in person, but most of our episodes are recorded remotely. We sit in our own houses and chat over Skype. We don’t actually record the Skype call, instead we each record our own audio locally and then I mix it together later. We have a pre-recording ritual which consists of three steps:

  1. I count us in to hit Record in GarageBand. This means that the audio tracks will start at roughly the same point.
  2. I ask for five seconds of silence at the start of recording. This provides a convenient place at the start of each track to get a sample of background noise for noise reduction.
  3. I turn up the volume on my headphones, hold the headphones to my mic, and ask each host to talk into their microphone separately. This marks a point where the same audio is appearing both on my audio track (through the headphones) and on the host’s track, identical audio which allows me to sync up the tracks. Of course it’s not truly simultaneous as Skype introduces latency, but it’s good enough.

Sharing

The other hosts on the podcast then send their GarageBand files to me. Baz and Dave are users of the native macOS Mail app, which has a feature to send large files called MailDrop. For Atlantic 302, Pat and I have a shared Dropbox folder that he copies his file over. I mention this because the files involved are large: Atlantic 302 is a 30-minute show and our separate audio files are about 270Mb. Editing podcasts takes up a lot of disk space! (As a side note, I save my working podcast files in a subfolder of Downloads, and exclude the Downloads folder from Time Machine, to prevent backups getting too big).

Export

GarageBand has a default voice recording setting, which adds lots of effects such as reverb. The GarageBand interface is a little confusing, so I created a blank ‘patch’ with no effects whatsoever. I apply this patch in the Library before exporting. I’ve uploaded this blank patch in case you want to use it: it needs to be copied to
~/Music/Audio Music Apps/Patches
– you’ll need to create this folder if it doesn’t exist already.

I export each GarageBand file using the Share > Export Song to Disk menu command, and I save as an uncompressed 16-bit AIFF file. Rather annoyingly, this step creates a stereo AIFF file even though the recorded track from the microphone is mono, I haven’t bothered to figure out how to change this, so I just continue the rest of my workflow in stereo, and then convert to a mono MP3 file at the end.

Noise reduction

Our recordings tend to contain some hiss. If this hiss isn’t removed, it can be amplified at a later stage when applying compression. I use Audacity’s noise reduction function to pretty aggressively reduce noise in the AIFF files before dragging them in to Logic. I open a blank audio file, hit Cmd-Shift-I and select the AIFF for editing. I find the section of the audio at the start where everyone is silent, and select most of it, checking that there isn’t any breathing or noise that isn’t present through the whole recording. Then I select Effect > Noise Reduction and click Get Noise Profile to sample the background noise. I deselect the audio previously selected (important to do this, or the next step will only reduce the noise on the selection) and select Effect > Noise reduction again. You’ll notice there are lots of parameters to adjust, here are the settings that I use, chosen out of trial and error:

noise-reduction-progressNoise reduction (dB): 24; Sensitivity 11.50; Frequency smoothing (bands): 10. The last option, Noise: , should be set to Reduce, not Residue.

This takes a long time, typically nearly two minutes on my 2015 MacBook Pro. I use this time to start exporting the other tracks from GarageBand, and dragging completed files into Logic Pro X. Once the noise reduction has finished, I choose File > Export Audio, and export as another 16-bit AIFF file.

Logic Pro X

Logic Pro X costs €200 in the Irish Mac App Store. I know this is a huge amount – which is why I edited the first few episodes of Worst Case Scenario in Audacity. But Logic has one feature called Strip Silence which saves a huge amount of time and I’m much quicker at editing once I switched.

To start, create a project in Logic. It doesn’t matter what input settings you use, as you will be importing the previously-recorded tracks. Drag your tracks in, you can even drag them in one go, if you do just make sure that you ‘create separate tracks’ in the dialog. Once you have done this, you can delete the original empty track that Logic added for you.

Syncing audio tracks

By now you should have your three audio tracks in Logic. To sync them up, I look for the audio at the start of the file where each host speaks into my mic via my headphones (described earlier). I drag each track to the left and right around this point until the audio is roughly in sync. I find it helpful to zoom in (by pinching the trackpad) to do this, you can sometimes align visually using the waveforms on the track.

Audio effects and EQ

The Inspector sidebar in Logic, showing the Compressor, EQ and Noise Gate applied to Dave's audio (left) with the master Compressor on the right
The Inspector sidebar in Logic, showing the Compressor, EQ and Noise Gate applied to Dave’s audio (left) with the master Compressor on the right

I apply previously saved patches for my co-hosts. You can download these patches: Thomas, Dave, Baz, Pat (you add these to the same folder as the blank patch explained above – Logic and GarageBand use the same plugins in the same folders). These patches contain an EQ (to emphasise and de-emphasise different sound frequencies), a compressor (to make quiet noises louder) and a noise gate (to ignore sound below a certain level). They are different based on certain factors, Baz, Pat and I use the same Pyle dynamic microphone but Baz and I both have fairly quiet voices, so they need boosting. Dave uses a Rode condenser microphone, which provides a lovely loud sound (the Pyle mics are very quiet) but tends to pick up more background noise. For my own patch, I added an extra DeEsser plug-in, as my ‘s’ sound is very hissy. Finally I add a master compressor on the output (it’s listed under Dynamics > Compressor) which effects all tracks, I turn up the compression to 3 and leave everything else at the default.

I try to avoid any clipping on the output meter (any positive number is clipping and will be shown in red), and will tweak the individual track compressor if someone’s audio is clipping, normally using the Make Up knob.

Strip Silence

Strip silence has been applied on Dave and Baz's tracks, but not on mine
Strip silence has been applied on Dave and Baz’s tracks, but not on mine

Now we get to where Logic earns its €200: the Strip Silence feature. This essentially translates a single continuous audio track into ‘blocks’ where someone is actually talking. This makes editing so much easier. The keyboard shortcut for Strip Silence is Ctrl-X (make sure you have the track highlighted), the settings I use are a tweaked version of Marco Arment’s recommendations – 2%/0.6/0.2/0.3 for those of us using dynamic microphones. I change the threshold to 4% for Dave’s microphone: as a condenser it picks up more background noise. As Marco points out, annoyingly Logic doesn’t remember your choices so you have to manually enter these in for every editing session.

Select following

At this point I delete all the chatter before the show starts, and I start editing proper. The one disadvantage of using Strip Silence is that you are left with a lot of empty sections where there are sections of the podcast where nobody is talking. This can be noticeable to the listener (depending on the background noise), so a lot of my editing work involves moving audio ‘back’ so there is no overlap. When you are faced with a period of silence, you want to select the next ‘block’ after the period of silence, and then use the Shift-F to select all blocks of audio following this block. You can then drag the audio back so that it cuts in just after the last person has finished talking.

Editing

As well as removing silences, you’ll often want to cut bits out. In the early days of Worst Case scenario, I was obsessive in cutting every last ‘um’ and ‘ah’, especially with my own voice. I’ve calmed down a bit now I’ve got used to listening my own voice (this took quite a while) and realising that these artefacts appear in everyday speech and the brain is incredibly good at filtering them out.

secondary-editing-toolI do remove any bumps, clicks or any other background noise that I think might distract the listener. Often the noise is in a single block so I can just click and delete. Sometimes you need to divide up a block of audio, the fastest way to do this is to set Logic’s secondary editing tool to be the marquee tool (see graphic). The primary tool should be the pointer tool. The secondary editing tool is invoked by holding down Cmd. You can use the marquee tool to drag over a selection of audio you want to delete, or by clicking once and hitting backspace you can split a block into two pieces.

Intros

On Atlantic 302 we use a spoken word intro and outro that myself and Pat take turns doing and which is recorded at the same time as each episode. For Worst Case Scenario, we use a short noise that Dave created while messing around with an app called cfxr, a little app that creates various sound effects. I turn the input volume down to -13db because otherwise the master compressor will make it too loud.

Export to iTunes

I prefer to export the song to iTunes as an AIFF (File > Share > Song to iTunes). The only metadata I add is the track name. From iTunes I have the export format set as 64 kbps mono (iTunes > Preferences > CD Import Settings > MP3 Encoder > Custom > 128kbps stereo bit rate + mono) so I just convert to MP3 after the AIFF is imported from Logic. Finally I right click the MP3 and Show In Finder to locate the file.

 

Announcing Direach, a new WordPress theme aimed at readers

As I was discussing on the last episode of Worst Case Scenario, I’m a bit of a luddite when it comes to the web. I like reading, and I dislike anything that distracts me from that task. Fortunately the Safari web browser comes with a great Reader mode which strips all the cruft from a page and simply displays the text of the main article, nicely formatted for reading (Firefox has this feature too). I use it constantly.

I decided a few years ago that I wanted my own website to be as readable as the special Reader mode in my browser. Every four months or so I would check to see if anyone had created a WordPress theme that could do the job, but I was never able to find anything suitable. So I wrote my own!

Direach (from díreach in Irish, meaning direct) is the fruit of my efforts, and it is the theme running on this site today. It is my effort to create a WordPress theme that is reader-friendly and accessible.

Typography

Direach doesn’t download a custom font, it uses the Georgia typeface which is a serif font with a relatively large x-height. Created by Matthew Carter for Microsoft specifically for screen use, it is the same font used by Safari’s Reader mode and is installed on the vast majority of computers, phones and tablets. A default serif font is declared for operating systems that do not ship with this font. The default paragraph font on most browsers will render at 18px, increasing to 20px on wider screens. Elements that are not part of the main body of the page have a reduced font size.

Reduced clutter

Almost all WordPress sites have a header at the top containing the site title, subtitle, and the navigation menu. This can take up a large proportion of the screen, especially if the reader is on a mobile device. Direach shifts this content down to the bottom of the article when it is only showing a single post or page. For index pages and the home page, this content is placed at the top. All content is displayed in a single column, apart from two columns of ‘widgets’ at the bottom of the front page. On single item pages/posts, the site title is appended to the article heading.

Small and fast

Not only does Direach not load any external fonts, it doesn’t add any JavaScript either. The markup is relatively clean. Even on my fairly slow US-based shared host, it loads relatively quickly.

Accessibility

Direach is based on the Underscores base theme by Automattic, and so it has excellent support for screen readers.

Future developments

Direach is licenced as GPL v2 or later and the source is available on GitHub. There are a few issues I still need to address – the image in the masthead does not deliver a retina size for devices with high-density screens, despite poking around in the source of get_header_image_tag I couldn’t find a way to get it to emit srcset attributes, despite this functionality being added in version 4.4.0. I’m not 100% happy with the final design and there are still a few rough edges.

I may submit this theme to wordpress.org in the future after a bit of dog fooding, although I think the design may break one or two of WordPress’s theme guidelines.

Reflections

It took quite a bit of work getting Direach to this state, in particular to get the theme working with some of the weird cases in the WordPress test data set. At various stages I worried whether this theme is too stark – almost Brutalist in nature. I also worry that it gives this site a slightly-too-authoritative tone. But overall I’m happy with the results.

Installing

To install this theme on your own site, go to Direach’s home on GitHub and under Clone or Download choose Download ZIP (your browser may automatically decompress the theme, in which case you will have to recompress it). Upload this theme to your WordPress install via Appearance > Themes > Add New > Upload Theme. You can upload a custom image beside the site title under the Appearance tab of the admin interface.

Three podcasters fix a WordPress plugin bug (with chat logs)

On Worst Case Scenario, the podcast I host with Baz Taylor and Dave Sims, we use a WordPress plugin called Seriously Simple Podcasting to host our podcast feed. It’s a fantastic minimalist plugin with little bloat and works very well for us.

We also installed an add-on called Seriously Simple Stats which would give us download counts for each episode of the podcast.

However the plugin wasn’t showing the client information properly and this was annoying Dave.

Screen Shot 2016-07-20 at 20.12.17
The three of us poked at it at various points during the day, and despite not being WordPress experts (and in my case, being very far from a PHP expert), we managed to get it working.

Screen Shot 2016-07-20 at 19.49.28

Podcast app User agent Strings

Here are some user agent strings reported by one or two podcast apps:

  • “AppleCoreMedia/1.0.0.13F69 (iPhone; U; CPU OS 9_3_2 like Mac OS X; en_ie)” – native iOS podcast app, amongst other things
  • “Pocket Casts” a podcast app that is particularly popular on Android
  • “Overcast/1.0 Podcast Sync (x subscribers; feed-id=y; +http://overcast.fm/)” – from Marco Arment’s Overcast app, which helpfully tells you how many subscribers you have in the agent string
  • “iTunes/12.4.2 (Macintosh; OS X 10.11.5) AppleWebKit/601.6.17” – downloads from the Mac version of iTunes

Here’s the bit of the plugin that detects what client you’re using

if ( stripos( 'itunes', $user_agent ) !== false ) {

$referrer = 'itunes';

Hm. There was no entry for AppleCoreMediaPlayer, which was why downloads from the native podcast app were being detected as ‘Other’. But we tried downloading episodes from iTunes on the Mac and that was still recorded as Other.

In fact, apart from plays from the website, every client was being recorded as ‘Other’ – except for Pocket Casts. What was going on?

Screen Shot 2016-07-20 at 19.44.03When your needle and your haystack are the same size

Screen Shot 2016-07-20 at 19.46.40The stripos($haystack, $needle) function in PHP looks to see if a string $needle is in the string $haystack, if it is, it returns an integer with the position of $needle in $haystack, otherwise it returns false.

Absentmindedly, I typed ‘php’ in a mac terminal expecting to get an error, but instead getting a blank prompt, indicating I could type PHP code enclosed in <?php ?> and hit ctrl-D to make it run (why does OS X ship with PHP? I have no idea). I tried a smaller test case:

Screen Shot 2016-07-20 at 19.51.22

Those of you reading probably have the aha! moment by now, but it took a bit of probing from Baz before I got it:

Screen Shot 2016-07-20 at 19.52.53

And that was also the reason why Pocket Casts was showing up correctly – because the entirety of the user agent string is “Pocket Casts”!  Anyhow, changing the function around to read

if ( stripos( $user_agent , 'itunes' ) !== false ) {

$referrer = 'itunes';
and adding AppleCoreMedia to the list got everything working fine. Well almost.

Double hits from the iOS podcasts app

We then hit another problem:

Screen Shot 2016-07-20 at 19.57.11

Turns out any downloads from the iOS Podcasts app were being counted twice. It seems like Podcasts first sends a HEAD request for the mp3 file, presumably to get size information so it can populate the progress indicator, with the user agent “Podcasts/2.4”. The app then sends a normal GET request for the mp3 file with the AppleCoreMedia user agent mentioned earlier.

Screen Shot 2016-07-20 at 20.01.55

Being lazy I just added a return statement if we detected the Podcasts user agent:

if(stripos( $user_agent,'podcasts/' ) !== false ) {
 			return;
 		}

I submitted it as a pull request and the maintainer merged it within a few hours. It was fun chatting away with Baz and Dave on iMessage while we tried to fix it.

We need to stop this nonsense about teaching coding in primary school

Today there was a story in the Irish Times, headlined ‘Bruton wants lessons in coding for primary school pupils’, announcing that the Irish Minister for Education, Richard Bruton, was considering the introduction of programming into the national curriculum for primary schools.

I’m passionate about programming. I run a software company. I program in my spare time, for fun. I co-organised a hackathon in Limerick  with the sole purpose of programming for fun with other people for an entire day.  I am a host on a podcast with two other programmers where we talk about, among other things, programming. I’ve also spent some time teaching maths and science in secondary school. And I am convinced that the idea of teaching primary school children to program during the school day is nonsense.

The assertion by tech companies that they can’t find programmers is a myth

The Irish Times articles cites lobbying by some tech companies that they can’t find good people. This is a complete myth, a combination of (a) tech companies not wanting to pay programmers decent wages (b) tech companies being really bad at recruitment and (c) tech companies not being willing to take graduates on and help them develop appropriate modern programming skills. I recruited a graduate developer two years ago for my company Reg Point of Sale, and I came across countless IT graduates who still couldn’t find a job six months after graduating, because all the job adverts were looking for 2 years experience. If tech companies would spend their own money investing in people, rather than whining at the government to spend our money, they wouldn’t have a problem.

It’s also worth noting that even if the plaintive cries about a skills shortage from the tech industry were true, it’s not clear how teaching a bunch of eight year-olds how to write for loops would help.

Teaching programming would require a huge continued capital investment

Compulsory programming on the primary school curriculum would be incredibly expensive.  I’m sure some of these tech companies are salivating at the prospect of juicy hardware, software and support contracts, involving proprietary solutions that will obsolete quickly.

We will be teaching skills that will be obsolete by the time these kids graduate

Take the average ten year-old in primary school: the twelve years that will pass before this kid graduates from college is an aeon away in tech terms – especially in programming languages. The concept that a primary school kid could learn skills now that would be useful to the tech industry in twelve years time is not consistent with the rapid change associated with tech and programming.

We could actually end up with less people in tech

Consider a child who has a natural aptitude for problem solving and logical thinking that suggests they might enjoy programming. But what if the teacher doesn’t have a strong grasp of the material, or the myriad of other reasons why a young child might not have a good experience learning a difficult technical craft like programming. Suddenly this child gets it into their head that ‘programming is hard’ or ‘not for them’, even though if they had been exposed to it at a later age, they might have found some of the joy that some of us derive from programming.

We do need investment in primary education, but in things that are useful to a child’s development

If the Minister for Education has some spare cash burning a hole in his pocket, it’s not as if other priorities don’t exist – for example investing in teaching core literacy and numeracy in primary school which has only marginally improved in 35 years, or doing something to attacking the unconscionable difference in education outcomes for kids from poorer backgrounds compared to those from more comfortable backgrounds.

Programming is great and you should try it right now!

Adults have infinitely more problems that can be solved by simple computer programs than children do. So why don’t you pick up Learn Python the Hard Way, and if you get through that, start on Automate the Boring Stuff with Python. If you’re lucky you’ll experience an enormous thrill as the computer starts to do your bidding. Maybe the Minister himself might try his hand at a few if statements while considering whether to foist this stuff on our nation’s children.

I think programming is a great thing to learn. Just not for all primary school kids during the school day. I hope the Minister reconsiders his plan.

Irish Population change 2006-2016 by area

The preliminary Census 2016 results were released today. Exciting times for data nerds like me!

The CSO published changes showing population changes since the last census, showing that the population had grown everywhere in the country apart from small decreases in Mayo, Sligo and Donegal of -0.2%, -0.1% and -1.5% respectively. I thought it would be more interesting to look at population changes over two census periods, i.e. 2006-2016.

The table below shows population change in each area between 2006 and 2016. Limerick City was the only area to show a decrease, with the population changing by -2.5% compared to a national increase of 12.2%.

Table and CSV file link below. Note that the Limerick City boundaries correspond to the historical (pre-local authority merger) boundaries of the city, but includes the addition of the Limerick North Rural electoral division.

 

2006 2011 2016 Ch 06-16 %ch
Carlow 50349 54612 56875 6526 13.0%
Dublin City 506211 527612 553165 46954 9.3%
Dún Laoghaire-Rathdown 194038 206261 217274 23236 12.0%
Fingal 239992 273991 296214 56222 23.4%
South Dublin 246935 265205 278749 31814 12.9%
Kildare 186335 210312 222130 35795 19.2%
Kilkenny 87558 95419 99118 11560 13.2%
Laois 67059 80559 84732 17673 26.4%
Longford 34391 39000 40810 6419 18.7%
Louth 111267 122897 128375 17108 15.4%
Meath 162831 184135 194942 32111 19.7%
Offaly 70868 76687 78003 7135 10.1%
Westmeath 79346 86164 88396 9050 11.4%
Wexford 131749 145320 149605 17856 13.6%
Wicklow 126194 136640 142332 16138 12.8%
Clare 110950 117196 118627 7677 6.9%
Cork City 119418 119230 125622 6204 5.2%
Cork County 361877 399802 416574 54697 15.1%
Kerry 139835 145502 147554 7719 5.5%
Limerick City 59790 57106 58319 -1471 -2.5%
Limerick County 124265 134703 136856 12591 10.1%
North Tipperary 66023 70322 71370 5347 8.1%
South Tipperary 83221 88432 89071 5850 7.0%
Waterford City 45748 46732 48369 2621 5.7%
Waterford County 62213 67063 68032 5819 9.4%
Galway City 72414 75529 79504 7090 9.8%
Galway County 159256 175124 179048 19792 12.4%
Leitrim 28950 31798 31972 3022 10.4%
Mayo 123839 130638 130425 6586 5.3%
Roscommon 58768 64065 64436 5668 9.6%
Sligo 60894 65393 65357 4463 7.3%
Cavan 64003 73183 76092 12089 18.9%
Donegal 147264 161137 158755 11491 7.8%
Monaghan 55997 60483 61273 5276 9.4%
State 4239848 4588252 4757976 518128 12.2%

CSV file link

 

Supercalifragilis-HibernoCaledonia

HibernoCaledoniaLike others, I’ve spent the last week in shock over the UK’s vote to leave the EU. I was born and raised in Ireland but my parents are British, and I have lots family and friends over the water. I was just so gutted and saddened when the Leave result was announced early in the morning. In fact the next day I drove over to South Wales to exhibit my Reg point of sale app. Staying for a few days in a part of the UK knowing that the majority of people around me wanted to Leave was just depressing.

Over the last few days, Scottish First Minister Nicola Sturgeon has been making brave attempts to ‘keep Scotland in the EU’ – but even if there was another independence referendum, it’s difficult to see how Scotland can Remain. Spain will always veto any attempt to admit what they would view as a ‘sub-nation’ to the EU because of concerns about Catalonia’s independence ambitions. Meanwhile over in Ireland we are worried about an uncertain future.

But for those of you in these isles who are full of despondency: don’t worry. I have a plan.

(Your post-Brexit despondency will be lifted if you sing along with the headings. Trust me.)

A country that’s part-British but without the xenophobia

What if Ireland formed a union with Northern Ireland and Scotland, which would then enjoy continued membership of the EU by inheriting Ireland’s seat? We could be one nation together, with significantly devolved powers as currently exist in the Stormont, Holyrood administrations, complemented by a new devolved administration for Dublin. We’d have to have a new federal parliament for HibernoCaledonia, probably in Belfast.

With one stroke we could solve the political status of Northern Ireland. Unionists would not be smothered by a perfidious South intent on dismantling their culture. Nationalists would see a ‘nation once again’, just with an extra bit added on.

If we joined together we’d be bigger than Bulgaria

Population of the Republic of Ireland: 4.6m
Population of Northern Ireland: 1.8m
Population of Scotland: 5.3m

Total population of HibernoCaledonia: 11.7m

HibernoCaledonia would have a GDP of over $567bn, making us the 35th largest economy in the world by that measure. We would be the headquarters of some impressive international companies such as Ryanair and Royal Bank of Scotland, and the new country would be able to challenge for significant inward investment.  We would be the pro-European powerhouse of North-Western Europe, showing the world that internationalism and tolerance is still alive and well in these isles.

Supercalifragilis-HibernoCaledonia!

I know it sounds like a joke but I’m deadly serious. Our three countries face an immense threat with the prospect of Brexit. In our own ways, we would all benefit from the more pluralistic administration that a union would bring. It would put to bed once and for all the Northern Ireland question, which otherwise will continually threaten the peaceful future of the province. The Remain side were right, we are Stronger In. Let’s join our hands and work for a shared European future.

The Curious Tale of Limerick Marketing Company

IMG_2557Limerick Council announced recently that it had promoted its Communications Officer to be Head of Marketing, a pretty un-noteworthy story even by the sleepy standards of local news in a small city.

Yet the appointment marks the end of a sorry tale of money wasted, opportunities missed and the continuing damaging culture of secrecy that pervades Limerick Council.

One of the unintended consequences of Fine Gael’s commitment in 2011 to consolidate some state bodies was that it left a number of people with lucrative permanent public sector jobs needing to be redeployed. Part of Limerick Council’s response was to set up a number of companies (why the separate companies were needed was never explained: was it to support salary increases outside of the public sector pay freeze? I suspect we will never know), including the Limerick Marketing Company, which was launched with great fanfare and an announcement that the company would double visitor numbers in five years. The company’s two employees came from state agencies that were affected by Enda Kenny’s putsch on quangos.

This ‘company’ never published any details about its staff or its activities beyond a pretty bland statement of objectives on the Council’s website. Two and a half years later, due to restructuring in staff in the council, the need for the company has gone and the idea has been quietly forgotten (and presumably, the objective to double visitor numbers has died with it).

It’s difficult to criticise the marketing of Limerick that has taken place over the last three years because frankly there wasn’t that much of it. Sure there were a few articles in the local papers, which I’m sure provided gratification for the individuals involved, but there was very little national or international coverage, and so in the absence of any other evidence it seems like the objective of Limerick Marketing Company was “Let’s tell ourselves how great Limerick is, and we’ll hope someone outside the city notices”.

One of two flagship events of the Limerick Marketing Company was Riverfest, an event rightly criticised by Brian Leddin last year as an event that “reflects a city as sophisticated as a Supermacs outlet on a Saturday night”, and that was “lame and mediocre”. Brian’s full article is worth a read as he also highlights the inward looking approach to marketing our city.

The second event was acknowledged locally to be a complete disaster. The marketing company spent half of its annual budget underwriting a “rugby world club sevens” event, and a five-year contract was signed with a private company to underwrite this event. The Limerick Leader reported that the turnout was “paltry”, with only 300 people attending one of the events in Thomond Park, and a total subsidy of €200 for every ticket sold from the public purse.  The Leader termed Limerick Marketing Company’s justification for the event to be “self-serving drivel” – strong words for a local newspaper that is normally very supportive of local events.

The new marketing company was stitched in to the fifteen year socio-economic plan for Limerick (the “Limerick 2030 Plan”) – with nineteen specific actions assigned to it. Even though the marketing section of the 2030 plan was perhaps one of the weakest sections of the document (I described it as being “pretty terrible” in my submission to the plan), at least it published some initial steps that the Limerick Marketing Company could take. Out of nineteen actions I cannot find any evidence that any of them were completed, even though all actions were due to have been completed by the time the company ceased operations.

The one positive initiative that the Limerick Marketing Company was involved in was the ‘street ambassador programme’ that ran over the summer months. This wasn’t an initiative of the Company – it merely inherited responsibility for it. Once the company inherited the responsibility, it promptly scrapped the programme.

In fact there is no evidence that the company ever traded at all. The most recent returns of Limerick City & County Marketing Limited were made in April 2016, where the accounts showed no activity beyond the issuing of a share capital of €2. It was reported recently that the board of the company hasn’t met in the last two years.

It didn’t need to be like this. Between promoting a culture of openness, creativity, debate and vibrance; and targeting specific visitor niches where we can compete effectively; we really could have doubled visitor numbers in five years. Instead it feels like we will continue talking to ourselves, and the promises will continue to be forgotten.

Five reasons why you should buy my old post office van

1. The most patriotic vehicle you could buy

IMG_2518It’s 2016. One hundred years ago a bunch of lads took over a post office and announced to the world our nation’s great destiny. It is your patriotic duty to commemorate these great men and women and what better way to do it than drive around in a green post office van. As Pearse wrote “there are many things more horrible than bloodshed, and not owning a van is one of them”. Commemorate the historic anniversary of the minor disruption to our postal services with the Renault Kangoo Tiocfaidh Ár Lá Centenary Edition today, together with its unique 2016 numberplate. Never forget the sacrifice of our forefathers.

2. Profit from the great gay conspiracy to destroy Irish family values

DSCF6730
Remember last year when the gays got together and mounted a well-funded campaign to undermine traditional Irish Family Values? This is your chance to benefit from some of the trillions of euro that were pumped into this country to destroy marriage, which would have remained secret but for the courageous work of Breda O’Brien. Obviously I can’t detail the secret investments that were made into this van as part of The Great Liberal Conspiracy To Force Sodomy On The Good Irish People but trust me, the gays don’t do things by halves.

3. A bold fashion statement

IMG_2519Pre-distressed clothes are so in right now. Why should your van be any different? To ensure you retain that edgy look as you drive, and to echo the edgy tones of Greg Lauren’s Spring 2016 ready-to-wear collection as breathlessly described by Vogue Magazine, I have performed some scratch detailing on left hand side of the van so you can convey a contemporary aura to the world. Sneer at the rest of the drones with their boringly unblemished means of transport as you cruise around in this fabulous example of hand-crafted pret à porter.

4. You’re not buying a van, you’re buying freedom

In the great tradition of car marketing, here’s a photo of the van in the wilds of Kerry.
DSCF6646
Don’t you feel wild and dangerous after looking at that photo? Don’t you agree that owning this van will make you more attractive to whichever gender(s) you fancy? You’re special, you’re unique, you need this van.

5. Apparently I need an odd number of paragraphs if this is to go viral

155,000km, full Renault service history, taxed till December, tested till January. Selling because we need a 3-seater van now Sheila’s dad lives with us. I’m spectacularly bad at negotiating so you can probably buy it for a lot less than it’s worth.  Live the dream, buy my van.

Identifying Irish addresses by county

My friend Emmet called me with an interesting problem today. He had a spreadsheet with 28k rows. One of the columns was an address, sort of separated by commas. The address column was very inconsistent. Some ended in Ireland, others just had the county name, some used the form “County Limerick”, others “Co. Limerick”, and others still just “Limerick”. He needed to do some calculations by county so he needed to extract the county name for each row. As I learned doing the pubs research, Irish addresses are a pain!

I’d dealt with this sort of problem before (not with 28k rows mind!) when I used to work for national charities and it used to bug me terribly.

Emmet found a way to anonymise the data so he could send me a subset. I had a play around with a spreadsheet-based solution before breaking out the Python for a quick hack.

The script below reads in a file called “input.csv” and writes to a file called “output.csv” with the same data, but with the county name and a comma added to the start of each line (or Unknown if the script couldn’t work it out).

The script is case-insensitive, and matches the rightmost county on each line, so an address in Omeath, Co. Louth is correctly identified as being in Louth, and Dublin Rd., Athlone, Co. Westmeath matches Westmeath, not Dublin.

The script is fairly flexible about the structure of the input file, so the address data can be in different columns, or all in one.

Here’s the script:

###Usage: python parse-csv.py###
###Input file must be called input.csv###


#function definition: input_text is a string, all_ireland is a bool
def prepend_address_with_county(input_text,all_ireland):
    #prepare the county list
    counties_list = ['Carlow','Cavan','Clare','Cork','Donegal','Dublin','Galway','Kerry','Kildare','Kilkenny','Laois','Leitrim','Limerick','Longford','Louth','Mayo','Meath','Monaghan','Offaly','Roscommon','Sligo','Tipperary','Waterford','Westmeath','Wexford','Wicklow']
    #add on the six counties if we want all-Ireland
    if all_ireland == True:
        counties_list.extend(['Antrim','Armagh','Derry','Down','Fermanagh','Tyrone'])
    outfile = ''
    errorcount = 0
    linecount = 0
    #loop over each line
    for line in input_text:
        linecount += 1
        #keep track of the county we're going to feed in
        county_match = ''
        #let's keep track of the index of what we have found, we want the rightmost match
        old_find_index = 0
        #loop over all counties
        for county in counties_list:
            #look for the county, starting from the RHS
            # also convert to uppercase first
            find_index = line.upper().rfind(county.upper())
            #have we found anything? (find_index will be -1 if we haven't found anything)
            if find_index > old_find_index:
                #keep the county match
                county_match = county
                #update the rightmost index count
                old_find_index = find_index
        #have we got any matches?
        if old_find_index != 0:
            outfile += county_match+","+line
        else:
            outfile += "Unknown,"+line
            errorcount += 1
    return {"output":outfile,"errors":errorcount,"lines":linecount}




file = open("input.csv" ,'rU')
output_csv = open("output.csv",'w')
result_dict = prepend_address_with_county(file,True)
percentage_error = 100*result_dict["errors"]/result_dict["lines"]
print "%d lines processed, %d Unknown counties (%.2f%%)" % (result_dict["lines"], result_dict["errors"],percentage_error)
output_csv.write(result_dict["output"])

Escape to the pub with a Raspberry Pi, a pressure mat and push notifications

My father-in-law moved in with us two weeks ago. He is a lovely kind man in his late eighties and it’s a pleasure having him around.

He has Alzheimer’s and needs someone around him all the time during the day. We’re managing this OK while juggling the needs of the business. Unfortunately he can sometimes wake up in the middle of the night in a state of anxiety because he doesn’t know where he is.  This means that Sheila and I can’t get out to the local for a quick pint even after he’s gone to bed.

The mat of freedom, with the white cable on the top left going in to our bedroom
The mat of freedom, with the white cable on the top left going in to our bedroom

Enter the lazy programmer…

There’s nothing like the prospect of a pint to stir the motivations of a hacker!  I had a Raspberry Pi lying around the house. I’d been looking for an excuse to mess around with push notifications on the iPhone for a while, and I thought I could rig something up that would send a push notification to our phones if he left his bedroom during the night.

Internet of things mats

The pressure mat
The pressure mat

Our local electronics retailer Maplin sells a pressure mat – it’s a simple switch designed to be placed under a doormat. Hooking this up to a GPIO pin on the Pi would allow me to send a notification to our phones using Apple’s Push Notification Service. Here’s the general flow:

Pressure mat -> Raspberry Pi -> Apple Servers -> our phones

Not the most complicated of hacks by any means, but if it was going to allow us to get out for a pint it would be worth it.

Setting up the Pi

The Raspberry Pi beside the bed, with wires from the pressure mat connected to GND and GPIO pin 18 via an old telephone cable
The Raspberry Pi beside our bed, with wires from the pressure mat outside the door connected to GND and GPIO pin 18 via an old telephone cable

I bought the Pi two years ago with the aim of doing a bit of tinkering over Christmas, before realising that, although the Pi is an amazing platform at an amazing price, it’s still a Linux box and I didn’t want to be tinkering with .conf files to get things working over my Christmas holidays. But I’d been feeling vaguely guilty that this credit-card sized wonder was sitting gathering dust while kids a quarter of my age around the world were using it to achieve amazing things.

I downloaded the Raspbian Linux distribution from the Raspberry Pi website – choosing the Raspbian Jessie Lite distribution as I didn’t need any graphical niceties. I was hoping I could just boot up the Pi and get its IP address from the local network but ping 255.255.255.255 didn’t show anything up and my Apple AirPort Extreme router, although rock solid and wonderful in many ways, doesn’t show a list of ethernet clients, so I had to hook up a HDMI cable to finish the setup. Setting a static IP was a bit of a pain as the network stack changed significantly last year and most of the links I found had outdated information, but there’s a very comprehensive thread on StackExchange which explains what you need to do to dhcpd.conf (note to self, recent distros include a zeroconf implementation so you should be able to do something like ssh pi@rasbperrypi.local and it should get you in to a Pi with a fresh OS install)

Processing a push notification with an iOS device

This was actually the easiest bit of the whole process. Apple’s docs on push notifications are really good.

Here’s the entirety of the code of the iOS app, pretty much taken verbatim from Apple’s example code:

- (BOOL)application:(UIApplication *)application didFinishLaunchingWithOptions:(NSDictionary *)launchOptions {
    // Override point for customization after application launch.
    // bitwise OR to include all notification types
    UIUserNotificationType types = (UIUserNotificationType) (UIUserNotificationTypeBadge |
                                                             UIUserNotificationTypeSound | UIUserNotificationTypeAlert);
    //register these notification types
    UIUserNotificationSettings *mySettings = [UIUserNotificationSettings settingsForTypes:types categories:nil];
    [[UIApplication sharedApplication] registerUserNotificationSettings:mySettings];
    // Register for remote notifications -- this will prompt the user to allow notifications
    [[UIApplication sharedApplication] registerForRemoteNotifications];
    
    return YES;
}

-(void)application:(UIApplication *)application didRegisterForRemoteNotificationsWithDeviceToken:(NSData *)deviceToken
{
    //triggered when user allows notifications
    //Log the token
    NSLog(@"device token: %@",deviceToken);
    // Also store the token in NSUserDefaults
    NSUserDefaults *defaults = [NSUserDefaults standardUserDefaults];
    [defaults setObject:deviceToken forKey:@"deviceToken"];
    [defaults synchronize];
}

I wrote the device token to NSUserDefaults in case I wanted to display it in the app, but I took the lazy way out and just printed it with an NSLog statement, so I could copy it into my Python script.

Sending a push notification with a Python script

Here’s my Python script that detects someone stepping on to the mat, and which sends a request to Apple’s APNS server:

import RPi.GPIO as GPIO
import time
import datetime
import socket
from apns import APNs, Frame, Payload

GPIO.setmode(GPIO.BCM)
GPIO.setwarnings(False)

# our pressure mat is connected to GPIO pin 18
button = 18

# setup the pin as input, and enable the pullup resister
# this means when the switch is pressed, it will read GND, i.e. False
GPIO.setup(button, GPIO.IN, GPIO.PUD_UP)

# insert the tokens you NSLogged from your iOS app here - long lines of hex
token_hex = ''
sheila_token = ''
# setting the payload here - we just want the default sound, and we don't care
# what the badge says so we'll just set it to 1 each time
payload = Payload(alert="Joe is on the move!", sound="default", badge=1)

# run in an infinite loop
while True:
    # if switch is pressed (reading False - see note on GPIO.setup() above)
    if GPIO.input(button) == False:
        #logging for debugging
        print str(datetime.datetime.now()), "button pressed"
        #create the push notification object
        apns = APNs(use_sandbox=True, cert_file='push-notification-cert.pem', key_file='push-notification-key.pem')
        time.sleep(1)
        # wrapping this in a try/except block as the script was occasionally
        # barfing on a socket error
        try:
            apns.gateway_server.send_notification(sheila_token, payload)
        except socket.error, (value, message):
            print str(datetime.datetime.now()),"Socket Error", message
            #recreate the apns object
            apns = APNs(use_sandbox=True, cert_file='push-notification-cert.pem', key_file='push-notification-key.pem')
        time.sleep(1)
        #we're done with Sheila's phone, now let's do the same for mine
        try:
            apns.gateway_server.send_notification(token_hex, payload)
        except socket.error, (value, message):
            print str(datetime.datetime.now()),"Socket Error", message
        time.sleep(10)

Apple recently changed their push notification protocol to a brand new version, which I tried to connect to using a Python HTTP/2 library called Hyper – it’s labelled as a ‘very early alpha’ and it may work very well but after a few hours of trying to create the HTTP/2 request I was still getting errors so I used a library that uses the old protocol called PyAPNS which worked fine although I had to insert a few sleep() statements to avoid some socket errors.  I also had to do some fandangling with the push notification certificate, splitting up the .p12 file into a certificate and key in Keychain Access to use with the script.

My Linux skills are a bit rusty so it took a while to remember to type screen then <CTRL-A> d to detach a separate terminal which would run even after I logged out of the SSH session.

It works!

Notification on my phone's lock screen when the mat is stepped on
Notification on my phone’s lock screen when the mat is stepped on

For all the ugly hacking, it seems to work! Sheila and I can nip down for a quick pint to our local knowing that we can quickly return home if her dad starts wandering.

Further work

I spliced in an old telephone cable to connect the pressure mat outside the door with the Raspberry Pi beside my bed. I was in a rush so I used sellotape! Aside from tidying that up into something a little less ugly, here’s the things I’d like to do next with the project

  1. Replace the Raspberry Pi with something like an ESP8266 module that could run off a battery, so I don’t need trailing wires. This post from Stavros Korokithakis shows how he recreated an Amazon Dash button using an ESP8266 looks promising.
  2. Using the ESP8266 would mean that I would have to handle the push notification logic on an external server, so that the ESP8266 would send a HTTP request to a Flask server which would send the request to Apple.
  3. Having the logic on the server means that I could log the data to a database, which means we could track how often the night interruptions were happening.
  4. which reminds me I should enter some logic so that the script only does push notifications and logging at night, sometimes when we’re going in and out of his room to do washing our phones go crazy!