Month: April 2010

Using the places database

I was asked recently by a colleague for some information about the names and locations of local authorities in this country. I was able to respond quickly and usefully thanks to the places database, which sits on the website of the Department for Communities and Local Government.

Here’s what I did, as a simple example of what you can do with this resource. We’re just going to produce a spreadsheet containing the names and contact information for local councils in England. I’m no expert on this stuff, but hopefully this demonstrates some of what is possible, and encourages folk to have a play.

First, go to http://www.places.communities.gov.uk/ in your web browser.

Scroll down and choose ‘download data by theme’:

Download data

On the next screen, we need to tell the system what information we want to extract through a number of steps. Here’s what steps 1-3 should look like for our example (click for a bigger version):

Steps 1 to 3

For step 1 select Current, step 2 select Key Facts, step 3 select Local Authority.

Two more questions to answer:

Steps 4-5

Step 4 choose Place Details, Step 5 leave start and end dates both as current.

Finally, there is a bit of a warning message – which I just ignore – and then the option to download the data as either an Excel spreadsheet or in CSV format:

Steps 6-7

Then just hit download, and your data will be saved to your computer. Dead easy.

Thanks to Martin Stone who first pointed this out to me.

I’d be interested to find out what uses other people have been putting this tool to.

The iPad: computer or device?

There has been a flurry of reviews and opinions about Apple’s new gadget, the iPad, this weekend as the devices has been launched in the States. They should be in the UK by the end of April, and I still haven’t made up my mind about whether I’m going to get one or not.

ipad

A really interesting debate was kicked off by Cory Doctorow on BoingBoing with a specific philosophical problem with the iPad, in that it is a computing device that is seemingly at odds with the prevailing culture of computing:

The way you improve your iPad isn’t to figure out how it works and making it better. The way you improve the iPad is to buy iApps. Buying an iPad for your kids isn’t a means of jump-starting the realization that the world is yours to take apart and reassemble; it’s a way of telling your offspring that even changing the batteries is something you have to leave to the professionals.

In other words, where is the room for tinkering with a device like this? How can you get a piece of software onto your iPad, other than by having it accepted by Apple onto the AppStore?

Jeff Jarvis also has issues with the iPad:

The iPad is retrograde. It tries to turn us back into an audience again. That is why media companies and advertisers are embracing it so fervently, because they think it returns us all to their good old days when we just consumed, we didn’t create, when they controlled our media experience and business models and we came to them. The most absurd, extreme illustration is Time Magazine’s app, which is essentially a PDF of the magazine (with the odd video snippet). It’s worse than the web: we can’t comment; we can’t remix; we can’t click out; we can’t link in, and they think this is worth $4.99 a week. But the pictures are pretty.

There’s no denying it is a beautiful bit of kit, though, and a winning user experience. Take the review by Jason Snell:

One day, devices like the iPad may very well change the way we view computers and technology. But right now, I don’t believe the iPad is going to make anyone stop using their main Mac or PC. If you were in the market for an e-book reader or a supplemental laptop, though, I’d give those plans a serious re-think.

Because the iPad is such a new concept, Apple faces some serious challenges in making people understand how they might use it and why they should buy one. It’s not a product type people are familiar with, like a PC or a phone, or a TV or a lawnmower. It’s neither fish nor fowl, and consumers are pretty comfortable with their chicken and salmon, thank you very much.

Joe Clarke also has an interesting take:

This was the weekend those of us with high standards lost their remaining residue of patience for ideologues who hyperbolize about open systems without actually creating something people want to use.

I think there is an important distinction to make between those who use computer purely to consume stuff – whether it’s web browsing, playing music and videos, doing a bit of online shopping, Facebooking and emailing, and those who create on a bigger scale using technology – those that produce a lot of content, whatever the medium, and those that want to program computers to do things.

The idea, frankly, that someone would buy an iPad so that they could learn PHP on it, or something, is a bit daft. Instead the iPad could be seen as the type of device people first use to get online, and if curiosity makes them want to find out how stuff is created, they graduate to more flexible machines, in other words a laptop or desktop computer.

I suspect then that iPads – and similar tablet devices – could begin to replace netbooks, which are often bought as cheaper alternatives to full laptops. As Tim Anderson’s recent piece shows, though, even an entry level netbook can be a pain to get working.

My main use for an iPad would be in using tools like my email, Twitter, and especially Google Reader, in a comfy way when I am away from my desk. Whether that’s worth £500 I’m not sure.

The interesting thing is to watch emergent technology to see where it will go. The great example is SMS and mobile phones – it was never thought likely that people would use text messaging, and yet it is a phenomenally popular tool.

Here’s another example, from my own technology use. I bought a Kindle a few months ago, mainly to have a play and without any serious idea that I might stop reading paper books. However, I’ve found myself using it more and more – but not to read books.

Kindle

It’s really easy to get PDFs on the Kindle, either by emailing them into a dedicated address for my device (which costs a few pence) or just transferring by USB when the Kindle is connected to my computer, like any other external storage. The Kindle has now become the thing I use to read documents published electronically, whether white papers, instruction manuals, policy documents, whatever. Rather than staring at my laptop screen, or printing them out, I now just download them onto the Kindle and read them on there.

