Program to print music list?

[Kyle]

Is there such a thing that will print a catalog of your music
collection?

[MrC]

Sure, there are a number of different CD / digital music cataloging
software packages out there. OrangeCD, Helium 2006, MP3 Collector,
Music Label 2006 etc. They all create not only database catalogs, be
can also print or export to various formats such as HTML, XML, etc.

[ceejay]

Or see the helper program to go with this plugin...
http://forums.slimdevices.com/showthread.php?t=18418

It will apparently parse your slim database and print stuff out...

Ceejay

[jth]

Yes, DirectPlayBook.pl will print out your music collection from the
slimserver's point of view. It's pretty bare-bones but with a bit of
knowledge of SQL and the slimserver's database tables, you could
customize it to print whatever you want. It currently prints to plain
text, but I'm working on a PDF version. Here's an excerpt of what it
looks like:


Code:
--------------------
...
657 - Bob Marley - Legend
4441 - Is This Love
4442 - No Woman No Cry (Live)
4443 - Could You Be Loved
4444 - Three Little Birds
4445 - Buffalo Soldier
4446 - Get Up Stand Up
4447 - Stir It Up
4448 - Easy Skanking
4449 - One Love / People Get Ready
4450 - I Shot The Sheriff
4451 - Waiting In Vain
4452 - Redemption Song
4453 - Satisfy My Soul
4454 - Exodus
4455 - Jamming
4456 - Punky Reggae Party
295 - Boccherini - Quintet For Guitar & Strings In D Major, G. 448 "Fandango" / Savino / Artaria /
HCX 3957026
2691 - Pastorale
2692 - Allegro Maestoso
2693 - Grave Assai - Fandango
...
--------------------

[bruce]

How can I print a list of my library sorted by album artist -- the
primary artist on an album (which is already a tag, right?) -- and then
by album?

iTunes (which I use to manage my library) can sort by artist and then
album, but that results in compilations, soundtracks, etc. being listed
multiple times (because each song has a different artist) and therefore
dominating the list, even though I don't care about those artists.

DirectPlay seems to do the same.

Ideally I would actually like to sort first by genre, then by album
artist. But I can get around the genre problem by just printing
multiple lists.

Thanks for any help!

[joncourage]

The tagging utility I use can export all the files from a folder of your
choice on down, along with all the tags that you specify, to Excel or
HTML. From there it's just a matter of sorting and printing.

I'm using Tagscanner.

[bruce]

TagScanner 4.9 correctly found all my 5000 tracks, but has correctly
found just the length of each file. Almost all the files say "no
Artist" and "no Title". The only exceptions are the handful of files
whose tags I previously edited with another tag editor. Do you have any
idea what's wrong?

These are MP3 files ripped and automatically tagged with iTunes. The
tags show up fine in iTunes, SlimServer, etc.

I've emailed the TagScanner guy but I'm not counting on an answer, so I
figured I'd ask here. Thanks!

[snarlydwarf]

Post by bruce
TagScanner 4.9 correctly found all my 5000 tracks, but has correctly
found just the length of each file. Almost all the files say "no
Artist" and "no Title". The only exceptions are the handful of files
whose tags I previously edited with another tag editor. Do you have any
idea what's wrong?

Well, since I went through something similar last night (blaming
everything but what the real problem was): check permissions. That
sounds like what slimserver was doing to me last night before I
realized it was a BUOD error -- 'bad user on device'. It could get the
track names, but couldn't play some tracks or get the tags read in
right.

[street_samurai]

I hate to sidetrack this thread but it seems appropriate:

I've tried a few different music cataloging software and none of them
allow you to just catalog your albums alone (excluding tracks). Some
will export only the Album field but will do it for -every- track.

Basically I just want a listing of all my Albums by Artist with the
year field. I know this could be tricky for Various Artists albums but
it doesn't seem that difficult.

Anyone seen software that can do this?

ss.

[jth]

Basically I just want a listing of all my Albums by Artist with the year
field. I know this could be tricky for Various Artists albums but it
doesn't seem that difficult.
Anyone seen software that can do this?
ss.

Here's the approximate SQL you need to get this sort of listing:

select contributors.name, albums.title, albums.year from albums,
contributors where albums.contributor = contributors.id order by
contributors.name, albums.year;

If you can get my DirectPlayBook.pl script working, you can just remove
the existing SQL statements and replace them with this
one to get the listing that you are looking for.

[Skunk]

Post by street_samurai
Basically I just want a listing of all my Albums by Artist with the
year field. I know this could be tricky for Various Artists albums but
it doesn't seem that difficult.

