PDA

View Full Version : Announce: Album Catalog Creator v1.4 (ACC)



SilverRS8
2009-07-22, 11:52
This is actually not a plug-in but more of an add-on. It generates a HTML catalog of your music catalog stored in SqueezeCenter (see image below). This catalog can be used for print purposes or just as offline (distributable) catalog.

Most important changes for this version:
- Support for Album Artist (just like the TPE2 feature in SC)
- Support for multiple discs (see image below for an example)
- When an artist has multiple discs, this is indicated in tracklisting
- In the header 'n Disc/CD set' is added to the album name
- Display track duration option
- Help balloons in the GUI

To download go to:
http://acc.vanholt.nl

Any comment or issues? Please reply to this thread or drop a mail.

gandt
2009-07-23, 00:56
Ok got this to the point that it sees the database which is on \\hpserver\music which i have tried entering in both that form and as a mapped drive. In both cases it does the same thing - it finds a single album (Procol Harums "Home" which is not the first of last folder i added!) and nothing else

any advice cos the single entry looks great - I just have 27,000 more!


graham

SilverRS8
2009-07-23, 01:22
Ok got this to the point that it sees the database which is on \\hpserver\music which i have tried entering in both that form and as a mapped drive. In both cases it does the same thing - it finds a single album (Procol Harums "Home" which is not the first of last folder i added!) and nothing else

any advice cos the single entry looks great - I just have 27,000 more!


graham

The global steps to get a remote server working are:
Pre-req:
- Allow MySql remote access (refer to remote server screen in ACC)
- Install MySQL ODBC driver
- Map a drive from the machine you run ACC from to the music share (or select the option 'Use album cover stored in SqueezeCenter instead of physical file'

Configure ACC:
- Enter IP number of the remote server
- Enter the correct 'Full remote physical path to music share'. Errors here only cause album art not to appear but does not effect the display of all albums and tracks in the database.
- Enter a starting folder to limit the scope. Without starting folder, the complete database is processed. I my self have a large number of single (not album related) tracks and a folder will all full albums hence my starting folder is the full album folder.

I would advise though to test the initial settings to select a folder with a few albums.

Send me the acc.log file and I'll see if I can help. ACC has been tested on a 35000 track library.

gandt
2009-07-23, 03:04
Ive done all your pre reqs so ive attached the log

hope it helps

browellm
2009-07-23, 03:44
Does this support 64bit Vista yet?

tamanaco
2009-07-23, 04:29
I'm now running SC 7.4 SQLite builds, will this new version work from the server if I enter the drive\path to the folder\files of the library in the ACC settings? Any plans to support SQLite?

SilverRS8
2009-07-23, 11:11
Ive done all your pre reqs so ive attached the log

hope it helps

The problem is in the remote path you entered. You used an UNC notation. You should use a physical path reference. If you press the test button a record from the database is displayed. The first part of this path reference is the path you must enter (Only the part that essentially matches the folder you shared).

For me to give you the right path I need to know:
- Is the remote server a Windows server of Linux?
- What path is reported when pressing the test button?
- What folder did you share so that is is accessible from the machine you run ACC from?

Also note that the help in the remote option screen as well as the help balloons describe quiet well what to do.

SilverRS8
2009-07-23, 11:13
Does this support 64bit Vista yet?

It hasn't been tested on Vista 64 yet (as I don't have this platform). Earlier test from users revealed that it did not work due to the ODBC driver.

As a workaround you could run a Windows 32bit Virtual Machine.

SilverRS8
2009-07-23, 11:15
I'm now running SC 7.4 SQLite builds, will this new version work from the server if I enter the drive\path to the folder\files of the library in the ACC settings? Any plans to support SQLite?

*EDIT*
SQLite does not support remote access so this will not be supported but if I understand correctly there will be a choice to use MySQL over SQLite. In that case I will support ACC for future SC versions but only if the DB is MySql based.

rperkin
2009-07-24, 04:08
I have found ACC to be one of the most useful tools for use with SC.

As a relative newcomer to the world of Squeezebox, I (like I guess all of us here!) suffered the pain of ripping and tagging my music. ACC not only documents my collection, but is also less forgiving than SC. I believe that's a good thing, because it can expose errors in tagging which otherwise go unnoticed as we sit back and listen to the music :).

As for the other points here:
- ACC works on my 23,000+ track collection
- I have used it against a local database, a remote database on a Linux-based QNAP NAS, and a remote database under WinXP, all without problem

The output looks very professional. I like it!

Apart from showing off to friends, an ACC printout has a much more down-to-earth use. My music collection has cost me a very significant sum of money over the years; should there be a disaster (fire, flood, whatever) I now have a most useful document to back up any insurance claim...

Kind regards

gandt
2009-07-24, 04:16
got it sorted by following the results of "Test" which was a bit unexpected..but anyway thanks

browellm
2009-07-24, 04:28
It hasn't been tested on Vista 64 yet (as I don't have this platform). Earlier test from users revealed that it did not work due to the ODBC driver.

As a workaround you could run a Windows 32bit Virtual Machine.

I have now got this working on Vista x64 by installing the 32bit ODBC driver :P

Have to say it looks pretty fantastic.

I just seem to have one issue; when an album has multiple track artists it shows a number of entries for the same track for each artist e.g. on Mali Music by Damon Albarn and other artists:

