Keepass Auto-Type Examples

I’ve been using Keepass to store my passwords for years but it was only this year that I realised (yes, how could I not know?!) that the Auto-Type functionality can be customised to handle obscure login forms. Below are a list of some of the Auto-Types that I’ve created to handle a selection of sites I visit. Hopefully they will come in useful for someone else 🙂

EE

{USERNAME}{TAB}{TAB}{PASSWORD}{ENTER}

Nationwide
This only works from when you’ve entered your memorable word. Unfortunately the fields aren’t visible until that memorable word is entered.

Under the Advanced tab, enter a new String field with the key “PASSNUMBER” and the value of your pass, e.g. “123456”

{TAB}{TAB}{PICKCHARS:PASSNUMBER:ID=1, C=1}{TAB}{PICKCHARS:PASSNUMBER:ID=2, C=1}{TAB}{PICKCHARS:PASSNUMBER:ID=3, C=1}{TAB}{TAB}{TAB}{TAB}{TAB}{SPACE}

NS&I
Under the Advanced tab, enter a new String field with the key “SURNAME” and the value of your pass, e.g. “Bloggs”

{USERNAME}{TAB}{TAB}{TAB}{S:SURNAME}{TAB}{TAB}{PASSWORD}{ENTER}

Natwest (NWOLB)
This only works from the Step 2 page (after you’ve entered your Customer Number and clicked Continue. If you’re not on a shared PC you can optionally decide to get it to remember your Customer Number and therefore the first page you’ll land on is the Step 2 page).

Under the Advanced tab, enter a new String field with the key “PIN” and the value of your pass, e.g. “1234”

{PICKCHARS:PIN:c=3}{PICKCHARS:Password:c=3}{ENTER}

Sainsbury’s Bank
This only works from the Step 2 page (after you’ve entered your Username and clicked Continue. If you’re not on a shared PC you can optionally decide to get it to remember your Username

Under the Advanced tab, enter a new String field with the key “PIN” and the value of your pass, e.g. “123456”

{PASSWORD}{TAB}{TAB}{PICKCHARS:PIN:ID=1, C=1}{TAB}{PICKCHARS:PIN:ID=2, C=1}{TAB}{PICKCHARS:PIN:ID=3, C=1}{TAB}{TAB}{ENTER}

Scottish Widows
This has only been tested on the Personal Pensions page – https://personal.secure.scottishwidows.co.uk/login/

{USERNAME}{TAB}{TAB}{PASSWORD}{ENTER}

Price I’ve paid for petrol since mid 2008

I’ve kept track of the price I’ve paid for petrol since mid 2008. I started collecting the data when I noticed the price of petrol had risen a fair bit from when I got my first car. Here’s the full spreadsheet for the anyone who wants to look at the details, but some key facts:

  • I’ve spent over £17,610 on fuel since the 21st May 2008!
  • That’s over 14500 litres of fuel
  • The highest price I’ve paid is 140.9 pence (ouch!)
  • The lowest price I’ve paid, 85.9 pence
  • And one time I managed to fill my car with 52.63 litres of petrol (and I thought it had a 50 litre tank until then!)

(For the eagle eyed – there appears to be an anomaly on the 6th May 2012, but other than that, all the other points are correct)

Dart Charge Number Plate Lookup

My mum used the Dartford crossing back in August 2015 and paid the charge prior to her crossing.  At the time she paid the charge, the online form didn’t have the recently added “Find vehicle” button, so she entered what she thought was her number plate, but made one small character mistake.

Roll on December 2015 and she received a penalty notice!  Rather flustered about having to pay a fine charge on top of the payment she’d already made, I phoned the number and found out that since it was the first offence, you could simply pay the “missed” payment amount.

What was wrong with the online form at the time was that there wasn’t an option to check that the number plate you’d entered was valid.  A rather simple addition… but it must have made the govenment quite a bit of money in fines!

It’s good to see this has now been changed and there’s a “Find vehicle” button which searches for the vehicle description.

What it does show though is that if there’s an API available to display more information about user entered data – in this case DVLA lookup – consider providing this as a feature to your users to prevent mistakes.