Wooh, just got this working, using the pinout from sparkfun where they list the FTDI cable.
Green > Reset on arduino
Yellow > TX on arduino
Orange > RX on arduino
Red > 5V on arduino
Black > GND on arduino
Brown > GND on arduino
where the colours refer to the colours of the exposed cables on the FTDI cable.
It works, except I can't get auto-reset working. I've since disconnected the green wire, and am just pressing the reset button on the arduino, 2 seconds after i hit upload in the IDE, and it's working swimmingly 