Announce: Album Catalog Creator for SlimServer

[SilverRS8]

Frank,

I looked into the output again: the script is retrieving the proper cover art from the db, just the server ip is not fully resolved (it's still 127.0.0.1 in the source instead of 192.168.x.y). If I replace the strings in the output file the covers are displayed correctly.

Thanks for the support, Joachim

PS Forget about my prior statement with the mixed up directories. I was wrong - each script writes into its own directory. So this is correct.

Thanks very much Joachim for sorting that out. Great job. I'll change it in the code.

So can you confirm that RC6-Alt1 works fine for you but RC6-Beta doesn't or does RC6-Beta also works for you but has the same problem?

Can you say something about performance of RC6-Alt1 vs RC6-Beta?

Frank

[friediger]

Hi,

I'm having a problem using ACC. I am trying to connect to a remote slimserver running on a QNAP NAS server. What I have done:

1. I have downloaded the ODBC drivers and installed them (I use Windows Vista)
2. I have ssh'd into the server and changed the my.tt file so that remote connections are allowed.

I have clicked the 'test' button in ACC and it tells me that the connection to the database is successful. However, when I click 'start' I get the following error message:

Error while querying for album data
Error number: -2147217887
Error description: ODBC driver does not support the requested features (translated from Danish, so probably not 100% correct)
Unable to continue. Click OK to quit ACC.

I have downloaded the MySQL query browser and I can connect to the remote database on the QNAP without any problems.

I have looked through the thread but haven't found anyone with a similar error. I hope someone has some ideas on what's causing the error.

Thanks in advance,
Kasper

[Kuben72]

I have the same problems. In the acc.log file I can see that it doesn't get to create the table it needs.

/Kuben72

[SilverRS8]

Hi,

I'm having a problem using ACC. I am trying to connect to a remote slimserver running on a QNAP NAS server. What I have done:

1. I have downloaded the ODBC drivers and installed them (I use Windows Vista)
2. I have ssh'd into the server and changed the my.tt file so that remote connections are allowed.

I have clicked the 'test' button in ACC and it tells me that the connection to the database is successful. However, when I click 'start' I get the following error message:

Error while querying for album data
Error number: -2147217887
Error description: ODBC driver does not support the requested features (translated from Danish, so probably not 100% correct)
Unable to continue. Click OK to quit ACC.

I have downloaded the MySQL query browser and I can connect to the remote database on the QNAP without any problems.

I have looked through the thread but haven't found anyone with a similar error. I hope someone has some ideas on what's causing the error.

Thanks in advance,
Kasper

There seems to be a problem in ACC supporting remote Linux servers (a big thanks to forum user parubini for indicating this). It appears that, besides the filesystem, SQL connectivity is also case-sensitive. I'm in the process of fixing the code and hope to post it this week. Please try it if posted and let me know the outcome...

Frank

[Kuben72]

Yep. Changed acc to ACC in the whole script and the Albums.id to albums.id in the create table statement and now it is running like mad on my computer

Edit: How long does it take ?

[SilverRS8]

Yep. Changed acc to ACC in the whole script and the Albums.id to albums.id in the create table statement and now it is running like mad on my computer

Edit: How long does it take ?

Yep. That should do the trick. How long it takes depends on your DB size. It make take up to several minutes if you have a few thousand albums. The actual catalog display of the RC6-Alt1 version is slow in comparison to RC6-Beta because it retrieves the album covers by URL directly from squeezecenter but it does support embedded album art though.

EDIT: You may want to narrow the scope for testing by specifying a starting folder in the main screen.

Frank

[Kuben72]

'### Iterate through every album by AlbumID
iAlbumID = rs("AlbumID")
sql = "SELECT distinct genres.namesort AS 'Genre' FROM albums " &_
"left join tracks on tracks.album=albums.id " &_
"left join genre_track on genre_track.track=tracks.id " &_
"left join genres on genre_track.genre=genres.id " &_
"Where Albums.ID = " & iAlbumID & " " &_
"order by genre;"

Should also be changed to:

'### Iterate through every album by AlbumID
iAlbumID = rs("AlbumID")
sql = "SELECT distinct genres.namesort AS 'Genre' FROM albums " &_
"left join tracks on tracks.album=albums.id " &_
"left join genre_track on genre_track.track=tracks.id " &_
"left join genres on genre_track.genre=genres.id " &_
"Where albums.id = " & iAlbumID & " " &_
"order by genre;"

/Kuben72

[Kuben72]

The mht file is also wrong. It uses the ip-adress 127.0.0.1 when it should use the ip-adress from the option.

/kuben72

[SilverRS8]

Just posted RC7 (http://www.vanholt.nl/acc/acc.htm) which should fix the issues with remote Linux servers.

I added a new option to use the either the physical album cover files on disc or the album cover files by SqueezeCenter URL reference. The latter one is much slower. Not with generating the actual catalog but only when displaying it as URLs to SqueezeCenter are then resolved. Is does however support embedded cover files in tags.

If you have a remote Linux server, let me know if it works aas I am unable myself to test it.

Frank

[Kuben72]

I have tried it and it works as long I check the "Use album cover...." option. Otherwise I get a no-cover image for the albums.