Hi All,

Since I bought my Squeezebox I have greatly expanded my music
collection which is good. The bad thing is that when I want to play
something I can't possibly remember my whole collection. I think that
sounds pretty familiar to many of you?

In search of a tool able to print the collection in nice format to
paper I got stuck; there isn't such a tool.

Therefore I have created a script to do exactly that and maybe someone
can use it to so I decided to post it here.

The script is called AlbumCatalogCreator. I have attached some images
from the GUI and the output files. There are a few options to change
the layout. The help file further explains most of the questions (I
hope).

How does it work:
- It connects directly to SlimServer database using default credentials
used at installation. It then queries the database and generates the
output.

Some things to know:
- The mySQL ODCB driver is required to be able connect to the
SlimServer database. It can be downloaded here: 
http://dev.mysql.com/downloads/connector/odbc/3.51.html
- It looks for album cover files named either cover.jpg or folder.jpg
which must reside in the actual album directory.
- It assumes there is a dedicated folder for compilation albums because
the SlimServer internal compilation detection doesn't work very well (I
am forcing myself to put it nicely)
- It automatically inserts page breaks (only for printing purposes).
Since browser print margins can only be set using the browser, you may
need to narrow the default margings. You can also change the header and
footer so the ugly URL isn't printed put page number are instead (see
help screen in application for more info)

Well, I hope you can use it at your advantage.

I consider it a Beta version because it works for me but hasn't been
tested by anyone else yet.

Since its a VBScript, you can change it yourself but I would greatly
appreciate if you use this threads in case of bugs or ideas for me to
work on so other users can use it too.

The script can be downloaded from:
http://www.vanholt.nl/uploads/AlbumCatalogCreator.zip

Start the script by double clicking the AlbumCatalogCreator-V1.hta
file.

For those interested; have fun and happy new year in advance.

Frank


+-------------------------------------------------------------------+
|Filename: catalog-short-sample.jpg                                 |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=3939|
+-------------------------------------------------------------------+

-- 
SilverRS8
------------------------------------------------------------------------
SilverRS8's Profile: http://forums.slimdevices.com/member.php?userid=12818
View this thread: http://forums.slimdevices.com/showthread.php?t=41597

_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss

Reply via email to