PDA

View Full Version : Announce: Album Catalog Creator for SlimServer



Pages : [1] 2

SilverRS8
2007-12-31, 09:36
NOTE: Please go to http://forums.slimdevices.com/showthread.php?t=66555&highlight=album+catalog+creator as this thread has been replaced





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 or ACC in short. 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 HTML 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) (EDIT: In the new version this is obsolete. Refer to end of thread)
- 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/acc/acc.htm

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

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

Frank

NOTE: Screenshots are based on initial beta release. The GUI has been changed and output improved over the various subreleases...

bobharp
2007-12-31, 09:50
Awesome Frank.

Thanks for the holiday gift. I will try it out tonight.

I'm sure SlimDevices will want you to add your utility to the wiki:
http://wiki.slimdevices.com/index.cgi?PluginsAudio

Happy New year!

Fifer
2007-12-31, 10:08
I've been looking for something like this. Thanks, I'll feed back when I've tried it.

alanj
2007-12-31, 11:33
Brilliant idea, been looking for something like this for ages!

Can't get it to work yet though .... my SqueezeCentre is on a different Linux server, so anyone know what the userid/password that an SC7 install would use is?

SilverRS8
2007-12-31, 11:40
Brilliant idea, been looking for something like this for ages!

Can't get it to work yet though .... my SqueezeCentre is on a different Linux server, so anyone know what the userid/password that an SC7 install would use is?

Sorry, looked at it again and the script only works when SS is installed on the same Windows machine.

Frank

Sam Lowry
2007-12-31, 11:42
I will try this soon. Thanks for the effort, looks great. I wanted to strongly recommend for the sake of the trees of planet Earth, that everyone prints to a PDF version and not use paper whenever possible. Based on my current collection of music, I believe it would take many hundreds of double-sided pages. Hopefully there are font choices for headlines.

tamanaco
2007-12-31, 11:46
I just tried running the script from my SC 7.0 Windows XP server after installing the ODBC connector 3.51. After the script runs for a few seconds I get the following error:

Error creating file C:\Album Art Creator\AlbumCatalogs\AlbumList - Long - 12/31/07.html
Possibly Open by another application?

I stopped SqueezeCenter.exe and kept mysqld.exe running, but it still gave the same error.

Any suggestions?

EDIT: I noticed that the help button does not work from the GUI interface, but if I click AlbumCatalogCreator-help.hta in the includes folder it works... In the help file it refers to SC 6.5... Is this a limitation?

Mark Miksis
2007-12-31, 11:50
If the database structure hasn't been changed SC should work. The script currently expects the database to be on the same machine but you can easily change this.

Note that the default installation of SC configures mysqld to only accept connections from localhost.

SilverRS8
2007-12-31, 12:45
I just tried running the script from my SC 7.0 Windows XP server after installing the ODBC connector 3.51. After the script runs for a few seconds I get the following error:

Error creating file C:\Album Art Creator\AlbumCatalogs\AlbumList - Long - 12/31/07.html
Possibly Open by another application?

I stopped SqueezeCenter.exe and kept mysqld.exe running, but it still gave the same error.

Any suggestions

EDIT: I noticed that the help button does not work from the GUI interface, but if I click AlbumCatalogCreator-help.hta in the includes folder it works... In the help file it refers to SC 6.5... Is this a limitation?

Thanks for the update. The script uses the current date to create the filename. You apparently have american notation which uses slashes which is not allowed in a file name.

I fixed it and updated the download so please download again and let me know if it works.

I will also fix the helpfile issue tomorrow. I used a fixed path assuming the mshta executable is in c:\windows and you apparently have windows installed in a different directory. Sorry for my (ugly) coding error (never use fixed paths, use system variables). Must have been a quick coding mistake and never looked at it again. (its almost party time here because of old-new year).

Frank

tamanaco
2007-12-31, 13:58
Thanks for the update. The script uses the current date to create the filename. You apparently have american notation which uses slashes which is not allowed in a file name.

I fixed it and updated the download so please download again and let me know if it works.

I will also fix the helpfile issue tomorrow. I used a fixed path assuming the mshta executable is in c:\windows and you apparently have windows installed in a different directory. Sorry for my (ugly) coding error (never use fixed paths, use system variables). Must have been a quick coding mistake and never looked at it again. (its almost party time here because of old-new year).

Frank

Ok, I tried beta 2 and got the same error, but after I click ok on the error message it starts IE with the content of my music catalog. There are some album covers missing which "should" be there. I double checked the albums with missing album art in the resulting catalog and all my album folders have a corresponding folder.jpg. I also have album art embedded in every track. The font for the tracks also look a bit small in the browser, but it might be my browser's font settings.

Btw, thanks for sharing the script... it shows a lot of promise.

Don't worry about fixing it today... Go party and have a Happy New Year!

alanj
2007-12-31, 15:09
Hi Frank,
Well been delving on my Linux server and found as already pointed out by Fletch that only local connections are enabled.

This should be dead easy to change as it is only a setting in the my.cnf file to alter the bind address from the current 127.0.0.1 to whatever your servers ip is. lol However I have tried that but the my.cnf file gets overwritten and reset to the original every time I restart it! Very annoying.

Don't suppose anyone knows what in Slimserver is resetting the /var/cache/slimserver/my.cnf file do they?
I think it is being created from a /var/share/slimserver/my.tt file but not sure how to change that to set the correct ip as it isn't a straight copy but full of variables.

Mark Miksis
2007-12-31, 15:29
Don't suppose anyone knows what in Slimserver is resetting the /var/cache/slimserver/my.cnf file do they?
I think it is being created from a /var/share/slimserver/my.tt file but not sure how to change that to set the correct ip as it isn't a straight copy but full of variables.

I assume you're using a recent SC7 nightly? If so, look for bindAddress in server.prefs. I'm not sure what the syntax is if you want to list multiple IPs.

MillmoorRon
2007-12-31, 16:15
I get the same error as tamanaco but it still seems to work OK!

The results are excellent.

I do have a feature request: can it be made to ignore 'the' etc. (per Slimserver setting?) so artists are in a more sensible order?

SilverRS8
2008-01-01, 02:05
I will try this soon. Thanks for the effort, looks great. I wanted to strongly recommend for the sake of the trees of planet Earth, that everyone prints to a PDF version and not use paper whenever possible. Based on my current collection of music, I believe it would take many hundreds of double-sided pages. Hopefully there are font choices for headlines.

The shortlist version is probably more useful if you have a very large collection. Less detail but a lot less paper wasted.

scalesr1
2008-01-01, 03:07
I too got the same results. Clicking OK revealed that a catalogue had been
created but listing all albums as being by 'various artists', very few with
cover art but nothing else.

Apart from that - looks really good. I will investigate with more sort
options.

Thank you for the good work and have a great new year.

Richard Scales

SS 6.5.1 running on Windows 2003 SBS with 3,300 albums

-----Original Message-----
From: discuss-bounces (AT) lists (DOT) slimdevices.com
[mailto:discuss-bounces (AT) lists (DOT) slimdevices.com] On Behalf Of MillmoorRon
Sent: 31 December 2007 23:16
To: discuss (AT) lists (DOT) slimdevices.com
Subject: Re: [slim] Announce: Album Catalog Creator for SlimServer


I get the same error as tamanaco but it still seems to work OK!

The results are excellent.

I do have a feature request: can it be made to ignore 'the' etc. (per
Slimserver setting?) so artists are in a more sensible order?


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

SilverRS8
2008-01-01, 03:34
I too got the same results. Clicking OK revealed that a catalogue had been
created but listing all albums as being by 'various artists', very few with
cover art but nothing else.

Apart from that - looks really good. I will investigate with more sort
options.

Thank you for the good work and have a great new year.

Richard Scales


Hi Richard,

I did a minor update on the file creation error. Also the help screen, when windows is not installed in c:\windows should work now. Can you test this and let me know the results?

Can you also let me know (for me to try to re-create the problem in order to fix it):
- what paths you use as Starting folder and as Compilation folder?
- What cover art file names do you use? Cover.jpg and folder.jpg should be supported if they are placed in the same directory the track file is located. Is you filesystem case-sensitive?

NOTE: When starting folder is the same as compilation folder, all albums are treated as compilations and album artist is named 'various artists'

Thx for the effort and nice to hear you (and others) find the script also very useful.

If you have made any additions yourself please send them to me also. I like to maintain a single 'master' version for other forum users to use.

Frank

scalesr1
2008-01-01, 04:42
I just ran the updated version and can confirm the following:

No error message once catalogue is created.

I must confess that I have not got a specific folder for compilations so I
did not specify one. Neither had I specified a starting folder though for
testing purposes I can see that it might help as running it against my
entire collection takes a while!

File system is not case sensitive (Windows) and I can confirm that cover art
is named folder.jpg, cover.jpg and I seem to have a lot of dlimage.jpg
(generated by a cover art generation script!) I assume that I could just
rename these to cover.jpg etc.

If I specify a starting folder in order to select a subset of my collection
then the artists displays perfectly - so it seems that it only displays
'various artists' for all albums if no starting folder is specified.

I expect that if I specify the root as the starting folder - it might work
just fine.

Thanks again for this - nice work.

Richard Scales



-----Original Message-----
From: discuss-bounces (AT) lists (DOT) slimdevices.com
[mailto:discuss-bounces (AT) lists (DOT) slimdevices.com] On Behalf Of SilverRS8
Sent: 01 January 2008 10:35
To: discuss (AT) lists (DOT) slimdevices.com
Subject: Re: [slim] Announce: Album Catalog Creator for SlimServer


Richard Scales;253106 Wrote:
> I too got the same results. Clicking OK revealed that a catalogue had
> been
> created but listing all albums as being by 'various artists', very few
> with
> cover art but nothing else.
>
> Apart from that - looks really good. I will investigate with more sort
> options.
>
> Thank you for the good work and have a great new year.
>
> Richard Scales
>

Hi Richard,

I did a minor update on the file creation error. Also the help screen,
when windows is not installed in c:\windows should work now. Can you
test this and let me know the results?
Can you also let me know:
- what paths you use as Starting folder and as Compilation folder?
- What cover art file names do you use? Cover.jpg and folder.jpg should
be supported if they are placed in the same directory the track file is
located. Is you filesystem case-sensitive?

Thx for the effort and nice to hear you (and others) find the script
also very useful.

If you have made any additions yourself please send them to also so I
can include them for maintaining a single 'master' version for other
forum users to use.

Frank


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

Rick B.
2008-01-01, 07:52
Looking good! Main problems I am having:

- I have many albums with multiple genres and if I ask it to print genres it only prints one of the genres seemingly at random
- I can't get it to exclude a genre - probably linked to issue above
- I have multiple hard drives and it doesn't find a second folder inside my specified folder - i.e., it doesn't see the shoertcut to the F:\ from the D:\ folder - only the D:\ folder is created

Thanks for what looks to be a great little app!

SilverRS8
2008-01-01, 08:11
Thx for your reaction and testing.


I have many albums with multiple genres and if I ask it to print genres it only prints one of the genres seemingly at random

So what you actually would like is an option to display the genre of each track instead of album based? Ordering multiple multi genre albums based on genre is not possible i think (how would you like to output to look?)but if you have a suggestion and more users want this I can see if I can code it into the script?


- I can't get it to exclude a genre - probably linked to issue above

Indeed linked to the previuous request.


- I have multiple hard drives and it doesn't find a second folder inside my specified folder - i.e., it doesn't see the shoertcut to the F:\ from the D:\ folder

The script doesn't actually traverse directories. It looks at the source location of a tracks as stored in the database. It does however expect that all album tracks are in the same folder. Having album tracks dispersed over several directories is not supported.


- only the D:\ folder is created

What do you actually mean? The script doesn't create folders, beside a 'AlbumCatalogs' folder in the script folder to write the generated files to. It only performs read actions (only for album covers).

Frank

tamanaco
2008-01-01, 08:38
Just downloaded beta 3 and I do not see the Start or Help buttons. The font of the GUI is bigger, but no where to click to start the process.

Edit: Never mind... I was able to resize the window and see the missing buttons. But there's still something wrong with the layout of the GUI.

Instead of the error I get a window with the number of tracks and albums. Once you click ok on this window is closes the GUI.
Still missing album covers.

SilverRS8
2008-01-01, 08:46
Just downloaded beta 3 and I do not see the Start or Help buttons. The font of the GUI is bigger, but no where to click to start the process.

Edit: Never mind... I was able to resize the window and see the missing buttons. But there's still something wrong with the layout of the GUI.

I didn't change any GUI code but if others users are experiencing the same...please react.

Frank

SilverRS8
2008-01-02, 02:54
I must confess that I have not got a specific folder for compilations so I
did not specify one. Neither had I specified a starting folder though for
testing purposes I can see that it might help as running it against my
entire collection takes a while!

Thx for the update. I fixed it because this should work ofcourse.


File system is not case sensitive (Windows) and I can confirm that cover art
is named folder.jpg, cover.jpg and I seem to have a lot of dlimage.jpg
(generated by a cover art generation script!) I assume that I could just
rename these to cover.jpg etc.

No need to rename files. You can easily add you cover files used to line 70 (of the current script version -> download again for current version please):
sCoverFilename = "cover.jpg,folder.jpg"

So your change would look like:
sCoverFilename = "cover.jpg,folder.jpg,dlimage.jpg"

Regards,

Frank

Rick B.
2008-01-02, 05:57
Thx for your reaction and testing.



So what you actually would like is an option to display the genre of each track instead of album based? Ordering multiple multi genre albums based on genre is not possible i think (how would you like to output to look?)but if you have a suggestion and more users want this I can see if I can code it into the script?

What do you actually mean? The script doesn't create folders, beside a 'AlbumCatalogs' folder in the script folder to write the generated files to. It only performs read actions (only for album covers).

Frank

Fistly, I have multiple genres only at the album level, not song level. All I meant was that you have an option to include genre in the printout but it only prints out one genre at random. I have a max of 3 genres per album.

Secondly, if I have albums in a directory D:\Slim it finds them, but it does't find the albums that I have in F:\Slim, even though I have a shorcut for F:\Slim in D:\Slim. An alternative would be to allow us to set up multiple drives like this: D:\Slim;F:\Slim

The biggest potential user for your script is someone with lots of music - meaning, they likely have more than one hard drive.

Thanks again for taking this on. Much appreciated.

SilverRS8
2008-01-02, 07:20
Fistly, I have multiple genres only at the album level, not song level. All I meant was that you have an option to include genre in the printout but it only prints out one genre at random. I have a max of 3 genres per album.

Secondly, if I have albums in a directory D:\Slim it finds them, but it does't find the albums that I have in F:\Slim, even though I have a shorcut for F:\Slim in D:\Slim. An alternative would be to allow us to set up multiple drives like this: D:\Slim;F:\Slim

1: I will investigate what is needed to implement this.
On the database side there is a table linking Genres to tracks but there is no table linking albums to genres. So the album genre or genres must be extracted from the seperate album tracks (as a first thought).

2: Must be possible to solve.
I just need to know how such an entry (shortcut as part of path) is stored in the SS Database. I will create an identical path structure to investigate.

I may need some time but i'll get back on both. Thx for your comment.

moley6knipe
2008-01-02, 07:37
I'm really interested in this app - would it be possible to modify it to pick up artwork that SS has added from embedded tags, rather than folder.jpg?

I think it's possible, because Emmisary's app (http://forums.slimdevices.com/showthread.php?t=28457&page=13) did just that when I ran it under 6.5.x. Sadly that app no longer runs under 7, as far as I can see.

I'd love to help, but I've only just started to learn html!

moley6knipe
2008-01-02, 07:41
...and another thought; presumeably it picks up the "Artist" field from the db when it runs? Can it be tweaked to use whatever SS calls "Artist Sort"?

SilverRS8
2008-01-02, 07:45
I'm really interested in this app - would it be possible to modify it to pick up artwork that SS has added from embedded tags, rather than folder.jpg?

I think it's possible, because Emmisary's app (http://forums.slimdevices.com/showthread.php?t=28457&page=13) did just that when I ran it under 6.5.x. Sadly that app no longer runs under 7, as far as I can see.

I'd love to help, but I've only just started to learn html!

All album covers are stored in BLOB recordfieldtypes. I will try to figure out how this can be accomplished and added. HTML is just the markup and not that real exiting or complex. For some advanced stuff I can use mySQL or SQL knowledge mostly regarding the formatting of SQL SELECT statements. So I don't know if your experienced in SQL?

EDIT: The script uses the tracks.title (not titlesort), albums.title (not titlesort) and contributor.name (not namesort) fields. The xxxxsort fields are not used by the script because they are all in uppercase and contain only A-Z characters. Special chars are replaced by spaces for the xxxxsort fieldtypes.
Hope this is an answer to your question?

Frank

scalesr1
2008-01-02, 08:41
Thanks again for that, I already figured out the line for adding cover art
info.

I can see now that I will have to sort out all my various artist albums
because it seems that I should not include them in the 'artist' sorted list.

I will try the other sorts next


Thanks again

Richard

-----Original Message-----
From: discuss-bounces (AT) lists (DOT) slimdevices.com
[mailto:discuss-bounces (AT) lists (DOT) slimdevices.com] On Behalf Of SilverRS8
Sent: 02 January 2008 09:54
To: discuss (AT) lists (DOT) slimdevices.com
Subject: Re: [slim] Announce: Album Catalog Creator for SlimServer


Richard Scales;253115 Wrote:
> I must confess that I have not got a specific folder for compilations so
> I
> did not specify one. Neither had I specified a starting folder though
> for
> testing purposes I can see that it might help as running it against my
> entire collection takes a while!

Thx for the update. I fixed it because this should work ofcourse.

Richard Scales;253115 Wrote:
> File system is not case sensitive (Windows) and I can confirm that cover
> art
> is named folder.jpg, cover.jpg and I seem to have a lot of dlimage.jpg
> (generated by a cover art generation script!) I assume that I could
> just
> rename these to cover.jpg etc.

No need to rename files. You can easily add you cover files used to
line 70 (of the current script version -> download again for current
version please):
sCoverFilename = "cover.jpg,folder.jpg"

So your change would look like:
sCoverFilename = "cover.jpg,folder.jpg,dlimage.jpg"

Regards,

Frank


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

Fifer
2008-01-02, 09:10
Sorry, looked at it again and the script only works when SS is installed on the same Windows machine.

Frank
Ah, that won't work for me then. No worries, I'm sure many will find this useful.

moley6knipe
2008-01-02, 10:45
Thanks Frank! I wonder why SS translates sorting to UPPERCASE? Again, I'm only just starting to learn SQL so I'm a long way off yet! Sorry. I'm one of those strange people who's learning it for fun ;-)

Secret Squirrel
2008-01-02, 12:12
Thanks Frank! I wonder why SS translates sorting to UPPERCASE? Again, I'm only just starting to learn SQL so I'm a long way off yet! Sorry. I'm one of those strange people who's learning it for fun ;-)

My guess is that making everything uppercase removes weirdness of case. Remember, a computer is not intelligent (neither am I really) but a capital A's value is not equal to a lowercase a. Thus, The Who would have a different sort value than THE WHO. It seems weird but that's my guess.

I hope that sheds a little light on it for you!

SS

webrits
2008-01-02, 13:36
Thanks for putting this together 'SilverRS8'....

Unfortunately I can't even get it to install...Once the first install window starts I get the message
" a scrpt on this page is causing internet explorer to run slowly if it continues to run your computer may become unresponsive".
Is it something I've done wrong??

Thanks again...

Paul

Phil Leigh
2008-01-02, 13:41
Thanks for putting this together 'SilverRS8'....

Unfortunately I can't even get it to install...Once the first install window starts I get the message
" a scrpt on this page is causing internet explorer to run slowly if it continues to run your computer may become unresponsive".
Is it something I've done wrong??

Thanks again...

Paul
I get exactly the same thing! (xp sp2, ie 7.0.5730)

Chewie
2008-01-02, 14:27
Thanks for putting this together 'SilverRS8'....

Unfortunately I can't even get it to install...Once the first install window starts I get the message
" a scrpt on this page is causing internet explorer to run slowly if it continues to run your computer may become unresponsive".
Is it something I've done wrong??

Thanks again...

Paul


I get the same message, but my message appears after Iíve installed the program and started it running. It was running for over an hour this morning and the message just kept popping up every 5 or 10 minutes, after about 70 minutes I just ended it.

XP SP2 ie 7.0.5730.13

sellars
2008-01-02, 15:18
Hi,
I am running SS 6.5.1 - 10879, Windows XP SP2, .Net 1.1 and 2.0, IE 6 (upgraded to IE7) and beta 4 of the catalog creator.
I am getting this error message: A script on this page is causing Internet Explorer to run slowly. If it continues to run, your computer may become unresponsive.

I tried upgrading from IE6 to IE7. No matter if I select to stop the script or keep running it, the pop up continues to come up.

Any help would be appreciated.

alanj
2008-01-02, 17:27
Hi,
Well I have got the connection to SC on Linux to work now. Needed the following changes ...
Edit the server.prefs file and change 3 lines, all close together. Look for the bindAddress. Change from 127.0.0.1 to your servers IP. Also add the server ip to the allowedHosts line.
Change the hostname on the dbsource: line as well.

Above is best done with slimserver stopped so the file isn't updated while you are editing it.

I also had to create a new user in the slimserver MySql with access from anywhere and grant it access to the slimserver tables.

Finally edited the VB script line 41 to use the new IP userid and password.

The script then runs and retrieves data from the remote Linux server.
Sadly I am now stuck. lol All albums are reported as "Various Artists" - as per other posts where no compilation directory is set. I haven't yet found out how to add the Linux path of my compilation directory correctly. I suspect either or both the lack of a drive value ( c: )or the slash directions.
Whatever I have tried in the compilations directory field ( full unix path with or without quotes ) causes the script to fail with a message reporting that the script is causing IE to run slowly. Why IE? No idea.
Also no album art at all is retrieved, presumably due to paths again.

I have copied my music data to my Windows box and installed a local copy of SC7 and the script runs fine against it. Only niggle I could find is when displaying the tracks from multiple albums. It would be nice to add a disc number sub heading.

Sorry to ramble on. Thanks for an excellent script Frank. Very useful.

SilverRS8
2008-01-03, 00:02
I created a beta4 version with some bug fixes which apparently causes the script to run slowly for some :-(
I restored beta3 so if you download it again i guess the 'run slowly' problems should be gone.

I will take a close look into the problem this afternoon. If any of you like to participate in a more in depth debugging please send me a PM. I may get in touch to do some troubleshooting or to get additional information needed for debugging. Maybe keep in mind the timezone in case direct contact (IM) may be usefull). I live in the netherlands.

