Re: Convert file names to a usable list?

Is it possible under Windows XP / Vista to create a database or list from
the
names of files from within a directory and subdirectorys?

I want to make a list/database of quite a lot of mp3s so i can order and
print them in either access or excel.

The file structure I use is:

C:\...\Music\artist\artist - title.mp3

Many thanks
Gary

Open up a cmd prompt window.

use the cd command to get to the directory of interest.
You didn't give the full path so I can't spell it out for you.
To go from the Music directory to the artist directory
the command would be
cd artist

You can go one directory at a time or do it all with one
command. If the directory name has any spaces in it
you must enclose the string in double quotes.
i.e.
cd "Documents and Settings"

Once you get to the directory of interest the command

dir > list.txt

will create the list that you want.

Also try

dir /w > list.txt

to see if you prefer that format.



Thank you, its close to what i need but it doesnt include the subdirectory
of the artist that contains the actual mp3 file - ie. it only lists the
artists.

A typical full path is:

c:\documents and settings\gary\my documents\my music\aerosmith\aerosmith -
love in an elevator.mp3

So you see if I am in the "my music" directory the 'dir > list.txt' command
only lists the artists not the actual music titles. One other problem is that
there maybe cover art, or other file types in some of the directories - is it
possible to only list the .mp3 file types?

Many thanks again
Gary
.

Relevant Pages

  • Re: Convert file names to a usable list?
    ... I would like to make an Excel file that lists all my '.mp3' files. ... Dim FSO, Arg, oFol, oFils, oFil, TS, sList ... use the cd command to get to the directory of interest. ... artists. ...
    (microsoft.public.windowsxp.general)
  • Re: Convert file names to a usable list?
    ... Dim FSO, Arg, oFol, oFils, oFil, TS, sList ... use the cd command to get to the directory of interest. ... of the artist that contains the actual mp3 file - ie. it only lists the ... artists. ...
    (microsoft.public.windowsxp.general)
  • Media Center 2005 MP3 Music Catalog Trouble
    ... I have a large music collection, all MP3, and I don't understand how MCE ... MCE when I select My Music and then select Artists and pick "The Beatles" ... the "View Albums" doesn't list the Albums, it says "Select the View Songs ... fine and lists all the songs on the Album. ...
    (microsoft.public.windows.mediacenter)
  • Info on South Florida event - and opinions sought on a dumb question (long)
    ... Negotiating with artists. ... robin style with a few other performers (we are calling these "community ... thought to break it up into two lists... ... John T. Funnyguy ...
    (rec.music.makers.guitar.acoustic)
  • Re: [opensuse] how to know when the last time files have been accessed.
    ... On Sunday 23 September 2007 19:22, Arie Reynaldi Z wrote: ... I have samba file server that uses as file-sharing (mostly mp3). ... Note, too, that any command that reads a file (cp, less, file, zip, tar ... many others) will alter the access time. ...
    (SuSE)