Car Servicing

The other day, I had to take the car into the garage for a couple of things – nothing massive, just a replacement headlight bulb, and a check into some squealy noises in the power-steering.

In the end, the car was in the garage all day, as I was at work. They did the bulb, checked for the intermittent noise, and looked at some other stuff.

When I went in to the garage to collect the car and pay the bill, I was fully expecting a bill for £80-£100, what with time, materials and the like. My estimate of what the bill would be was hugely wrong – awesomely, impressively wrong.

The bill actually came to – are you sitting down? – 95p. Needless to say, I didn’t bother paying it by credit card…


Let the train take the strain

I saw yesterday in the news that apparently the route I use to get to work is a huge success, with 35% more passengers on it per year than originally predicted. Which is great in a number of ways – although not so great in a number of others.

Last year saw the route take 670,000 passengers, which isn’t bad for a fairly rural/provincial service.

But, if the route is so successful, and (if you average out the costs of travel at £10 per passenger – which I reckon is probably a conservative estimate) has already repaid the original investment would it be too much to ask to have trains of three or even four carriages, rather than the current standing-room-only rigid-in-peaktime trains of only two carriages? It’s not like the platforms can only cope with two carriages, and it would probably persuade a lot more people to use the service on a regular basis.

As it is, the service is OK – depending on when and where you get on the train. In the mornings, I’m lucky now to get a free table, although on the way back it’s not to bad (for me, anyway) as I get on the train as soon as it pulls in, rather than trying to jam myself in at the last possible second. But for many people that’s how they see the peak-time service – as one equivalent to a commuter train to London, jam-packed and standing room only.

If One Trains repaid some of the customer/passenger investment by adding an extra carriage or two, the service would be just as well used – and probably more so – but with a considerable lessening in the number of customer complaints.

You’d think that would make sense, wouldn’t you?


Migrating Databases

Currently, for various reasons, I seem to be heavily involved in moving databases around. Not just the data, but the databases themselves. If you’re at all geeky, it’s kind of interesting, seeing how other people organise data as opposed to how I prefer to do it, and looking at the future-proofing of such data. If you’re not geeky then don’t read any further, you’ll just get bored. There’ll be something else along later for you, I’m sure.

In one case, the client is moving from an on-line service provider to an in-house solution that’ll be written solely by Yours Truly. In a lot of ways it’s a complete nightmare – the provider will only export the data in one format, an Excel spreadsheet. That then has to be converted to something that’ll work with SQL, then get tweaked so it’ll work without crashing on import to MySQL, and that’s just to get it into a “temporary” table before I do a whole bundle of conversions on the data in order to get it all to work in the way I want it to.

In the other main scenario (there are a couple of other smaller jobs too, but two main jobs at the moment) I’m going the other way – from an existing in-house database (on MS Access) to a much more stable, versatile, and extensible on-line version with nice web front-end and a bundle more functionality. Again, it’s producing some interesting challenges- not least that Access really doesn’t like exporting to anything. Ever.

All the same though, both jobs are interesting and (dare I say it) fun. They’re making me think (hard) and come up with solutions to problems, which is actually always something I enjoy. Once I’ve got the current data migrated over, then I get to do a load of other stuff with it in order to fit it all in with the plans/ideas that’re already present, and that again will be something I enjoy.

Yes, I truly am that sad. Worrying, isn’t it?


CAPI_Worker module

A while back, I upgraded my phone to the Sony Ericsson K800i. Once I’d received the phone, I also installed the Sony-Ericsson PC Suite, so I could synchronise the phone and my PC (something that’s always a pain in the arse anyway). Ever since then, I’ve had an error come up every time I start the PC, telling me that the CAPI_Worker module has crashed. It’s not a big problem, but it’s an annoying one, because it also meant that while I could connect my phone to the PC for moving files around and the like, I couldn’t actually sync it – I synced OK the first time I installed the PC suite, but then it wouldn’t connect any more.

