Export part of a database in a "tree like" style

[rockstar1707]

I have my collection sorted in a following way:

"Artist/Album/"tracks"'

I would like to print part of a database - content of a CD with Mp3's - in a "tree like" style. This means that the output would look something like expanded view in Windows Explorer. Something like this:

Code: Select all

CD Title (= Location)
  + Artist
     + Album
         |---- Track 1
         |---- Track 2
         |---- Track 3
         |---- etc.
     + Album
         |---- Track 1
         |---- Track 2
         |---- Track 3
         |---- etc.
  + Artist
     + Album
         |---- Track 1
         |---- Track 2
         |---- Track 3
         |---- etc.
     + Album
         |---- Track 1
         |---- Track 2
         |---- Track 3
         |---- etc.

Is there a way to do a script which would do something like this. Or maybe there's a program which would be able to produce that kind of output from XML or Excel file or something like that. The problem is that I have all those songs in a database, but not on a disc. So if I wanted to use some other program, I would have to load and print content for every single CD that I have, and I have quite few of them.

Thanks you very much for any kind of answer or information on this.

[nachtgieger]

Take a look at www.cdrlabel.com. I use an older version that prints only the filenames, the latest version is said to read also MP3 tags.

[rockstar1707]

Thank you for the answer.

I already have a program who can read CD and print the contenct in a "tree-like" style. I'm using some old program, called Cool Label. It does exactly what I want. However, it's not being developed anymore for 5 years now.

Now the problem is, that I would like to use this feature in connection with MediaMonkey, because I have my whole database here. And the program you mentioned can not read XML file which is exported from Media Monkey.

So, if someone has an idea how to solve this, I'd be really glad.

[Bex]

If you know how to use Access you can make a report there!

Let me know if you need any help.

[psyXonova]

If you know how to use Access you can make a report there!

Let me know if you need any help.

I would really like to see an easy way to make a tree-like report in Access...
I deal with access a lot and still haven't found an easy way to do it (while i know a couple of hard to do [lots of programming required])

[rockstar1707]

Well, actually I don't know a lot about Access, and I thought that I could learn it a bit

But if psyxonova says that this is not exactly "easy work", i'll try to find out some other solution.

Thanks anyway.

[Plethora]

what about making a .bat file with the following commands

echo off
C: [Drive where mp3's are stored]
cd mydocuments\mp3s [change directory to where files are stored]
tree /a > C:\Inetpub\wwwroot\alist.txt [Make a tree in a .txt to where you want the file to be stored]


Type these commands in a .txt and then changed the extension to .bat and you can just click on the icon and it will run the batch file.

you could use your CD drive as the source and make a list off of a CD.

looks like this

F:.
+---Artists
| +---10000 Maniacs
| | \---MTV Unplugged
| +---3 Doors Down
| | +---Away From The Sun
| | \---The Better Life
| +---311
| | +---Grassroots
| | +---Music
| | \---Transistor
| +---50 Cent
| | \---Get Rich Or Die Tryin
..... and so on

the forum font may squish the actual spaces between lines

hope this simple solution helps