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

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: Export part of a database in a "tree like" style

by Plethora » Tue Jul 26, 2005 4:39 pm

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

by rockstar1707 » Sat Jul 23, 2005 9:36 am

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.

by psyXonova » Tue Jul 19, 2005 7:41 am

Bex wrote: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])

by Bex » Sat Jul 16, 2005 11:25 am

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

Let me know if you need any help.

by rockstar1707 » Sat Jul 16, 2005 10:22 am

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.

print cd label

by nachtgieger » Thu Jul 14, 2005 2:36 am

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.

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

by rockstar1707 » Tue Jul 12, 2005 8:11 am

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.

Top