Anyway, last night I did some furkling (also known as “fucking about on t’internet, and searching Google in particular”) about the problem, and then had a play on the PC. Sony Ericsson themselves insist there’s no problem, and that if the CAPI_Worker module is crashing, you’ve got a dodgy install of Windows. Only that’s not the answer at all – fortunately, I read someone else’s post about that before I tried re-installing Windows. But I did find a fix. After the more link, it gets a bit geeky…
Read the rest of this entry »


Commuting Travel

According to this story, a study by the RAC Foundatioin suggests that about 70% of British workers travel to work by car.

To be honest, I really can’t say that I’m surprised. Up until recently, I’ve always commuted to work by public transport- whether that’s bus, train, or both. It’s been very rare that I can walk to work, and also pretty rare (until moving to Norfolk) for me to drive to work, although that’s primarily due to the fact I’ve only owned a car in the last six months.

While I was in Manchester, it was always far easier to use a bus than to drive in to work. Cheaper, too- by a massive margin. The amount I paid for a weekly ticket into the city centre was about the same as I’d have paid for one day’s parking. Even when I started working in Oldham, and doubled by weekly bus-ticket costs (due to needing tickets from two bus companies) it was still significantly cheaper. Mind you, the service by First Bus from Oldham was fucking abysmal, which didn’t help – but it was still easier than doing the run by car.

In Bracknell (the only place recently where I could walk to work for some time) I didn’t drive to work- the train to Wokingham (once I’d moved from the walk-to-work place) took 10 minutes, and would race past the daily traffic jams on the A329(M) every day. Again, it cost me about £10 per week to do – and parking for the day in Wokingham would’ve run to about £6 or so, which made it cost effective.

When I started here in Cambridge, I was still living in Bracknell, and used the train to get here and back every week. If I’d been driving it would’ve taken me about as long as the train journey, but if I’d had the choice, I’d have used a car – just lugging a week’s worth of clothes on the train every week was a pain in the arse, and would’ve been far easier in a car.

Since we moved to Norfolk, I do still tend to use the train most of the time. As I’ve written before, it takes a bit more time door-to-door, but does have the advantage of giving me extra time to do work, and the like. Works for me.

This week, though, the train line is being fixed/maintained/repaired/whatever along a large section of the train route, which is being replaced by buses. So I’m driving in this week, because it’s easier.

But if Attleborough wasn’t on the main train line to Cambridge, or if I worked outside the city centre, I’d be driving it every day. There would be no point in using public transport, because it would make the commute unfeasibly long. When I change contracts, if it’s a place off the beaten track, I’ll be driving in.

Reports like this that then say people should use more public transport are all well and good, but before anyone is able to get the majority of people onto public transport, the infrastructure for it has to be there – the services have to be reliable, on-time, and regular. More importantly, they have to go where people want them to go – there’s no point creating a huge business park that doesn’t have a good bus service, for example (and believe me, I’ve worked in a few of those).

Until the infrastructure is sorted out, people won’t use it. And until people start using it, the companies will say there isn’t the demand for the infrastructure to be expanded. Good, innit?


“Observant”

I’ve been using online banking for years now. I look at it at least every couple of days, and keep a fairly close eye on what’s coming in and out of the account, which means I also look at the online statement on a regular basis.

A lot of the transaction details start off with four numbers, something like “8217 iTunes”. I’d never really paid attention to them, just figuring that it was some kind of bank code. In a way I was right.

You see, I’ve just figured out what those numbers actually are.

Recently, the bank sent me an updated Switch/Maestro card- nice of them, considering I hadn’t asked for it- which (obviously had a different 16-digit number on the front to the one I already had.

Yes, the four numbers on the bank statement are the last four on the card. Turns out I’d forgotten to update the card details on my iTunes account, so the old card (which should’ve been “immediately cancelled once I started using the new one”, according to my fuckwit bank) was used when I downloaded some music from them. And lo, the old card’s four numbers are listed against iTunes.

Clever, innit?


21+

In light of this ridiculous story where a 71 year old man was refused alcohol “because he wouldn’t confirm he was over 21 when asked”, I wonder how long it will be before someone else comes forward and says “I’m 16, and the same store let me buy alcohol”?