PDA

View Full Version : Print out of CD list



jmschnur
2011-10-13, 12:39
With over 1000 CDs ripped via EAC to Flac, it now is the time to make a good print out.
I have the flac files on my computer and they are all found by slimserver 6.6.2 and LMS 7.7 RC 5.

How do I get the list of abllums into an excel spread sheet or other printable data base?

Joel

mike_knott
2011-10-13, 14:02
I just use the following from a command prompt after navigating to the music's source folder:

Dir /s /on >c:\dirlist.txt

The text file can then be edited in Excel, if required.

Mike...

dasmueller
2011-10-13, 14:26
Check this out. It really is pretty cool. There are 2 versions and its customizable. Believe it only currently works with SBS 7.5 versions. 2nd link is to discussion here in the forums.

http://acc.vanholt.nl/

http://forums.slimdevices.com/showthread.php?t=74452&highlight=album+catalog

jmschnur
2011-10-13, 15:11
This does look good. However I have 7.6.2. Would need to get 7.5.4 to use it or can we expect an update soon?

Stratmangler
2011-10-13, 15:49
You can download and install the free version of Media Monkey, let it scan your music folder, then export that data in a variety of formats.

Chris :)

jmschnur
2011-10-13, 16:08
I will try that. Have not likeed mm in the past. Would be nice if ACc would work with 7.6 etc

dasmueller
2011-10-13, 18:22
If you do not find something that works for you downgrading to 7.5.4 to use ACC and print out what you want and then upgrade to what you now have is a path you could take. A hassle I am sure just depends on how important this is to you and what features you want.

DK_Dennis
2011-10-14, 01:41
I, too, was looking for something to make a list of albums..

I tried van Holts' solution, but it "only" works on windows with IE, and "only" if the squeezebox server database is mysql.

There is no criticism involved here, I think van Holts' solution is pretty neat, so I'm merely stating facts..

I'm studying python and sqlite (free time project), and I've hacked together a small program that can extract the data and present it along with a down-scaled (thumbnail?) version of the album art.