Thx for the responses!

Frank

ymilner
2008-01-03, 00:24
Thanks for the script!
One issue I didn't see mentioned here: I get question marks instead of all non-latin characters (cyrillic, hebrew) in song titles, album titles and genres. Any hope?

Phil Leigh
2008-01-03, 05:27
I created a beta4 version with some bug fixes which apparently causes the script to run slowly for some :-(
I restored beta3 so if you download it again i guess the 'run slowly' problems should be gone.

I will take a close look into the problem this afternoon. If any of you like to participate in a more in depth debugging please send me a PM. I may get in touch to do some troubleshooting or to get additional information needed for debugging. Maybe keep in mind the timezone in case direct contact (IM) may be usefull). I live in the netherlands.

Thx for the responses!

Frank

Yes Frank - that fixed the "a script is running slowly" problem.
Now I get a "an error occurred while connection to the database" error
Error Number 0

The ODBC connector is installed so I guess it must be something to do with the connect string?
Regards
Phil

(PS Really looking forward to getting this running!)

SilverRS8
2008-01-03, 06:15
Yes Frank - that fixed the "a script is running slowly" problem.
Now I get a "an error occurred while connection to the database" error
Error Number 0

The ODBC connector is installed so I guess it must be something to do with the connect string?
Regards
Phil

(PS Really looking forward to getting this running!)

Thx Phil for the update regarding the running slow problem.

Some things to know regarding the connection string:
- The SlimServer database is default configured to accept only local connections. Is SlimServer installed on the same machine as the one you run the script from?
- I haven't tested it yet on SqueezeCenter because it is still in Beta. Which version do you use?
- The connection string is configured with the default credentials; UID=Slimserver with no password. Is this still default or did you change it sometime for your SS installation?
- Try turning of your firewall just for test. The connection is made on port 9092

Frank

Phil Leigh
2008-01-03, 06:32
Thx Phil for the update regarding the running slow problem.

Some things to know regarding the connection string:
- The SlimServer database is default configured to accept only local connections. Is SlimServer installed on the same machine as the one you run the script from?
- I haven't tested it yet on SqueezeCenter because it is still in Beta. Which version do you use?
- The connection string is configured with the default credentials; UID=Slimserver with no password. Is this still default or did you change it sometime for your SS installation?
- Try turning of your firewall just for test. The connection is made on port 9092

Frank

Frank:
1) SlimServer is on the same PC as the script
2) - aha - this may be the problem...I am running SS 7.0!
3) the credentials look OK ... the connect string matches what is setup in the (SS 7.0) server.prefs...

dbpassword: ''
dbsource: dbi:mysql:hostname=127.0.0.1;port=9092;database=%s
dbusername: slimserver
disableStatistics: 0

4) Firewall made no difference.

Maybe I just have to wait for a SS7 version?
Thanks
Phil

tamanaco
2008-01-03, 07:50
I haven't tested it yet on SqueezeCenter because it is still in Beta. Which version do you use?

Frank

Hmmm, so SC 6.x is a limitation. That's what I thought when I first read the help file. Oh well, I guess I'll have to wait for an SC 7.0 version too.

SilverRS8
2008-01-03, 08:00
Hmmm, so SC 6.x is a limitation. That's what I thought when I first read the help file. Oh well, I guess I'll have to wait for an SC 7.0 version too.

I haven't tested it on SC. If the database structure and UID and PWD haven't change I guess it should work. Maybe others have tested it with SC7 and have good results?

Siduhe
2008-01-03, 08:03
I haven't been able to get beta v3 up and running on SC7, but it works fine with my 6.5.5 installation.

Phil Leigh
2008-01-03, 08:04
I wonder if the ODBC 3.5.1 driver is not compatible with the MySQL in ss7?

The connect strings look fine (and identical) to me...

Secret Squirrel
2008-01-03, 08:08
I installed and ran it on SqueezeCenter 7.0 and it ran fine. The only isse I had was that it listed all artists as "Various Artists", but I noticed further up in the thread that happens when you don't enter a compilation directory which I didn't. I hope to spend some time on the script to see a work around.

Continued thanks Frank for your great work on this!

SS

SilverRS8
2008-01-03, 08:10
I haven't been able to get beta v3 up and running on SC7, but it works fine with my 6.5.5 installation.

Thank you very much for testing this and clearing this up !!
Then either the Database structure of SC is different or field names/types have chached in relation to SS. I'm installing SC right now on my laptop just to see what the differences actually are.

When the debugging is done on 6.5 I'll adapt it as soon as possible to SC.

Frank

Phil Leigh
2008-01-03, 08:12
I installed and ran it on SqueezeCenter 7.0 and it ran fine. The only isse I had was that it listed all artists as "Various Artists", but I noticed further up in the thread that happens when you don't enter a compilation directory which I didn't. I hope to spend some time on the script to see a work around.

Continued thanks Frank for your great work on this!

SS


SS - can you post the contents of your my.cnf file in
C:\Documents and Settings\All Users\Application Data\SqueezeCenter\Cache

please?
thanks
Phil

Secret Squirrel
2008-01-03, 08:17
I'll be glad to...when I get home this evening! (10:15 EST here now)

I'm afraid I don't even know which of Frank's versions I am running at the moment either. Sorry!

SS


SS - can you post the contents of your my.cnf file in
C:\Documents and Settings\All Users\Application Data\SqueezeCenter\Cache

please?
thanks
Phil

Phil Leigh
2008-01-03, 08:18
SS - many thanks!
Phil

Siduhe
2008-01-03, 08:23
Interesting - I had also assumed it was just an SC7 issue.

Two things to mention: I'm currently running SC7 on a virtual machine, which may have something to do with it. Also, the VM is running XP Home (rather than XP Pro which is my normal OS).

I'll play around a bit more to see if either of these two have something to do with it. Have been planning a take the plunge migration to SC7 for my main set up for a while now - this may be the push to do it.

SilverRS8
2008-01-03, 08:26
I installed and ran it on SqueezeCenter 7.0 and it ran fine. The only isse I had was that it listed all artists as "Various Artists", but I noticed further up in the thread that happens when you don't enter a compilation directory which I didn't. I hope to spend some time on the script to see a work around.

Continued thanks Frank for your great work on this!

SS

The 'Various artist' issue was solved in Beta4 but that one caused 'script running slow' errors. It worked fine on my Vista install but I guess it had problems running on XP. I'm gonna test that tonight. Should be a easily fixed.

Thanks very much for your much appreciate support!

SilverRS8
2008-01-03, 08:28
I'll be glad to...when I get home this evening! (10:15 EST here now)

I'm afraid I don't even know which of Frank's versions I am running at the moment either. Sorry!

SS

It's in the title bar of the AlbumCatalogCreator window.

Frank

Secret Squirrel
2008-01-03, 08:33
Just alittle more information (very little). I am running SC 7.0 on Windoze XP Pro...non-VM machine. I'm also running on the latest FireFox version 2. My guess is that I am running Frank's version 3 because of the Various Artist bug.

I will post all of my information this evening. then I'll download and run version 4.

More info later...sorry!

SS


Interesting - I had also assumed it was just an SC7 issue.

Two things to mention: I'm currently running SC7 on a virtual machine, which may have something to do with it. Also, the VM is running XP Home (rather than XP Pro which is my normal OS).

I'll play around a bit more to see if either of these two have something to do with it. Have been planning a take the plunge migration to SC7 for my main set up for a while now - this may be the push to do it.

tamanaco
2008-01-03, 08:33
Thank you very much for testing this and clearing this up !!
Then either the Database structure of SC is different or field names/types have chached in relation to SS. I'm installing SC right now on my laptop just to see what the differences actually are.

When the debugging is done on 6.5 I'll adapt it as soon as possible to SC.

Frank

On SC 7.0 beta, for me, is not a DB connection issue. The main issue I'm experiencing is with some albums not displaying the covers. (All the tracks are listed) I think this issue "might" be related to special characters in the name of the folder when the script is trying to get to the folder.jpg. In my case, the missing covers are from folders with names that have letters with Spanish, Portuguese accents and those with ";" in the folder name. (":" are translated into ";" during the ripping process)

Phil Leigh
2008-01-03, 08:36
A little more info...the ODBC driver works OK in Control Panel - I can configure it and connect to the slimserver database OK using the same info as is in the connectstring in the script...very odd.

SilverRS8
2008-01-03, 11:04
On SC 7.0 beta, for me, is not a DB connection issue. The main issue I'm experiencing is with some albums not displaying the covers. (All the tracks are listed) I think this issue "might" be related to special characters in the name of the folder when the script is trying to get to the folder.jpg. In my case, the missing covers are from folders with names that have letters with Spanish, Portuguese accents and those with ";" in the folder name. (":" are translated into ";" during the ripping process)

Thank you Tamanco. Just tried to simulate your problem and a semicolon (;) is stored as %3B is the database track path. I didn't account for that. I will create a conversion table for all special characters so album covers should be displayed correctly!

Thx again for indication the problem right on the spot!

SilverRS8
2008-01-03, 11:22
I created a webpage for ACC releases.

See: http://www.vanholt.nl/acc/acc.htm

Frank

Phil Leigh
2008-01-03, 11:36
Frank
I just stuck this code into your script (where you talk to the database for the first time)

Set cnn = New ADODB.Connection
cnn.ConnectionString = ConnectString
cnn.Open

and it works (ie the connection opens fine) so the problem I have isn't with the string or the ODBC drivers...

I get a 3706 error when your script tries to read the recordset...?
Regards
Phil

Siduhe
2008-01-03, 11:39
Just to confirm I have the same problem as Phil - XP Pro and SC7 (latest nightly).

Is the user still slimserver in SC7, I would imagine it is now squeezecenter?

Phil Leigh
2008-01-03, 11:44
Just to confirm I have the same problem as Phil - XP Pro and SC7 (latest nightly).

Is the user still slimserver in SC7, I would imagine it is now squeezecenter?

I think it still "slimserver" - or at least that opens a connection to the database...

Siduhe
2008-01-03, 11:46
It works for me if I change the script UID to "squeezecenter" - all other variables stay the same. In particular, database is still Slimserver.

Phil Leigh
2008-01-03, 11:54
It works for me if I change the script UID to "squeezecenter" - all other variables stay the same. In particular, database is still Slimserver.

Rats! - It still doesn't work for me and that would have been such a simple and logical fix :o)

Siduhe
2008-01-03, 11:59
Aw shucks, and just when I was feeling the warm glow of success.

If it helps, my set up is as follows:

Create System DSN in ODBC Source Adminstrator as follows:

DAta Source Name - Squeezecenter
User - squeezecenter
Port - 9092
Test and OK

Change script using Edit Pad Pro as follows:

'MySQL connect constants
Const ConnectString = "DRIVER={MySQL ODBC 3.51 Driver};Server=127.0.0.1;Port=9092;Database=slimse rver;UID=squeezecenter;Password=;Option=3"

Save and run script. Seems to have done the job for me. How did you edit the script? Notepad not the best thing to use in my experience as it doesn't always preserve the line endings - just in case this is relevant.

P.S. There is no space between slimserver as may show in this post - c/p issue.

Phil Leigh
2008-01-03, 12:47
Aw shucks, and just when I was feeling the warm glow of success.

If it helps, my set up is as follows:

Create System DSN in ODBC Source Adminstrator as follows:

DAta Source Name - Squeezecenter
User - squeezecenter
Port - 9092
Test and OK

Change script using Edit Pad Pro as follows:

'MySQL connect constants
Const ConnectString = "DRIVER={MySQL ODBC 3.51 Driver};Server=127.0.0.1;Port=9092;Database=slimse rver;UID=squeezecenter;Password=;Option=3"

Save and run script. Seems to have done the job for me. How did you edit the script? Notepad not the best thing to use in my experience as it doesn't always preserve the line endings - just in case this is relevant.

P.S. There is no space between slimserver as may show in this post - c/p issue.

Siduhe - thanks...

I removed the ODBC driver and reinstalled.
Then I followed your instructions. The ODBC driver tested out ok in control panel...but I still get a 3706 error in the script. This error is generally something to do with the way that the ODBC drivers are installed...so the problem may be unique to my PC.

I used Wordpad to edit the script.
Cheers
Phil

Secret Squirrel
2008-01-03, 15:42
SS - can you post the contents of your my.cnf file in
C:\Documents and Settings\All Users\Application Data\SqueezeCenter\Cache

please?
thanks
Phil

Phil,

I didn't find a my.cnf but just a "my" file with no extension. I have attached it here as my.txt. I hope it has some information for you!

Here's some more information:

Windows XP Professional 2002 Service Pack 2

SqueezeCenter Version: 7.0 - 15047 - Windows XP - EN - cp1252
Server IP address: 192.168.1.103
Perl Version: 5.8.8 MSWin32-x86-multi-thread
MySQL Version: 5.0.22-community-nt

Album Catalog Creator v1.0 beta 3

HTH,

Secret

Secret Squirrel
2008-01-03, 15:51
Silly me the update didn't work the first time so I edited the message.

Sorry,

SS


Phil,

I didn't find a my.cnf but just a "my" file with no extension. I have attached it here as my.txt. I hope it has some information for you!

Here's some more information:

Windows XP Professional 2002 Service Pack 2

SqueezeCenter Version: 7.0 - 15047 - Windows XP - EN - cp1252
Server IP address: 192.168.1.103
Perl Version: 5.8.8 MSWin32-x86-multi-thread
MySQL Version: 5.0.22-community-nt

Album Catalog Creator v1.0 beta 3

HTH,

Secret

schatzy
2008-01-03, 20:50
Thanks for this great utility. I love it.

I have found one thing though that may need to be looked into. I am describing it here for others to try and see if they come up with the same issue.

Background:

1) two computer running windows XP SP2 latest updates

2) computer one runs SS 6.5 latest release, computer two runs SC7 Latest nightly

3) same issue shows up on both systems using same set of mp3 files

4) file layout is MP3\letter\artist\album (e:\mp3\B\Boston\Don't Look Back)

Test procedure:

1. run SS 6.5 and SC7 clear and rescan on same data files set. (Both computers are linked to same NAS).

2. run Album Catalog Creator

3. select only one artist by using start folder option. (E:\A\Alice in Chains). I know that there are 5 albums with a total of 57 tracks in this folder.

4. Press start after 15 seconds two windows pop open as follows:

First window: (dialog box)
Album Catalog Creator is finished - states the following:
Total number of tracks processed: 57
total number of albums processed: 3

Second window: (IE Window)
Display shows 4 albums with 42 tracks

5. last album in alphabetical order is not shown. I have tried this on many different artists folders and on both computers. I even went as far as changing the name of one of the albums (in the mp3 tags) to force it to show up before some of the others alphabetically and it is always the last album alphabetically that does not show up.

Has any one else seen this issue.

P.S. it also happened when i did a full Album Catalog Creation on my full MP3 set of files (58281 tracks by 3481 artists and 7957 albums).

By the way when i printed the list to a PDF file it come up with 889 pages when displaying album art and track titles and 140 pages when done as a short list without covers or track titles.

Other that this one issue i have not found any other problems with the operation of this utility. It works great.

Thanks for your great work and time to do this

Schatzy

SilverRS8
2008-01-04, 12:47
I just posted Beta 4 on http://www.vanholt.nl/acc/acc.htm

The following changes are made:
FIXED: Album cover not displayed if album path name contains non alpha numeric chars
FIXED: Script hangs when an album path containing non alpha numeric chars was selected as starting folder
FIXED: Very last album was never included in the catalog
FIXED: Album counter did not refect the actual processed albums
FIXED: The very last line of albums in the catalog were followed by empty dummy albums with no album cover
ADDED: acc.log file created on every run

Album covers should now be displayed correctly even if there are non alpha numeric chars in the path name.
Issues posted by Schatzy (previous post) should also be fixed.

Please let me know if this fixes indeed solves some problems you were having.

Frank

sellars
2008-01-04, 18:25
Hi,
thanks for the "new" beta 4 - I am not getting the error anymore regarding the script that slows down my computer.

Great work - and lots of opportunities for additional features :)

agentsmith
2008-01-04, 21:40
I downloaded and installed the MySQL connector into my Vista machine.

When trying to run the script, the GUI comes up, when I pressed Start, I got the error:
---------------------------------
"An error occured while connection to the database, the error data is printed below:
Error Number: 0
Error Description:"
----------------------------------

Squeezecenter is started with the following info:

----------------------------------
SqueezeCenter Version: 7.0 - 15013 - Windows Vista - EN - cp1252
Server IP address: 192.168.0.101
Perl Version: 5.8.8 MSWin32-x86-multi-thread
MySQL Version: 5.0.22-community-nt

---------------------------------

Any idea what the problem is? Does the SQL connector need to be started manually? I cannot find a start option for it.

SilverRS8
2008-01-05, 00:05
I downloaded and installed the MySQL connector into my Vista machine.

When trying to run the script, the GUI comes up, when I pressed Start, I got the error:
---------------------------------
"An error occured while connection to the database, the error data is printed below:
Error Number: 0
Error Description:"
----------------------------------

Squeezecenter is started with the following info:

----------------------------------
SqueezeCenter Version: 7.0 - 15013 - Windows Vista - EN - cp1252
Server IP address: 192.168.0.101
Perl Version: 5.8.8 MSWin32-x86-multi-thread
MySQL Version: 5.0.22-community-nt

---------------------------------

Any idea what the problem is? Does the SQL connector need to be started manually? I cannot find a start option for it.

The script is developed on SlimServer 6.5 and only tested on SlimServer 6.5 (SC not supported yet). I don't know how it will react on SqueezeCenter. Judging from this thread it does work sometimes but also often there are sql connect problems.

When most of the debugging on 6.5 has been done i will start to make it compatible with SC.

Frank

scalesr1
2008-01-05, 00:40
Just tried the latest version - superb - thanks again for all the hard work.

Please could you confirm the operation of the 'Various Artists' function?

Would I be right in thinking that if I collated all my 'Various Artist'
style albums into one folder, performed a re-scan in SS then ran your script
specifying the various artist folders - then it would simply show the album
once in your list and not split it out for each artist? If so, I shall
attend to some file housekeeping and make it so!

Now, it may be beyond the capability of the environment which your script is
written in but it would be an absolute killer app for me if it were to
locate and download (perhaps with some user interaction) any missing
artwork!

Thanks again,

Richard Scales




-----Original Message-----
From: discuss-bounces (AT) lists (DOT) slimdevices.com
[mailto:discuss-bounces (AT) lists (DOT) slimdevices.com] On Behalf Of SilverRS8
Sent: 04 January 2008 19:48
To: discuss (AT) lists (DOT) slimdevices.com
Subject: Re: [slim] Announce: Album Catalog Creator for SlimServer


I just posted Beta 4 on http://www.vanholt.nl/acc/acc.htm

The following changes are made:
FIXED: Album cover not displayed if album path name contains non alpha
numeric chars
FIXED: Script hangs when an album path containing non alpha numeric
chars was selected as starting folder
FIXED: Very last album was never included in the catalog
FIXED: Album counter did not refect the actual processed albums
FIXED: The very last line of albums in the catalog were followed by
empty dummy albums with no album cover
ADDED: acc.log file created on every run

Album covers should now be displayed correctly even if there are non
alpha numeric chars in the path name.

Please let me know if this fixes indeed solves some problems you were
having.

Frank


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

SilverRS8
2008-01-05, 00:55
Just tried the latest version - superb - thanks again for all the hard work.

Please could you confirm the operation of the 'Various Artists' function?

Would I be right in thinking that if I collated all my 'Various Artist'
style albums into one folder, performed a re-scan in SS then ran your script
specifying the various artist folders - then it would simply show the album
once in your list and not split it out for each artist? If so, I shall
attend to some file housekeeping and make it so!

Thx. Glad you like it.
Yep. When all compilations are under one folder, rescanned by SS they and this folder is selected as Compilation folder in ACC they are displayed correctly.

SS itself also attempts to automatically categorize albums on if they are compilation albums but it also does this for artist album on which various guest artists perform. So putting them in a seperate folder is the only way it would really go well. Thats why I added this feature.


Now, it may be beyond the capability of the environment which your script is
written in but it would be an absolute killer app for me if it were to
locate and download (perhaps with some user interaction) any missing
artwork!

That actually is a really good idea. I'll take a look how the Amazon SOAP interface works and if I can talk to it from the script.

Frank

Siduhe
2008-01-05, 01:25
I downloaded and installed the MySQL connector into my Vista machine.

When trying to run the script, the GUI comes up, when I pressed Start, I got the error:
---------------------------------
"An error occured while connection to the database, the error data is printed below:
Error Number: 0
Error Description:"
----------------------------------

You can try my solution which is working for me with SC7 and an XP Pro box (but not for others with a similar setup):

http://forums.slimdevices.com/showpost.php?p=253924&postcount=64

Chautara
2008-01-05, 02:25
Fantastic utility - it's just what I've been looking for! Beta 4 solves all the problems I was having with album art but one problem remains.

My SS database contains both MP3 and WMA files which SS handles perfectly well in terms of displaying Tag details, however ACC will not display the Artist from WMA files. Any ideas?

SilverRS8
2008-01-05, 02:51
Fantastic utility - it's just what I've been looking for! Beta 4 solves all the problems I was having with album art but one problem remains.

My SS database contains both MP3 and WMA files which SS handles perfectly well in terms of displaying Tag details, however ACC will not display the Artist from WMA files. Any ideas?

EDIT: I did some investigation and it seems this is indeed a bug in the script. I think it will be solved somewhere tomorrow. I'll post it as new Beta

Frank

Phil Leigh
2008-01-05, 02:56
I downloaded and installed the MySQL connector into my Vista machine.

When trying to run the script, the GUI comes up, when I pressed Start, I got the error:
---------------------------------
"An error occured while connection to the database, the error data is printed below:
Error Number: 0
Error Description:"
----------------------------------

Squeezecenter is started with the following info:

----------------------------------
SqueezeCenter Version: 7.0 - 15013 - Windows Vista - EN - cp1252
Server IP address: 192.168.0.101
Perl Version: 5.8.8 MSWin32-x86-multi-thread
MySQL Version: 5.0.22-community-nt

---------------------------------

Any idea what the problem is? Does the SQL connector need to be started manually? I cannot find a start option for it.

I have the same issue under XP - and unlike Siduhe, changing the UID to "squeezecenter" doesn't fix the problem.

This is where the error is generated:


'Open connection with SlimServer DB
Set rs = CreateObject("ADODB.Recordset")
rs.ActiveConnection = ConnectString
rs.CursorType = adOpenKeyset 'Use openkeyset cursor to enable cursor movement
If err.number = -2147467259 then
on error goto 0
msgbox "Error connecting to SlimServer database." & vbcrlf &_
"The required mySQL ODBC driver is not installed or is not set to use the default credentials. Refer to Help screen for more information on mySQL ODBC driver download and installation" & vbcrlf & vbcrlf &_
"Click OK to quit script."
self.close
Elseif err.number Then
on error goto 0
msgbox "An error occured while connection to the database. The error data is printed below." & vbcrlf &_
"Error number: " & err.number & vbcrlf &_
"Error description: " & err.description & vbcrlf & vbcrlf &_
"Click OK to quit script."
self.close
End If


The error (which is not trapped by the code at the moment) is 3706 which is associated with the SQL ODBC driver not being installed correctly...but it appears to be OK as far as I can test it. The XP admin tools test out ok for this driver. Not sure how to debug it further.

I am only posting this to help Frank in his testing of the SC7 version.

Chewie
2008-01-05, 08:42
Iíve just tried it again using acc-v1-b4 and the script now runs for 20 Seconds before I get the announcement.

Stop running this script?

" a script on this page is causing internet explorer to run slowly if it continues to run your computer may become unresponsive

SlimServer Version: 6.5.4 - 12568 - Windows XP - EN - cp1252
Server IP address: 192.168.1.66
Perl Version: 5.8.8 MSWin32-x86-multi-thread
MySQL Version: 5.0.22-community-nt

Phil Leigh
2008-01-05, 10:47
Some encouraging progress:
Using Beta 4, I uninstalled the MS MDAC components and reinstalled. The script is now working! Obviously the ODBC drivers were not registered properly for some reason on my system.
However, it does take a VERY long time to run...I can hear the hard disk thrashing. (2500 albums over 3 drives...)
After an hour I stopped the mshta process and restarted, pointing the script at a directory with just three albums in it (E:\ABBA) - still took "ages" but did finish and did produce beautiful output - nice work!

I am now re-running at E:\... it's been running for about an hour...

SilverRS8
2008-01-05, 11:25
Some encouraging progress:
Using Beta 4, I uninstalled the MS MDAC components and reinstalled. The script is now working! Obviously the ODBC drivers were not registered properly for some reason on my system.
However, it does take a VERY long time to run...I can hear the hard disk thrashing. (2500 albums over 3 drives...)
After an hour I stopped the mshta process and restarted, pointing the script at a directory with just three albums in it (E:\ABBA) - still took "ages" but did finish and did produce beautiful output - nice work!

I am now re-running at E:\... it's been running for about an hour...

I will create additional debug logging in the next Beta to see which function is causing the delay. If you can send me that logfile I hope I can solve the problem. But again SC is not supported yet so I won't get into that much deeper until the debugging on SS has been done.

Just for performance comparison; 3200 tracks, 230 albums, with tracklisting only takes 20 seconds on my machine (AMD 3800+ X2) so for 2500 albums i would estimate a time of 250 seconds (little more than 4 minutes) would be required in your case.

It is however interesting to read you have several drives. Since natively SS only supports one drive I guess you use shortcuts to the two other drives? I think this may be the problem. It can be fixed ofcourse.

Frank

Phil Leigh
2008-01-05, 11:38
I will create additional debug logging in the next Beta to see which function is causing the delay. If you can send me that logfile I hope I can solve the problem. But again SC is not supported yet so I won't get into that much deeper until the debugging on SS has been done.

Just for performance comparison; 3200 tracks, 230 albums, with tracklisting only takes 20 seconds on my machine (AMD 3800+ X2) so for 2500 albums i would estimate a time of 250 seconds (little more than 4 minutes) would be required in your case.

It is however interesting to read you have several drives. Since natively SS only supports one drive I guess you use shortcuts to the two other drives? I think this may be the problem. It can be fixed ofcourse.

Frank
Frank,
Happy to supply you with the log file once that Beta is available.

Yes I have 3 drives (E:\ F:\ G:\), all referenced by a single folder on C:\ (C:\music) which has the three necessary shortcuts. This works fine under SC7 (never worked properly under 6.x for me).

Interestingly, it is the C:\drive - which has no music on it - that is being thrashed...
As always I'll be delighted to help you debug the script when you are ready.
Regards & Thanks
Phil

Phil Leigh
2008-01-05, 11:40
Sorry - that was a stupid observation by me...of course it is the C:\ drive that is being thrashed because that is where the SlimServer database is - doh!

SilverRS8
2008-01-05, 14:38
Fantastic utility - it's just what I've been looking for! Beta 4 solves all the problems I was having with album art but one problem remains.

My SS database contains both MP3 and WMA files which SS handles perfectly well in terms of displaying Tag details, however ACC will not display the Artist from WMA files. Any ideas?

I just posted Beta 5 on http://www.vanholt.nl/acc/acc.htm which has a fix for the WMA problem. Please let me know the outcome of your test.

Frank

SilverRS8
2008-01-05, 14:43
Frank,
Happy to supply you with the log file once that Beta is available.

Yes I have 3 drives (E:\ F:\ G:\), all referenced by a single folder on C:\ (C:\music) which has the three necessary shortcuts. This works fine under SC7 (never worked properly under 6.x for me).

Interestingly, it is the C:\drive - which has no music on it - that is being thrashed...
As always I'll be delighted to help you debug the script when you are ready.
Regards & Thanks
Phil

Phil, I just posted Beta 5 which contains some advanced logging for me to be able to troubleshoot some issues more easily. Can you send me the acc.log file through a PM.

Note: The logfile contains all album entries. I would be only interested in the path names especially the beginning of them because I would like to know how paths through shortcuts are actually stored in the database and what i need to do to make them work from the script. So if you want to strip any album info prior to sending me the logfile feel free but leave the specifics in there.

Frank

SilverRS8
2008-01-05, 14:47
Iíve just tried it again using acc-v1-b4 and the script now runs for 20 Seconds before I get the announcement.

Stop running this script?

" a script on this page is causing internet explorer to run slowly if it continues to run your computer may become unresponsive

SlimServer Version: 6.5.4 - 12568 - Windows XP - EN - cp1252
Server IP address: 192.168.1.66
Perl Version: 5.8.8 MSWin32-x86-multi-thread
MySQL Version: 5.0.22-community-nt

Can you download beta5 and send me the acc.log through a PM? also see the note in my previous post!

Frank

Chautara
2008-01-05, 15:44
I just posted Beta 5 on http://www.vanholt.nl/acc/acc.htm which has a fix for the WMA problem. Please let me know the outcome of your test.

Frank

Frank

I've just run a test with Beta 5 and at first glance everything looks great. Thanks for a great piece of work - I'm sure that a lot of folk will find ACC very useful! The icing on the cake would be if you were able to implement the earlier suggestion concerning album art!

RalphO
2008-01-05, 15:49
!)[/QUOTE]Now I get a "an error occurred while connection to the database" error
Error Number 0

The ODBC connector is installed so I guess it must be something to do with the connect string?
Regards
Phil

(PS Really looking forward to getting this running!)[/QUOTE]


I would really like to get this working as it is something that I have wanted for a long time. I am getting the same message Error Number 0. I am afraid that I do not have the knowledge to set up an ODBC connector or know if it is installed properly. I did download the MySQL as instructed at the start of the thread. Is there anywhere that will take me through this step by step? I did try to create a connector but I did not know what to input for items like the data source name etc. Any help would be welcome.

SilverRS8
2008-01-05, 16:00
I would really like to get this working as it is something that I have wanted for a long time. I am getting the same message Error Number 0. I am afraid that I do not have the knowledge to set up an ODBC connector or know if it is installed properly. I did download the MySQL as instructed at the start of the thread. Is there anywhere that will take me through this step by step? I did try to create a connector but I did not know what to input for items like the data source name etc. Any help would be welcome.

What version do you use? SlimServer 6.5 or SqueezeCenter? The latter is not supported yet because problems with the current version need to be resolved first. It will be supported in the very near future.

It should be enough to just install the mySQL ODBC connector but you should read the responses from Phil regarding problems you can encounter. He did some troubleshooting because the ODBC connector was not installed/registered correctly.

Frank

RalphO
2008-01-05, 16:22
What version do you use? SlimServer 6.5 or SqueezeCenter? The latter is not supported yet because problems with the current version need to be resolved first. It will be supported in the very near future.

It should be enough to just install the mySQL ODBC connector but you should read the responses from Phil regarding problems you can encounter. He did some troubleshooting because the ODBC connector was not installed/registered correctly.

Frank

I am using Slimserver version 6.5.4 on a windows XP machine. I will look through Phil's comments again to see if I can work out what is wrong.

Thanks

Phil Leigh
2008-01-06, 06:02
Hello - good news!
I realised my own stupid mistake which was to leave tracing enabled on the ODBC connector...so the disk access I was experiencing was in fact Windows writing to the log file!.
Now tracing is off and the script does indeed work quickly.

Further good news...because the script accesses the SlimServer/Squeezecenter database rather than the file system, it is quite happy with having music spread across multiple discs!.

To Ralph...

To be honest I'm not sure what I did to get things working.
i did install this:
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en


and then re-installed the mysql odbc connector
to test the connector, go to
settings - control panel - administrative tools
and double click on Data Sources (ODBC)
go to the System DSN tab and "add" the MySQL ODBC 3.51 Driver by creating a new Data Source.
set up as follows:
Data Source Name - anything you want
Description - leave blank
Server - localhost (or 127.0.0.1)
User - Squeezecenter
database - slimserver
on the Connect options tab, set port to 9092

Then press "test" - you should see a dialog box "Success; a connection was made!"

After that I restarted the machine...
If that doesn't work, then the MySQL driver is not installed.

SilverRS8
2008-01-06, 06:24
Hello - good news!
I realised my own stupid mistake which was to leave tracing enabled on the ODBC connector...so the disk access I was experiencing was in fact Windows writing to the log file!.
Now tracing is off and the script does indeed work quickly.

Further good news...because the script accesses the SlimServer/Squeezecenter database rather than the file system, it is quite happy with having music spread across multiple discs!.

Thx Phil for the update and good to hear everything works. Database Tracing can indeed have a high impact! Is the output also good?
I'm currently installing SC in a VM and if I like the current state I will move to SC also and then start making ACC compatible with SC.

Frank

Phil Leigh
2008-01-06, 07:52
Thx Phil for the update and good to hear everything works. Database Tracing can indeed have a high impact! Is the output also good?
I'm currently installing SC in a VM and if I like the current state I will move to SC also and then start making ACC compatible with SC.

Frank

Frank - yes the output is excellent - many thanks for all of your hard work.
I've made a couple of tweaks...
1) For compilations - but not normal albums it's nice to have the artist next to the track
2) for the durations, I've removed the leading zero which makes it easier to read (for me anyway)

If Left(rs("duration"),2) = "00" Then
sDuration = Right(rs("duration"), 5)
Else
sDuration = rs("duration")
End If
If left(sDuration,1)="0" Then
sDuration = Right(sDuration,4)
End If
If iType = 2 Then
sTracklisting = sTracklisting & rs("tracknumber") & " - " & rs("tracktitle") & " (" & sDuration & ")" &" - " & rs("artist")
Else
sTracklisting = sTracklisting & rs("tracknumber") & " - " & rs("tracktitle") & " (" & sDuration & ")"
End If
iTotalNumberOfTracks = iTotalNumberOfTracks + 1
iNumberOfTracks = iNumberOfTracks + 1

3) I've changed the album sort order to be year within artist which is the way (I think) most people organise their collections?
sQOrderBy = "order by artist,year,lcase(convert(albums.titlesort using utf8)),tracks.disc,tracks.tracknum;"


I have some issues with a handful of artworks, but I don't believe these are connected to your code.

The last piece of the jigsaw for me is to get the sort order for artists to ignore "The" so that "The Hollies" is under "H" not "T"...I'm not quite sure how to do that.

Again, many thanks
Phil

Kyle
2008-01-06, 07:57
Wow! This looks great! Any way to get a complete tutorial on getting this to work with SB 6.5*? Phil, is your post (8:02 today) fairly complete on everything that needs to be done?

Phil Leigh
2008-01-06, 08:13
Wow! This looks great! Any way to get a complete tutorial on getting this to work with SB 6.5*? Phil, is your post (8:02 today) fairly complete on everything that needs to be done?

Kyle - to be honest I'm not sure and I'm no expert on this!
My post was related to SC7 not SB 6.5, but the ODBC setup/testing is the same, except that the UID for 6.x is "slimserver" not "squeezecenter"...so the script as currently coded works fine under 6.x.

I think that several people are having a problem with the installation of the MySQL ODBC connector. This is a Windows issue.
Phil

Secret Squirrel
2008-01-06, 08:27
Frank,

I just downloaded and ran beta 5 on SC 7.0 with no problems. The results are fantastic in my opinion as I only have a straight vanilla database. I really wanted a printed catalog for family and friends.

Thanks for all the good work, amazingly fast turn-around on changes/corrections, and filling a much needed niche!

SS

SilverRS8
2008-01-06, 08:33
Frank - yes the output is excellent - many thanks for all of your hard work.
I've made a couple of tweaks...
1) For compilations - but not normal albums it's nice to have the artist next to the track
2) for the durations, I've removed the leading zero which makes it easier to read (for me anyway)

If Left(rs("duration"),2) = "00" Then
sDuration = Right(rs("duration"), 5)
Else
sDuration = rs("duration")
End If
If left(sDuration,1)="0" Then
sDuration = Right(sDuration,4)
End If
If iType = 2 Then
sTracklisting = sTracklisting & rs("tracknumber") & " - " & rs("tracktitle") & " (" & sDuration & ")" &" - " & rs("artist")
Else
sTracklisting = sTracklisting & rs("tracknumber") & " - " & rs("tracktitle") & " (" & sDuration & ")"
End If
iTotalNumberOfTracks = iTotalNumberOfTracks + 1
iNumberOfTracks = iNumberOfTracks + 1

3) I've changed the album sort order to be year within artist which is the way (I think) most people organise their collections?
sQOrderBy = "order by artist,year,lcase(convert(albums.titlesort using utf8)),tracks.disc,tracks.tracknum;"

Good comment. Escpecially (1). That is how it should be. I'll change it too in my code for next releases.


The last piece of the jigsaw for me is to get the sort order for artists to ignore "The" so that "The Hollies" is under "H" not "T"...I'm not quite sure how to do that.

I have been thinking about how to do this. I think the easiest way is to create a so called 'disconnected recordset' (a new recordset, not connected to the database but only available inside the code. This recordset can be used to copy all content of the database query to but without the keywords to be stripped ('The' etc).
After this one can apply all sorting options on the disconnected recordset like you normally can.
It should be better to do all this direct from the query to the database and hence without the disconnected recordset but my SQL knowledge is not that good to determine if this is possible to do in query.

Frank

Phil Leigh
2008-01-06, 08:42
Frank - I don't think you can do this directly within the SQL query. You would have to parse the result set to strip out the leading "noise" words and then re-sort.



Regards
Phil

RalphO
2008-01-06, 09:35
To Ralph...

To be honest I'm not sure what I did to get things working.
i did install this:
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en


and then re-installed the mysql odbc connector
to test the connector, go to
settings - control panel - administrative tools
and double click on Data Sources (ODBC)
go to the System DSN tab and "add" the MySQL ODBC 3.51 Driver by creating a new Data Source.
set up as follows:
Data Source Name - anything you want
Description - leave blank
Server - localhost (or 127.0.0.1)
User - Squeezecenter
database - slimserver
on the Connect options tab, set port to 9092

Then press "test" - you should see a dialog box "Success; a connection was made!"

After that I restarted the machine...
If that doesn't work, then the MySQL driver is not installed.


I really appreciate all of the help that you guys are giving. However, I still cannot get past the MySQL connect issue. I have tried re-installing and tried to download the microsoft utility but with no success. When I test the connection it gives an error message saying it can't connect to MySQL. When I tried to download and install the microsoft utility it said that it was incompatible for my version of windows and something along the lines that I had all of the parts needed.

Anymore help would be greatly appreciated.

RalphO
2008-01-06, 09:56
I can report that I have managed to get the ODBC connection to work. I fiddled around a bit and what finally worked was that I ttok out the ip address of my server and just left it blank (I guess that it uses the default. Anyway that gave me the wonderful message "success a connection was made".

I am sorry to say that I still cannot get ACC to work. I am still gettinmg error number 0. I have tried using ACC V3, 4 & 5 and I have tried a reboot. I also checked that tracing was not running.

Any other suggestions would be appreciated.

Phil Leigh
2008-01-06, 10:41
I can report that I have managed to get the ODBC connection to work. I fiddled around a bit and what finally worked was that I ttok out the ip address of my server and just left it blank (I guess that it uses the default. Anyway that gave me the wonderful message "success a connection was made".

I am sorry to say that I still cannot get ACC to work. I am still gettinmg error number 0. I have tried using ACC V3, 4 & 5 and I have tried a reboot. I also checked that tracing was not running.

Any other suggestions would be appreciated.

Ralph - this was where I was some time yesterday PM.
I wish I could give you a simple solution.
You now have the ODBC connector working which is a step forward.

I suspect you are now actually getting the 3706 error (but you can't see that - needs a slight coding change to reveal that error code). This is indicative of a registry / driver registration problem. I think you should try to re-register the OLE ADO components.
To do this, go to C:\program files\common files\system\ole db

and then for each .dll file in there, use regsvr32 (from a command window) to re-register each dll.

Go to Start - Run
type CMD
type regsvr32 msdadc.dll (and repeat for each .dll file)
Then reboot!

Hope this fixes it for you
regards
Phil

PS I don't know why this would work - but it is what I did.

This

SilverRS8
2008-01-06, 11:50
I can report that I have managed to get the ODBC connection to work. I fiddled around a bit and what finally worked was that I ttok out the ip address of my server and just left it blank (I guess that it uses the default. Anyway that gave me the wonderful message "success a connection was made".

I am sorry to say that I still cannot get ACC to work. I am still gettinmg error number 0. I have tried using ACC V3, 4 & 5 and I have tried a reboot. I also checked that tracing was not running.

Any other suggestions would be appreciated.

The server should be specified and can either be 127.0.0.1 or localhost.

What you can also do is try to connect using the mySQL query browser at http://dev.mysql.com/downloads/gui-tools/5.0.html

You can use this to connect to the mySQL DB using a more ituitive GUI and you probably get a more detailed error message when it still goes wrong.
Once you have installed it, run it and specify the connect data as in the attached screenshot. It the connect succeeds, you can browse through the table structure and create a query if you like to retrieve some data (but that is what the script is doing for you).

If this still doesn't work, try removing an reinstalling slimserver as this will also reinstalla and register the mySQL DB.

Hope this can be of any help.

Frank

Phil Leigh
2008-01-07, 08:14
Frank - this might be the basis for solving the "The " problem...
SELECT
IF ( LEFT(artist, 4)='The ', SUBSTRING(artist FROM 4), artist ) AS
artist_sort_name
FROM <table>

ORDER BY artist_sort_name

or something like that...

I'll try it later - my MySql is not strong.
regards
Phil

Mongo
2008-01-07, 09:00
I also had the error "0" return, after setting up mysql successfuly ( and testing it). I had downloaded and extracted the program to a folder in program files. It would not work. I tried running the album catalogue program in it's original zipped format from my desktop and it worked. Maybe there is a clue here as to the real problem for those with the error "0" return.

slimkid
2008-01-07, 09:30
Would it be possible to extend the functionality to include the ability to use album artist/band tag where the album is a compilation - in a similar way how SS does it right now?

thks

SilverRS8
2008-01-07, 09:32
Wow! This looks great! Any way to get a complete tutorial on getting this to work with SB 6.5*? Phil, is your post (8:02 today) fairly complete on everything that needs to be done?

It should really be that easy as installing the ODBC driver and than run the script. For help regarding the ACC tool itself, the help screen should address most questions.

Windows machines sometimes do have problems with the ODBC driver and then the steps of Phil can be very helpfull.

Frank

SilverRS8
2008-01-07, 09:44
Would it be possible to extend the functionality to include the ability to use album artist/band tag where the album is a compilation - in a similar way how SS does it right now?

thks

Sure. That is the change that Phil (with code snippet) has done and how it should work. I'll put this into my code and post it this evening (it now 17.45 here) as download.

Frank

Phil Leigh
2008-01-07, 10:15
Frank - cracked the "The " problem...

two blocks of code changes:

1):

sQBase = "select IF ( LEFT( contributors.name, 4)='The ', SUBSTRING(contributors.name FROM 5), contributors.name) AS sort_name, " &_
"CONVERT(contributors.name USING utf8) as artist,CONVERT(albums.title USING utf8) as album,albums.year AS year, tracks.url AS filepath, tracks.tracknum AS tracknumber, " &_
"CONVERT(tracks.title USING UTF8) as tracktitle,CONVERT(SEC_TO_TIME(tracks.secs),CHAR) as duration, genres.namesort AS 'genre' " &_
"from tracks " &_


2):


If iSortby = 1 then
sQOrderBy = "order by sort_name,year,lcase(convert(albums.titlesort using utf8)),tracks.disc,tracks.tracknum;"
Elseif iSortby = 2 then
sQOrderBy = "order by lcase(convert(albums.titlesort using utf8)),sort_name,tracks.disc,tracks.tracknum;"
Else
sQOrderBy = "order by genre,sort_name,lcase(convert(albums.titlesort using utf8)),tracks.disc,tracks.tracknum;"
End If


Works great! (but there is a performance drop because the sort_name column is not indexed so the "order by clause" is slow...but not too bad with 28,000 tracks)
Regards
Phil

SilverRS8
2008-01-07, 11:39
Would it be possible to extend the functionality to include the ability to use album artist/band tag where the album is a compilation - in a similar way how SS does it right now?

thks

I just posted Release candidate 1 on http://www.vanholt.nl/acc/acc.htm. I think it is quiet stable now. The only real problems around concenr the installing are correct functioning of the mySQL ODBC driver.

Changes:
FIXED:Display Artist name in tracklisting for 'Various Artist' albums
ADDED:Sorting by year inside artist albums (newest album first)
CHANGED:Removed leading zero in front of track duration times

A big thanks to Phil Leigh for his suggestions in a previous post. These are now incorporated.

Frank

SilverRS8
2008-01-07, 11:46
Frank - cracked the "The " problem...
two blocks of code changes:
1):
sQBase = "select IF ( LEFT( contributors.name, 4)='The ', SUBSTRING(contributors.name FROM 5), contributors.name) AS sort_name, " &_
"CONVERT(contributors.name USING utf8) as artist,CONVERT(albums.title USING utf8) as album,albums.year AS year, tracks.url AS filepath, tracks.tracknum AS tracknumber, " &_
"CONVERT(tracks.title USING UTF8) as tracktitle,CONVERT(SEC_TO_TIME(tracks.secs),CHAR) as duration, genres.namesort AS 'genre' " &_
"from tracks " &_

2):
If iSortby = 1 then
sQOrderBy = "order by sort_name,year,lcase(convert(albums.titlesort using utf8)),tracks.disc,tracks.tracknum;"
Elseif iSortby = 2 then
sQOrderBy = "order by lcase(convert(albums.titlesort using utf8)),sort_name,tracks.disc,tracks.tracknum;"
Else
sQOrderBy = "order by genre,sort_name,lcase(convert(albums.titlesort using utf8)),tracks.disc,tracks.tracknum;"
End If

Works great! (but there is a performance drop because the sort_name column is not indexed so the "order by clause" is slow...but not too bad with 28,000 tracks)
Regards
Phil

Hi Phil,

Very good job done!! I look into it later and do some testing but very good to know that it can be done in a query. Personally i'm still strugling if I like 'The' to be stripped or not when sorting because I think I will look for bands at the 'T' when searching for e.g. 'The Killers'. Maybe other thread readers can give their opinion on this too?

I just posted release candidate 1 with your previous suggestions. I only changed the album sort to newest album first instead of oldest first. I think this is more logical but ofcourse that is a personal preference.

Thx again for your good work !!

Frank

Phil Leigh
2008-01-07, 12:08
Hi Phil,

Very good job done!! I look into it later and do some testing but very good to know that it can be done in a query. Personally i'm still strugling if I like 'The' to be stripped or not when sorting because I think I will look for bands at the 'T' when searching for e.g. 'The Killers'. Maybe other thread readers can give their opinion on this too?

I just posted release candidate 1 with your previous suggestions. I only changed the album sort to newest album first instead of oldest first. I think this is more logical but ofcourse that is a personal preference.

Thx again for your good work !!

Frank

Frank it is a pleasure to collaborate with you! - you did all the hard work without which none of this would be possible

Maybe the "the" problem could be a user choice? ... also, anyone with albums by The The is ALWAYS going to have a problem :o).

