Monday, 18 March 2013

Toyota Wiper Refill

I couldn't find anywhere with quite the right information on it to help me change the rubber bit of my wiper blades (apparently called refills or sometimes inserts).  So here's my instructions, for my Toyota Corolla Verso 2005 UK.

This video is pretty good, but you can't see the key stages clearly.
http://www.youtube.com/watch?v=R8Ijmsg2sKs

0. Get new blades
I got them from my dealer or local Toyota specialist.  The two front ones cost me about £16.  To me the real Toyota ones aren't much more expensive than generic ones and look like they will be much better.

0.5 Get an old rag

1. Remove the wiper blades.
These are the whole assembly including the rubber bit and the bits that it connects to.  The wiper blade connects to the wiper arm.  The arm hooks around part of the blade assembly.  There is a little bit of plastic on this part of assembly.  When you push it towards the wiper arm, you can push the blade assembly down towards the car and the whole assembly becomes free.

Now get your old rag out and place it carefully under the bare wiper arm, and place is carefully against the windscreen.  This avoids either scratching the windscreen when it is placed carefully against it, or smashing it when the spring loaded arm is brushed against and fires itself at the windscreen!

1.5 Look at the existing assembly.
Note: 
A: where the metal bits fit into the insert (That's the rubber bit.)
B: Which end of the rubber insert is fixed (One end of the rubber is fixed and held in place and the other end moves in an out of the blade assembly as you flex the rubber.)

2. Remove the old Insert
Starting at the fixed end, you need to pull the rubber out of the metal bit of the wiper assembly that's holding it in place.  You might damage the old rubber insert to do this, but you should not need to damage or bend the wiper assembly.

There are two metal rods holding the insert into place.  At the very end of the insert near the fixing point, pull the rubber insert through these metal rods away from the assembly. [The pull direction is critical here.  If the wiper was still fixed to the car you would be pulling the rubber through the windscreen into the car.]  Keep pulling the first inch or so through until the bit of the insert that is held fixed into place by the assembly is free.  You should now be able to slide the whole of the insert out.

3. Put the old metal rods into the new insert

4. Push the new insert into the wiper assembly
Work out which end of the new insert should be the fixed end.  Push the unfixed end of the rubber insert into the fixed end of the wiper assembly, then thread the whole length of the insert into the wiper assembly.  The fixed end of the insert is angled so when you push hard when the whole insert is threaded, the fixed end becomes fixed (the metal holds the insert and won't release it.)

Good luck!

Monday, 4 March 2013

PS3 Superslim 12G to 500G upgrade

I bought a 12G PS3 Superslim because it is cheap, but I wanted to upgrade it to a 500G PS3 because that's loads of space for lots of games.  On Amazon the 12G version is currently £149, but the 500G version is £229.  That's £80 for an HDD.

So here's what I used to do the upgrade: 
1 OFF Sony PlayStation 3 Replacement Hard Disk Drive (HDD) Mounting Bracket (£8.10 Amazon)
1 OFF 500GB SATA 2.5" 5400rpm 8MB cache HDD (£43.00 Amazon)

That's a saving of nearly £30.

I used the official HDD mounting because I don't want my new PS3 to be klunky.  I bought a Seagate Momentus HDD because it said on the Amazon web page it was PS3 compatible and it is.

The mounting comes with instructions on how to open the HDD drive slot and fit the new HDD and even comes with the screws.  

This video show you how to open the PS3.

But this video is the same guy's video with him successfully installing the HDD.  (It just doesn't show him opening it so well.

Good luck!

Tuesday, 15 January 2013

LibreOffice Mail Merge Printing

This is how to print a document which has had the mail merge fields put into it and already had the database created from a spreadsheet.  I'll document that part someday, but this is what I did today.

I did it on LibreOffice, but I'm guessing it also applies to old OpenOffice too.

I got all this stuff from this 10 minute video, but sometimes you can't wait 10 minutes!
http://www.youtube.com/watch?v=prZJ4w-q9AA

  1. Open document you've already put the database fields into.
  2. Print to a file:
    File/Print - pop up should appear "Your document contains address database fields.  Do you want to print a form letter?" You do so press 'Yes'
    *Possible Warning Popup see Check Connection Settings Below*
    Output/File (not the printer default) / Save as single document / OK
  3. Save as Type 'pdf'/ enter filename / save
  4. You now have a PDF that you can print.
Job done.

Check Connection Settings

But what if you had a popup with the option to 'Check Connection Settings' with the text:
"The data source "PresentsDB" was not found. Thus the connection to the data source could not be established.  Please check the connection settings"

This means that LibreOffice does not know where to get the data from.  So you need to register the database on this machine.  To do this:
  1. Press the 'Check Connection Settings' button on the popup.
  2. Register the database:
    New... / Browse to your .odb file /open
    The registered name should appear, hit OK
    The db should now be registered, hit OK.
  3. Now try printing again :-)

Tuesday, 1 January 2013

My Book World Edition File Copy

If you want to copy or move some files on a Western Digital My Book World edition NAS (network attached storage), then you could copy and paste from your PC, but this takes forever if there is much data since all of the files have to come over the network to the PC and then come back.

However, I've successfully used the "Copy Manager" to do this.  This function is supposed to be used for copying from the NAS to an external USB storage device, but you can get it to copy within the My Book itself.

You access the 'Copy Manager' in a similar way to when you logging into the 'Network Storage Manager'.  I.e. through a web browser pointing to your device.  You might have to put something like http://192.168.10.24 into your browser.  You will then get to the login screen which will allow you to select the 'Administrator Name', 'Password', 'Tool' and 'Language'.  Change tool from 'Network Storage Manager' to 'Copy Manager' to get into the tool.

When there:

  1. select the destination address in the source window
  2. do not press 'next' button.  The destination address appears in the box in the bottom.  
  3. Copy the destination by selecting it and ctrl-c ing it (or just remember what it says)
  4. Now select the source address in the source window.
  5. This time press the 'next' button.
  6. The copy manager now prevents you from selecting the NAS for the destination, expecting only a USB destination.
  7. Now paste (or type) the destination address from stage 3 into the box.
  8. Press 'next'
  9. Press 'start'
Bingo

Tuesday, 22 November 2011

Parental Control on Sony Bravia TV

To change the parental lock on my Sony Bravia TV you need to know/setup a PIN.  Then to access parental control do this:
  1. Home Button
  2. Settings
  3. System Settings
  4. Parental Lock
  5. PIN
  6. Parental Rating
This menu system is called the XMB or XrossMediaBar.

Enabling Lovefilm on Bravia TV

This seems really complicated.
  1. Get a lovefilm account that includes streaming of films.
  2. Setup a 'Sony Essentials' account online here: https://internet.sony.tv . You'll need to register your Bravia TV, giving the registration code (the 'where is this' link explains how to get this code from your TV).
  3. Within Sony Essentials, Navigate to 'Personalised Services', and link to Lovefilm.  This should take you to your lovefilm account (on your PC) where you need to confirm you want to link to that account.
To change the account linked to the TV, you need to access the Sony Essentials account, then unlink Lovefilm, then link to Lovefilm using the new account


Tuesday, 21 June 2011

Celebrating the Solstice at Stonehenge on the Wrong Day

Why is everyone celebrating the Summer Solstice at Stonehenge on the wrong day?

Today is Tuesday 21st June 2011. According to Wikipedia, the summer solstice occured today at 17:16 UTC. That's basically 17:16 GMT which is 18:16 BST, the time currently used at Stonehenge.

Why do people go to Stonehenge to celebrate the summer solstice? Well, they go there to see the sun rise at its most northerly position of the year. And here's the thing: sunrise tomorrow morning at 04:43 BST (according to this website) is 10 hours 27 minutes after the astronomical time of the solstice, which is actually closer to the solstice than today's sunrise which also occured at 04:43 some 13 hours 33 minutes before the exact time of the solstice. That means that the sun will rise tomorrow slightly further north tomorrow than it did today! Then on Thursday it will start to recede.

So who decides which day to celebrate? I'm going to find out ...