Excel Number format for Sort Codes

In the UK bank sort codes take the format 99-99-99 for example,   Excel plays silly buggers with this,  you can get around it by prefixing it with a ‘ which will turn the field to text but really there is a better way by creating a  custom number format.

Simply go to format cells -> Custom and then enter 00-00-00 as the format.   this has the added bonus of preserving the leading number if it is a zero.

Have fun

Cockney Rhyming Slang For Dogs

Right, a friend of mine down the pub has taken in a young dog because the family that had him originally discovered that one of the kids is allergic to dogs.

This little hound is a lovely animal but does not seem to respond to my friend’s commands, I have deduced from this that it is not that it is because it is a puppy but due to it’s former location (London) and therefore it is obvious that he doesn’t understand people in Worcestershire and must only speak Cockney rhyming slang…

I have started on a translation guide for him, and when complete will be printed out and posted in the pub at dog level to assist canine communication.

Windows and doors , paws
Apostle’s creed , lead
Elbows and toes, nose
Having a beg, cocking a leg
Daily mail, wagging my tail
Parking , barking
Give me a phone, throw me a bone
Having a yap, one requires a scoop and bag
Strike a match, catch

This is a work in progress…

Notion Ink Adam – 3G Settings. Apn settings

Just a quick note.

You will need to reboot after inserting SIM card.

In the mobile settings you will need to create a new Apn entry.  You will be able to get this from your providers website.

Important : the name on the entry will need to match the providers name for it to work.

On hold to Vodamoan (Vodafone)

/me complaining on IRC about calling Vodafone…

< tig> grrr dealing with vodamoan :-I
< tig> up a tier and round and round we go
< tig> will it get fixed nobody knows…
< tig> tell the tale tell it once more
< tig> I am repeating my self now, what a bore
< tig> on hold with the music in a repeating loop
< tig> now my hot cup of tea is luke warm gloop
< tig> will they come back, it’s a mystery to me
< tig> yuck I now am having to suffer a mug of cold tea
< tig> but what is this that wakes me from my slumber?
< tig> oh cock it is tech support telling me to ring another number 🙁

Airports

Sitting in departures at Belfast City airport (I refuse to refer to it by it’s daft new name) and I am reminded of the kicking that Heathrow, Gatwick and others got in the press when they could not stay open in the snow.  The criticism was levelled that they were more focussed on being shopping malls than airports, something they howled at and denied. 

If airports want to be taken seriously as transport conduits and not “retail experience centres” they need to stop shit like the following.  I am currently sitting looking at a departure board and the status comments for all non-boarding flights is listed as “Relax and Shop”.  It does very little for your credibility when you are trying to pretend that you are not just focussed on extracting cash from a captive audience.

Cooking Parsnip and Pecan Cake: The Linux Distro Guide

From a conversation on #staffslug

We start of with a recipe for fantastic cake :

http://www.bbcgoodfood.com/recipes/12983/catherine-marshalls-parsnip-and-maple-syrup-cake

We then see how given this recipe or source different distros would approach cooking it based on past experiences. Please note this is humour and don’t start getting pedantic 🙂

Ubuntu

Cooking is reasonably successful, not very fast but was reasonably friendly, used brand name ingredients, the icing sugar came out a bit odd but tasted alright so you can’t be arsed to fix it.

Debian

Getting the ingredients together took a tad longer, couln’t use the recipe as provided as the BBC trademark did not fit with the rules, consequently cake is now called IcedParsnip Cake but apart from that the recipe went well, shame some of the ingredients were a little stale. Also mixed spice cannot be used as it is a closed ingredient provided by a third party company that refuses to reveal the exact recipe.

RedHat/CentOS

Cake was baked with tried and tested ingredients some however were a couple of years old. Cake, although of professional quality was rock hard and stable. Better for construction use than eating. RedHat cake comes with support tag, CentOS version identical but now called CommunityEnterpriseCake.

Fedora

Uses the freshest ingredients but halfway through the baking stabs you in the face with a circular dependency on pecans.rpm.

Gentoo

All ingredients have to be grown from scratch (yes you could use packages but then you could not do compiler fu), recipe is eventually very quick but by the time you have grown everything and baked the cake everyone else has eaten theirs (also then you find out it has raisins in it as you messed up a USE flag when you were fiddling with stuff waiting for your pecan tree).

SugarCRM ZuckerReports Encoded Settings

I love the reports we get out of SugarCRM now but ZuckerReports sometimes does things that throw me off for a while and then make me kick myself when I understand them later. Today’s case in point I needed to add someone to an existing scheduled report. Zucker (at the moment) does not have any facility for this, you just delete the old one and set up a new one, but I was not having any of this and dived into the database.

Now in the interface and the database the scheduled reports settings are “encoded” and it would appear that adding an e-mail address should have been straight forward. An example :

a:7:{s:10:”FooCoUsers”;s:8:”j.smiths”;s:6:”format”;s:3:”PDF”;s:15:”parent_category”;s:0:””;s:13:”parent_module”;s:0:””;s:9:”parent_id”;s:0:””;s:10:”send_email”;s:38:”d.badgers@fooco.com,j.smiths@fooco.com”;s:6:”record”;s:36:”44989f47-f46e-f334-c287-4c45cb79ff98″;}

Pretty obvious where the email addresses are and they simply appear to be comma separated. So all you do is add the email address in after the last one prefaced with a comma? Not quite…

If you do this then the report will fail silently and will not run and you will be digging around trying to find out what happened! 🙂

The Reason aka why you are here

Breaking down the report setting encoding is simple (not sure what the a7 bit is) but then you have inside the curly braces a number of data values each separated by a semi colon ( ; ) the values are in “quote marks” and then they are prefaced by an s:$: value. This value is the a number of characters inside the data quotes for that entry eg s:6:”record” because the word record is 6 letters long. In the case of the e-mail address list it is everything (including the commas) between the quote marks. If you don’t change the s:$: value for a record and change the value (unless the new data is exactly the same length) it will fail silently!

Anyway I hope this helps someone as I was fiddling with this for ages 🙂