Some people will want the artist name to not show "the" in the final display...that could be switchable too.
as for year within artist - I've always sorted my vinyl/cd's as chronological sequence within artist...maybe a few other people should give their opinion?

Have a great evening
Phil

Siduhe
2008-01-07, 13:43
Personally i'm still strugling if I like 'The' to be stripped or not when sorting because I think I will look for bands at the 'T' when searching for e.g. 'The Killers'. Maybe other thread readers can give their opinion on this too?

Caveat - I have a lot of compilation albums (>60%) so I rarely sort by artist. However, I've got quite a few albums that begin with "The". I have SC set to ignore "The" when sorting, but I actually think I would like Album Catalogue Creator to follow the precise format rather than ignore the first word.

As Phil says, an option to do either would be ideal, but if I had to pick one, I'd go with "as titled".

Phil Leigh
2008-01-07, 15:05
Caveat - I have a lot of compilation albums (>60%) so I rarely sort by artist. However, I've got quite a few albums that begin with "The". I have SC set to ignore "The" when sorting, but I actually think I would like Album Catalogue Creator to follow the precise format rather than ignore the first word.

As Phil says, an option to do either would be ideal, but if I had to pick one, I'd go with "as titled".

Siduhe - I was only talking about artist, not album title (which I agree should never be changed). But I think an option is the best approach.
Phil

schatzy
2008-01-07, 15:19
SilverRS8,

Thanks for all the great work over the week end on this.

Phil, Siduhe,

Thanks for all the work you guys have done also.

"THE" I feel should be user selection for the artist not the Album title. But then again what about "THE THE". As Phil has stated it will always be a problem. I had forgotten about them and now i am curious how SS 6.5 and SC7 handle it, have not listened to them lately.

As for the Year in the Title. I have always sorted by albums/CD's/Tapes alphabetically but all my MP3's/FLAC's are by year in the album folder name "c:\\mp3\artist\(1997)Album Title". Not sure why I did it that way. But it does make it easier to follow the artist by musical progression. Mya be it should also be a selection. Although to many selections may make it overwhelming for some people.

Just my 2 cents.

Schatzy

RalphO
2008-01-07, 17:12
The server should be specified and can either be 127.0.0.1 or localhost.

What you can also do is try to connect using the mySQL query browser at http://dev.mysql.com/downloads/gui-tools/5.0.html

You can use this to connect to the mySQL DB using a more ituitive GUI and you probably get a more detailed error message when it still goes wrong.
Once you have installed it, run it and specify the connect data as in the attached screenshot. It the connect succeeds, you can browse through the table structure and create a query if you like to retrieve some data (but that is what the script is doing for you).

If this still doesn't work, try removing an reinstalling slimserver as this will also reinstalla and register the mySQL DB.

Hope this can be of any help.

Frank

As I have got the ODBC connector to work okay now I am not sure that this will help me.

tamanaco
2008-01-07, 17:16
Lots of changes around here. I was gone for a couple days and we got the Duet and ACC is up to beta 5!

I just tested beta 5 and I'm still having issues with album art not showing up for albums whose Genre, Artist or Album name have extended characters in their path. For example all of the Albums under the Genre R&B are missing the album art.

I noticed that the order of the tracks for albums with more than 10 Tracks is not ordered. All my tracks are named xx. trackname.flac. Where xx = 01-99.

When I select to sort by Album... is it possible to set it so that is sorted by Genre (Alphabetically) and within each Genre by Artist (Alphabetically). I find the layout when sorting by Artists is a bit wasteful. I organized my Library without a common folder for albums with Various Artists. See example below. (Lines below represents a folder and subfolder)

World
_____Putumayo Presents (Various Artists Compilations)
__________ Album Name 1
__________ Album Name 2
.
.
.
__________ Album Name n

I set up my ripper so that the folder structure for all my albums including albums with "Various Artists" is created using the following format.
[genre]\[Album Artist]\[Album Name]\[track]. [title]

I the case above "Putumayo Presents (Various Artists Compilations)" is the [Album Artist] and then each track within each [Album Name] is tagged with its respective [Artist].

For non-compilation albums [Album Artist] = [Artist]

Another thing, what about splitting the albums after a certain number of tracks. A DJ gave me a bunch of CD Mixes and I ripped all the CDs to the same folder... The DJ Mix folder has about 45 tracks numbered 1 to 45. I used track offset as I ripped each subsequent CD and I used the DJ's logo as the Album Art for all 45 song. So the Album is named DJ Mix and each track has the artist name associated with it. If I could set ACC to limit the number of tracks per album and to continue with the next song and with the same album cover in the next column it would be nice. Btw, I believe this might be to much trouble to implement, but I just wanted to put it out there.

Thanks again

nspindel
2008-01-07, 17:48
Hi Frank -

Great idea for a script.

I'm running it on my server with SC 6.5.4. It runs to the point where it finds all of the music, but I don't have any cover art displayed. I think I may know the issue, just not sure what to do about it.

My music is all stored on a TeraStation, and I have a drive mapped on my server to the share location where the top of the music folder structure is. In Windows Explorer, I am able to refer to this mapped drive without any issues. However, for some reason I am not able to use the mapped drive in SC. I need to set the music location in the server settings to the fully qualified path - \\terastation\share\music\musiclibrary, as opposed to M:\MusicLibrary.

I suspect that your script is only compatible with a mapped drive format, not fully qualified paths. So you're able to extract the genre/artist/album/title info from the mysql database, but then you aren't able to find the cover art due to the fully qualified path issue.

So either:

1) I need to figure out why the heck SC won't recognize a drive mapped to a network share, or
2) If it's a known issue that SC can't use such mapped drives, then perhaps your script could be made compatible with fully qualified paths.

Thanks....

RalphO
2008-01-07, 19:09
Go to Start - Run
type CMD
type regsvr32 msdadc.dll (and repeat for each .dll file)
Then reboot!

This

Phil

I tried this but found that there were some dll files that I could not re-register. The message said that the dll file loaded but the DIRewgister entry point was not found. Thjis file can not be regisitered.

I am not sure whethjer this is my problem or not.

RalphO
2008-01-07, 19:18
I also had the error "0" return, after setting up mysql successfuly ( and testing it). I had downloaded and extracted the program to a folder in program files. It would not work. I tried running the album catalogue program in it's original zipped format from my desktop and it worked. Maybe there is a clue here as to the real problem for those with the error "0" return.

Mongo

I too tried this. I did not get the program to run but I did not get thge error 0. In fact I got the previously reported Script is making Internet Explorer run slow. I am very surprised that this made a difference.

nspindel
2008-01-07, 20:01
I did some research on the threads and figured out what I needed to do in order to get the mapped drives to work. However this then triggered the script running will cause the system to run slow error from Internet Explorer that has been widely reported. I saw a post saying to try running Beta 3 to get rid of this problem, but I no longer see that as an active link. FYI, I'm running your RC1.

Thanks.

SilverRS8
2008-01-08, 01:18
Lots of changes around here. I was gone for a couple days and we got the Duet and ACC is up to beta 5!

I just tested beta 5 and I'm still having issues with album art not showing up for albums whose Genre, Artist or Album name have extended characters in their path. For example all of the Albums under the Genre R&B are missing the album art.

I'll fix this today and post an update.


I noticed that the order of the tracks for albums with more than 10 Tracks is not ordered. All my tracks are named xx. trackname.flac. Where xx = 01-99.

The sorting is done by mySQL. Getting the sorting into the code, as first guess, would be a lot of work. Personally I have al my tracks numbered without a leading '0'. Using Tag&Rename this is one click of a button for all the tracks you have. Maybe a quick workaround?


When I select to sort by Album... is it possible to set it so that is sorted by Genre (Alphabetically) and within each Genre by Artist (Alphabetically). I find the layout when sorting by Artists is a bit wasteful. I organized my Library without a common folder for albums with Various Artists. See example below. (Lines below represents a folder and subfolder)

I think sorting by album and then artist is most common but it is noted as feature request vor future versions. I'm thinking to implement several levels of sorting in the GUI.


World
_____Putumayo Presents (Various Artists Compilations)
__________ Album Name 1
__________ Album Name 2
.
.
.
__________ Album Name n

I set up my ripper so that the folder structure for all my albums including albums with "Various Artists" is created using the following format.
[genre]\[Album Artist]\[Album Name]\[track]. [title]

I the case above "Putumayo Presents (Various Artists Compilations)" is the [Album Artist] and then each track within each [Album Name] is tagged with its respective [Artist].

For non-compilation albums [Album Artist] = [Artist]

Ofcourse everything could be implemented but this would be too user specific to implement as general solution. The way the internal SS/SC compilation detection works is unuseable. A single Artist with multiple guest appearances will be detected as compilation album. The only way to cope with this is to use a folder structure for it. Using a 'various artist' folder is, I think, the most applicable for general usage.


Another thing, what about splitting the albums after a certain number of tracks. A DJ gave me a bunch of CD Mixes and I ripped all the CDs to the same folder... The DJ Mix folder has about 45 tracks numbered 1 to 45. I used track offset as I ripped each subsequent CD and I used the DJ's logo as the Album Art for all 45 song. So the Album is named DJ Mix and each track has the artist name associated with it. If I could set ACC to limit the number of tracks per album and to continue with the next song and with the same album cover in the next column it would be nice. Btw, I believe this might be to much trouble to implement, but I just wanted to put it out there.

Thanks again

I can image this request but I can also image that this would be confusing because at first site it would illustrate that there are multple albums where there is just 1. But this ofcourse may be my personal preference.

Frank

SilverRS8
2008-01-08, 01:20
Caveat - I have a lot of compilation albums (>60%) so I rarely sort by artist. However, I've got quite a few albums that begin with "The". I have SC set to ignore "The" when sorting, but I actually think I would like Album Catalogue Creator to follow the precise format rather than ignore the first word.

As Phil says, an option to do either would be ideal, but if I had to pick one, I'd go with "as titled".

I think the best is indeed to implement is as option. I'll look into it but am not sure if this will be in the v1.0 version or it will be the v1.1 version. The latter would mean v1.0 has to be ready for 'release' first.

Frank

SilverRS8
2008-01-08, 01:25
SilverRS8,

Thanks for all the great work over the week end on this.

Phil, Siduhe,

Thanks for all the work you guys have done also.

"THE" I feel should be user selection for the artist not the Album title. But then again what about "THE THE". As Phil has stated it will always be a problem. I had forgotten about them and now i am curious how SS 6.5 and SC7 handle it, have not listened to them lately.

You're really welcome. Glad a lot of you like the application :-)It should be easy to let the script just scan for the word 'The<space>' in the first four characters.


As for the Year in the Title. I have always sorted by albums/CD's/Tapes alphabetically but all my MP3's/FLAC's are by year in the album folder name "c:\\mp3\artist\(1997)Album Title". Not sure why I did it that way. But it does make it easier to follow the artist by musical progression. Mya be it should also be a selection. Although to many selections may make it overwhelming for some people.

Just my 2 cents.

Schatzy

Acsending/descending sorting based on 'Year' will be made an option in the future. I think this is a very general option which should be changeable easy because of its personal character.

Frank

SilverRS8
2008-01-08, 01:31
I did some research on the threads and figured out what I needed to do in order to get the mapped drives to work. However this then triggered the script running will cause the system to run slow error from Internet Explorer that has been widely reported. I saw a post saying to try running Beta 3 to get rid of this problem, but I no longer see that as an active link. FYI, I'm running your RC1.

Thanks.

The script will take the path reference stored in the database and look for album art in that path.

So is your path reference stored in the DB is e.g. E:\music\<artist>\<album> than that exact path should also be available from the computer ACC is running from. It shoul be an easy change to have ACC look at another drive letter but that would, again, be too user specific to implement as general option (at least for version 1 of ACC). But if you need help on where to change this, let me know.

Frank

nspindel
2008-01-08, 04:47
I think I got that end sorted out. There was a thread that documented what I needed to do to get drive mappings to network shares to work. So now I'm able to set SC to look at M:\MusicLibrary rather than \\terastation\share\music\MusicLibrary.

The problem now is that once I made that change, I started getting that "script running will cause computer to run slow" error every 30 seconds. Not sure how to work around that.

SilverRS8
2008-01-08, 05:31
I think I got that end sorted out. There was a thread that documented what I needed to do to get drive mappings to network shares to work. So now I'm able to set SC to look at M:\MusicLibrary rather than \\terastation\share\music\MusicLibrary.

The problem now is that once I made that change, I started getting that "script running will cause computer to run slow" error every 30 seconds. Not sure how to work around that.

The drive mapping is OK but are the paths stored in the database identical? I mean I can image that they are stored on an other drive letter because the SC is running on a remote machine and hence does probably have other drive mappings. You can easily check with the mySQL Query browser and query the contents of the slimserver.tracks table.

Frank

tamanaco
2008-01-08, 06:22
I'll fix this today and post an update.
Thanks... I'll be looking for it.



The sorting is done by mySQL. Getting the sorting into the code, as first guess, would be a lot of work. Personally I have al my tracks numbered without a leading '0'. Using Tag&Rename this is one click of a button for all the tracks you have. Maybe a quick workaround?

I thought you were using data already massaged by SC. They appear in the Web UI from SC ordered and without the leading zeros. I'll think about implementing your work around.




I think sorting by album and then artist is most common but it is noted as feature request vor future versions. I'm thinking to implement several levels of sorting in the GUI.

Great.



Ofcourse everything could be implemented but this would be too user specific to implement as general solution. The way the internal SS/SC compilation detection works is unuseable. A single Artist with multiple guest appearances will be detected as compilation album. The only way to cope with this is to use a folder structure for it. Using a 'various artist' folder is, I think, the most applicable for general usage.

I agree with your assessment about this request being too user specific. Using tags I usually search by [Artist Name] or [Album Name] When I search by [Genre] the folder structure I use simplifies things for me. I have a lot of World music and I have problems searching by [Artist Name] because I can't remember or spell the name of most of the Artists and/or albums. Also, most of my World music is from compilation albums for a specific music style, from a specific geographic area or from a specific record company. So, in the [Album Artist] tag from which the folder structure is create, I incorporate the style of music, geographic area or record company name.



I can image this request but I can also image that this would be confusing because at first site it would illustrate that there are multple albums where there is just 1. But this ofcourse may be my personal preference.
Frank
Agreed... again, as you said, user specific.

parubini
2008-01-08, 06:58
Hi,

I have already made some mod's to ACC-RC1 to allow a mapped drive to work, using a SlimServer hosted on another (Linux) machine. Within the ACC script it is necessary to swap the slimserver local path to files (as stored in the DB) with the mapped drive as seen by ACC - in my case from /home/user1/Music to x:\Music. Only a few lines to change. This works ok though I still have an outstanding bug with the Compilation Folder and First Folder which does cause the running slow error. When fixed this evening I will post my contribution in case this helps.

Phil. R.

SilverRS8
2008-01-08, 07:03
Hi,

I have already made some mod's to ACC-RC1 to allow a mapped drive to work, using a SlimServer hosted on another (Linux) machine. Within the ACC script it is necessary to swap the slimserver local path to files (as stored in the DB) with the mapped drive as seen by ACC - in my case from /home/user1/Music to x:\Music. Only a few lines to change. This works ok though I still have an outstanding bug with the Compilation Folder and First Folder which does cause the running slow error. When fixed this evening I will post my contribution in case this helps.

Phil. R.

Great work. Let me know the outcome of your fixes.
Schatzy has done some thorough testing regarding the 'running slow' issue which helped me to pinpoint the problem. I hope to have a fix for this this evening but Schatzy is going to test this prior to releasing it as fix. It only becomes an issue with very large collections and is related to the redimensioning with preserve option of the album array.

Frank

Phil Leigh
2008-01-08, 07:49
I noticed that the order of the tracks for albums with more than 10 Tracks is not ordered. All my tracks are named xx. trackname.flac. Where xx = 01-99.




Hmmm - I have lost of albums with > 10 tracks - some with >90! and they all sort fine. My track files are named slightly differently: 01 - trackname.FLAC, 02 - trackname.FLAC. However, that shouldn't matter because the script uses the track number tag in the the SC/SS database. As Frank suggested, you should use tag & rename (and complete rescan) to ensure the tracknumber tags are correct before proceeding further.

tamanaco
2008-01-08, 07:59
Hmmm - I have lost of albums with > 10 tracks - some with >90! and they all sort fine. My track files are named slightly differently: 01 - trackname.FLAC, 02 - trackname.FLAC. However, that shouldn't matter because the script uses the track number tag in the the SC/SS database. As Frank suggested, you should use tag & rename (and complete rescan) to ensure the tracknumber tags are correct before proceeding further.

If the tags were the problem, I would also see this problem with the ordering of the tracks in the SC web interface. I don't have such sorting problem with my existing tags there. As I said before, isn't the data used for ACC already massaged by SC/MySQL?

schatzy
2008-01-08, 10:39
tamanaco,

Are you using SC7 or SS 6.5.4?

I have many albums with > 10 tracks and they seem to work fine.

I have found that there are many differences in the way SC7 and SC work with special characters including the "." if your track numbers have any inconsistency especially if there happens to be a rouge space in there somewhere then it seems to throw off a lot of other listings even from other albums.

I have a few files (30-40) that are giving me problems and i am doing some very extensive testing before attempting to do write a bug report. And i also see that some of the problems i have been having have been fixed in the latest nightly any way.

As Phil and Frank suggested maybe a good look at the tags and a rescan will help you out.

I have also noticed that with the latest nightly i need to actually shut off my computer and start it back up to make some of the changes work correctly. Don't understand that part but that is just how computers can be sometimes.

I will post more of my findings in the next few days.

Schatzy

tamanaco
2008-01-08, 11:21
tamanaco,

Are you using SC7 or SS 6.5.4?

I have many albums with > 10 tracks and they seem to work fine.

I have found that there are many differences in the way SC7 and SC work with special characters including the "." if your track numbers have any inconsistency especially if there happens to be a rouge space in there somewhere then it seems to throw off a lot of other listings even from other albums.

I have a few files (30-40) that are giving me problems and i am doing some very extensive testing before attempting to do write a bug report. And i also see that some of the problems i have been having have been fixed in the latest nightly any way.

As Phil and Frank suggested maybe a good look at the tags and a rescan will help you out.

I have also noticed that with the latest nightly i need to actually shut off my computer and start it back up to make some of the changes work correctly. Don't understand that part but that is just how computers can be sometimes.

I will post more of my findings in the next few days.

Schatzy

I'm using SC7. Everything in my library displays as expected in the Web UI. I'll wait a little while longer before I change all my tags. The tag/folder/file naming format that I'm using is not "unusual", in fact, it's the default in many rippers. Since I backed up all of my libray recently to a separated drive (Over 570 CDs in Flac format) I do not want to make any changes to my tags unless they're absolutely necessary.
Thanks...

schatzy
2008-01-08, 14:35
tamanaco,

I suspect you are using some form of windows operating system, Which one?

If i have read your earlier posts correctly the you are using a period "." between the track number and the title. Is this correct?

If it is that would be very un-standard as that causes all operating systems to think harder about the file name. All operating systems expect filename.xxx or filename.xxxx . By putting in that extra "." (01.filename.xxx) some systems will get very confused and others will just get past it, although slowly.

every tagger i have ever tried either used dashes or underscores set up as standard (01-filename.xxx or 01_filename.xxx)

As for changing all of your tags that is probably not necessary, but there may be a rouge one out there the is causing some of the problems seen by ACC-RC1. Frank is working on this with all the testing I am doing for him. Hopefully it gets figured out in the next few days.

Schatzy

parubini
2008-01-09, 14:18
Hi,

I have already made some mod's to ACC-RC1 to allow a mapped drive to work, using a SlimServer hosted on another (Linux) machine. Within the ACC script it is necessary to swap the slimserver local path to files (as stored in the DB) with the mapped drive as seen by ACC - in my case from /home/user1/Music to x:\Music. Only a few lines to change. This works ok though I still have an outstanding bug with the Compilation Folder and First Folder which does cause the running slow error. When fixed this evening I will post my contribution in case this helps.

Phil. R.

See attached modified version of ACC-RC1 (just the hta file, assumes full version already installed) to allow for mapped drives. This will allow ACC to see a remote slimserver (which could be on a Linux machine). There may yet be an unresolved issue regarding the case of startfolder and compilation folder. But if folder names are entered as seen in Windows Explorer or using the browse button then all seems ok. Many of the case changes seemed unnecessary since the sql INSTR is case insensitive. As a result I did take the liberty to partially rewrite the fnCreateSQLQuery function, so that I could understand the use of directory paths.