Right now I'm struggling a bit with presenting data nicely in a .pdf file, as well as porting the application to other OS'es. (I'm on linux, and running SBS 7.6.1 - r33110)
Maybe I should let the output be HTML, and users could, themselves, convert to the "proper" format that they like the most?

Making a GUI for it will certainly present a challenge, I'm sure...

I'll make sure to inform in this thread, when I have something that could be worth your time.

If you're interested in this, could you please reveal what OS you are running squeezeboxserver on ?

Also: Any special wishes, other than being able to make a nice list of your albums?

Suggestions are welcomed, I don't hold a patent on getting good ideas :)

JonWill
2011-10-14, 01:46
I'd be interested in this - am currently running SBS on WHS 2011 (but that is effectively the same as 64Bit Windows 7).

And no special requests - I too only really want a list of albums and tracks - perhaps the ability to group them by artist/ album or perhaps genre might be useful... and I think I'd rather the output wasn't in pdf - I'd like to fiddle with formatting myself ...

Looking forward to having a go with it

Jon

enz01
2011-10-14, 02:20
If you use mp3tag (and, as an SB user, why wouldn't you), it provides this functionality by default and the resultant output can be heavily customised.

Formatting of the results is powerful but somewhat opaque. Luckily Florian maintains an archive of various user contributions, many of which are very neat. See http://forums.mp3tag.de/index.php?showtopic=1563 for more info.

Enjoy

DK_Dennis
2011-10-14, 02:35
Maybe I forgot to add:

Currently, it sorts artists, and gathers albums under each artist - albums are sorted after their Year, track sorting after track number.

I'd like it to also present the file format (flac, mp3, ogg, etc. and bitrate) along with the album data

Since I've used Picard for tagging, my tags do not include genres, but I certainly see the usefulness of that.
I'll see what I can do in this matter, but I worry a bit that not all tracks in an album would have the same genre tag, and hence, we wouldn't be listing whole albums.


Right now it also occurs to me, that I might have chosen perl instead of python - since perl will already be present, when SBS is.
This would probably also facilitate publishing the application as a plugin (or is that squeezebox app, now?)

I guess I'll skip the .pdf conversion, and simply aim at presenting a HTML report, for now.

fphredd
2011-10-14, 08:20
I, too, was looking for something to make a list of albums..

Also: Any special wishes, other than being able to make a nice list of your albums?

Suggestions are welcomed, I don't hold a patent on getting good ideas :)

I'd like to be able to output the list without thumbnails as most of my music has no album cover (live stuff)

Thanks!

dasmueller
2011-10-14, 08:50
I'd like to be able to output the list without thumbnails as most of my music has no album cover (live stuff)

Thanks!

ACC will do this w the quick reference catalog. I also have a lot of live music w no covers and chose this route. Keep in mind that this will still be a large document. My approx 2k album collection was 38 pages. The full catalog w artwork and track listings becomes ginormous.

Pascal Hibon
2011-10-14, 09:16
I just use the following from a command prompt after navigating to the music's source folder:

Dir /s /on >c:\dirlist.txt

The text file can then be edited in Excel, if required.

Mike...

+1 for this method.
This is the simplest way of accomplishing what you need. You can even do some additional formatting with some simple macros in excel.

jmschnur
2011-10-14, 09:37
I, too, was looking for something to make a list of albums..

I tried van Holts' solution, but it "only" works on windows with IE, and "only" if the squeezebox server database is mysql.

There is no criticism involved here, I think van Holts' solution is pretty neat, so I'm merely stating facts..

I'm studying python and sqlite (free time project), and I've hacked together a small program that can extract the data and present it along with a down-scaled (thumbnail?) version of the album art.

Right now I'm struggling a bit with presenting data nicely in a .pdf file, as well as porting the application to other OS'es. (I'm on linux, and running SBS 7.6.1 - r33110)
Maybe I should let the output be HTML, and users could, themselves, convert to the "proper" format that they like the most?

Making a GUI for it will certainly present a challenge, I'm sure...

I'll make sure to inform in this thread, when I have something that could be worth your time.

If you're interested in this, could you please reveal what OS you are running squeezeboxserver on ?

Also: Any special wishes, other than being able to make a nice list of your albums?

Suggestions are welcomed, I don't hold a patent on getting good ideas :)

Very interesting.

I use W7 64 bit -


Currently 7.7 is on my WHS 2011 server. I also have 7.6.2 on my W7 ultimate 64 bit machine but it is not running. 7.7 exe seems fine on the WHS-2011 server. I have a copy of my flac files in both machines.

List searchable by artist, composer, date etc and then printed to pdf wojuld be very nice so one cold have several different pdfs.

e.g.


Davis, Miles (list of CDs)
Verdi (list of CDs)

or Krall (list of CDs)

etc

Joel

jmschnur
2011-10-14, 09:40
Maybe I forgot to add:

Currently, it sorts artists, and gathers albums under each artist - albums are sorted after their Year, track sorting after track number.

I'd like it to also present the file format (flac, mp3, ogg, etc. and bitrate) along with the album data

Since I've used Picard for tagging, my tags do not include genres, but I certainly see the usefulness of that.
I'll see what I can do in this matter, but I worry a bit that not all tracks in an album would have the same genre tag, and hence, we wouldn't be listing whole albums.


Right now it also occurs to me, that I might have chosen perl instead of python - since perl will already be present, when SBS is.
This would probably also facilitate publishing the application as a plugin (or is that squeezebox app, now?)

I guess I'll skip the .pdf conversion, and simply aim at presenting a HTML report, for now.

please let me know when you want someone to try it out.

joel

lrossouw
2011-10-18, 08:54
If you simply want lists and you know SQL you can download an SQLite viewer tool and extract the data pretty easily. You need to stop the server first as it won't allow the viewer tools to access the database while the server is running.

DK_Dennis
2011-10-26, 07:50
This just to "keep up the hope".. it still might take a while.

I've jumped aboard the graphics programming - not easy, but still seems doable, within a reasonable time horisont.

For my own, private, reasons I want the program to function and look the same, on Windows, OSX and linux. That will probably make it last a little longer, but that's what I want..
(Actually, I'm trying to build skills for another project)

Screenshots are too large to attach here, so I've uploaded some at imageshack.
Right now it looks like this, on linux and Windows, respectively.

Please let me know what you think:
http://imageshack.us/photo/my-images/337/linux1.png
http://imageshack.us/photo/my-images/840/linux2.png
http://imageshack.us/photo/my-images/412/winim.png


"Templates", or sketches for HTML output, as well as other ideas are still much welcomed :)

bobertuk
2011-10-26, 09:01
This just to "keep up the hope".. it still might take a while.

I've jumped aboard the graphics programming - not easy, but still seems doable, within a reasonable time horisont.

For my own, private, reasons I want the program to function and look the same, on Windows, OSX and linux. That will probably make it last a little longer, but that's what I want..
(Actually, I'm trying to build skills for another project)

Screenshots are too large to attach here, so I've uploaded some at imageshack.
Right now it looks like this, on linux and Windows, respectively.

Please let me know what you think:
http://imageshack.us/photo/my-images/337/linux1.png
http://imageshack.us/photo/my-images/840/linux2.png
http://imageshack.us/photo/my-images/412/winim.png


"Templates", or sketches for HTML output, as well as other ideas are still much welcomed :)

The images look good to me - great work. I have a couple of questions...

I run SbS/LMS on a Linux based NAS but use a MacBook Pro (running OSX Lion) as a portal into the NAS.

1. Will your GUI allow access to a database on another computer/server/NAS?

2. Are you intending to make a GUI for Mac as well as for Linux and Windows?

It would be a really good cataloging solution for us Mac users.

Bob

DK_Dennis
2011-10-26, 09:41
Yes, the final program will work on Macs as well..

The first version(s) will make a copy of your database (for more than one reason), so if the file library.db is visible from any device (windows, linux, OSX) attached to the NAS, of if you can download a copy of the database, it should work - well, albumart won't, as I would need file access to that as well.

Hmm.. maybe I should work out a path substitution of sorts for all the folks running Squeezebox server on a NAS..

I'm interested to find out, if there could be made som sort of one-fits-all solution - also for users of older versions of Squeezebox/Slimserver (running mySQL).

I wondered about scraping the squeezebox webservice, but I think it will be too hard - and far too easily broken after updating SBS and so...


Thanks for feedback :)

bobertuk
2011-10-26, 09:49
Yes, the final program will work on Macs as well..

The first version(s) will make a copy of your database (for more than one reason), so if the file library.db is visible from any device (windows, linux, OSX) attached to the NAS, of if you can download a copy of the database, it should work - well, albumart won't, as I would need file access to that as well.

Hmm.. maybe I should work out a path substitution of sorts for all the folks running Squeezebox server on a NAS..

I'm interested to find out, if there could be made som sort of one-fits-all solution - also for users of older versions of Squeezebox/Slimserver (running mySQL).

I wondered about scraping the squeezebox webservice, but I think it will be too hard - and far too easily broken after updating SBS and so...


Thanks for feedback :)

Wonderful :)

