PDA

View Full Version : Copying filenames into a table


cargosales
9th Jun 2009, 23:05
I'm sure this, or something like it has been asked recently but I can't find the relevant thread so apologies if this has already been covered.

It's about time I got round to sorting out all the zillions of photos and video clips I've got and to work out how to catalogue / tag them.

My smartarse other half is running Vista on her little used, leisure-use-only machine and has glibly pointed out how easy it is to tag all her photos, whereas I'm running XP on my almost-exclusively-for-business machine and have absolutely no intention of downgrading to Vista.

Does anyone know how I can copy all the filenames in any given folder and paste them as text in Word/Excel/Access, and thence add the tags I'd like to ? Ideally I'd like to include a thumbnail and/or a shortcut in the table as well but I guess that might be asking too much?

Any ideas please folks?

Thanks in advance

CS

GrumpyOldFart
9th Jun 2009, 23:37
I think this (http://www.karenware.com/powertools/ptdirprn.asp)will do what you want.

stagger
9th Jun 2009, 23:40
Something like Directory Lister will do it...

Print File List with Directory Lister Pro (http://www.krksoft.com/index.php)

Or just bring up a command prompt for the folder - use the DIR command to generate file list and manual copy it into excel (which should parse the columns).

srobarts
10th Jun 2009, 00:03
Or just bring up a command prompt for the folder - use the DIR command to generate file list and manual copy it into excel (which should parse the columns).
I guess I am showing my age as I started in PCs with Dos 1.1 and always go to DOS for a solution first...
There is a DOS command that will write the directory to a text file.
dir /b > directory.txt

this saves the cutting and pasting

This article Print a list of directory contents in Windows 2000 with DOS (http://articles.techrepublic.com.com/5100-10878_11-5035179.html) gives you more info and the switches you can use to alter the output.
Have fun

bnt
10th Jun 2009, 23:46
Dang - you beat me to dir <path> /b > directory.txt - though I would add /s if the directory has multiple subdirectories.

Saab Dastard
11th Jun 2009, 00:08
Copy your files to the Vista PC if it's so easy.

You'll even get a free backup thrown in for no extra effort! :ok:

SD