I'm not sure about the year field, but to print a list of albums I've
gone to Browse Music Folder on the web interface, opened the frame with
the albums in a new window, and printed from there. If you named your
directories with years, it might solve your problem.

EDIT: sorry to be of no help, it just occured to me- most people
probably make directories by artist and it wouldn't format like mine
does.

[MrC]

Post by street_samurai
I've tried a few different music cataloging software and none of them
allow you to just catalog your albums alone (excluding tracks). Some
will export only the Album field but will do it for -every- track.
Basically I just want a listing of all my Albums by Artist with the
year field. I know this could be tricky for Various Artists albums but
it doesn't seem that difficult.
Anyone seen software that can do this?
ss.

As i mentioned in the second post of this thread, try OrangeCD. I use
it and it does exactly what you want.

[Jon]

What would be really cool would be a way to build a personal music
catalog (perhaps in PDF format), that includes not only artist and song
titles, but also a copy of the album cover ...

[MrC]

Post by Jon
What would be really cool would be a way to build a personal music
catalog (perhaps in PDF format), that includes not only artist and song
titles, but also a copy of the album cover ...

You mean something like the attached (unzip and view the PDF)?


+-------------------------------------------------------------------+
|Filename: music catalog.zip |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=895|
+-------------------------------------------------------------------+

[Jon]

Post by MrC
You mean something like the attached (unzip and view the PDF)?

Oh yeah ... I'm assuming you did that with OrangeCD? When I checked out
their web site, it seemed that you have to insert each CD for it to
catalog them. Does it have a means of using the information (tags and
album art, or WMA lossless files) that is already on my hard drive? I
am not keen on (re)inserting 800 CDs into my CDROM drive ...

[MrC]

Oh yeah ... just what I was looking for! I am assuming you used
OrangeCD to do this ... I looked at their web site and it was unclear
how this would work with WMA files already on my hard disk ... but I
downloaded and installed it, and it works great! I suspect that, in my
case, it used the folder and file names to get the required info, since
they don't claim to directly support WMA ... but however it did it, it
worked great!
Just curious, have you looked at a competitive product called CATraxx,
and if so how do they compare? they showed up on a google search for
OrangeCD ...
At any rate, thanks for the tip!

As you discovered, OrangeCD catalogs by format (CD, DVD, on-disk music
files, etc.). It can do any/all of reading existing music on-disk, and
catalog your CDs. It does support WMA. Be sure to try the newest beta
version - i've been using the daily builds and the new beta for a
while. The developer, while very slow and unresponsive, does solid
work.

I've looked at CATraxx, and a bunch of others. I didn't care for
CATraxx, but at least one other person in these Slim forums does like
it. I wrote up a little review of various programs on the OrangeCD
forums - seach for helium and you should find it.

If you don't have Adobe Acrobat to produce PDFs, download and install
the free, opensource PDFCreator.

[street_samurai]

Thanks all. I'll check out OrganeCD for sure, its the only cataloger I
didn't try from the first page.

I do keep my albums in Artist - Album [Year] directory names but I'd
ideally like everything in some kind of database readable format and
because of various inconsistencies in the name importing, a "dir /s >
albumlist.txt" type command into Excel doesn't import correctly.

Thanks for the help!

ss.

[street_samurai]

Just a quick update to this thread.

Orange CD doesn't support Flac... although I agree that it is a very
nicely designed program for sorting your MP3 collection.

Anyone else have any suggestions for a cataloging software that can
output: Artist - Album - Year to a database readable format...
preferably for windows and without a database query... and one that
knows what at Various Artists album is...?

I know... I'm sooo picky.

Thanks!

ss.

[Mark Lanctot]

I was using MPEG Audio Collection until recently:

http://mac.sourceforge.net/

Since I've uninstalled it, I can't remember
whether it provides a means of printing output,
but you may want to give it a try.

Post by bruce
TagScanner 4.9 correctly found all my 5000 tracks,

but has correctly

Post by bruce
found just the length of each file. Almost all the

files say "no

Post by bruce
Artist" and "no Title". The only exceptions are the

handful of files

Post by bruce
whose tags I previously edited with another tag

editor. Do you have any

Post by bruce
idea what's wrong?
These are MP3 files ripped and automatically tagged

with iTunes. The

Post by bruce
tags show up fine in iTunes, SlimServer, etc.
I've emailed the TagScanner guy but I'm not counting

on an answer, so I

Post by bruce
figured I'd ask here. Thanks!

--
___________________________________


Mark Lanctot
___________________________________






__________________________________________________________
Find your next car at http://autos.yahoo.ca