So it’s possible that the game changing use of devices like the iPad hasn’t even been identified yet. But I think it is important to recognise that these things are devices and not computers, at least not in the sense that a lot of us are used to.

The DavePress survey

Hello everyone, welcome back after the easter break!

I’d be really interested to find out more about the people who read this blog, and what they make of it. So, I threw together this little survey. It’s done in Google Docs, and if you can’t access it for some reason but would like to complete it, just drop me an email and I’ll send you a version you should be able to use.

Thanks in advance!

Update: thanks to all who have taken the survey. I’ll publish the results soon.

Moving to Google Apps…and surviving!

Dave says: Paul is a director of Learning Pool, and thus my boss. When he offers to contribute a post to this blog, I don’t have to say yes, but it kind of makes sense to do so. As well as being someone who knows how to run a great business, Paul also has an understanding of big IT that I simply don’t, thus he is much better placed to write about this than me!

Everyone knows that Learning Pool is all about collaboration, sharing and saving money.

Over the last three years it has also been all about growing a busy and successful business too.

While most of us at #teamlovely just want to meet customers, sell business and do interesting projects, someone has to make sure the lights stay on and that our growing team can continue to work efficiently, no matter where they were.

A few months ago I realised that at least some of this responsibility was mine. I was sitting in an airport (can’t remember which one) unable to connect to our exchange server.Frustrated, I called our tech team and asked them what was up. They fixed the immediate issue but reminded me that the server we were using was

  1. old;
  2. underspecified;
  3. overworked.

Some joviality along the lines of ‘it should see my diary and see what overworked really is!’ later, I received a quote to replace our internal systems with the latest that Microsoft and Dell had to offer.

The response left me running straight into the arms of Google!

We implemented Google Apps in around five weeks and are using the service for email and documents. In the next few weeks we’ll also be moving to Google Sites, from Sharepoint, having trialled this extensively and successfully.

While the project was pretty straightforward, there were a few things to consider that we would have thought should be just easy:

  • How do you set up a LAN without an expensive piece of Microsoft kit and associated licencing? – Google have no good ideas about this so we’ve gone with a standard Windows Server workgroup (much to the displeasure of @ianmoran!);
  • How do you deploy updates to each PC? – answer is that you don’t so you’re expecting all your users to be diligent about keeping their kit up to date;
  • What about all that historical data? – there are a number of solutions for getting archived email data into the Google cloud. We found a real restriction with our upload speed which made this process a pain we could have done without.

And so to Google Apps…

The Good

  • Excellent support. The guys at Google listened to what we wanted to achieve and then in a very matter of face way did it;
  • You can save money. The total cost of ownership of a Google based approach is much lower than a traditional solution. We’ve spent around £6,000 on hardware and licenses. The alternative was a £35,000 project. While we will need to pay an annual subscription to Google, having to pay out less cash has been very welcome;
  • Collaboration – Google docs just works. Several people can collaborate on a document across the net in real time;
  • Google works offline – we didn’t really expect it to, but it does!
  • No more Sharepoint – while I’m sure Sharepoint is a valuable and well built tool, it became the subject of intense hatred at Learning Pool over the last few years. I guess we didn’t invest enough in the initial set up and training. Although my experience is that Google Sites is far better in terms of its ability to enable collaboration.

The Bad

  • Google is a work in progress. I can pretty much guarantee that if you see something you don’t like, the answer from Google will be “we’re fixing that”. On the one hand that makes me feel better about the approach we take at Learning Pool – I have no doubt some of our customers feel the same frustration. At least we know they are working on it I guess;
  • Collaboration requires a Google account – I think this will be a seriously limiting factor in the long run, particularly as we work with organisations who are mainly public sector;
  • We still use Outlook – much and all as we would love to get rid of this, we’re reliant on Outlook for integration with our CRM – something we just can’t live without. No doubt though that Google mail works best in the browser;
  • Managing PCs on our ‘network’ is now pretty difficult – over time this could become a real overhead but we’re working on it as best we can for now;
  • Google Spreadsheets – in my opinion this just doesn’t work right now – the functionality isn’t rich enough and its routinely too slow to use and so there’s no way we can leave Excel behind just yet;
  • Google sites don’t really support hierarchy – this means that all your sites exist at the same level and you need to stitch it together with some html yourself;
  • Search on Google sites isn’t security trimmed. If a user searches all sites they’ll get documents returned that they don’t have permission to. We did have a bit of a chuckle at how Google have mucked up the search function – they are working on it of course (release due in a few weeks!)

On the whole then I’d recommend Google Apps as a way forward for providing groupware for a small to medium sized enterprise like Learning Pool. We like the idea of software as a service and five weeks into the project, most things work just as well as before and some things work a lot better indeed.

Nice work Google (and the Learning Pool and Konnexion teams too of course!). Kenny, our Head of Tech, has written two posts covering the operational side of the big switch over on the LP blog.

Load more posts!