Arduino as USB -> TTL ?

Hi,

I have a Logitech Revue (a set-top box for TVs) whose mainboard has a UART chip (without a convenient plastic-housed connector). Apparently it is possible to connect this UART to a PC USB socket by soldering one end of an appropriately intelligent cable into a few holes on the mainboard...

The guide I am following says :

USB->TTL or similar board/setup (An Arduino in tristate mode works great)

Can anyone explain what this means? Arduino seem to produce many types of board... I'd hate to guess and get the wrong one. And what is "tristate mode"?

I have so far tried using this cable with the head cut off and the Tx, Rx, and Gnd wires attached to the Revue. This actually worked in that I was able to see console output spewing out, as expected, but unfortunately I couldn't send anything. The UART was transmitting ok but not receiving anything.

I would like to now try using "an Arduino", as the guide recommends. Can anyone tell me more specifically what to buy and what to do?

Very many thanks!