To use with a remote Linux machine, edit the head of the script to change the ip address of slimserver machine and also the remote path and matching mapped path. Ideally these could be added to the GUI.

On Linux machine you must allow remote access to the slimserver DB. This is easily achieved by commenting the bind-address line in the file 'my.tt', within the slimserver local MySQL. On my SUSE Linux machine, slimserver is installed in /usr/local and this is located in /usr/local/slimserver/MySQL/my.tt . This action does then rely on your firewall protecting the DB rather than the MySQL server.

Note, I have only tested this with a remote Linux server, not with a local slimserver on a windows machine.

I hope this helps

Phil. R.

tamanaco
2008-01-09, 15:13
Frank, as you start to implement sorting options, please add [Album Artist] as a sorting option within Albums. When the list is created one of the artists from my compilation albums is picked as the author of the album.

Btw, I just tried RC1 and it still misses the album covers as before.

Thanks

RiccardoR
2008-01-09, 16:21
I have my server with two drive C: (is a little partition with WINXP and Slimerver) and D: (the large partition with my music collection), but my PC is another machine on the network. With the new version of ACC (for mapped drive) it stop with this error: "error connecting to Slimserver database. The required mySQL ODBC driver is not installed or is not set to use the default credentials...Click OK to quit."

What can I do? (ACC is the waited solution for what I needed!!!)

Thanks, Riccardo

SilverRS8
2008-01-10, 00:06
Frank, as you start to implement sorting options, please add [Album Artist] as a sorting option within Albums. When the list is created one of the artists from my compilation albums is picked as the author of the album.

Btw, I just tried RC1 and it still misses the album covers as before.

Thanks

I 'll look into it. I think Album artist is just another contributors role, from database point of view. Would you like a seperate album artist vs Artist sorting or must Albumartist be included when selecting sort by Artist? Most of the mp3 tags have empty AlbumArtists fields and mainly Artist fields filled (expect .wma files which always uses this field).

Frank

SilverRS8
2008-01-10, 00:15
I have my server with two drive C: (is a little partition with WINXP and Slimerver) and D: (the large partition with my music collection), but my PC is another machine on the network. With the new version of ACC (for mapped drive) it stop with this error: "error connecting to Slimserver database. The required mySQL ODBC driver is not installed or is not set to use the default credentials...Click OK to quit."

What can I do? (ACC is the waited solution for what I needed!!!)

Thanks, Riccardo

I think parubini already did a lot of work in this area. Isn't your answer already in his thread posts?
I think you need to install the ODBC driver on the target machine. Change the server= option in connection string to the target server. If i'm right you also need to change the mySQL configuration to accept remote connections because default is to only accept local connection but if I understand right, you run ACC from a different machine than SS is on?
Finally you need to make the proper changes to the script so that the path locations is properly replaced by the path you use from the machine you run ACC from. An example on this; The path stored for each track in the DB is D:\<path to track>. ACC will then look into the path D:\<path to track> for the albumcover file. This path doesn't exists on the local machine. You need to map a drive to the music collection. So lets say drive E: will be mapped. Then ACC should be changed to replace D: with E: in order to be able to find the cover files.

I can look into it deeper and give some code specifics but i'm out of time right now (another day at work).

Hope this helps you though.

Frank

ModelCitizen
2008-01-10, 01:12
Wow! This is exactly what I've been wanting for the last three years! It's brilliant. All kudos to Frank.... and thank you very much indeed, I installed it and the connector in seconds and had a catalogue in a minute or two. Superb.

There are only two things that make it anything less but entirely perfect and they are so minor they're hardly worth mentioning, but are very simple to fix so I thought it might be worth it.

I'd prefer it if the album covers and track listings were top aligned. In IE7 (at least) if you have one album with lots of tracks the album next to it will appear with lots of white space above it. I think it'd look better if both the album and the track text were top aligned (so that the track listings and the album cover were directly beneath the grey gradiated album title bar).

The other is that generally the text is very small and the built-in browser text resizing facility does not work (i.e. IE Toolbar/View/Text Size). I understand that it might be a simple style sheet change to get this to work?

They are very minor things though and do not detract from the fact that this is a great utility.

Thanks.

MC

tamanaco
2008-01-10, 06:25
I 'll look into it. I think Album artist is just another contributors role, from database point of view. Would you like a seperate album artist vs Artist sorting or must Albumartist be included when selecting sort by Artist? Most of the mp3 tags have empty AlbumArtists fields and mainly Artist fields filled (expect .wma files which always uses this field).

Frank

Frank, I'd like and appreciate a separated Album Artist sort as my Folder structure is built using this tag instead of the Artist. I use the artist tag for individual tracks. I did this to avoid having a large Various Artist folder. The reason for this is that I used my library with an old media player that uses the folder structure to navigate the library. I also have a lot of World Music compilation albums which are easier to navigate using Genre and the folder structure.

Thanks

parubini
2008-01-10, 07:06
I have my server with two drive C: (is a little partition with WINXP and Slimerver) and D: (the large partition with my music collection), but my PC is another machine on the network. With the new version of ACC (for mapped drive) it stop with this error: "error connecting to Slimserver database. The required mySQL ODBC driver is not installed or is not set to use the default credentials...Click OK to quit."

What can I do? (ACC is the waited solution for what I needed!!!)

Thanks, Riccardo

Riccardo

The ODBC driver must be installed on the local machine at which you will be running ACC. You must be able to see the music folder on the remote machine as a mapped network drive on the local machine.

At the top of my script, change the line
Const sRemotePath = "/home/philip/Music/"
to reflect the drive on your Windows slimserver machine (D:\ I think from your post).

Change the line
Const sMappedPath = "X:\Music\"
to be the mapped network drive, for example to
Const sMappedPath = "Y:\"
If you have mapped your remote D: drive to be Y: on your local machine. (It seems that Windows drive letters must always be in uppercase - as you see in Windows Explorer).

You must also change the IP address in the script to point to the remote machine on your network running slimserver.

Note, I have only been able to test my script with a remote Linux machine but see no reason why this should not work with a remote windows machine. All the script does is a string replacement between the remote path stored within the slimserver database and the local path.

Phil. R.

Kyle
2008-01-10, 12:47
Some questions:

The .html long output comes up in IE and populates with pictures, but the other long output comes up in Firefox (default browser) and does not populate. Why is this?

I have two covers (all cover art is titled cover.jpg) that will not load into either long output. They work fine in Slimserver. The ACC report shows no problem that I can see.

Can the output (with pictures) be saved to a file that can be printed from another computer?

Phil Leigh
2008-01-10, 12:52
Some questions:

The .html long output comes up in IE and populates with pictures, but the other long output comes up in Firefox (default browser) and does not populate. Why is this?

I have two covers (all cover art is titled cover.jpg) that will not load into either long output. They work fine in Slimserver. The ACC report shows no problem that I can see.

Can the output (with pictures) be saved to a file that can be printed from another computer?

Do the names of albums or artists have special/foreign characters in them?

The output is saved automatically into the AlbumCatalogs folder... as an HTML file (web page)

SilverRS8
2008-01-10, 13:44
Some questions:
The .html long output comes up in IE and populates with pictures, but the other long output comes up in Firefox (default browser) and does not populate. Why is this?

I have two covers (all cover art is titled cover.jpg) that will not load into either long output. They work fine in Slimserver. The ACC report shows no problem that I can see.

Like Phil suggest probably a special character in path or filename. Can you let me know which special characters are used? You need to look at the full path to the file.


Can the output (with pictures) be saved to a file that can be printed from another computer?

Yes. A .MHT file is also generated and placed in the Output folder. A .MHT file is an Internet Explorer archive file. You can use this to view the catalog on other computers. The file is pretty large though so if you are able to print to PDF, that maybe a better solution.

Frank

SilverRS8
2008-01-10, 13:47
Frank, I'd like and appreciate a separated Album Artist sort as my Folder structure is built using this tag instead of the Artist. I use the artist tag for individual tracks. I did this to avoid having a large Various Artist folder. The reason for this is that I used my library with an old media player that uses the folder structure to navigate the library. I also have a lot of World Music compilation albums which are easier to navigate using Genre and the folder structure.

Thanks

Ok. I'll take a look at it. Will be in a next version though. The next version will have a seperate screen with a number of layout options and advanced sorting (2 or 3 levels).

SilverRS8
2008-01-10, 14:13
Wow! This is exactly what I've been wanting for the last three years! It's brilliant. All kudos to Frank.... and thank you very much indeed, I installed it and the connector in seconds and had a catalogue in a minute or two. Superb.

Thx for your great reaction. Much appreciated. Keeps me working on improvement and a next version of the tool.


I'd prefer it if the album covers and track listings were top aligned. In IE7 (at least) if you have one album with lots of tracks the album next to it will appear with lots of white space above it. I think it'd look better if both the album and the track text were top aligned (so that the track listings and the album cover were directly beneath the grey gradiated album title bar).

If this request is also wanted by other users, this can become an option in the next version which will have numerous layout options extra. As for now you have to add a vertical alignment tag to the CSS code. It'll cost me some testing to figure out where exactly but if you want i can figure it out.


The other is that generally the text is very small and the built-in browser text resizing facility does not work (i.e. IE Toolbar/View/Text Size). I understand that it might be a simple style sheet change to get this to work?

This is actually done deliberatly. Because some album tracks have very long names, a larger font will make to layout look ugly. I admit the font is pretty small and probably too small for screen reading but it is intended for print and then it actually is quiet readable. Changing the font size to a larger font is not that easy. The PrintPageSeperation function is based on the characteristics of the current font and font size (things like maximum tracks on page). Changing the font size would also mean changing this function. It can be done ofcourse and it may also be a future option but that depends on the general request for such option.

Frank

Kyle
2008-01-10, 15:05
Like Phil suggest probably a special character in path or filename. Can you let me know which special characters are used? You need to look at the full path to the file.

One album name has an accent mark, and one artist's name has an umlaut. I guess these are causing problems?




A .MHT file is also generated and placed in the Output folder. A .MHT file is an Internet Explorer archive file. You can use this to view the catalog on other computers. The file is pretty large though so if you are able to print to PDF, that maybe a better solution.

Frank

The .MHT file does not populate with album art, but the .HTML file does. Is there a reason for this?

SilverRS8
2008-01-11, 00:41
One album name has an accent mark, and one artist's name has an umlaut. I guess these are causing problems?

I think so. Thanks for the feedback. I'll look into the code to if this is the problem and can be fixed.


The .MHT file does not populate with album art, but the .HTML file does. Is there a reason for this?[/QUOTE]

The .MHT file should be identical to the .html file. I'll also take a look at this one.

Frank

parubini
2008-01-11, 02:45
Frank

Have you considered if you will be able to include my suggestions for handling mapped paths in a future release of ACC ? From the very complimentary comments that you have received I could imagine that you could have a long development programme should you wish ! Perhaps you might consider placing the source on a development site (such as sourceforge or similar) which includes a revision mechanism and would allows others to contribute changes ?

Phil. R.

ps. For anyone else using my modified script, you might wish to change the line 'bEnhancedLogging = 2' to 'bEnhancedLogging = 0'. This will reduce the size of the log file and speed up the process for very large databases.

SilverRS8
2008-01-11, 03:08
Frank

Have you considered if you will be able to include my suggestions for handling mapped paths in a future release of ACC ? From the very complimentary comments that you have received I could imagine that you could have a long development programme should you wish ! Perhaps you might consider placing the source on a development site (such as sourceforge or similar) which includes a revision mechanism and would allows others to contribute changes ?

Phil. R.

ps. For anyone else using my modified script, you might wish to change the line 'bEnhancedLogging = 2' to 'bEnhancedLogging = 0'. This will reduce the size of the log file and speed up the process for very large databases.

First off all I would like to thank you for your active involvement in this thread and ACC. I think you have done a lot of good work for users with remote DBs.

I have thought about how this could be implemented but I need some additional scenario and technical info to see if the process can be automated or that, because of the broad range of scenario's possible, some things can't be automated and have to be adapted manually to the users situation. If its implemented it ofcourse has to be a reliable solution. But, its on my todo list.
I actually really look forward to creating all the new options but there are still some issues to resolve with this one I think.

Do you think the ACC user base is already large enough to take it more serious and do it the sourceforge way? I have no overview of users really using the tool already because I have no download stats so judging from the forum thread there are not really that many active (involved) users. That can ofcourse also mean that the script works as it should for them.

Do you think there is potential and an oppertunity for ACC to grow bigger? (other users are welcome to react)

BTW. I have made an RC2 version which should address the 'script is running slow issue' and perform better but that is currently being tested by Schatzy and it may still have a problem with it so I hope to be able to post this soon.

Frank

parubini
2008-01-11, 05:11
Do you think the ACC user base is already large enough to take it more serious and do it the sourceforge way? I have no overview of users really using the tool already because I have no download stats so judging from the forum thread there are not really that many active (involved) users. That can ofcourse also mean that the script works as it should for them.

Do you think there is potential and an oppertunity for ACC to grow bigger? (other users are welcome to react)



Frank

Frank

It is always surprising to me that this facility was never part of the core slimserver. Reading the forums there are so many threads providing alternative approaches. I believe that there is a demand for such a facility, either as a stand alone application, or embedded in slimserver. I am sure the limiting factor to the development of ACC is your own time, hence partly my suggestion to host on a development site. I don't think number of users should put you off from this. I am sure the more the code is developed the more users there will be. The disadvantage of increased popularity will be an increase in feature requests ! There are just so many different ways to sort and print the data, everyone wants something slightly different !

Phil.R.

Kyle
2008-01-11, 08:00
The .MHT file does not populate with album art, but the .HTML file does. Is there a reason for this?

The .MHT file should be identical to the .html file. I'll also take a look at this one.

Frank

The appears to be a problem with Firefox. When I open the .MHT file in IE, the art appears.

ModelCitizen
2008-01-13, 01:41
This is a wild shot in the dark but I'm now getting desperate.

For some days SlimCenter 7 has been listing duplicate tracks in a large number of my albums. I'm trying to figure out what may have changed around the time this first started and the biggest change around this time was that I added the Windows SQL ODBC connector and used Album Catalog for the first time.

I did a default installation of the ODBC connector and did not configure it in any any way. It just worked out of the box.

Can anyone offer any input (at all) about whether the installation of the ODBC driver might have anything to do with this problem..,. and if so how... and how I might cure it? I assuming Album Creator cannot have any bearing on the problem as it does not write and merely reports.

Thanks.

MC

Phil Leigh
2008-01-13, 04:55
This is a wild shot in the dark but I'm now getting desperate.

For some days SlimCenter 7 has been listing duplicate tracks in a large number of my albums. I'm trying to figure out what may have changed around the time this first started and the biggest change around this time was that I added the Windows SQL ODBC connector and used Album Catalog for the first time.

I did a default installation of the ODBC connector and did not configure it in any any way. It just worked out of the box.

Can anyone offer any input (at all) about whether the installation of the ODBC driver might have anything to do with this problem..,. and if so how... and how I might cure it? I assuming Album Creator cannot have any bearing on the problem as it does not write and merely reports.

Thanks.

MC


MC - it cannot be anyhting to do with ACC as it does not update the database - it only reads it.
Also the ODBC connector is NOT used by anything else but ACC and cannot cause the problem either.

I had this problem on 6.x and it drove me crazy. In my case it was caused by the windows Shortcuts that were being used to point to my multiple music drives. I eventually figured out that I had old deleted versions of the shortcuts sitting in the recycle bins of the external drives...however, SS was still finding them even though they were deleted!
My advice is to check carefuly your recycle bins.

I'm reasonably confident that SS only reports what it finds so multiple tracks are being found - or rather, it is finding more than one route to your tracks. Do you also use MusicIP for example?

frold
2008-01-13, 09:34
Well it doesnt seems to work on my system

WinXP
Squeezecenter 7.0 nightly build 11th of jan.
mysql-connector-odbc-3.51.23-win32.zip

even after a restart...

Settings:
Display tracks: yes
Album cover size: normal
Display genre: no
Sort by: Album
Folder containing various artists: C:\Slimdevice\Musik\Various
Starting folder: C:\Slimdevice\Musik

Then I get a popup
"An error accured while connecting to the database. The error data is printed below.
Error number: 0
Error description

Click okay to quit the script."

That it :S

Phil Leigh
2008-01-13, 09:37
Have you tested the ODBC connector in Control Panel as described earlier in this thread?

frold
2008-01-13, 10:05
there is 157 posts I havent read them....

SilverRS8
2008-01-13, 10:24
Just to let you know....

I'm working on RC2 which has some fixes. I can confirm the album cover issues some have posted and working on it. Also Schatzy is doing some testing. Hope to post it somewhere in this week.

As for the issue of Frold; SC7 isn't officially supported yet although it works fine but it seems the different beta build also have different connection requirements. I installed SC7 this weeks (required for the new Duet controller I ordered) and ACC works without having to change anything.
Others though have mentioned that the UID of the connection string must be changed in order to get ACC working and other problem are all related to ODBC issues (not ACC).

Frank

ModelCitizen
2008-01-13, 11:15
Cheers Phil.
Thanks for your input Phil.

I have disabled all plugins. I have removed the SQL ODBC driver. I have deleted all recycle bin stuff on all drives... but still I have duplicates.

Diagnosing is incredibly frustrating. SC7 takes 2 hours to rescan my 1500 albums. Although I've created a subset of my music for testing purposes I can't replicate the problem with it.

This is the thread for my (lonely) problem. If anything else springs to mind.. however tenuous, please let me know.
http://forums.slimdevices.com/showthread.php?t=42081

MC




MC - it cannot be anyhting to do with ACC as it does not update the database - it only reads it.
Also the ODBC connector is NOT used by anything else but ACC and cannot cause the problem either.

I had this problem on 6.x and it drove me crazy. In my case it was caused by the windows Shortcuts that were being used to point to my multiple music drives. I eventually figured out that I had old deleted versions of the shortcuts sitting in the recycle bins of the external drives...however, SS was still finding them even though they were deleted!
My advice is to check carefuly your recycle bins.

I'm reasonably confident that SS only reports what it finds so multiple tracks are being found - or rather, it is finding more than one route to your tracks. Do you also use MusicIP for example?

SumnerBoy
2008-01-13, 12:55
Hi, firstly I would like to say thanks a heap for a great tool. It is something I have been looking for/wanting to do for a long time.

I can successfully process my music collection and get the album catalog output files. Viewing them in IE I can see the album art but viewing in Firefox I cannot - is this a known issue?

Also, if I try to print in IE I am firstly unable to select Print from the main file menu, and if I right click on the page itself and select Print I get a scripting error.

How do I go about printing to/converting to a PDF file as this is how I would like to store my catalog?

Any help or pointers would be warmly received!

SilverRS8
2008-01-13, 14:44
Hi, firstly I would like to say thanks a heap for a great tool. It is something I have been looking for/wanting to do for a long time.

Thx for your appreciation !!


I can successfully process my music collection and get the album catalog output files. Viewing them in IE I can see the album art but viewing in Firefox I cannot - is this a known issue?

Yep. Its on my 'fix list'. Firefox is a bit more strict in holding to standards then IE is. I'm changing the code so that more standard code is generated which should resolve the Firefox issue. Planning on somewhere this week for release....


Also, if I try to print in IE I am firstly unable to select Print from the main file menu, and if I right click on the page itself and select Print I get a scripting error.

How do I go about printing to/converting to a PDF file as this is how I would like to store my catalog?

This is not yet a known problem but since ACC is still in 'beta' issues are to be resolved :-) Just need your help...

By my knowledge a page has no control over the Print option being available or not.
Can you provide me with some more info on this one? Does it have anything to do with the number of albums? How large is your collection? Can you try only generating for a few albums and see if the problem persists?

When this problem is solved, you can ofcourse create your PDF file by just printing to the PDF print. I myself also use this for archive purposes.

Frank

SumnerBoy
2008-01-14, 00:26
Yep. Its on my 'fix list'. Firefox is a bit more strict in holding to standards then IE is.

Ok great - I will keep an eye out for the next release.


When this problem is solved, you can ofcourse create your PDF file by just printing to the PDF print.

I just tried this again and now it seems to be working (blushing). Not sure what happened there, as I tried it quite a few times before posting this question! Nevermind, it is now allowing me to print in both IE and Firefox.

I am unable to work out how to print to PDF however. There is an option to 'Print to file' but that just generates .prn files. Do I need to install some sort of PDF printer/emulator?

Thanks for your prompt response!

SilverRS8
2008-01-14, 00:49
I just tried this again and now it seems to be working (blushing). Not sure what happened there, as I tried it quite a few times before posting this question! Nevermind, it is now allowing me to print in both IE and Firefox.

I am unable to work out how to print to PDF however. There is an option to 'Print to file' but that just generates .prn files. Do I need to install some sort of PDF printer/emulator?

Thanks for your prompt response!

Glad it is working. No problems with album covers in Firefox anymore? To create a PDF you either have to install Adobe Acrobat (this will also install a PDF printer) or a third party PDF printer (PDF995 is freeware). When selected, these printers will ask for a file name of the PDF to be created.

Frank

