Automounting USB Device in Virtual Box

To automount a USB device in virtual box go to machine settings, ports, and add the device as a filter as per screenshot.

TVONDEMAND instructions for Ubuntu

Keep forgetting where to find this so posting here. This is what you need to do to get tvondemand to work (TVNZ)

Make sure you have the latest flashplayer then:

sudo add-apt-repository ppa:mjblenner/ppa-hal
sudo apt-get update && sudo apt-get install hal

After that you seem to have to restart the computer.

Unity - Adding Applications to Launcher if they don't get recognised automatically

When I installed Open Office Unity didn't 'see' it. I had to launch it using a terminal. To get it to show up when you search and so you can pin it to the launcher make a file with a .desktop extension as follows:

[Desktop Entry]
Version=1.0
Name=NAME OF APPLICATION
Comment=WHATEVER YOU WANT TO SAY ABOUT IT
Exec=PATH TO EXECUTABLE
Icon=PATH TO ICON
Terminal=false
Type=Application
Categories=Application;

Put the file in your home directory under .local/share/applications, It will then show  up when you search for it. If you want to add it to the launcher fire it up then right click on the icon on the launcher and 'Add to Favorites'

Quest Powershell
To find out what groups manage an Exchange mailbox and what permissions there are on a mailbox type the following in Quest Power Shell:

Get-QADUser |Get-QADPermission

Excel 'fun'

Handy code for conditional formating here: http://superuser.com/questions/484215/setting-background-colour-of-cells-based-on-their-string-length

Find duplicates in data using conditional formating:  http://spreadsheets.about.com/od/excelformatting/qt/090516_find_duplicates_in_Excel.htm

Gmail - Deleting lots of old email at once

Find the old email using the following the search  (for example):

in: inbox before: 2013/01/05

Then select all and delete

Redirecting when you change the index.html to an index.php (for example)

.htaccess files are more useful than I thought ... http://css-tricks.com/how-to-redirect-indexhtml-to-indexphp/