1 - Spoons (5:19)
2 - Bamako City (4:09)
3 - Le Relax (3:52)
4 - Nabintou Diakité (1:47)
4 - Nabintou Diakité (1:47)
5 - Makelekele (4:24)
5 - Makelekele (4:24)
5 - Makelekele (4:24)
5 - Makelekele (4:24)
5 - Makelekele (4:24)
5 - Makelekele (4:24)
5 - Makelekele (4:24)
6 - The Djembe (4:35)
6 - The Djembe (4:35)
6 - The Djembe (4:35)
6 - The Djembe (4:35)
6 - The Djembe (4:35)
7 - Tennessee Hotel (3:42)
7 - Tennessee Hotel (3:42)
7 - Tennessee Hotel (3:42)
7 - Tennessee Hotel (3:42)
7 - Tennessee Hotel (3:42)
7 - Tennessee Hotel (3:42)
7 - Tennessee Hotel (3:42)
8 - Niger (3:53)
8 - Niger (3:53)
8 - Niger (3:53)
8 - Niger (3:53)
8 - Niger (3:53)
8 - Niger (3:53)
8 - Niger (3:53)
8 - Niger (3:53)
9 - 4 AM at Toumani's (3:07)
9 - 4 AM at Toumani's (3:07)
10 - Institut National des Arts (4:15)
10 - Institut National des Arts (4:15)
10 - Institut National des Arts (4:15)
10 - Institut National des Arts (4:15)
11 - Kela Village (3:11)
11 - Kela Village (3:11)
11 - Kela Village (3:11)
11 - Kela Village (3:11)
12 - Griot Village (1:12)
13 - Le Hogon (3:52)
13 - Le Hogon (3:52)
13 - Le Hogon (3:52)
13 - Le Hogon (3:52)
14 - Sunset Coming On (4:14)
15 - Ko Kan Ko Sata Doumbia on River (1:04)
16 - Les Escrocs (5:08)

Any idea's on configuring ACC or adjusting my tagging schema to avoid this?

tamanaco
2009-07-24, 04:47
*EDIT*
SQLite does not support remote access so this will not be supported but if I understand correctly there will be a choice to use MySQL over SQLite. In that case I will support ACC for future SC versions but only if the DB is MySql based.

A work around might be to copy the .db file locally before processing it. See my reply to your post in the Dev thread here: http://forums.slimdevices.com/showpost.php?p=442996&postcount=3

SilverRS8
2009-07-24, 13:46
I have now got this working on Vista x64 by installing the 32bit ODBC driver :P

Great ! Good to know that is the trick.


Have to say it looks pretty fantastic.

I just seem to have one issue; when an album has multiple track artists it shows a number of entries for the same track for each artist e.g. on Mali Music by Damon Albarn and other artists:

1 - Spoons (5:19)
2 - Bamako City (4:09)
3 - Le Relax (3:52)
4 - Nabintou Diakité (1:47)
4 - Nabintou Diakité (1:47)
5 - Makelekele (4:24)
5 - Makelekele (4:24)
5 - Makelekele (4:24)
5 - Makelekele (4:24)
5 - Makelekele (4:24)
5 - Makelekele (4:24)
5 - Makelekele (4:24)
6 - The Djembe (4:35)
6 - The Djembe (4:35)
6 - The Djembe (4:35)
6 - The Djembe (4:35)
6 - The Djembe (4:35)
7 - Tennessee Hotel (3:42)
7 - Tennessee Hotel (3:42)
7 - Tennessee Hotel (3:42)
7 - Tennessee Hotel (3:42)
7 - Tennessee Hotel (3:42)
7 - Tennessee Hotel (3:42)
7 - Tennessee Hotel (3:42)
8 - Niger (3:53)
8 - Niger (3:53)
8 - Niger (3:53)
8 - Niger (3:53)
8 - Niger (3:53)
8 - Niger (3:53)
8 - Niger (3:53)
8 - Niger (3:53)
9 - 4 AM at Toumani's (3:07)
9 - 4 AM at Toumani's (3:07)
10 - Institut National des Arts (4:15)
10 - Institut National des Arts (4:15)
10 - Institut National des Arts (4:15)
10 - Institut National des Arts (4:15)
11 - Kela Village (3:11)
11 - Kela Village (3:11)
11 - Kela Village (3:11)
11 - Kela Village (3:11)
12 - Griot Village (1:12)
13 - Le Hogon (3:52)
13 - Le Hogon (3:52)
13 - Le Hogon (3:52)
13 - Le Hogon (3:52)
14 - Sunset Coming On (4:14)
15 - Ko Kan Ko Sata Doumbia on River (1:04)
16 - Les Escrocs (5:08)

Any idea's on configuring ACC or adjusting my tagging schema to avoid this?

How have you tagged the multiple artists? By using a separator char (;)? Let me know and I'll see if I can fix this within ACC.

I think most users just use the artist tag for this separating them with a comma instead of the ; char. The ; causes separate entries for each artist in the ARTIST DB Table. I have to look if I can create a query that aggregates all track artists to a single DB entry or string. Then use the ALBUMARTIST tag to enter the well...albumartist. This requires that you have set the TPE2 option in SC and in ACC correspondingly (refer to TPE2 help in Option screen of ACC)