frold
2008-01-14, 00:55
To create a PDF you either have to install Adobe Acrobat (this will also install a PDF printer) or a third party PDF printer (PDF995 is freeware


I can recommand PDFcreator: http://www.pdfforge.org/products/pdfcreator

SumnerBoy
2008-01-14, 01:17
No problems with album covers in Firefox anymore?

Unfortunately yes - I still can't see the album art in Firefox, but assuming I can get this PDF printing to work with IE (which looks like it should be fine) I won't need to use Firefox.

Thanks again.

schatzy
2008-01-14, 07:55
For those of you having problems with displaying ACC results in FireFox.

FireFox does not have native support for .MHT files. These are proprietary to Microsoft applications.

There was a MAF Extension written for FireFox 1.5 that would allow .MHT files to be opened in FIreFox 1.5, but it has not been updated for the changes to newer version of FireFox.

As for the .html files. fire fox does not recognize the format of the link to the cover.jpg. It is currently formatted as
C:/folder/folder.cover.jpg

For FireFox to be able to see it is must be
file:///C:/folder/folder/cover.jpg

The unfortunate this with this is that IE7 will disregard the "file:///" and display the cover.jpg file properly but if you are using an older version of IE such as 6.0.5 then you may have problems with the cover.jpg file showing. Some country specific versions of 6.0.5 (Spanish version) did not allow the "file:///" to be disregarded and will error out if it is in the path to the file.

Hopefully SliverRS8 can come up with some alternate way of coding these path to the cover.jpg file but it may not be possible.

Schatzy

SilverRS8
2008-01-14, 08:12
For those of you having problems with displaying ACC results in FireFox.

FireFox does not have native support for .MHT files. These are proprietary to Microsoft applications.

There was a MAF Extension written for FireFox 1.5 that would allow .MHT files to be opened in FIreFox 1.5, but it has not been updated for the changes to newer version of FireFox.

As for the .html files. fire fox does not recognize the format of the link to the cover.jpg. It is currently formatted as
C:/folder/folder.cover.jpg

For FireFox to be able to see it is must be
file:///C:/folder/folder/cover.jpg

The unfortunate this with this is that IE7 will disregard the "file:///" and display the cover.jpg file properly but if you are using an older version of IE such as 6.0.5 then you may have problems with the cover.jpg file showing. Some country specific versions of 6.0.5 (Spanish version) did not allow the "file:///" to be disregarded and will error out if it is in the path to the file.

Hopefully SliverRS8 can come up with some alternate way of coding these path to the cover.jpg file but it may not be possible.

Schatzy


Thx Schatzy. The addition of file:/// was already on my firefox fixlist but I didn't knew that different versions of IE cope differently with it so thats gooed to know.

Although the script is a .hta application it is not running in an Internet Explorer process and hence I cannot detect which version of IE is installed (besides some not so nice workarounds) to automatically determine if 'file:///' can be used or not. The reason why Microsoft decided to use a seperate 'mshta' interpreter was that under the security context of IE, a script isn't allowed anything to do directly on the system. A .hta is always allowed running code to do anything that is allowed in the current user context.

Do you know if the version prior to IE7 (is that 6.0.5 or is there something in between?) does cope with the file:/// prefix? If that is so I don't thing many would have a problem.
Another option would be to create an option for various IE versions (either through the GUI or by setting a variable value in the script).

Frank

schatzy
2008-01-14, 13:28
Frank,

The real problem I beleive with IE6 more along the lines of

A. if the file was produced by IE6 then no problem
B. If file produce by another application the it must be in a very specific path structure.
C. For unknown reasons it also has to do with the version of MS Office or Word.

I have read reports that If you have Office 2003 installed it works fine with IE6. And then there are others that have reported problems with Outlook Express having to be reinstalled to make it work with IE6.

My feeling is that those who have not upgraded to IE7 have much older computers where IE7 just does wont work. Also IE7 does not work on anything other than XP SP2 or Vista, or so Microsoft says, i have not tried it myself.

Anyone running Windows 2000 or 98SE will probably have a problem, Although I have heard that you can view any .mht files on Win2k or 98SE if you install the latest Outlook Express even if you don't use it.

But that's just the way Microsoft products are. Designed to be a PITA.

Schatzy

RiccardoR
2008-01-14, 16:18
Thanks to SilverRS8 for helping me: the error was in some part missing in IE6 on my server, doing all on my computer it was ok.

But I have another question: most of my covers are embedded in mp3 files, there are only the flac's with separate cover.jpg. There is a method to extract album art (in automatic manner, obiouvsly) or You think in a next version of ACC this will be a feature?

Ciao, Riccardo

schatzy
2008-01-14, 16:50
RiccardoR,

Mp3Tag should be able to do it for you.

I personally have not used it but know of some other people that have done this, and they said it worked great.

It can be found here http://www.mp3tag.de/en/.

Schatzy

SilverRS8
2008-01-15, 01:01
Thanks to SilverRS8 for helping me: the error was in some part missing in IE6 on my server, doing all on my computer it was ok.

But I have another question: most of my covers are embedded in mp3 files, there are only the flac's with separate cover.jpg. There is a method to extract album art (in automatic manner, obiouvsly) or You think in a next version of ACC this will be a feature?

Ciao, Riccardo

It is possible to extract any tag data including album covers from a mp3 file. So what I mean to say is that I cn change ACC to get the art from the file and make an option if this is prefered or not. To do so I need a COM/ActiveX object but haven't been able to find one yet. I'll post a question about this in the developers forum. If I find one, then yes this will be a future option else I must disappoint you.

I do think though that the majority uses the cover.jpg or folder.jpg files.

Frank

SilverRS8
2008-01-15, 12:35
I finally had some time to do some fixing and posted the RC2 release on www.vanholt.nl/acc/acc.htm

Changes in RC2:
FIXED Album covers not correctly displayed when path contains special characters
FIXED When a starting or compilation folder is selected and Start was pressed the folders fields reversed to the previous setting but were executed correctly
FIXED Album covers were not displayed in firefox
CHANGED Calibri font in Artist and Album header to Tahoma as Calibri is only default installed on Windows Vista OS which caused a font replacement to Times New Roman when Calibri was missing

Still working on some other issues with Schatzy which may result in a fix later this week (hopefully).

Frank

Secret Squirrel
2008-01-15, 12:45
I finally had some time to do some fixing and posted the RC2 release on www.vanholt.nl/acc/acc.htm

Changes in RC2:
FIXED Album covers not correctly displayed when path contains special characters
FIXED When a starting or compilation folder is selected and Start was pressed the folders fields reversed to the previous setting but were executed correctly
FIXED Album covers were not displayed in firefox
CHANGED Calibri font in Artist and Album header to Tahoma as Calibri is only default installed on Windows Vista OS which caused a font replacement to Times New Roman when Calibri was missing

Still working on some other issues with Schatzy which may result in a fix later this week (hopefully).

Frank

Frank,

You're amazing! I don't know how you're getting all of these things straightened out and added so quickly and maintain a normal life. I don't have any software consultants that work that fast (okay, one).

I can't wait to get home tonight and try the new release!

Have you entertain the idea of getting this into the trunk of SlimCenter? Personally, I think it's something everyone could use.

Thanks again,

SS

tamanaco
2008-01-15, 14:06
I finally had some time to do some fixing and posted the RC2 release on www.vanholt.nl/acc/acc.htm

Changes in RC2:
FIXED Album covers not correctly displayed when path contains special characters
FIXED When a starting or compilation folder is selected and Start was pressed the folders fields reversed to the previous setting but were executed correctly
FIXED Album covers were not displayed in firefox
CHANGED Calibri font in Artist and Album header to Tahoma as Calibri is only default installed on Windows Vista OS which caused a font replacement to Times New Roman when Calibri was missing

Still working on some other issues with Schatzy which may result in a fix later this week (hopefully).

Frank

Frank, I'm getting the following error with yes/no option whenever I try to run the RC2 script from my server.
"Stop Running this Script?
A Script on this page is causing Internet Explorer to run slowly, if it continues to run your computer might become unresponsvie"

If I click yes... I get ACC Window with a blue background with the title on top and your signature on the lower right. If I click no... I just get the hourglass and the same message reapears after a few seconds. Using process explorer I can see that the mshta.exe is using up to 95% of the CPU before it issues the message. I only get one line that reads "STATUS : fnReadSettings():ENTER:3:55:20 PM" in the acc.log

Other than cosmetic problems with the layout of the app window and fonts, I never had any run-time issues with the ACC script. The script is running on Windows XP SP2. Any ideas?

schatzy
2008-01-15, 15:09
Frank,

I'm now getting the same error as tomanaco.

Tried a few things in the script but was not able to get it to work. Will look at it more when i arrive home this evening.

Secret Squirrel
2008-01-15, 16:47
Frank,

I'm now getting the same error as tomanaco.

Tried a few things in the script but was not able to get it to work. Will look at it more when i arrive home this evening.

I just ran release candidate 2 and it worked for me albiet with no background on the window and something I hadn't noticed before. ACC tells me I have 351 Albums and SC 7 tells me I have 348. Also, I wonder why ACC accesses the internet.

Overall, I happy with what I have.

Thanks again,

SS

schatzy
2008-01-15, 17:34
tomanaco,

I opened the ACC.cgf file in note pad. It looks something like this

SF|I:\MP3\J\Jackson, Michael\(1979) Off The Wall
G2E|
CF|

Remove from the first line
"I:\MP3\J\Jackson, Michael\(1979) Off The Wall"

The file should then look like

SF|
G2E|
CF|

Save this and try running ACC-RC2.

If the path that we removed does not exist on your computer then this will probably not work as ACC is looking for it and can not find it.

Let me know if that fixes it.

Schatzy

tamanaco
2008-01-15, 20:10
tomanaco,

I opened the ACC.cgf file in note pad. It looks something like this

SF|I:\MP3\J\Jackson, Michael\(1979) Off The Wall
G2E|
CF|

Remove from the first line
"I:\MP3\J\Jackson, Michael\(1979) Off The Wall"

The file should then look like

SF|
G2E|
CF|

Save this and try running ACC-RC2.

If the path that we removed does not exist on your computer then this will probably not work as ACC is looking for it and can not find it.

Let me know if that fixes it.

Schatzy

Where is this acc.cfg file located? It does not exist in the folder where I extracted the RC2 zip file and it's not created in this folder after I run the script either. The folder has the include subfolder, history.txt, acc.log and the albumCreator-V1.hta file.

SilverRS8
2008-01-16, 00:19
Hi all,

Sorry for the problems caused. Although minor fixes i'll have it tested in the futuru by Schatzy first before posting again.I'm doing some fixes right now. Be back soon with an update.

Frank

SilverRS8
2008-01-16, 00:20
Where is this acc.cfg file located? It does not exist in the folder where I extracted the RC2 zip file and it's not created in this folder after I run the script either. The folder has the include subfolder, history.txt, acc.log and the albumCreator-V1.hta file.

The fact that the acc.cfg file is not created is the cause of the problem. The acc.cfg file is created (or updated) at every run. Thx for the info. Helps me to find the problem. looking into it now...

SilverRS8
2008-01-16, 00:22
I just ran release candidate 2 and it worked for me albiet with no background on the window and something I hadn't noticed before. ACC tells me I have 351 Albums and SC 7 tells me I have 348. Also, I wonder why ACC accesses the internet.

Overall, I happy with what I have.

Thanks again,

SS

It doens't access the internet by any means. It open IE with a parameter to open a locally created file. Thats all for internet. What message did you get that made you think it was accessing the internet?

SilverRS8
2008-01-16, 01:30
Problems should be fixed now and will be tested by Schatzy prior to posting them again (learned my lesson) :)

Frank

schatzy
2008-01-16, 05:08
tamanaco,

You should find the configuration file in the acc-v1-RC2 folder that is crated on unzipping the downloaded file.

If you are not seeing it is may be hidden by windows.
1. open the folder with ACC in it.
2. click on "tools" (in the tool bar at the top)
3. click on "folder options"
4. click on the "view" tab
5. under the "hidden file and folders" click on "show hidden fies and folders"
6. also uncheck "hide extensions for known file type" and
7. click OK.

at this point you should see a file called ACC.cfg

If you still do not see it then open note pad and type in the following

SF|
G2E|
CF|

Save the file as ACC.cfg in the folder with the acc program.

if it saves it with a .txt at the end the rename the file ACC.cfg and try ACC again.

Schatzy

tamanaco
2008-01-16, 05:34
tamanaco,

You should find the configuration file in the acc-v1-RC2 folder that is crated on unzipping the downloaded file.

If you are not seeing it is may be hidden by windows.
1. open the folder with ACC in it.
2. click on "tools" (in the tool bar at the top)
3. click on "folder options"
4. click on the "view" tab
5. under the "hidden file and folders" click on "show hidden fies and folders"
6. also uncheck "hide extensions for known file type" and
7. click OK.

at this point you should see a file called ACC.cfg

If you still do not see it then open note pad and type in the following

SF|
G2E|
CF|

Save the file as ACC.cfg in the folder with the acc program.

if it saves it with a .txt at the end the rename the file ACC.cfg and try ACC again.

Schatzy

Thanks Schatzy... I run my systems so that I can see all the hidden files as an administrator. Frank said that the file is created when the script is executed. It is not in the zip file. I usually remove every trace of the previous version of any beta software from my computer before I install the next version. This way I avoid any issues related to compatability from files in one version that might've changed in the next.

schatzy
2008-01-16, 05:39
Also, I wonder why ACC accesses the internet.

Overall, I happy with what I have.

Thanks again,

SS

Secret Squirrel

IE is normal set to try and connect to the internet normally. This can be changed (work off line mode)but then every time you go to use it to connect to the internet you would have to manually tell it to connect (on line mode). In fact all browsers work this way.

So when ACC opens IE to display, IE thinks it should try and connect to the internet to get ready for your request of a web page. But ACC is telling it what to display so it displays the ACC generated page and is then reday for yout to type in a web address or choose from favorites etc.

Schatzy

tamanaco
2008-01-16, 05:40
Hi all,

Sorry for the problems caused. Frank

Frank, everyone using beta software should be aware that issues like this "will" occur from time to time. No need to apologize. I'm amazed at how quickly you fix and add functionality to this thing. I appreciated all the effort you're putting on ACC.

Thanks again.

schatzy
2008-01-16, 05:42
Thanks Schatzy... I run my systems so that I can see all the hidden files as an administrator. Frank said that the file is created when the script is executed. It is not in the zip file. I usually remove every trace of the previous version of any beta software from my computer before I install the next version. This way I avoid any issues related to compatability from files in one version that might've changed in the next.

Did you get it to work?

Schazy

tamanaco
2008-01-16, 05:47
Did you get it to work?

Schazy

I removed it. I'm waiting for Frank to upload the next release.

Thanks...

Secret Squirrel
2008-01-16, 06:16
Frank,

You're amazing! I don't know how you're getting all of these things straightened out and added so quickly and maintain a normal life. I don't have any software consultants that work that fast (okay, one).

I can't wait to get home tonight and try the new release!

Have you entertain the idea of getting this into the trunk of SlimCenter? Personally, I think it's something everyone could use.

Thanks again,

SS

Frank,

I just get a request from Zone Alarm to allow internet access. Maybe it's just IE making the request because I don't allow it as I normally use FireFox.

It just works for me. Thanks again!

SS

SilverRS8
2008-01-16, 08:13
Just posted (http://www.vanholt.nl/acc/acc.htm) the RC2a version with the following changes:
FIXED Problem with script running slow message of RC2 and screen updates
FIXED When selected startingfolder or compilation folder containing a ' character the script stopped
ADDED Store all settings. Also Radiobuttons.

It has already been tested by Schatzy so this one should resolve the previous problems. SecretSquirrel, can you test and confirm the correct working of ACC with Firefox?

Frank

MuckleEck
2008-01-16, 08:32
Frank,

This is an excellent program however I can't get it working...

The new RC2a version starts ok but the script running slow message comes up after a few minutes.

Looking at the log file, which is about 4M has hundreds (possibly thousands) of entries like

STATUS : 15:23:34 ;Various Artists;;;
STATUS : 15:23:34 ;Various Artists;;;
STATUS : 15:23:34 ;Various Artists;;;
STATUS : 15:23:34 ;Various Artists;;;
STATUS : 15:23:34 ;Various Artists;;;
STATUS : 15:23:34 ;Various Artists;;;
STATUS : 15:23:34 ;Various Artists;;;
STATUS : 15:23:34 ;Various Artists;;;

I stop the script after a while without an output being generated.

Any ideas?

I am running Squeezecenter and have changed the UID as previously explained.

Many thanks

Rick B.
2008-01-16, 08:34
Many thanks for this, Frank. I love it!

I'm not happy, however, with the quality of my album covers. Most of them are "thumbnails" that I copied from Amazon.com. They are generally 115 x 115 pixels. They look quite fuzzy on screen and in print.

Would I get better quality covers if I went with the larger covers from Amazon? Most of them are 240 x 240 pixels. If I did would I then get fewer albums per page from your script or do you scale them back down?

Thanks.

SilverRS8
2008-01-16, 08:36
Frank,

This is an excellent program however I can't get it working...

The new RC2a version starts ok but the script running slow message comes up after a few minutes.

Looking at the log file, which is about 4M has hundreds (possibly thousands) of entries like

STATUS : 15:23:34 ;Various Artists;;;
STATUS : 15:23:34 ;Various Artists;;;
STATUS : 15:23:34 ;Various Artists;;;
STATUS : 15:23:34 ;Various Artists;;;
STATUS : 15:23:34 ;Various Artists;;;
STATUS : 15:23:34 ;Various Artists;;;
STATUS : 15:23:34 ;Various Artists;;;
STATUS : 15:23:34 ;Various Artists;;;

I stop the script after a while without an output being generated.

Any ideas?

I am running Squeezecenter and have changed the UID as previously explained.

Many thanks

Can you provide additional info;
What paths were used as StartingFolder and Compilation folder?

Frank

MuckleEck
2008-01-16, 08:37
Rick,

try album art downloader....

http://www.hydrogenaudio.org/forums/index.php?showtopic=51896

Which trys various sites to get the images, I find that images between 300 and 500 pixels square look best.

For covers that are impossible to find I resorted to scanning them in myself!

MuckleEck
2008-01-16, 08:39
Frank,

Config file is

SF|
G2E|
CF|Y:\Music\V\Various Artists
DT|True
DG|False
ACS|True
APPS|True
SB|1

Last message before all teh various artists messages were:-

STATUS : WHERE INSTR(UCASE(tracks.url), 'FILE:///Y:/Music/V/Various%20Artists')
STATUS : group by tracks.id,lcase(convert(albums.title using utf8))
STATUS : order by lcase(convert(albums.titlesort using utf8)),tracks.disc,tracks.tracknum;
STATUS : fnCreateSQLQuery(2):LEAVE:15:19:55
STATUS : fnPerformQuery(2):ENTER:15:19:55
STATUS : fnPerformQuery():Recordset opened:15:19:55
STATUS : 15:19:55 ;Various Artists;;;
STATUS : 15:19:55 ;Various Artists;;;
STATUS : 15:19:55 ;Various Artists;;;

Many thanks for the ultra prompt response

Alasdair

schatzy
2008-01-16, 08:47
Frank,

Config file is

SF|
G2E|
CF|Y:\Music\V\Various Artists
DT|True
DG|False
ACS|True
APPS|True
SB|1

Last message before all teh various artists messages were:-

STATUS : WHERE INSTR(UCASE(tracks.url), 'FILE:///Y:/Music/V/Various%20Artists')
STATUS : group by tracks.id,lcase(convert(albums.title using utf8))
STATUS : order by lcase(convert(albums.titlesort using utf8)),tracks.disc,tracks.tracknum;
STATUS : fnCreateSQLQuery(2):LEAVE:15:19:55
STATUS : fnPerformQuery(2):ENTER:15:19:55
STATUS : fnPerformQuery():Recordset opened:15:19:55
STATUS : 15:19:55 ;Various Artists;;;
STATUS : 15:19:55 ;Various Artists;;;
STATUS : 15:19:55 ;Various Artists;;;

Many thanks for the ultra prompt response

Alasdair

What type of files are they? MP3, FLAC, WMA etc.

Also do you have any idea of how many files and folders are in your various artist folders?

Also what is the file structure under your Various Artists folder?

Schatzy,

MuckleEck
2008-01-16, 08:54
structure is as follows:-

y:\music\v\various artists\<album>\<track#> <artist> - <track name>.xxx

xxx is either FLAC or mp3

There are 120 albums in varius artists some with upto 200 tracks total of 3500 tracks

Alasdair

schatzy
2008-01-16, 09:07
structure is as follows:-

y:\music\v\various artists\<album>\<track#> <artist> - <track name>.xxx

xxx is either FLAC or mp3

There are 120 albums in varius artists some with upto 200 tracks total of 3500 tracks

Alasdair

MuckleEck,

Please try and select just one of the album folders in your that has less than 50 tracks (if you have one)

I.E. y:\music\v\various artists\<album>

And try to run ACC again, then run it on a folder that has more than 150 tracks and report back if either of those work.

I have tested this here on my system and do not find a problem, but i do not have any folder that has more than 56 tracks.

Thanks

Schatzy

Secret Squirrel
2008-01-16, 09:07
Just posted (http://www.vanholt.nl/acc/acc.htm) the RC2a version with the following changes:
FIXED Problem with script running slow message of RC2 and screen updates
FIXED When selected startingfolder or compilation folder containing a ' character the script stopped
ADDED Store all settings. Also Radiobuttons.

It has already been tested by Schatzy so this one should resolve the previous problems. SecretSquirrel, can you test and confirm the correct working of ACC with Firefox?

Frank

Frank,

I'll be happy to do that this evening, but won't get to it until about 8 EST. Sorry!

Thanks, as always, for all of your work on this!

SS

schatzy
2008-01-16, 09:10
Frank,

I'll be happy to do that this evening, but won't get to it until about 8 EST. Sorry!

Thanks, as always, for all of your work on this!

SS

Secret Squirrel

I found i had to change the file association for .htm and .html to force it to use FireFox.

This worked for me, but let me know how it goes after you have tried it.

Schatzy

tamanaco
2008-01-16, 17:37
Just posted (http://www.vanholt.nl/acc/acc.htm) the RC2a version with the following changes:
FIXED Problem with script running slow message of RC2 and screen updates
FIXED When selected startingfolder or compilation folder containing a ' character the script stopped
ADDED Store all settings. Also Radiobuttons.

It has already been tested by Schatzy so this one should resolve the previous problems. SecretSquirrel, can you test and confirm the correct working of ACC with Firefox?

Frank

Installed RC2a and the script ran without a hitch. All the album covers were found and displayed. The main problem that remains, in my case, is that not all the tracks are sorted correctly for all the albums. I'm trying to find out what's common with those albums whose tracks are out of order, but I can not find anything. The Web interface of SC7 displays all the albums with all the tracks in the correct order.

The other issue is "cosmetic" and does not need to be prioritize. I can live with it. I rather have more sorting options implemented. But just in case, I'm attaching two images. The one on the left is what I get when I start the ACC. The one on the right is what I get after I resize the ACC window. Btw, I did not have this issue with the first two beta release.

schatzy
2008-01-16, 18:10
tamanaco,

The issue with the resizing the windows of ACC is due to your font size selection in Windows.

I have been able to recreate this on my computer and would like you to check something.

1.right click anywhere on your desktop where there is not an icon

2. Click properties

3. Click the settings tab

4. Click the advanced button

5. Click the General tab if it is not showing

Under DPI setting what is the setting
Normal (96dpi), Large (120dpi) or Custom.

I believe that you will find that it is set to Large or Custom. Setting mine to large causes the same problem.

IF that is the case and you need it set to large or custom for some reason then let me know and i will make you a special background and then have you change the window size in the ACC.hta file to accommodate this font size setting.

If this is not the case then i will have to look into it further.But from the pictures you posted i think this will be the situation.


Schatzy

Secret Squirrel
2008-01-16, 18:26
Secret Squirrel

I found i had to change the file association for .htm and .html to force it to use FireFox.

This worked for me, but let me know how it goes after you have tried it.

Schatzy

I just download RC2a. Before running it I checked by file associations like Schatzy recommended and they were set for Firefox. I still got the Zone Alarm message about IE(no big deal), but everything ran fine as usual!

It just gets better!

Cheers guys!

SS

schatzy
2008-01-16, 18:32
Secret Squirrel,

So what you are saying is that it actually opened in FireFox but you still got a Zone Alarm message for IE.

This is probably caused by the fact that ACC uses a function of IE/Outlook/Office that is designed for saving web pages and then viewing them off line.

If this is the case can you live with the Zone alarm message be cause we will not be able to stop it happening without a change in Zone Alarm

Schatzy

Secret Squirrel
2008-01-16, 18:59
Secret Squirrel,

So what you are saying is that it actually opened in FireFox but you still got a Zone Alarm message for IE.

This is probably caused by the fact that ACC uses a function of IE/Outlook/Office that is designed for saving web pages and then viewing them off line.

If this is the case can you live with the Zone alarm message be cause we will not be able to stop it happening without a change in Zone Alarm

Schatzy

No, it still opens the output list in IE. I have NO PROBLEM with the ZA message and can ignore it anyway(as you probably know). Please don't put any work in that direction!

It does "weird" me out a bit that it still open in IE even though I checked the file associations. Will check more later but the better half requires my attention.

Cheers guys!

SS

schatzy
2008-01-16, 19:07
Secret Squirrel,

Can you check something.

1. Open you ACC folder
2. Open the AlbumCatalog folder
Question - the htm or html files in that folder do they have an IE icon or a Firefox icon.

Which icon is shown?

Schatzy

Secret Squirrel
2008-01-16, 20:22
Secret Squirrel,

Can you check something.

1. Open you ACC folder
2. Open the AlbumCatalog folder
Question - the htm or html files in that folder do they have an IE icon or a Firefox icon.

Which icon is shown?

Schatzy

Schatzy,

I checked as you requested. All the files except the MHTML have the Firefox icon. The MHTML have an icon I don't recognize. (Whew, I thought I was checking the associations correctly ;) )

HTH,

SS

SilverRS8
2008-01-17, 00:24
Schatzy,

I checked as you requested. All the files except the MHTML have the Firefox icon. The MHTML have an icon I don't recognize. (Whew, I thought I was checking the associations correctly ;) )

HTH,

SS

Hi Secret Squirrel,

First of all thx for your positive feedback in previous posts and i'm glad it works in firefox, although it opens in IE.

The opening of the file in IE is actually hardcoded for two reasons;
1. everybody has IE installed and not everybody has firefox. This script ofcourse could check on this but I don't know if its fair to say that, if firefox is installed, then open in firefox?
2. The .MHT file creation is only supported by IE.
I used the .MHT file in the past to open it in Word and do some additional markup stuff but now ACC is working a lot better I don't use it anymore to be honest. I think i'll make it an option to generate it as it slows down the finishing of the script.

If you like Firefox to open as default, change the code in the line 1062:
WshShell.run Chr(34) & "c:\Program Files\Internet Explorer\iexplore.exe " & Chr(34) & " " & Chr(34) & sOutputfileLong & Chr(34)
with the path to the executable of firefox. I think this should do the trick

Frank

SilverRS8
2008-01-17, 00:29
Installed RC2a and the script ran without a hitch. All the album covers were found and displayed. The main problem that remains, in my case, is that not all the tracks are sorted correctly for all the albums. I'm trying to find out what's common with those albums whose tracks are out of order, but I can not find anything. The Web interface of SC7 displays all the albums with all the tracks in the correct order.

The other issue is "cosmetic" and does not need to be prioritize. I can live with it. I rather have more sorting options implemented. But just in case, I'm attaching two images. The one on the left is what I get when I start the ACC. The one on the right is what I get after I resize the ACC window. Btw, I did not have this issue with the first two beta release.

Thx, Tamanaco for your feedback that it now works for you. You were still my list because you still had some issues.

The font size thing is indeed what Schatzy described. Actually applications can't handle the larger font size very well. They are all designed for the smaller one. Often you will see text missplacements and text not fitting into fixed size places like the statusbar. Please try to change the font size to something smaller and see what happens. It should look like the screenshot on the forum thread first post.

As for the sorting order; I'm aware of it and it can be related to tracks where other (guest) artists are singing along. This is currently being worked on...
I'll let you know if there is some progress here.

BTW; do you still have the acc.cfg (configuration file problem). that is; it is not created?

Frank

Frank

Diana
2008-01-17, 01:07
SilverRS8 wrote:
> The opening of the file in IE is actually hardcoded for two reasons;
> 1. everybody has IE installed

I wouldn't say that in the company of people using free software (e.g.
the GNU/Linux OS)!

;-)

SilverRS8
2008-01-17, 01:18
SilverRS8 wrote:
> The opening of the file in IE is actually hardcoded for two reasons;
> 1. everybody has IE installed

I wouldn't say that in the company of people using free software (e.g.
the GNU/Linux OS)!

