Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Looking for a folder/filename exporting


  • Please log in to reply

#1
taggs

taggs

    Member

  • Member
  • PipPip
  • 22 posts
Hi there,
I want to list all my music files in a database and/or spreadsheet. All of the files and folders are in one main mp3 folder. Does anyone know of a way that I can extract the files to list in an application such as Access or Excel?

For example

I have, say, a file structure like: MP3 (FOLDER) --> ARTIST NAME (FOLDER) --> ALBUM NAME (FOLDER) --> SONG TITLE (FILENAME)

The application would extract these files into a database or table like:

ARTIST NAME.......... ALBUM NAME............SONG TITLE
Billy Ray Cyrus.........Achy Breaky Heart....Achy Breaky Heart*
Britney Spears.........In The Zone ........... Toxic*

etc etc etc

There's maybe a really simple way to do this through Windows XP, but anyway, all suggestions appreciated

* Note: Songs listed are for illustration purposes only. They are not, nor should ever inferred to be, in the music collection (mp3 or otherwise) of the author of this post.
  • 0

Advertisements


#2
starjax

starjax

    Global Moderator

  • Global Moderator
  • 6,591 posts
did some searching and came up with this: http://www.softpedia...t-Creator.shtml
  • 0

#3
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
http://www.freedownl...ee_Printer.html
this one won't do what you want DIRECTLY...but with a little tweaking it will allow you to grab what you want out of it....it will create a text file that has the file trees listed...

if you change the "output settings" to tree view instead of list view... you get something like this:

C:\<foldername>\
|
|___<Subfoldername>
|
|___<FileList>

so in your case it would be like

C:\<music>\
|
|___<Billy Rae Cyrus>
|
|___<Achey Breaky Heart(album)>
|
|___<Achey Breaky Heart(Song)>
<Whatever other songs this loser sang that no one listened to>



and it would do that for each folder that's within the main <music> folder...
you could then copy each section to the proper column in a exell file

though this might get hairy...i'll keep looking hehe
  • 0

#4
taggs

taggs

    Member

  • Topic Starter
  • Member
  • PipPip
  • 22 posts
Sorry it's taken so long to reply, been rather busy. Two good suggestions - I will try them both and let you know how it goes.

<Edit> --------------

Just discovred Directory Lister at http://home.autocom....e/index_en.html

I'll try this. It doesn't do exactly what I want but I'll give it a try.

Thanks again.

Cheers.

Edited by taggs, 28 June 2007 - 05:55 PM.

  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP