The Eee Pad Transformer – my romantic tragedy

As a happily married man, falling in love again is not generally thought to be a good thing.  However last night I did. Not only that, but my wife was not happy.  I had better explain…

We are going away soon to the US so that I can be best man at my best mates wedding. Elizabeth and Jet are coming too, and we thought that as we will spend  a lot of time in planes, and waiting around that being able to distract ourselves with a good film or two would be a good thing.

We looked around a bit (quite a bit actually) and it came down to a decision between getting an iPad2 and an Eee Pad Transformer.  We knew exactly what we would get with the iPad2, but the Transformer was a bit of an unknown.  After deliberation, we opted for the Transformer.  The reasons?  It is cheaper – significantly – something like £200 all in, the ability to read websites as they are meant to be (flash) and we read many many good reviews from very well respected websites.

Out of the box the Transformer is amazing. After a quick charge, and logging in with your Google account, it knows exactly who you are – not only that but your contacts are downloaded, your photos are there, and all docs.  The unit itself is slick, image amazing and clear.  The Honeycomb UI – no problems with it at all (I haven’t experienced yet any of the problems with 3.01 that others have).

So what nearly caused us to return the Transformer only hours after receiving it? The things we wanted to use it for (films specifically) are so blinkin difficult to get on it!  I spent hours last night looking for ways to transfer films on, and woke up early again this morning to do the same thing.

The problem isn’t the unit specifically, it isn’t even the OS that runs on it. It is with Google.  I can see why people crow about the iPad.  The simplicity of having a store where you can select a film, and download it is just what you need.  The time and angst trying to find the right file coding for Handbrake, working out how to transfer it on to an SD card (which is not as easy as it sounds) is very close to not being worth the hastle.  Google need to address this, and quickly.  There are companies such as Netflix and Amazon who in the US allow for file download. The closest we have in the UK is BlinkBox which just allows download to PC.  It is a conflict that goes to the heart of the Android ideology – freedom to use which app you like, when you like with little control from an equivalent App Store, with amazing multitasking  etc. etc, but when the main competition is Apple, that likes to hand hold you through every process you have a problem.  it is not good enough to be good enough, you need to be the best, and sorting out this problem soon is critical.

Luckily, I have managed to find the right package to sort out the films – it isn’t perfect at all, but I can live with it until Google get their act together. And  I can stay with the tablet I love 🙂

Grrr… How to create a Fusion Table

Earlier this week, I came across a Guardian article about where schools were on strike – it included a Google map that had each Local Authority highlighted to show what percentage of schools are on strike.  Now, I have made my own map in Google before, and carefully drawn around each territory to show where we have School Representatives, but it is painstaking, and definitely not as professional as the Guardian one.  It made me wonder how they managed to create it.  If you want to skip to the end, then here is what I made!

The answer was in Google Fusion Tables – and after a couple of minutes of tinkering, I was hooked.  The possibilities here are amazing. But also quite a bit of learning to do – and as with everything new, lots went wrong.  Here is how I managed to create my Fusion Table showing all of the different areas of the UK, and where Scholastic have school representatives:


Golden rule: don’t build your data table in the Fusion Table itself – it is a very long winded and convoluted way.  Either build it in Excel or Google Spreadsheets, as you can import them when you are finished.

Get yourself some location data.  Now it depends which type of map you want to show. If I had wanted to show points in the map, then a place name, or postcode would have done and I could have skipped happily onto the next step. But I wanted to show each area as a layer on top of the map.  This is a lot more complicated.

I did plenty of Google searching to find the right data.  In the end, I found some from Nearby.Org, which isn’t perfect, but I can refine over time. To draw polygons over the right data you need a string of coordinates that show the edge of the area you want to cover.  Now, most coordinates come looking like this:

54.91567645	-1.743341174
54.91925706	-1.724644054
54.91056256	-1.718651474

Unfortunately, the lovely way that Google works, you need to reverse these codes, so they end up looking more like this:


Once you have all of the location data (and in my case I have 164 different lines in my database, each with up to 4000 coordinates in) – you can start to build up your spreadsheet.  I wanted to show the Rep name, Area name, phone number, email, Area number (more on this later) and finally the location.  Here is an example of mine.

All of the columns are self-explanatory, apart from location.  In the location column, you need to put in the KML data for the areas you want to show.  This can be done with the following code:

<Polygon> <outerBoundaryIs><coordinates> -2.51998453948394,51.6881171980821
-2.51981095720608,51.6881179666459  </coordinates> </outerBoundaryIs> </Polygon>

Now to do this for all areas would be very time consuming, had it not been for the wonderful concatenate function in Excel.  By using this, it saved me hours of coding work.

Once you have this in your table, you can then import it into Fusion Tables, using the import function.


Once you have imported it, you can click on ‘visualise’ which allows you to show the data you have in your table as a map.  As long as you have included the KML data here, you should have no problems.

All of the areas are red to start with, and you then have to work out how to change each area.  If you click on Configure Map Styles, then on Polygons, fill colour, buckets, you can then set the colour to be what you want.  Now as I had numbered my areas, I was able to set the number of ‘buckets’ to 100, and then I could say that bucket 1, should be green, 2 blue etc. etc.

Once you have done this, you have pretty much finished, you can grab the embed code and put that into a website or blog post.  There is, however much more you can do. You can merge tables to compare and contrast different sorts of data.  The visualisations are much more than maps, you can do timelines, heat maps, charts, storylines…the list is longer, and the possibilities pretty much endless.

Have you used Fusion Tables before? What for, and how have you found them?  I can’t wait to get stuck into more complex, but funkier data!

Grrr… How to embed flash files into PowerPoint

Ever wanted to add a flash object into PowerPoint and couldn’t work out how?  It is possible, but hidden!  Here is the how-to!

Step 1

  • Go to ‘view’
  • Click ‘Toolbars’
  • Select ‘Control Toolbox’

Step 2

  • Click on the ‘More Controls’ icon
  • Select ‘Shockwave Flash Object’

Step 3

  • Draw yourself the box that you want the flash movie to run in
  • Right click, select ‘properties’

Step 4

  • Change ‘EmbedMovie’ from false to true
  • Change loop from ‘true’ to ‘false’
  • Copy file location from the properties (right click on file, select properties) and copy/paste it into this space.
  • When you’ve finished, close down the properties box, and then set the presentation to go.
  • It should work!

Grrr… How to centre your Blogger header

Here’s a quick step-by-step guide on how to centre your Blogger header.  For those of you who have a Blogger header, it is automatically justified left, without an option to centre or right align.  For this, I am using my (very) old Blogger site, which as you’ll see had the grand total of zero posts!

Step 1 – Before you do anything, download the full template in case you make an error and break your site. A couple of seconds work will save lots of tears!

Step 2 – log in to Blogger, and click on Design

Step 3 – Click on Edit HTML

Step 4 – Click into the HTML box, and search for ]]></b:skin>

Step 5 – copy this code, or take it from where I copied it from which is on the very good and paste it in above the html code you searched for. Code:

#header-inner img {margin: 0 auto !important;}
#header-inner {text-align:center !important;} /*include this line if you are using Template Designer*/

Step 6 – preview your changes first, and when you are happy with them, save your template, as you are done!

Grrr… Using Evernote as a Twitter archive

If you have ever used a hastag on Twitter, you know there are many different places that you can use to save these tweets, but not a lot of them are that reliable.  I have used two or three, and have been let down by them on more than one occasion.  Therefore I needed something that I knew would work, and something that I knew wouldn’t just disappear! Therefore I started to use  Evernote to save Tweets, favourited blog posts and more, automatically…this is how!

Step One – grab the RSS feed from twitter that you want, in this example, I have used my own:

Step 2 – go to a free service such as Feed My Inbox and register with your Evernote email address.  Once you have done that, you can set up the RSS feed to send an email into Evernote once per day which will save your tweets.

Step 3 – get more advanced.  The above will work with every RSS feed you want to use, but you only get five free feeds before you start to pay, so how do you get more content saved without paying more money? Simples…

Go to Cliqset and (for free) set yourself up with all of the myriad social network services that you can.  You can see from my profile, that I have Google Reader, Picasa, WordPress, Twitter, Delicious etc. set up so that every time I am active on those accounts, it turns it into a single RSS feed – which I can put into Feed My Inbox, which automatically archives all my activity online.

What does this look like in Evernote?

Evernote will save all the feeds by date – so you will get everything by the day that it was sent in, but it will separate out each type of feed that you send through, so I can have all of the Tweets in one file, whilst the blog posts that I have favourited in Google Reader appear in a different note.

The good thing about using Evernote as the archive, is that it is all saved on your machine, rather than using the Twitter archive, which at the moment is pretty flaky!

Grrr… Emailing receipts into Evernote

As many of you will know, I am in the process of moving house, so am getting lots and lots (and lots) of receipts every day for different things. Rather than keeping everything on email, I needed to keep a track on what we’re spending, so decided to use Evernote to gather those receipts. But how do you get them into Evernote?

The first step is really easy

Right at the top of the web-version of Evernote, click on Settings.

When you are in Settings – on the left-hand-side at the bottom you will see your own person email address for Evernote. It’ll look something like this:

Step 3 – I have saved that email address in my contacts as Evernote, and anything that comes in that you need to save, just forward it on.

Moving on a bit, you can be slightly more advanced in your emailing.  In the example we are talking about here, I was keeping all the receipts for the house-move in Evernote, and if you look back at Step 1, you will see that I have a folder set up for just that.  To make sure that the note that you send, ends up in that folder you need to add a couple of things to your subject line.

If you add an ‘@’ then the folder name you want it to be in, so in my example ‘@housemove’ it will go straight into that folder.  Then, if you add a hashtag, it will act as a searchable tag.

Grrr… How to store your iTunes library on DropBox

As many readers will know my wife, Jet, has a new job in September in a very small school in Oxfordshire.  As a result, she needs a laptop she can rely on – and that definitely is not the Asus we have at the moment.  The new laptop arrived on Tuesday, and I had it in my head that we would do something funky with the iTunes library.  Now I have to say that it was @stuartridout that put it in my head a few months back on Twitter when he said he was considering using DropBox to store his iTunes library so that the library was available on all devices.  So, that is what we started…here is a how-to, warts ‘n’ all.

1. Open up iTunes, go to > Edit click on > Advanced and ensure that the following check boxes are checked:

2. Next, come out of iTunes, and go to the folder that you hold your iTunes music in (most commonly in My Music) and copy the entire folder over to your DropBox account.  NOTE: ensure you don’t put it in ‘public’ as in theory it will be open for other people to see and use. If it is within your private section, you are fine.

Now here is where we suffer from having a large music collection (over 25gb) and a very slow upload speed (at times as low as 50kb/sec).  If you want to do this, and it is worth it, then ensure you have time!  I ensured that I had set the power options on the laptop to ‘never off’ when plugged into the mains so that it could run overnight.

3. At this stage, you have your iTunes library on your old PC DropBox folder, and online – you now need to download it onto the new PC.  It will then start to automatically synchronise files.  Please take note of the above point on speed – it will take some time especially on slow connections!

4. Now, you have your iTunes library on your old PC, your new PC and in my case I have it on my HTC Desire as I downloaded the DrobBox App.

5. So you have it in your DropBox folder on your new PC – how do you get it into iTunes? Well, simples…go to iTunes, File, Add Folder to Library

6. This bit is all done now – just a bit of housekeeping now – ensure you have de-authorised iTunes on your old PC. That is all, good luck!