;-)

True. But (maybe sadly) ACC is writtin in VBScript and hence only runs on Windows -> everybody has IE installed ;-). I know this is not pretty and do I agree with you but my Perl skills are just at zero level I'm afraid.

Do I hear someone offering to port it to Perl so ACC runs on any platform? :-)

Frank

MuckleEck
2008-01-17, 01:38
MuckleEck,

Please try and select just one of the album folders in your that has less than 50 tracks (if you have one)

I.E. y:\music\v\various artists\<album>

And try to run ACC again, then run it on a folder that has more than 150 tracks and report back if either of those work.

I have tested this here on my system and do not find a problem, but i do not have any folder that has more than 56 tracks.

Thanks

Schatzy

Schatzy,

I ran various scenarios last night as follows:-

1. Reverted to another machine and installed Slimserver from the website, asked it to scan just one directory of tracks (mixture of MP3 and FLAC) with no album with more than 20 songs, then ran ACC no issues! :-) This directory was on my C drive not the NAS
2. Added an album into this directory that has 201 tracks, again no issues! :-)
3. Then asked slimserver to rescan the entire directory including all the various atrists folders (this took a couple of hours) then ran acc....no joy, kept coming up with the slow script error, I kept pressing no, thinking that it may eventually get there...but once the log file was 20M and had 441,000 entries of various artists I gave up.
4. Ran acc but this time did not specify a compilation directory...runs but doesn't show up any album art and obviously every compilation is split into the separate areists, I have the same issue with Secret Squirrel in that it opens the resulting file in IE even though Firefox is set as my main browser. When I open the files in Firefox they look the same as IE (i.e. no album covers) The album covers are all either cover or folder.jpg and various sizes all covers in the folder of the album. All covers visible in Album View of Slimserver.

Sorry for being a pest!...but this will be great for me thanks.

SilverRS8
2008-01-17, 02:14
Schatzy,

I ran various scenarios last night as follows:-

1. Reverted to another machine and installed Slimserver from the website, asked it to scan just one directory of tracks (mixture of MP3 and FLAC) with no album with more than 20 songs, then ran ACC no issues! :-) This directory was on my C drive not the NAS
2. Added an album into this directory that has 201 tracks, again no issues! :-)
3. Then asked slimserver to rescan the entire directory including all the various atrists folders (this took a couple of hours) then ran acc....no joy, kept coming up with the slow script error, I kept pressing no, thinking that it may eventually get there...but once the log file was 20M and had 441,000 entries of various artists I gave up.
4. Ran acc but this time did not specify a compilation directory...runs but doesn't show up any album art and obviously every compilation is split into the separate areists, I have the same issue with Secret Squirrel in that it opens the resulting file in IE even though Firefox is set as my main browser. When I open the files in Firefox they look the same as IE (i.e. no album covers) The album covers are all either cover or folder.jpg and various sizes all covers in the folder of the album. All covers visible in Album View of Slimserver.

Sorry for being a pest!...but this will be great for me thanks.

Problems are there to be solved so we'll do our very best. Am I right that it only goes wrong when letting ACC run on the complete Various Artist folder when the actual data is on the NAS? In that case the following question;
- Is SS or SC running on the NAS or on your computer?

If running on the NAS, what is the path to the compilation folder from the NAS point of view? ACC will use this path to check if there are album covers. But this exact same path probably isn't available on your computer where ACC runs hence it can't find them. This however should not result in the ACC hanging.
If this is indeed the scenario you're using check out the posts from phil. The trick here would be to subsitute the paths stored in the database to a path that can be resolved from the computer running ACC. You probably have a mapped drive to the NAS.

Let me know if this scenario is the case.

Frank

SilverRS8
2008-01-17, 02:44
Schatzy,

I ran various scenarios last night as follows:-

1. Reverted to another machine and installed Slimserver from the website, asked it to scan just one directory of tracks (mixture of MP3 and FLAC) with no album with more than 20 songs, then ran ACC no issues! :-) This directory was on my C drive not the NAS
2. Added an album into this directory that has 201 tracks, again no issues! :-)
3. Then asked slimserver to rescan the entire directory including all the various atrists folders (this took a couple of hours) then ran acc....no joy, kept coming up with the slow script error, I kept pressing no, thinking that it may eventually get there...but once the log file was 20M and had 441,000 entries of various artists I gave up.
4. Ran acc but this time did not specify a compilation directory...runs but doesn't show up any album art and obviously every compilation is split into the separate areists, I have the same issue with Secret Squirrel in that it opens the resulting file in IE even though Firefox is set as my main browser. When I open the files in Firefox they look the same as IE (i.e. no album covers) The album covers are all either cover or folder.jpg and various sizes all covers in the folder of the album. All covers visible in Album View of Slimserver.

Sorry for being a pest!...but this will be great for me thanks.

Just had a look into the problem;
1 - How large is your total music catalog?
2 - Try specifying a starting folder

My folder structure is something like:

\Music\seperate tracks\rock
\Music\seperate tracks\club
\Music\seperate tracks\Jazz
\Music\Full albums\<artist>\<album>
\Music\Full albums\Various Artist\<album>

When I only specify the compilation folder (no starting folder) then I have 1250 + albums because first three listed paths are considered full albums but because they only contain seperate tracks almost each track is considered an album.

When I specify the starting folder to point to the full albumsfolder the output is ok as is the album count.

Try to play with the starting folder to see if this has an effect.

Frank

MuckleEck
2008-01-17, 02:48
Frank,

SS is on a laptop (for testing) SC on a desktop (primary) all music stored on a NAS

On the desktop with SC running the URL in the MySQL database looks like

file:////n2100/itunes/Music/B/Bach/Bach-%20Organ%20Works%20-%20Michael%20Murray/04%20%20-%20Toccata,%20Adagio%20and%20Fugue,%20for%20organ% 20in%20C%20major,%20BWV%20564%20(BC%20J36).flac

This is from an excel query of the database.

Thanks

SilverRS8
2008-01-17, 02:54
Frank,

SS is on a laptop (for testing) SC on a desktop (primary) all music stored on a NAS

On the desktop with SC running the URL in the MySQL database looks like

file:////n2100/itunes/Music/B/Bach/Bach-%20Organ%20Works%20-%20Michael%20Murray/04%20%20-%20Toccata,%20Adagio%20and%20Fugue,%20for%20organ% 20in%20C%20major,%20BWV%20564%20(BC%20J36).flac

This is from an excel query of the database.

Thanks

Ah I see. Then the workaround as posted by Phil is applicable. When you have i.e. drive X mapped on your windows computer to \\n2100\itunes\music all ACC needs to do is replace \\n2100\itunes\music by X:\ when looking for album covers and it should work.
Please view the post from Phil first (he also attached his version of the script (beware; based on a previous release)) as I'm currently at work and can't get into code specifics right now.

Frank

schatzy
2008-01-17, 05:01
SilverRS8 wrote:
> The opening of the file in IE is actually hardcoded for two reasons;
> 1. everybody has IE installed

I wouldn't say that in the company of people using free software (e.g.
the GNU/Linux OS)!

;-)

Diana,

Maybe you should have read through the thread before posting.

As Frank said anyone that uses this WILL have IE installed. Because it will not work if it is not.

SilverRS8
2008-01-17, 05:27
Just to clearify things up because I think there is a miss understanding here. ACC does not have a external browser requirement. It generates plain text files which happen to have the .html extension. It can be opened with IE or Firefox (as this was fixed in the last version).

It also creates a .MHT file which is a archive file of IE only for usefullness but not required since the .HTML files have the same content (but can't be distributed).

It just opens IE, for the user convinience, to display the generated output file and because IE is installed default on Windows this was hardcoded.

Frank

tamanaco
2008-01-17, 05:38
Thx, Tamanaco for your feedback that it now works for you. You were still my list because you still had some issues.

The font size thing is indeed what Schatzy described. Actually applications can't handle the larger font size very well. They are all designed for the smaller one. Often you will see text missplacements and text not fitting into fixed size places like the statusbar. Please try to change the font size to something smaller and see what happens. It should look like the screenshot on the forum thread first post.

As for the sorting order; I'm aware of it and it can be related to tracks where other (guest) artists are singing along. This is currently being worked on...
I'll let you know if there is some progress here.

BTW; do you still have the acc.cfg (configuration file problem). that is; it is not created?

Frank

Frank

No problem, I'm glad to be of any help.

I use Remote Desktop from a laptop running Vista to manage my SC 7 Server remotely. The Advanced button under Desktop Properties is greyed out in RD, but changing the font size via IE from Large to Medium fixed the problem. My thanks to Schatzy.

Hmmm, I thought you were using the [track] tag to generate the sorting order. I will patiently wait for your fix.

No problems with acc.cfg RC2a creates it.

schatzy
2008-01-17, 09:35
to: tamanaco,

Glad to be of assistance.

To: MuckleEck

I will be borrowing a NAS with music on it this weekend to do some other testing for SilverRS8.

If you are still having problems after going through Phil's posts let me know and I will try to figure out a senario for you that will work to your and others benefit.

Schatzy

MuckleEck
2008-01-17, 10:21
Schatzy & Frank,

I have played around with things and found the following:-

1. I change the SS to log on as user and then use x:\music as the folder, SS still stored everything in the database as \\n2100\itunes\music...so no joy there
2. I copied all my music onto an external USB drive. Attached this to the pc and asked SS to rescan...except that it still looked at the NAS...I then disconnected the PC from the network and rescanned...result.
3. Ran ACC and it worked...still a few missing pictures but can sort that out separately.
4. Ran ACC with the various artists folder specified, worjed exactly as above.

Conclusions:-

a) ACC doesn't seem to like the references to external drives and the speed of the drive may be an issue.
b) Pop the music onto an external USB drive and do a run...excellent results

If I can do any more testing just give me a shout many thanks for a great program

MuckleEck
2008-01-17, 10:32
Frank,

Now that I have it working I have a request.

I use a customDB setting in my tags that allows me to sort the music by who owns it in the family (me, wife, kids etc)

How easy would it be to add an extra sort criteria that can be customised?

The heading in the MySQL database is value although I am unsure of what context that is in. I think it may be one of tme comments fields. in MP3Tag it is shown as COMMENT SONGS-DB_CUSTOM1 as one of the Extended Tags.

Many thanks

schatzy
2008-01-17, 11:19
Frank,

Now that I have it working I have a request.

I use a customDB setting in my tags that allows me to sort the music by who owns it in the family (me, wife, kids etc)

How easy would it be to add an extra sort criteria that can be customised?

The heading in the MySQL database is value although I am unsure of what context that is in. I think it may be one of tme comments fields. in MP3Tag it is shown as COMMENT SONGS-DB_CUSTOM1 as one of the Extended Tags.

Many thanks

MuckleEck,

When you say you have it working, do you mean off the USB drive or the NAS?


Conclusions:-

a) ACC doesn't seem to like the references to external drives and the speed of the drive may be an issue.

When you say the speed of the drive do you mean the spinning speed or the time to access the drive through the network?

Schatzy

SilverRS8
2008-01-17, 12:09
Frank,

Now that I have it working I have a request.

I use a customDB setting in my tags that allows me to sort the music by who owns it in the family (me, wife, kids etc)

How easy would it be to add an extra sort criteria that can be customised?

The heading in the MySQL database is value although I am unsure of what context that is in. I think it may be one of tme comments fields. in MP3Tag it is shown as COMMENT SONGS-DB_CUSTOM1 as one of the Extended Tags.

Many thanks

Good to hear the positive results. Good work. With a small change you can leave all data on the NAS. Just map a drive to the NAS and add a replace() function command somewhere to replace the NAS path notation to the mapped drive location. This way you can leave SS, its database and file storage untouched and just use ACC like it should be.
If you want to try this let me know. I'll show you the code for the replace command.

Frank

MuckleEck
2008-01-17, 13:44
Frank,

I shall have a play with the replace() caommand tomorrow

Shatzy,

It worked through the USB only.

I suspect that there may be an issue wither with the drive mapping (as discussed with Frank above) or the speed at which the data can be recovered from the NAS, not sure. My network is all 100M so quick enough although using a USB2 HD was significantly faster for a scan by SS.

Thanks

Alasdair

SilverRS8
2008-01-18, 15:30
To solve the track sorting problem with tracks with other artists featuring, I have to change quiet a lot of the query code. Actually I have to split the query into returning all the results as it does now, the process them and determine if it is to be marked as Various album or not. I will also use the followong algorithm;
If an artist performed more than half of the songs and also features in the other songs (with other artist featuring) that that artist is marked as Album Artist. Finally when all this is done the total recordset will have a trustfull Album Artist column which can be sorted on.

I think this will work quiet well and even eliminate the use for specifying the compilation folder. But this will cost some time though to implement and test so bare with me on that one please.


I would also like to ask which new features you would like to see implemented? I'll collect them all and see which are implemented in the next version.

Anyway, thx guys(/girls?) for your support of ACC so far...

Frank

schatzy
2008-01-18, 19:33
Schatzy & Frank,

I have played around with things and found the following:-

1. I change the SS to log on as user and then use x:\music as the folder, SS still stored everything in the database as \\n2100\itunes\music...so no joy there

What brand of NAS do you have? Also does it have its own software to set up the network drive letter.

The reason I ask is that I have a Buffalo Link Station here this weekend and it has it's own software that it uses to set it up and set the drive letter it uses.

I find that it does exactly as you stated above it drops teh mapped letter.

I forced a mapping through windows and it worked correctly and showed the drive letter in the path. As seen below

SilverRS8
2008-01-18, 23:56
Just to let you know; i'm looking into the possibility to add NAS support to ACC by adding the option to enter the path to the NAS and the drive letter used in windows so ACC can do the substitution automatically and find the albumcovers like it is supposted to.

Frank

scalesr1
2008-01-19, 00:06
I would love to see it optionally seek out any missing album artwork.

Thank for all the hard work.

Richard Scales


-----Original Message-----
From: discuss-bounces (AT) lists (DOT) slimdevices.com
[mailto:discuss-bounces (AT) lists (DOT) slimdevices.com] On Behalf Of SilverRS8
Sent: 18 January 2008 22:31
To: discuss (AT) lists (DOT) slimdevices.com
Subject: Re: [slim] Announce: Album Catalog Creator for SlimServer


To solve the track sorting problem with tracks with other artists
featuring, I have to change quiet a lot of the query code. Actually I
have to split the query into returning all the results as it does now,
the process them and determine if it is to be marked as Various album
or not. I will also use the followong algorithm;
If an artist performed more than half of the songs and also features in
the other songs (with other artist featuring) that that artist is marked
as Album Artist. Finally when all this is done the total recordset will
have a trustfull Album Artist column which can be sorted on.

I think this will work quiet well and even eliminate the use for
specifying the compilation folder. But this will cost some time though
to implement and test so bare with me on that one please.


I would also like to ask which new features you would like to see
implemented? I'll collect them all and see which are implemented in the
next version.

Anyway, thx guys(/girls?) for your support of ACC so far...

Frank


--
SilverRS8

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

Ur[s]uS
2008-01-19, 07:52
Just to let you know; i'm looking into the possibility to add NAS support to ACC by adding the option to enter the path to the NAS and the drive letter used in windows so ACC can do the substitution automatically and find the albumcovers like it is supposted to.

Frank

it might be inelegant, but i've just read this thread three times and have managed to get parubeni's modified script to work with my system

for the record:

slimserver 6.5.4 running on Windows Media Center
music files stored on \\Readynas\music\
map that path as network drive, say Z:\
install ACC to run on the same computer as slimserver

then using parubeni's modified script:
- change IP address back to localhost 127.0.0.1
- change network path to the \\Readynas\music\ (as per slimserver database)
- change mapped path to Z:\ (as per windows mapping)

set parameters on script GUI (leaving VA and start folder blank, as my solution to VA is to list artists in songtitle and list albumartist/band etc as "VA")

click start

check log for details - upon opening the database, it should report references to the records being entered for each album etc


without using parubeni script and making changes, the script would peg the CPU and log reported blank entries over and over and over again - before script running slow error etc.

i preferred to run the script on the same computer as slimserver (for convenience and to avoid opening ports on the firewall, even temporarily)

this works really great
it looks pretty and does a job i've been interested in having done for some time
well done to all and to SilverRS8, of course, in particular
thank you


some comments that might be helpful:

- suggest extended default covers to include "front.jpg"

- it is possible for *.png files to work too? (i've changed all mine to cover/folder.jpg, so not needed for me, but maybe others not so diligent)

- extend the characters to include "DvořŠk" (the "r" in Dvorak the composer)

- i'm not sure genre exclusion works - i'd expect to be able to type "Classical" and expect all my Bach Cantatas to be omitted - this did not happen (my workaround was to move all classical artists to new folder and move all other music to folder on same level - that way i can limit the script to the folder without classical music)

- i choose sort by artist, which is what i want
but it then sub-sorts the albums by year in reverse chronological order (i'm sure you intend other options in due course, but i wonder whether the default should be alphabetical or years chronologically)


i've yet to play around with the print options and margins etc. but did notice some overhanging pages with long album titles (mainly in classical music, which folder i've excluded by default)


anyway - those are my comments

thanks again to SilverRS8 - the script works a treat (after a few long hours getting - what would probably be simple things for other people - to work !!!!)

SilverRS8
2008-01-19, 11:35
uS;260443']it looks pretty and does a job i've been interested in having done for some time
well done to all and to SilverRS8, of course, in particular
thank you

Always good to hear positive feedback. Keeps me focused on improving it. It is actually quiet easy to change ACC to access the NAS through the mapped drive letter and scan for album covers. It should only be one simple Replace command added to the code. I'm going to create some GUI options to facilitate NAS users. I'm interested in the changes you or other NAS users might have made to get ACC working with a NAS. I can then code this into a next version. So if you have some examples, please post it here or send me the code by PM.



uS;260443']some comments that might be helpful:

- suggest extended default covers to include "front.jpg"

You can change line 72 in the script 'sCoverFilename = "cover.jpg,folder.jpg"' and add your cover file name to the comma seperated list.


uS;260443']- it is possible for *.png files to work too? (i've changed all mine to cover/folder.jpg, so not needed for me, but maybe others not so diligent)