Having artwork available would be nice as well.

Bob

HeadBanger
2011-10-27, 01:29
@ DK_Dennis. Good stuff this is somesting I'd definitely use. Please keep us all posted on your progress!

DK_Dennis
2011-11-06, 06:00
Just this morning, I've found another way of doing things; a way, where it will work on any platform - and on all versions of squeezeboxserver - also when it's running on a NAS.

This new approach will also make some other things possible, that I've been wanting to do for a while. More on this later...

So it's kind of back to square one, though I can probably re-use a lot of GUI programming.

DK_Dennis
2012-01-08, 10:17
The project is still chucking along, though I've had a few setbacks.

Among them:
- I've had to change to another GUI toolkit completely. (Square one again!) Some things were simply not possible (- at least with my still rather limited set of skills).
- an internal modelling structure in the new GUI toolkit was obviously far too slow. I've created a new model that performs a lot better :)
- I've, just now, encountered what seems to be a bug in the LMS server's JSON interface. I can work around this to some extent, so tracks and albums can be catalogged as expected, but sorting tracks is still quite troublesome. (Bugreport filed on http://bugs.slimdevices.com)

Also, I've added options for catalogging a connected player's playlist, as well as saved playlists.

I'm still contemplating a plethora of design ideas for the output (and so also learning a lot more HTML/CSS).
It's still not too late, if anyone should have a design idea or two for the output - feel free to contact me.

And now - on with the coding...

maximus
2012-06-12, 04:11
Any news?

DK_Dennis
2012-06-23, 02:58
No "real" news, I'm afraid.

Mostly due to improved coding skills (I'm learning lots about a plethora of issues/challenges), I need to change some things, in order for it to be more readily maintainable. This goes for both the internal workings, as well as some output routines.

In effect, this is another total overhaul of the code, which has recently been postponed, due to "real life" issues like paying customers, family stuff and so...

At the moment, I can produce CSV files and a single HTML "look".
I would, however, like to implement a "standards" HTML output, where the user is able to choose among various templates, or simply extend the output with their own CSS template.

I've also found a way to directly produce MS Excel files, and am contemplating whether to include this as a function or not (the idea isn't bad, it's just that the final program will be cross-platform, not only running on Windows).

I'm also still struggling a bit with some internal functions, like letting user right-click on a tree item, and catalog from there, etc..


So, no real news, at the moment, but the project isn't dead.

jmschnur
2012-06-23, 03:19
Very interested in this. Glad you are still working on it.


J

docPhil
2012-06-27, 05:28
I posted a few weeks ago onto a different thread. I'm only producing an rtf document at the moment of my albums+songs but Word can open this. Instead of talking directly to the database, I got the album list from the server using JSON. This way it's safer, and I can run it on a different machine to the server. It runs on windows or a mac using mono. (I assume it would also work on linux with mono).


http://forums.slimdevices.com/showthread.php?93927-How-to-extract-an-Album-and-Artist-list&p=705750&viewfull=1#post705750