Yes, just add the .PNG file to line 72. As long as the browser supports it, it should work (I believe older IE version do not support PNG).

Just a tip; The multi rename tool of Total commander can be used to rename all xxxxxxxx.jpg files to i.e. cover.jpg. Just takes a few seconds to process hundreds of folders.


uS;260443']- extend the characters to include "DvořŠk" (the "r" in Dvorak the composer)

Noted and added to my fix list.


uS;260443']- i'm not sure genre exclusion works - i'd expect to be able to type "Classical" and expect all my Bach Cantatas to be omitted - this did not happen (my workaround was to move all classical artists to new folder and move all other music to folder on same level - that way i can limit the script to the folder without classical music)

Haven't used it lately but I will take a look at it.


uS;260443']- i choose sort by artist, which is what i want
but it then sub-sorts the albums by year in reverse chronological order (i'm sure you intend other options in due course, but i wonder whether the default should be alphabetical or years chronologically)

That is actually my personal preference. Will be made an option in a next version but if you like to change it, change line 477:
sQOrderBy = "order by artist,year DESC,lcase(convert(albums.titlesort using utf8)),tracks.disc,tracks.tracknum;"
to:
sQOrderBy = "order by artist,year ASC,lcase(convert(albums.titlesort using utf8)),tracks.disc,tracks.tracknum;"


uS;260443']thanks again to SilverRS8 - the script works a treat (after a few long hours getting - what would probably be simple things for other people - to work !!!!)

You very welcome and I think you did a pretty good job yourself getting it to work.

Frank

MuckleEck
2008-01-20, 13:38
Shatzy,

It seems that the drive mapping works if squeezecenter/slimserver is run at login and makes use of a users account information to colelct the mapping info...I run SC as a service and it doesn't see the mapping.

I am using a thexus 2100 NAS

terry
2008-01-20, 14:15
Hello,
I'm perplexed since the ODBC System DSN tests OK (via the ODBC Data Source Administrator) and the entire SQL command string (copied from the ACC.log) succeeds with the MySQL Query Browser but the ACC script itself fails with an error 0.

My system config:
Windows XP x64 SP2 (O/S on C:, Slimserver on D:, music on E:)
mysql ODBC connector for XP x64 v3.51.23
mysql gui tools v5.0-r12-win32
SlimServer Version: 6.5.2 - 12047 - Windows Server 2003 - EN - cp1252
Perl Version: 5.8.8 MSWin32-x86-multi-thread
MySQL Version: 5.0.22-community-nt

ACC.cfg:

SF|E:\Archived Music
G2E|
CF|E:\Archived Music\Various Artists
DT|False
DG|True
ACS|True
APPS|True
SB|1

Acc.log:

STATUS : fnReadSettings():ENTER:4:12:17 PM
STATUS : fnReadSettings():LEAVE:4:12:17 PM
STATUS : fnReadSettings():ENTER:4:12:17 PM
STATUS : fnReadSettings():LEAVE:4:12:17 PM
STATUS : fnReadSettings():ENTER:4:12:17 PM
STATUS : fnReadSettings():LEAVE:4:12:17 PM
STATUS : fnReadSettings():ENTER:4:12:17 PM
STATUS : fnReadSettings():LEAVE:4:12:17 PM
STATUS : fnReadSettings():ENTER:4:12:17 PM
STATUS : fnReadSettings():LEAVE:4:12:17 PM
STATUS : fnReadSettings():ENTER:4:12:17 PM
STATUS : fnReadSettings():LEAVE:4:12:17 PM
STATUS : fnReadSettings():ENTER:4:12:17 PM
STATUS : fnReadSettings():LEAVE:4:12:17 PM
STATUS : fnReadSettings():ENTER:4:12:17 PM
STATUS : fnReadSettings():LEAVE:4:12:17 PM
ACC Version : 1.0 Release Candidate 2a
STARTED : 1/20/2008 --- 4:12:17 PM
STATUS : Window created
STATUS : fnStart():ENTER:4:12:20 PM
OPTION SELEC: Display Tracks = False
OPTION SELEC: Cover art size = True
OPTION SELEC: Display Genre = True
OPTION SELEC: Sort by = Artist
OPTION SELEC: AutoPrintPageSep = True
OPTION SELEC: Filter: Starting folder = E:\Archived Music
OPTION SELEC: Filter: Compilation folder = E:\Archived Music\Various Artists
OPTION SELEC: Filter: Genres to exclude =
STATUS : fnStoreSettings():ENTER:4:12:20 PM
STATUS : fnStoreSettings():LEAVE:4:12:20 PM
STATUS : fnStart():LEAVE:4:12:20 PM
STATUS : fnStart2():ENTER:4:12:20 PM
STATUS : fnQueryLogic():ENTER:4:12:20 PM
STATUS : fnCreateSQLQuery(1):ENTER:4:12:22 PM
STATUS : fnCreateSQLQuery(1):
STATUS : select CONVERT(contributors.name USING utf8) as artist,CONVERT(albums.title USING utf8) as album,albums.year AS year, tracks.url AS filepath, tracks.tracknum AS tracknumber, CONVERT(tracks.title USING UTF8) as tracktitle,CONVERT(SEC_TO_TIME(tracks.secs),CHAR) as duration, genres.namesort AS 'genre' from tracks join albums on albums.id=tracks.album AND albums.titlesort!='SINGLE TRACK' AND albums.titlesort!='NO ALBUM' left join contributor_track on contributor_track.track=tracks.id and (contributor_track.role in (1) or contributor_track.role in (5))left join contributors on contributor_track.contributor=contributors.id left join genre_track on genre_track.track=tracks.id left join genres on genre_track.genre=genres.id
STATUS : WHERE INSTR(UCASE(tracks.url), 'FILE:///E:/Archived%20Music') AND !INSTR(UCASE(tracks.url), 'FILE:///E:/Archived%20Music/Various%20Artists')
STATUS : group by tracks.id,lcase(convert(albums.title using utf8))
STATUS : order by artist,year DESC,lcase(convert(albums.titlesort using utf8)),tracks.disc,tracks.tracknum;
STATUS : fnCreateSQLQuery(1):LEAVE:4:12:22 PM
STATUS : fnPerformQuery(1):ENTER:4:12:22 PM
STATUS : fnPerformQuery():Recordset opened:4:12:22 PM
ERROR : fnPerformQuery():An error occured while connection to the database. Error number: 0 -- Error description:


I agree that this should be basic included functionality with the Slimserver and would love to get this working. Does anyone have any ideas what could be wrong? Thanks in advance.

Terry

schatzy
2008-01-20, 18:14
Shatzy,

It seems that the drive mapping works if squeezecenter/slimserver is run at login and makes use of a users account information to colelct the mapping info...I run SC as a service and it doesn't see the mapping.

I am using a thexus 2100 NAS

MuckleEck,

I also run SC7 as a service and i had to map a drive through windows in the following manner. Putting what i did here not know what your experience is, and for those who are not so technically inclinde

1. Right click on "My Computer"

2. Click on "Map Network Drive..."

3. Pick drive letter that you want to use.

4. Browse (using browse button) to the folder on your network attached storage that has your music on it. You can not select the root folder as this will not create a proper mapping.

5. Click finish.

Test your mapping by opening my computer and clicking on the drive letter you selected it should bring up a the "contents" of the folder that you mapped to.

I did this with two different NAS boxes One Link Station and one Infrant. Both worked properly if the mapping was done as stated above.

If yo let the NAS Software select the drive letter or how it is to connect to your computer it WILL NOT work.

Phil had a work around that i tried and it worked as well but was much more work to get it working.

Schatzy

SilverRS8
2008-01-20, 23:58
Hello,
I'm perplexed since the ODBC System DSN tests OK (via the ODBC Data Source Administrator) and the entire SQL command string (copied from the ACC.log) succeeds with the MySQL Query Browser but the ACC script itself fails with an error 0.

The error 0 reporting is actually a bug. I've a new version ready with proper error messaging. I'll post it in a few days (after it has been tested).


I agree that this should be basic included functionality with the Slimserver and would love to get this working. Does anyone have any ideas what could be wrong? Thanks in advance.

Terry

Please wait a few days and I'll help you get it to work.

Frank

SilverRS8
2008-01-21, 00:00
Shatzy,

It seems that the drive mapping works if squeezecenter/slimserver is run at login and makes use of a users account information to colelct the mapping info...I run SC as a service and it doesn't see the mapping.

I am using a thexus 2100 NAS

The service is probable not running in the same user context as your logon account but as a system account. A system account does not have access to some resources where a normal user account has proviledges to.

If you change the Service login setting (service control panel) to use the same user credentials as the account you normally work on it should also work when running SC as a service. I does so on my computer.

Frank

MuckleEck
2008-01-21, 02:13
Frank and Schatzy,

I have changed the login for squeezecenter to use a login that has the drives mapped....all working now...many thanks

SilverRS8
2008-01-26, 13:19
Hi all,

I have posted the RC3 version of ACC.

RCS contains the following changes;
CHANGED Automatic Various Artist detection. No need for the compilation folder specification ! It has been removed
CHANGED Updated core database algorithm now using multiple queries to improve performance
CHANGED Names of output files
FIXED No strange sorting problems. Sorting is consistent now.
FIXED Error handling. No more error 0 messages
ADDED Will create a temporary database called ACC, Process all Various Artist albums as classified by SC and determine if this is really the case. If not, the Album artist is changed to reflect the correct Album Artist. When all changes are applied, the ACC table contains all correct information. This table is then used by the fnWriteOutput function to create the output.
ADDED When a track has a featuring artist specified in the Artist field tag, it is displayed in the tracklisting. Previously this was not shown for the Artist field tag (only for the track title tag).
ADDED When an album contains multiple CD's and the Dics field tag is used, it will display CDx in the tracklisting field
ADDED Option added for Genre includes and excludes
ADDED Option added for sorting Album Year ascending or descending
ADDED Option to distinguish album by either path or internal database ID. By path gives better result since even a case change in an album title will result in SC assinging a new album id resulting in sorting problems.
ADDED Selected sorting option displayed in the Title page

So the biggest change is probably there is no need to specify a compilation folder anymore. You also have to be aware of deselecting the 'Use folder structure to distinguish albums' option your album name tagging must be consistent for each album or otherwise ACC will show this as multiple albums because SC has used multiple album ids.

Schatzy has done a lot of testing for which i would like to thank him. Please let me know how RC3 performs. Native support for NAS devices is yet to be added.

For albums consisting of multiple CDs this either has to be indicated by the disc tag or in the Album tags. The same album tag with no disc tages results in strange results which is rather logical because the cd's can't be distinguished.

Frank

tamanaco
2008-01-26, 18:02
Frank, I think there is something wrong with the .zip file you attached. After I decompress it I endup with file called acc-v1-RC3. I click on it and nothing happens.

terry
2008-01-27, 07:59
Tamanaco,
Looks like it's an archive within an archive; just add a zip extension to open the embedded archive.

Frank,
With RC3 I'm now getting a non-zero error message; hope it means more to you!


ACC.log:

ACC Version : 1.0 Release Candidate 3
STARTED : 1/27/2008 --- 9:57:07 AM
STATUS : fnStart():ENTER:9:57:29 AM
OPTION SELEC: Display Tracks = False
OPTION SELEC: Cover art size = True
OPTION SELEC: Display Genre = True
OPTION SELEC: Sort by = Artist
OPTION SELEC: GenreIncludeExclude = Include
OPTION SELEC: Sort Year Descending = True
OPTION SELEC: AutoPrintPageSep = True
OPTION SELEC: Filter: Starting folder = E:\Archived Music
OPTION SELEC: Filter: Genres entered =
STATUS : fnStart():LEAVE:9:57:29 AM
STATUS : fnStart2():ENTER:9:57:29 AM
STATUS : fnQueryLogic():ENTER:9:57:29 AM
STATUS : fnPreProcessing():ENTER:9:57:30 AM
STATUS : fnPreProcessing():sql(1):Create table ACC SELECT CONVERT(album_artist.name USING UTF8) AS 'AlbumArtist',CONVERT(albums.title USING UTF8) AS 'AlbumName',Albums.id AS 'AlbumID',CONVERT(tracks.title USING UTF8) AS 'Title',CONVERT(tracks.disc USING UTF8) AS 'Disc',CONVERT(SEC_TO_TIME(tracks.secs),CHAR) as 'Duration',albums.year AS 'AlbumYear',tracks.url AS 'path',tracks.tracknum AS 'TrackNum',genres.namesort AS 'Genre',CONVERT(track_artist.name USING UTF8) AS 'TrackArtist' FROM albums join contributors AS album_artist on albums.contributor=album_artist.id 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 join contributor_track ON tracks.id = contributor_track.track and (contributor_track.role in (1) or contributor_track.role in (5)) join contributors AS track_artist on contributor_track.contributor = track_artist.id WHERE INSTR(UCASE(tracks.url), 'FILE:///E:/Archived%20Music') ORDER BY album_artist.namesort, albums.titlesort, tracks.disc, tracks.tracknum, track_artist.name, tracks.url;
STATUS : fnPreProcessing():LEAVE:9:57:30 AM
STATUS : fnCreateSQLQuery(0):ENTER:9:57:30 AM
STATUS : fnCreateSQLQuery(0):SELECT * FROM acc a Where AlbumArtist != 'Various Artists' order by AlbumArtist,AlbumYear DESC,AlbumName,Disc,Tracknum;
STATUS : fnCreateSQLQuery(0):LEAVE:9:57:30 AM
STATUS : fnPerformQuery(0):ENTER:9:57:30 AM
ERROR : fnPerformQuery():An error occured while connection to the database. Error number: 3709 -- Error description: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
STATUS : fnPerformQuery(0):Recordset opened:9:57:30 AM


ACC.cfg:

SF|E:\Archived Music
GE|
DT|False
DG|True
ACS|True
APPS|True
SB|1
SYD|True
GI|True
UFS|True

tamanaco
2008-01-27, 09:37
Tamanaco,
Looks like it's an archive within an archive; just add a zip extension to open the embedded archive.




Thanks Terry, that worked.

Frank, nice update the album tracks are now sorted correctly. One small "cosmetic" improvement could be to line up the least significant digit of the track names.

_9 - trackname ("_" = space)
10 - trackname

Instead of

9 - trackname
10 - trackname

What "free" utility are you guys using to generate .pdf file? I'm using PDF Creator 0.95. The page display beautifully within the IE7, but the resulting .pdf file ends up with some blank pages and page breaks in the wrong places. This is visible in the print preview and in the resulting .pdf file. I use the option to print to the pseudo PDFCreator printer to create the .pdf file. I tried it running ACC with the page break option checked and unchecked, but got the same result. Any suggestions?

Thanks...

Edit: One more thing. The track count is right, but the album count that is displayed after ACC runs is way off.

Kyle
2008-01-27, 11:59
CHANGED Automatic Various Artist detection. No need for the compilation folder specification ! It has been removed

Frank

WHOA!!! You mean now that I've changed my entire file system, you went and eliminated the need? ;-)

ModelCitizen
2008-01-27, 12:25
WHOA!!! You mean now that I've changed my entire file system, you went and eliminated the need? ;-)
Yup, that's how I felt too... :-)
MC

SilverRS8
2008-01-27, 13:14
WHOA!!! You mean now that I've changed my entire file system, you went and eliminated the need? ;-)

*BLUSHING* Uhmm I think so :-)

Point is; I managed to create a query in which SC returns all albums including the Various artist albums. I have a few albums on which one performing guest artist makes SC clasiffy the album as Various Artist album. Not feeling entire comfortable to live with that I thought of an 'algoritm' to determine for each Various Artist album if it is really a various artist album.

What the script technically does is; Sort the various artist by Artist. The shortest artist name is the Album Artist, If this album artist performs more then half of the song, the Various Artist is changed into the Album Artist. After all various artist albums are processed the actual output is created.

So, the big question here is; Does it do the job well? We did a lot of testing and it seems to do it ok but please let me know if this really is the case.

Frank

SilverRS8
2008-01-27, 13:16
Yup, that's how I felt too... :-)
MC

Sorry for all harm caused :-) Uhm can I still hide behind; 'but it is still a beta' please?

Let me know how it works for you....

Frank

SilverRS8
2008-01-27, 13:22
Thanks Terry, that worked.

Frank, nice update the album tracks are now sorted correctly. One small "cosmetic" improvement could be to line up the least significant digit of the track names.

_9 - trackname ("_" = space)
10 - trackname

Instead of

9 - trackname
10 - trackname

What "free" utility are you guys using to generate .pdf file? I'm using PDF Creator 0.95. The page display beautifully within the IE7, but the resulting .pdf file ends up with some blank pages and page breaks in the wrong places. This is visible in the print preview and in the resulting .pdf file. I use the option to print to the pseudo PDFCreator printer to create the .pdf file. I tried it running ACC with the page break option checked and unchecked, but got the same result. Any suggestions?

Thanks...

Edit: One more thing. The track count is right, but the album count that is displayed after ACC runs is way off.

Thx for the feedback. Good tip on addind a space char. Will add it in the next update.

The problem with blank pages is related to the ACC printseperator function. Based on a number of criteria (like maximum tracks on a page and maximum albums on a page etc) it determines whether to insert a print page seperator. This is not visible in the browser but only in the print preview (or PDF). In the help screen there are some tips on how to improve the seperation; lessen the page margins will probably do the trick here. Can you test this? If it does not work, can you send me two example pdf pages? I can then 'tune' the print seperation function with that.

Frank

SilverRS8
2008-01-27, 13:39
Tamanaco,
Looks like it's an archive within an archive; just add a zip extension to open the embedded archive.

Frank,
With RC3 I'm now getting a non-zero error message; hope it means more to you!

Hi Terry,

Can you disable line 489 in the AlbumCatalogCreator-V1.hta file and test if this makes a difference?

You can either remove it or put an ' character in front of the line to disable it.

Frank

terry
2008-01-27, 15:16
Frank,
Just to be sure, the line I commented out was the rs.close as shown in the following code fragment:


' ====== FUNCTION ================================================== ============
' Execute query and fill Album array
' ================================================== ============================
Function fnPerformQuery(iType)
oLogfile.writeline "STATUS : fnPerformQuery(" & iType & "):ENTER:" & Time()
On Error Resume Next
' rs.close
err.clear
rs.Open sql


Unfortunately, the resultant error appears the same:

ACC Version : 1.0 Release Candidate 3
STARTED : 1/27/2008 --- 5:14:24 PM
STATUS : fnStart():ENTER:5:14:27 PM
OPTION SELEC: Display Tracks = False
OPTION SELEC: Cover art size = True
OPTION SELEC: Display Genre = True
OPTION SELEC: Sort by = Artist
OPTION SELEC: GenreIncludeExclude = Include
OPTION SELEC: Sort Year Descending = True
OPTION SELEC: AutoPrintPageSep = True
OPTION SELEC: Filter: Starting folder = E:\Archived Music
OPTION SELEC: Filter: Genres entered =
STATUS : fnStart():LEAVE:5:14:27 PM
STATUS : fnStart2():ENTER:5:14:27 PM
STATUS : fnQueryLogic():ENTER:5:14:27 PM
STATUS : fnPreProcessing():ENTER:5:14:29 PM
STATUS : fnPreProcessing():sql(1):Create table ACC SELECT CONVERT(album_artist.name USING UTF8) AS 'AlbumArtist',CONVERT(albums.title USING UTF8) AS 'AlbumName',Albums.id AS 'AlbumID',CONVERT(tracks.title USING UTF8) AS 'Title',CONVERT(tracks.disc USING UTF8) AS 'Disc',CONVERT(SEC_TO_TIME(tracks.secs),CHAR) as 'Duration',albums.year AS 'AlbumYear',tracks.url AS 'path',tracks.tracknum AS 'TrackNum',genres.namesort AS 'Genre',CONVERT(track_artist.name USING UTF8) AS 'TrackArtist' FROM albums join contributors AS album_artist on albums.contributor=album_artist.id 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 join contributor_track ON tracks.id = contributor_track.track and (contributor_track.role in (1) or contributor_track.role in (5)) join contributors AS track_artist on contributor_track.contributor = track_artist.id WHERE INSTR(UCASE(tracks.url), 'FILE:///E:/Archived%20Music') ORDER BY album_artist.namesort, albums.titlesort, tracks.disc, tracks.tracknum, track_artist.name, tracks.url;
STATUS : fnPreProcessing():LEAVE:5:14:29 PM
STATUS : fnCreateSQLQuery(0):ENTER:5:14:29 PM
STATUS : fnCreateSQLQuery(0):SELECT * FROM acc a Where AlbumArtist != 'Various Artists' order by AlbumArtist,AlbumYear DESC,AlbumName,Disc,Tracknum;
STATUS : fnCreateSQLQuery(0):LEAVE:5:14:29 PM
STATUS : fnPerformQuery(0):ENTER:5:14:29 PM
ERROR : fnPerformQuery():An error occured while connection to the database. Error number: 3709 -- Error description: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
STATUS : fnPerformQuery(0):Recordset opened:5:14:29 PM

SilverRS8
2008-01-29, 00:39
Frank,
Just to be sure, the line I commented out was the rs.close as shown in the following code fragment:


' ====== FUNCTION ================================================== ============
' Execute query and fill Album array
' ================================================== ============================
Function fnPerformQuery(iType)
oLogfile.writeline "STATUS : fnPerformQuery(" & iType & "):ENTER:" & Time()
On Error Resume Next
' rs.close
err.clear
rs.Open sql


Unfortunately, the resultant error appears the same:

Strange. I can only relate this to mySQL and an open recordset that should be closed but others have reported no problem whatsoever. I tried several thing but they all result in non functioning ACC for other users.

I see in your system specs from your previous post you use the 64 bit version of XP? I'm afraid that I am unable to test and debug for that Windows version. Are you able to test ACC on the 32 bit version of Windows or maybe more easy on the server running SC? I think there will be no problem running ACC than...

Frank