PDA

View Full Version : Announce: Album Catalog Creator v2



SilverRS8
2009-12-31, 17:37
Hi all,

I just uploaded a new version of Album Catalog Creator. A tool to create a HTML catalog of your Squeezebox server music catalog.

ACC v2.0 new features:
- Unicode support for international characters
- Improved Quick Reference catalog
- ARTISTSORT tag sort support
- Many more features...

A sample Full and Quickreference catalog is attached. For more information and sample catalogs and ACC screenshots go to http://acc.vanholt.nl

If there are any issues or usage questions please use this thread.

And of course a very happy new year to everyone !!!

Frank

Chunkywizard
2010-01-01, 01:47
Hi Frank,

thanks for the update, I'm liking the property to change the location of the album property fields! One bug so far. I reported a while back about my Gnere Children's Music being not displayed. Now it's displayed, but incorrectly as Children#PH#s Music. Can you fix?

Thanks!

CW

SilverRS8
2010-01-01, 02:00
Hi Frank,

thanks for the update, I'm liking the property to change the location of the album property fields! One bug so far. I reported a while back about my Gnere Children's Music being not displayed. Now it's displayed, but incorrectly as Children#PH#s Music. Can you fix?

Thanks!

CW

Hi chunky,

Thx. Strange as it is working fine here. Can you mail me the acc.log file so I can see what setting you've used and try to reproduce it?

Frank

wowo
2010-01-01, 06:22
I have installed AAC but I get the following message when I click on the start button:
- Correcting incorrectly marked Various Artist albums
- No albums were found
Then the program stopped and of course no album catalog is created.
Squeezebox Server is installed on a Nas with SSODS.
Moose is working correct.
I am using Squeezebox Server Versie: 7.5.0 - r29584 (MySQL-versie: 5.1.34)

SilverRS8
2010-01-01, 06:37
I have installed AAC but I get the following message when I click on the start button:
- Correcting incorrectly marked Various Artist albums
- No albums were found
Then the program stopped and of course no album catalog is created.
Squeezebox Server is installed on a Nas with SSODS.
Moose is working correct.
I am using Squeezebox Server Versie: 7.5.0 - r29584 (MySQL-versie: 5.1.34)

According to your log file you used \\192.168.1.130\music\Music 1 as physical path which in fact is a UNC path notation. Since you are running SSODS you will probably have to use a notation like /usr/home/blabla. The path is used by ACC to get all data on music files residing within the directory specified. If the path is not the same as stored for music files in the database, no results are returned by the database query hence no albums found.

Press the TEST button on the remote server option screen and an example is displayed on the bottom of the ACC window on how the path is stored in squeezebox server. Use this to help you with the syntax.

Note:
Download v2.0 again as I made a small fix because the example didn't fit on the window anymore.

Let me know if this is of any help.

fphredd
2010-01-01, 08:49
Further to the discussion I began about differences in statistics btw Squeezebox Server and ACC using the previous version. Scanned a smaller directory:

Server: 230 albums with 4718 songs by 11 artists
ACC v2: Total albums: 250 Total tracks: 4989

??

Chunkywizard
2010-01-01, 08:58
Further to the discussion I began about differences in statistics btw Squeezebox Server and ACC using the previous version. Scanned a smaller directory:

Server: 230 albums with 4718 songs by 11 artists
ACC v2: Total albums: 250 Total tracks: 4989

??

this could be due to the directories being used in each case. For example, I have a muisc directory and an audiobook directory. SBS is pointing at the Music directory whereas ACC points at the whole drive and therefore captures the Audiobooks as well. Check the directories match in SBS and ACC

HTH

CW

wowo
2010-01-01, 10:18
According to your log file you used \\192.168.1.130\music\Music 1 as physical path which in fact is a UNC path notation. Since you are running SSODS you will probably have to use a notation like /usr/home/blabla. The path is used by ACC to get all data on music files residing within the directory specified. If the path is not the same as stored for music files in the database, no results are returned by the database query hence no albums found.

Press the TEST button on the remote server option screen and an example is displayed on the bottom of the ACC window on how the path is stored in squeezebox server. Use this to help you with the syntax.

Note:
Download v2.0 again as I made a small fix because the example didn't fit on the window anymore.

Let me know if this is of any help.
Yes you were right.
For me the path "//192.168.1.130/volume1/music/Music 1" did the trick.

SilverRS8
2010-01-01, 11:48
Further to the discussion I began about differences in statistics btw Squeezebox Server and ACC using the previous version. Scanned a smaller directory:

Server: 230 albums with 4718 songs by 11 artists
ACC v2: Total albums: 250 Total tracks: 4989

??

The album difference probably will be due to albums containing multiple discs. ACC will treat them as separate albums if the disc number is in the album name. This in turn results in a higher album count. If the albums are tagged properly (same album name and the disc tag is used to identify the discs) then album are grouped correctly by ACC.

Can you confirm that some multidisc albums actually are tagged with different album names?

Teus de Jong
2010-01-01, 14:06
Frank,

Thank you for this new version. But (you can always feel the but coming :)), there seems to be a problem with multi discs sets. Most of them are handled correctly. But I see also:

1. Several occasions where the cd-headers are wrong. E.g., I have a 11 cd-collection of Shostakovich' symphonies with Haitink. The header states correctly that this a an 11 cd set. But the first 3 cd's have the header CD 1. This happens with various others. The bug is always the same: the first x cd's have as header CD 1 (It's not the tags, because they display correctly in all other programs and were displayed correctly in the previous version of ACC.)

2. Some collections are not displayed by CD. This was also correct in the previous version. In the header the addition 'x CD Set' misses, and the headers CD 1, CD 2, etc. are missing.

Teus

Chunkywizard
2010-01-01, 14:14
Hi Frank,

any pointers on how to ensure when PDFing a catalogue to ensure each page contains only whole albums (and there is no albums split between 2 pages).

Cheers

CW

SilverRS8
2010-01-01, 14:36
Hi Frank,

any pointers on how to ensure when PDFing a catalogue to ensure each page contains only whole albums (and there is no albums split between 2 pages).

Cheers

CW

Yes, first narrow the page print margins and if there are still some page breaks going wrong, play with the print pagination settings in the advanced ACC option. Start by narrowing down the max tracks on page. The default settings should be ok for A4 formats and narrowed down margins.

SilverRS8
2010-01-01, 14:45
Frank,

Thank you for this new version. But (you can always feel the but coming :)), there seems to be a problem with multi discs sets. Most of them are handled correctly. But I see also:

1. Several occasions where the cd-headers are wrong. E.g., I have a 11 cd-collection of Shostakovich' symphonies with Haitink. The header states correctly that this a an 11 cd set. But the first 3 cd's have the header CD 1. This happens with various others. The bug is always the same: the first x cd's have as header CD 1 (It's not the tags, because they display correctly in all other programs and were displayed correctly in the previous version of ACC.)

I have several multi CD albums and their numbering is fine so it maybe the settings. Can you mail me the acc.log file for starters?


Some collections are not displayed by CD. This was also correct in the previous version. In the header the addition 'x CD Set' misses, and the headers CD 1, CD 2, etc. are missing.

Teus

Have you enabled the option 'Display CD#/Disc# (if applicable) in album header instead of tracklist' in ACC?

Frank

Chunkywizard
2010-01-01, 14:47
Hi Frank

I set paper to A4, margins to 0 and got rid of the header and footer and still it was wrong. I'll play with the options. I wondered if large art broke it

Cheers

CW

SilverRS8
2010-01-01, 15:42
Hi Frank

I set paper to A4, margins to 0 and got rid of the header and footer and still it was wrong. I'll play with the options. I wondered if large art broke it

Cheers

CW

Large art hasn't been my preference so I never played with it for printing purposes. Normal art size certainly works well in this regard.
I believe 'Maximum album rows per page = 3' should be a good setting for large art. Did you try that?

Chunkywizard
2010-01-01, 15:52
Hi Frank,

I was just working this out when your post came in. I think I need to set that to 4 and that will cure it. I'll report back.

Cheers

CW

Chunkywizard
2010-01-02, 00:57
Oh dear, I tried that and got:

Error while creating ACC table in database
Error Number: -2147217887
Error Description: ODBC driver does not support the requested properties
Unable to continue. Click OK to quit ACC

CW

SilverRS8
2010-01-02, 01:38
Oh dear, I tried that and got:

Error while creating ACC table in database
Error Number: -2147217887
Error Description: ODBC driver does not support the requested properties
Unable to continue. Click OK to quit ACC

CW

The creation of the temporary ACC table has nothing to do with the print pagination settings as these are applied during the writing of the catalogs when all database processing has already been done. Probably something other going wrong here. When you change the value of 4 back is the problem resolved (I can't imagine).

Chunkywizard
2010-01-02, 01:42
yep, 5 works :-S

Still playing around and I haven't had the error again. I have tried big art, small art, big and small font for tracks and no tracks. The only combo was big art, big font and 4 which caused the issue.

HTH

CW

SilverRS8
2010-01-02, 01:46
yep, 5 works :-S

Still playing around and I haven't had the error again. I have tried big art, small art, big and small font for tracks and no tracks. The only combo was big art, big font and 4 which caused the issue.

HTH

CW

I'll look into it. Interesting issue...

Frank

Teus de Jong
2010-01-02, 03:25
Frank,

I studied the mistakes more carefully (sorry for not doing this first). The first problem is only there when the disc set contains more than 9 discs. You can see a good example on the attached screen dump. There are 4 discs labeled CD 1. This should be: CD 1, CD 10, CD 11, CD 12.

I'll have a further look at the few sets that are not split in CDs at all.

A second sorry: I said this worked all right with the previous version, but that is not true. I just looked at a run I did in the beginning of december and the same mistakes are there also.

Teus

Teus de Jong
2010-01-02, 03:41
I also isolated the sets that are not split in CDs: these are all albums with more than one artist (the second is displayed behind each track as Ft. ...). Attached one example of a 2 CD set.

Teus

eyeball
2010-01-02, 04:38
I just uploaded a new version of Album Catalog Creator. A tool to create a HTML catalog of your Squeezebox server music catalog.
WOW, I didn't expect a 2.0 version that soon :) Works fine for me. Thanks very much.

Well, I just discovered an issue with sorting. If I select "TPE2 tag is AlbumArtist instead of band" and "Sort artist by ARTISTSORT tag", the albums that have an ALBUMARTIST set will be sorted by the ALBUMARTIST and not the ARTISTSORT tag. Example, 3 albums:

1.) ARTIST: Robert Plant, ARTISTSORT: Plant, Robert
2.) ARTIST: Robert Plant; Alison Krauss, ARTISTSORT: Plant, Robert; Krauss, Alison, ALBUMARTIST: Robert Plant & Alison Krauss
3.) ARTIST: Portishead

Now I would expect the sorting order to be as listed above, 1-2-3. But ACC sorts the albums in the order 1-3-2, because the ALBUMARTIST of the second album starts with "R".
Do you have a solution for this?

Rick B.
2010-01-02, 08:10
I get an error "balloon is undefined" when I run it. Windows 7, and I have the latest MySQL driver installed.

SilverRS8
2010-01-02, 10:25
I get an error "balloon is undefined" when I run it. Windows 7, and I have the latest MySQL driver installed.

Balloon refers to the balloon tips used by ACC. The balloon tips are the windows that appear when you hover with your mouse over the blue question marks.

Balloon tips are programmed in javascript. Since ACC depends on the Internet Explorer settings it may be due to the fact that you have configured some javascript restrictions. Does this ring a bell?

Frank

Rick B.
2010-01-03, 05:46
Balloon refers to the balloon tips used by ACC. The balloon tips are the windows that appear when you hover with your mouse over the blue question marks.

Balloon tips are programmed in javascript. Since ACC depends on the Internet Explorer settings it may be due to the fact that you have configured some javascript restrictions. Does this ring a bell?

Frank

I don't know java from coffee! Any idea how I can check?

SilverRS8
2010-01-03, 07:06
Frank,

I studied the mistakes more carefully (sorry for not doing this first). The first problem is only there when the disc set contains more than 9 discs. You can see a good example on the attached screen dump. There are 4 discs labeled CD 1. This should be: CD 1, CD 10, CD 11, CD 12.

I'll have a further look at the few sets that are not split in CDs at all.

A second sorry: I said this worked all right with the previous version, but that is not true. I just looked at a run I did in the beginning of december and the same mistakes are there also.

Teus

Solved in v2.0.3 and available for download

fphredd
2010-01-03, 07:51
The album difference probably will be due to albums containing multiple discs. ACC will treat them as separate albums if the disc number is in the album name. This in turn results in a higher album count. If the albums are tagged properly (same album name and the disc tag is used to identify the discs) then album are grouped correctly by ACC.

Can you confirm that some multidisc albums actually are tagged with different album names?

I haven't looked deep, but your explanation on the album differences make sense. I'll mess with an even smaller folder and work on cleaning up tags (some more), but the track counts should still match, no?

SilverRS8
2010-01-03, 08:22
I haven't looked deep, but your explanation on the album differences make sense. I'll mess with an even smaller folder and work on cleaning up tags (some more), but the track counts should still match, no?

Tracks should indeed be the same. So that is indeed strange. I'm curious though on your test results with a smaller subset.

tamanaco
2010-01-03, 08:34
Thanks Frank, 2.x has some great improvements. I have another "cosmetic" suggestion. Would it be possible to either restrict the codec and bitrate information to the table of content? If not, when selected, can this information be placed to the right of the Artist and Album names (headers) in the main body of the Album Catalog?

Edit: I just noticed that it appears to the right of the catalog in the example in the first post, but it displays to the left when I tested version 2.03.

Thanks...

SilverRS8
2010-01-03, 08:41
Thanks Frank, 2.x has some great improvements. I have another "cosmetic" suggestion. Would it be possible to either restrict the codec and bitrate information to the table of content? If not, when selected, can this information be placed to the right of the Artist and Album names (headers) in the main body of the Album Catalog?

Edit: I just noticed that it appears to the right of the catalog in the example in the first post, but it displays to the left when I tested version 2.03.

Thanks...

You can set the position where it should appear in the main interface. Options are Left, right or at the bottom.

I don't quiet understand what you mean with codec and table of contents?

tamanaco
2010-01-03, 09:16
You can set the position where it should appear in the main interface. Options are Left, right or at the bottom.

I don't quiet understand what you mean with codec and table of contents?

I see, I was looking at the "options" interface. Is there a way to get back to the "main interface" after you enter the options? I could not find a way to get back to the "main" (start page interface) other than restarting the program.

Edit: I see again... hitting Ok, brings you back to the main page.

What I meant was to restrict the "Display codec information" and "also display bitrate" options to the content page(s) only.

SilverRS8
2010-01-03, 09:26
I see, I was looking at the "options" interface. Is there a way to get back to the "main interface" after you enter the options? I could not find a way to get back to the "main" (start page interface) other than restarting the program.

What I meant was to restrict the "Display codec information" and "also display bitrate" options to the content page(s) only.

You are probably using Windows 7? Bill has decided to set the display to 125% of its normal size causing many application (especially web based apps) with font sizing issues. I have not found a way yet to reduce this by code for ACC only and I don't think there is a way to do this.

If the screen layout does not look like the screenshots on the ACC download page, position your mouse on the ACC screen, hold CTRL and use the scroll wheel to reduce Bills magnification factor. Or ofcourse reduce the Windows maginication to 100% (which sound more normal)

I'll create an automatic popup when Windows 7 is detected with this message.

About the codec in the table of contents, in my opinion the TOC should only include main data referred to, not meta data.

The codec info is however included (if selected) in the Quickref catalog.

Does this address your issues?

Frank

Larry G
2010-01-03, 09:50
I'm having a problem with the UI in V2.0.3. The initial window (attached) seems to be a fixed size and it cuts of the bottom of the form. I have two workarounds: 1. tab to the missing fields and they come into view as the window then scrolls; or 2. adjust the font size with Ctrl/-, which makes the bubble help unreadably small. The Options and Advanced Options screens have the same problem.

I'm running Windows Vista with a 1680x1050 display, IE 8 and Firefox 3.5.7.

The program itself (in the limited use I've given it) seems to work well and it will be very useful as I finally get my music all uploaded to the server. Thanks!

I am a new SB Radio user.

SilverRS8
2010-01-03, 10:01
I'm having a problem with the UI in V2.0.3. The initial window (attached) seems to be a fixed size and it cuts of the bottom of the form. I have two workarounds: 1. tab to the missing fields and they come into view as the window then scrolls; or 2. adjust the font size with Ctrl/-, which makes the bubble help unreadably small. The Options and Advanced Options screens have the same problem.

I'm running Windows Vista with a 1680x1050 display, IE 8 and Firefox 3.5.7.

The program itself (in the limited use I've given it) seems to work well and it will be very useful as I finally get my music all uploaded to the server. Thanks!

I am a new SB Radio user.

Funny as is the previous post I addressed this issue. CTRL - is also a good tip over the scroll wheel. Vista does not have a default magnification factor so either you have configured this in Windows or you have configured a larger than 100% Internet Explorer zoom factor as default setting?

I'll create a fix to make the window sizable. I'll post it later this evening.

Frank

SilverRS8
2010-01-03, 12:47
I'm having a problem with the UI in V2.0.3. The initial window (attached) seems to be a fixed size and it cuts of the bottom of the form. I have two workarounds: 1. tab to the missing fields and they come into view as the window then scrolls; or 2. adjust the font size with Ctrl/-, which makes the bubble help unreadably small. The Options and Advanced Options screens have the same problem.

I'm running Windows Vista with a 1680x1050 display, IE 8 and Firefox 3.5.7.

The program itself (in the limited use I've given it) seems to work well and it will be very useful as I finally get my music all uploaded to the server. Thanks!

I am a new SB Radio user.

I've made the default ACC window size somewhat larger and enabled the resizing of the window.

Fix available by downloading v2.0.4

Let me know if this solves your problem.

Frank

tamanaco
2010-01-03, 13:10
You are probably using Windows 7? Bill has decided to set the display to 125% of its normal size causing many application (especially web based apps) with font sizing issues. I have not found a way yet to reduce this by code for ACC only and I don't think there is a way to do this.

If the screen layout does not look like the screenshots on the ACC download page, position your mouse on the ACC screen, hold CTRL and use the scroll wheel to reduce Bills magnification factor. Or ofcourse reduce the Windows maginication to 100% (which sound more normal)

I'll create an automatic popup when Windows 7 is detected with this message.

About the codec in the table of contents, in my opinion the TOC should only include main data referred to, not meta data.

The codec info is however included (if selected) in the Quickref catalog.

Does this address your issues?

Frank

No issues. I edited my post before you answered. The problem before was between the keyboard and the screen (the end user). I'm happy with the resulting catalog layout now.

SilverRS8
2010-01-03, 13:51
No issues. I edited my post before you answered. The problem before was between the keyboard and the screen (the end user). I'm happy with the resulting catalog layout now.

Great to hear !

tamanaco
2010-01-03, 14:50
Maybe I spoke too soon... anyway... this is a different "cosmetic" issue.

I have a couple Spanish albums whose album/artist names start with either ¡ or ¿. These exclamation and question marks should be ignored and instead the first letter of the Album Name should be used to sort them. See ¡Cubanismo! Albums listed under "&" in the picture below.

I use the Genre, Album Artists and Album Name tags to build my folders structures. All my various artists albums in SC and ACC are displayed as expected except for "one" album. The relevant album tags for this album are: Album Artists: Belly Dance (Various Artist), Album Name: The Best Belly Dance Album in The World... Ever! Vol. 2., the album compilation flag is also set to 1 and every track has the correct Artist associated with it. As you can see in the pics below the SC Web UI lists the Album as expected under the Artist "Belly Dance (Various Artist)", but it appears that ACC changes the Album Artist tag to "Various Artist". Note that ACC does not change the album Roots Of Rumba Rock 2 whose Album Artist tag is displayed correctly as "Zaire Classics (Various Artists)" and which also has the compilation flag set to 1. I hope, this time, I explained the problem in a way you can understand.

lcjohnson
2010-01-03, 20:52
I am trying to run ACC 2.0 on my system, but I am getting a 3716 connection error when I press the test button. My particulars are:

- Windows XP SP 3. I have a simple shared network.
- Music folders are on a newly installed NetGear ReadyNAS Duo net attached server.
- Running Squeezebox Server Version: 7.4.1 at 192.168.1.150 (fixed IP addr)
- I have done the mod on the my.tt file on the server and rebooted the server.
- I have installed mysql-connector-odbc-5.1.6-win32.msi
- The media share on the server is mapped as drive M:
- Full remote path to music share is M:\Music

Clicking the test button I get 'error connectiong to the database' number 3716, 'Safety setings on this computer prohibit accessing a data soruce on another domain.'

Got any ideas to help? Thanks in advance, if you can.

Larry Johnson

Larry G
2010-01-03, 22:07
I've made the default ACC window size somewhat larger and enabled the resizing of the window.

Fix available by downloading v2.0.4

Let me know if this solves your problem.

Frank

Yes, it's much better. I still need to make it a bit wider (so that the Location drop down occupies only one line and fixes the overwriting of the author credit) and taller (so that the buttons show). But the resizing works (on the two option screens also). It looks like some of the anchor could yet be tweaked, but it's much much easier to use now.

Thanks, Larry

SilverRS8
2010-01-03, 22:13
I am trying to run ACC 2.0 on my system, but I am getting a 3716 connection error when I press the test button. My particulars are:

- Windows XP SP 3. I have a simple shared network.
- Music folders are on a newly installed NetGear ReadyNAS Duo net attached server.
- Running Squeezebox Server Version: 7.4.1 at 192.168.1.150 (fixed IP addr)
- I have done the mod on the my.tt file on the server and rebooted the server.
- I have installed mysql-connector-odbc-5.1.6-win32.msi
- The media share on the server is mapped as drive M:
- Full remote path to music share is M:\Music

Clicking the test button I get 'error connectiong to the database' number 3716, 'Safety setings on this computer prohibit accessing a data soruce on another domain.'

Got any ideas to help? Thanks in advance, if you can.

Larry Johnson

Sounds all good except that the full remote physical path is defined from the computer where SBS is running so this probably is not on drive M. Press the test button to get an example of a local path.

The 3716 problem is a Microsoft issue that pops up now and then. On the ACC homepage there are some tips on how to resolve this. Have you tried these yet?

Frank

SilverRS8
2010-01-04, 00:17
Maybe I spoke too soon... anyway... this is a different "cosmetic" issue.

I have a couple Spanish albums whose album/artist names start with either ¡ or ¿. These exclamation and question marks should be ignored and instead the first letter of the Album Name should be used to sort them. See ¡Cubanismo! Albums listed under "&" in the picture below.

Interesting issue. Can you mail me a file of an album with this issue? I will then work towards a resolution. Question though, does SBS ignore the ¡ and ¿ also and sort on the first letter of the album name?


I use the Genre, Album Artists and Album Name tags to build my folders structures. All my various artists albums in SC and ACC are displayed as expected except for "one" album. The relevant album tags for this album are: Album Artists: Belly Dance (Various Artist), Album Name: The Best Belly Dance Album in The World... Ever! Vol. 2., the album compilation flag is also set to 1 and every track has the correct Artist associated with it. As you can see in the pics below the SC Web UI lists the Album as expected under the Artist "Belly Dance (Various Artist)", but it appears that ACC changes the Album Artist tag to "Various Artist". Note that ACC does not change the album Roots Of Rumba Rock 2 whose Album Artist tag is displayed correctly as "Zaire Classics (Various Artists)" and which also has the compilation flag set to 1. I hope, this time, I explained the problem in a way you can understand.

I don't know if this has been improved in SBS but in the SC days albums the whole various artist detecting was kind a lousy. For this reason ACC determines for itself which album is a various artist album and which not. This works quiet well actually but as you correctly noticed in this single case not.

I will use the album tags you included to set up a test case in order to optimize the detection. This will probably be in the weekend though as sadly the christmas holidays are over. Maybe SBS has an improved detecting of various artists and can the detection code in ACC be removed. To be investigated I guess... I'll be back ;-)

tamanaco
2010-01-04, 07:57
Interesting issue. Can you mail me a file of an album with this issue? I will then work towards a resolution. Question though, does SBS ignore the ¡ and ¿ also and sort on the first letter of the album name?

Hi Frank, I sent you a sample file. SBS ignores the ¡ and ¿ and sorts then correctly by the first letter. I only have one artist that starts with ñ (Ñico Saquito) which SBS sorts after the "Z" under "?", but since I don't have a full album under this artist (Album Artist tag) ACC does not have to deal with it.



I don't know if this has been improved in SBS but in the SC days albums the whole various artist detecting was kind a lousy. For this reason ACC determines for itself which album is a various artist album and which not. This works quiet well actually but as you correctly noticed in this single case not.

I will use the album tags you included to set up a test case in order to optimize the detection. This will probably be in the weekend though as sadly the christmas holidays are over. Maybe SBS has an improved detecting of various artists and can the detection code in ACC be removed. To be investigated I guess... I'll be back ;-)

I understand what you're saying, but ACC sorted other "various" artists albums with similar characteristics correctly. I also send you a sample file from the album in question. Yeap, too bad the holidays are over.

stof77
2010-01-04, 09:32
Hi Frank, great work,

just testing now the last version, all seems ok after a quick look apart from the fact that I'd like to use the MHT file to be able to share the catalog with friends,

but it seems in fact it looks in the Squeezebox Music collection folder to load the album art & add it on the fly when I open the MHT file,

so It can't be shared, I konw about the Pdf Creator otion to generate a pdf file but I've been trying it several times with no luck and so much that it is starting to drive me nut ! ( I tried on XP & 7),
I let the otion to open the pdf at the end of the process, but acrobat reader tells me there is no file to open, arghh !

in the end it is very frustating because for now I can't share it with friends or maybe I didn't understand some things ?

btw, Is the MHT file is supposed to be open by anyone, anywhere or only on the machine where the music collection folder is ?

edit in fact reading again your webpage, I understand it should suites my needs :

To create a portable catalog for distribution or offline reading, select the 'Create internet explorer archive (.mht) file' option. This will create a single file which can be ported to other machine without losing the album art,

though when I tick this option the MHT file is only 1 Ko, something 's wrong, log file joined, if you can have a look when you'll have the time.

Chunkywizard
2010-01-04, 09:41
Hi there,

I asked the same thing of Frank (via email) and was told:

"This is a know Microsoft bug for which there is a hotfix available from Microsoft. ACC only calls the API to create the .MHT file.

http://support.microsoft.com/kb/891019

Microsoft has made a fix for it which you should be able to download through the link on the top.

besides this, there seem to be more problems related to .mht file usage. See links below

Some related links:
http://techrepublic.com.com/5208-6230-0.html?forumID=101&threadID=213591&start=0

http://support.microsoft.com/kb/891020

http://www.computing.net/answers/windows-xp/mht-file-probs-on-different-pcs/151939.html

All links indicate a Microsoft problem with i presume the Cdosys.dll file.

hope the first knowledge base article is your solution to the problem.

.MHT is nice but only supports internet explorer. Better to use is .PDF (bullzip)."

I too tried Bullzip and have an issue where no art work >500x500 is displayed in the PDF >:-C

CW

stof77
2010-01-04, 09:49
Just edited my message before I saw your answer,

will try the hotfix tomorrow, I'm done with it for today,

thanx for your answer,

let's hope we'll find a solution.

SilverRS8
2010-01-04, 11:13
Hi Frank, great work,

just testing now the last version, all seems ok after a quick look apart from the fact that I'd like to use the MHT file to be able to share the catalog with friends,

but it seems in fact it looks in the Squeezebox Music collection folder to load the album art & add it on the fly when I open the MHT file,

so It can't be shared, I konw about the Pdf Creator otion to generate a pdf file but I've been trying it several times with no luck and so much that it is starting to drive me nut ! ( I tried on XP & 7),
I let the otion to open the pdf at the end of the process, but acrobat reader tells me there is no file to open, arghh !

in the end it is very frustating because for now I can't share it with friends or maybe I didn't understand some things ?

btw, Is the MHT file is supposed to be open by anyone, anywhere or only on the machine where the music collection folder is ?

edit in fact reading again your webpage, I understand it should suites my needs :

To create a portable catalog for distribution or offline reading, select the 'Create internet explorer archive (.mht) file' option. This will create a single file which can be ported to other machine without losing the album art,

though when I tick this option the MHT file is only 1 Ko, something 's wrong, log file joined, if you can have a look when you'll have the time.

Did you try Bullzip PDF ?

To create a PDF you have to do the following:
1. Install Bullzip
2. Generate a Catalog with ACC
3. Do a print preview and narrow the margins. Remove the header and footer that is added by Internet Explorer/Firefox/Other
4. If the page breaks are not at the correct positions (albums break up in the middle or blank pages are added) you have to adjust the print pagination settings in the advanced options and repeat steps 2 and 3. Once figured out the settings are remembered end never to be looked after again. The default settings are ok for A4 paper size with 'use large track font' disabled.
5. Finally, Print the catalog and select the Bullzip PDF printer (or Acrobat printer if you use Adobe Acrobat). A file location for the PDF will be asked and the PDF is created.
It will not open up automatically as ACC has no knowledge of the filename you have chosen.

Does this help you?

Frank

eyeball
2010-01-04, 15:37
Any info on my sorting problem?
See message #23 (http://forums.slimdevices.com/showpost.php?p=501573&postcount=23)

fphredd
2010-01-04, 19:49
Tracks should indeed be the same. So that is indeed strange. I'm curious though on your test results with a smaller subset.

Squeezecenter:
63 albums with 721 songs by 1 artist.

ACC:
Total albums: 11 Total tracks: 145

Also, one of the albums shown in the ACC listing is actually in a different folder than the one listed as 'Starting Folder' or any sub-folder within that folder, i.e. music scanned should all be within M:\Dylan, but one album is in M:\Commercial CD's\Grateful Dead (the Artist on this one is 'Grateful Dead & Bob Dylan).

All very confusing...

SilverRS8
2010-01-04, 22:25
Any info on my sorting problem?
See message #23 (http://forums.slimdevices.com/showpost.php?p=501573&postcount=23)

Yep, working on it but probably this weekend due to free time.

SilverRS8
2010-01-04, 22:29
Squeezecenter:
63 albums with 721 songs by 1 artist.

ACC:
Total albums: 11 Total tracks: 145

Also, one of the albums shown in the ACC listing is actually in a different folder than the one listed as 'Starting Folder' or any sub-folder within that folder, i.e. music scanned should all be within M:\Dylan, but one album is in M:\Commercial CD's\Grateful Dead (the Artist on this one is 'Grateful Dead & Bob Dylan).

All very confusing...

You appear to use a Starting folder so that would explain that ACC has a lower count as the starting folder is a filter. The SBS count is an unfiltered number count.

The starting folder text is used in the query (so the query appears to be returning something it shouldn't) and must appear in every track path for it to be included. I'll do a back search on it but its working perfect for me as I have a folder with only full albums and many folders with seperate tracks. The starting folder I use is the one of the full album.

Have you used shortcuts within folders?
Can you perform a full DB rescan and then check if the problem still exists (maybe some info is not cleaned yet)?
Have you changed the folder structure lately?

Frank

Chunkywizard
2010-01-05, 02:14
Hi Frank

I've just tried 2.04 and have a few points.

1. Large Cover/Large Font/Display Tracks/ 4 no longer crashes ACC!

2. The title 'Album Catalog Creator' is scrolled in the default window size of the initial dialogue box (ie it shows 'Album Catalog Creator Al'.)

3. I still have my 'Children#PH#s Music' issue

4. Have you thought any more about removing the 'Tracks' heading above track listings?

Cheers

Paul

SilverRS8
2010-01-05, 02:28
Hi Frank

I've just tried 2.04 and have a few points.

1. Large Cover/Large Font/Display Tracks/ 4 no longer crashes ACC!

Great, but there has not been any code change to that respect so probably was a local issue on your side (lucky for me) ;-) I also couldn't reproduce the problem.


2. The title 'Album Catalog Creator' is scrolled in the default window size of the initial dialogue box (ie it shows 'Album Catalog Creator Al'.)

Please attach a screenshot.


3. I still have my 'Children#PH#s Music' issue


Working on that and will mail you a link with a version with additional logging to track the problem.


4. Have you thought any more about removing the 'Tracks' heading above track listings?

Not really yet as my focus is on resolving current issues. This is more of a preferrence thing. You're the second user asking about removal of the 'Tracks:' line prior to the tracklisting. Not yet a huge number. Personally, although obvious, I like the 'Tracks:' line. Any other users who want this removed? Please post a message.

Frank

Chunkywizard
2010-01-05, 03:07
Screenshot of issue attached,

CW

SilverRS8
2010-01-05, 03:22
Screenshot of issue attached,

CW

Version 2.0.4 has a modified background included that eliminates this problem. I can only conclude that you only extracted the .hta file from the zip file without the include folder?

Chunkywizard
2010-01-05, 04:00
Aha, guilty as charged...

CW

SilverRS8
2010-01-05, 06:45
WOW, I didn't expect a 2.0 version that soon :) Works fine for me. Thanks very much.

Well, I just discovered an issue with sorting. If I select "TPE2 tag is AlbumArtist instead of band" and "Sort artist by ARTISTSORT tag", the albums that have an ALBUMARTIST set will be sorted by the ALBUMARTIST and not the ARTISTSORT tag. Example, 3 albums:

1.) ARTIST: Robert Plant, ARTISTSORT: Plant, Robert
2.) ARTIST: Robert Plant; Alison Krauss, ARTISTSORT: Plant, Robert; Krauss, Alison, ALBUMARTIST: Robert Plant & Alison Krauss
3.) ARTIST: Portishead

Now I would expect the sorting order to be as listed above, 1-2-3. But ACC sorts the albums in the order 1-3-2, because the ALBUMARTIST of the second album starts with "R".
Do you have a solution for this?

Hi Eyeball,

I have some questions regarding this:
1. When you disable "TPE2 tag is AlbumArtist instead of band", is the sorting then right?
2. I think this issue is more multi artist related. Can you verify and confirm that even with the "TPE2 tag is AlbumArtist instead of band" option enabled, that sorting on ARTISTSORT works fine as long as there are no multiple artists on the album?

Frank

Chunkywizard
2010-01-05, 07:08
One more observation for you. I'd be interested in what you think. I have some albums with 2 years in their tags. For example Queen - Queen II. The original album was 1974 but later there was a US Hollywood Records Release with some remixes from 1991. I have the later album but did not want all tracks labelled 1991, so tracks 1-11 are 1974 and 12-14 are 1991. In the QuickRef the album gets labelled 1991. Is it possible to either get it labelled with the year that most tracks are (ie 1974) or have both years displayed? Obviously if you start displaying multiple years then compilations should be excluded as these have the possibility of having many years (if you date the track not the album as I do)

CW

fphredd
2010-01-05, 07:59
You appear to use a Starting folder so that would explain that ACC has a lower count as the starting folder is a filter. The SBS count is an unfiltered number count.

The starting folder text is used in the query (so the query appears to be returning something it shouldn't) and must appear in every track path for it to be included. I'll do a back search on it but its working perfect for me as I have a folder with only full albums and many folders with seperate tracks. The starting folder I use is the one of the full album.

Have you used shortcuts within folders?
Can you perform a full DB rescan and then check if the problem still exists (maybe some info is not cleaned yet)?
Have you changed the folder structure lately?

Frank

Changed starting folder to M:\
Results:

ACC: Total albums: 2110 Total tracks: 22487
Created with Album Catalog Creator version 2.0.4

Squeeze: 2561 albums with 32899 songs by 490 artists.

Now here's a question...my M: drive is actually a mapped network drive - could this be part of my issue?

Thanks for the continued help tracking this down.

SilverRS8
2010-01-05, 08:28
Changed starting folder to M:\
Results:

ACC: Total albums: 2110 Total tracks: 22487
Created with Album Catalog Creator version 2.0.4

Squeeze: 2561 albums with 32899 songs by 490 artists.

Now here's a question...my M: drive is actually a mapped network drive - could this be part of my issue?

Thanks for the continued help tracking this down.

Is does not matter whether the M: drive is a local drive or not. Do you have shortcuts defined to a locations outside the M:\ folder?

Just to test things, can you set the starting folder to a folder of which you know the count of the albums yourself? This way it should be easy to verify the counts.

Hope we get this sorted out.

Frank

SilverRS8
2010-01-05, 08:32
One more observation for you. I'd be interested in what you think. I have some albums with 2 years in their tags. For example Queen - Queen II. The original album was 1974 but later there was a US Hollywood Records Release with some remixes from 1991. I have the later album but did not want all tracks labelled 1991, so tracks 1-11 are 1974 and 12-14 are 1991. In the QuickRef the album gets labelled 1991. Is it possible to either get it labelled with the year that most tracks are (ie 1974) or have both years displayed? Obviously if you start displaying multiple years then compilations should be excluded as these have the possibility of having many years (if you date the track not the album as I do)

CW

I understand you don't want duplicate tracks and use this approach to solve it but I don't think this is a common practice. Officially they are two albums. So ofcourse ACC could be modified but I would consider it a workaround.

Chunkywizard
2010-01-05, 08:43
Actually, I have been reading up some more and apparently people tag with 'ORIGYEAR' for the original year of recording, and with YEAR for year of the album. If both were set then I guess it's right to display YEAR.

Anyway, I understand you not wanting to workaround,

Cheers

CW

wowo
2010-01-05, 09:56
Actually, I have been reading up some more and apparently people tag with 'ORIGYEAR' for the original year of recording, and with YEAR for year of the album. If both were set then I guess it's right to display YEAR.
Since version 7.4, SBS prefers the ORIGYEAR tag (=TORY/TDOR)
over the YEAR tag (TYER/TDRC).

This means that if you are using the ORIGYEAR tag, in SBS the value of the ORIGYEAR tag is mapped to all the normal year-fields in SBS !!. AAC is then also using the ORIGYEAR value.

In my opinion, this a good behaviour.

If however an album has different ORIGYEAR values (for instance in compilation albums, I set the ORIGYEAR tags of the individual tracks), AAC will take the ORIGYEAR value of the last track of the album (= mostly the youngest year).
This is a behaviour many media-players will do.

wowo
2010-01-05, 10:07
If you have an "normal" artist with more than one album, AAC sort the albums by year.

AAC sort the albums of the Various Artists also by year.
I rather would like if AAC could sort the Various Artists by album name, as SBS also does.

Thanks for all the good work! For me AAC is almost perfect.:)

SilverRS8
2010-01-05, 10:19
If you have an "normal" artist with more than one album, AAC sort the albums by year.

AAC sort the albums of the Various Artists also by year.
I rather would like if AAC could sort the Various Artists by album name, as SBS also does.

Thanks for all the good work! For me AAC is almost perfect.:)

Never though about it but sounds much more logical. Will implement it.

Thanks for the appreciation !

SilverRS8
2010-01-05, 11:36
If you have an "normal" artist with more than one album, AAC sort the albums by year.

AAC sort the albums of the Various Artists also by year.
I rather would like if AAC could sort the Various Artists by album name, as SBS also does.

Thanks for all the good work! For me AAC is almost perfect.:)

You have a PM with a link to test the fix for sorting the Various Artist albums.
Let me know is this is working as it should....

Frank

stof77
2010-01-05, 11:58
Did you try Bullzip PDF ?

To create a PDF you have to do the following:
1. Install Bullzip
2. Generate a Catalog with ACC
3. Do a print preview and narrow the margins. Remove the header and footer that is added by Internet Explorer/Firefox/Other
4. If the page breaks are not at the correct positions (albums break up in the middle or blank pages are added) you have to adjust the print pagination settings in the advanced options and repeat steps 2 and 3. Once figured out the settings are remembered end never to be looked after again. The default settings are ok for A4 paper size with 'use large track font' disabled.
5. Finally, Print the catalog and select the Bullzip PDF printer (or Acrobat printer if you use Adobe Acrobat). A file location for the PDF will be asked and the PDF is created.
It will not open up automatically as ACC has no knowledge of the filename you have chosen.

Does this help you?

Frank

OK I installed Bullziped, & just finished to try it, the pdf creation is working, sure, had to
- fight with the margins to avoid a few problems &
- to get rid of an album that is understood as 3 albums in SBS (& even more in ACC), arhh...the joy of tagging...nevermind will try to retag it another time.

now it's seems all ok.

Thanx for the help & your work,

I still need to properly tag most of my Mp3 (i've only done 15 or 20 % so far),

Flac are good : 667 albums in a 68 pages pdf including the toc.

SilverRS8
2010-01-05, 12:07
OK I installed Bullziped, & just finished to try it, the pdf creation is working, sure, had to
- fight with the margins to avoid a few problems &
- to get rid of an album that is understood as 3 albums in SBS (& even more in ACC), arhh...the joy of tagging...nevermind will try to retag it another time.

now it's seems all ok.

Thanx for the help & your work,

I still need to properly tag most of my Mp3 (i've only done 15 or 20 % so far),

Flac are good : 667 albums in a 68 pages pdf including the toc.

Thanks for the positive feedback ! Keeps me improving ACC...

fphredd
2010-01-05, 12:21
to get rid of an album that is understood as 3 albums in SBS (& even more in ACC), arhh...the joy of tagging...nevermind will try to retag it another time.

now it's seems all ok.

Thanx for the help & your work,

I have had this issue as well. Have you tracked down what is 'faulty' in the tagging that causes this?

SilverRS8
2010-01-05, 12:31
I have had this issue as well. Have you tracked down what is 'faulty' in the tagging that causes this?

Just a note (maybe it is the clue you're after):
When an album name is used with different cases they are stored with unique album ID. Example:
Jagged Little Pill
Jagged little Pill
Jagged little pill

are classified by SBS as three different albums. SBS itself has some logics that upon presentation considers this as a single album. ACC however will treat these as different albums. In other words, watch for consistency in case usage.

I personally don't see this as a short comming but handy as it reveals incosistent tagging.

fphredd
2010-01-05, 15:08
Just a note (maybe it is the clue you're after):
When an album name is used with different cases they are stored with unique album ID. Example:
Jagged Little Pill
Jagged little Pill
Jagged little pill

are classified by SBS as three different albums. SBS itself has some logics that upon presentation considers this as a single album. ACC however will treat these as different albums. In other words, watch for consistency in case usage.

I personally don't see this as a short comming but handy as it reveals incosistent tagging.

I agree, not a bad 'tag debugger' but that's not the solution here. Thanks for the suggestion.

fphredd
2010-01-05, 20:39
Is does not matter whether the M: drive is a local drive or not. Do you have shortcuts defined to a locations outside the M:\ folder?

Just to test things, can you set the starting folder to a folder of which you know the count of the albums yourself? This way it should be easy to verify the counts.

Hope we get this sorted out.

Frank

I used M:\10,000 Maniacs as the starting folder for ACC. This folder has 4 Albums with 87 Tracks. I also have a folder M:\Commercial\10,000 Maniacs with 3 more albums.

ACC showed 6 Total albums on its scan; the 3 in M:\Commercial\10,000 Maniacs, but only 3 of the 4 in the folder I actually was pointing to.

wowo
2010-01-06, 03:57
You have a PM with a link to test the fix for sorting the Various Artist albums.
Let me know is this is working as it should....

Frank
Unfortunately it is working the same as before, nothing changed.

By the way:
AAC counts 1615 albums, 21904 tracks
SBS counts 1615 albums, 21984 tracks
Almost the same :), but a little strange.

SilverRS8
2010-01-06, 06:54
Unfortunately it is working the same as before, nothing changed.

By the way:
AAC counts 1615 albums, 21904 tracks
SBS counts 1615 albums, 21984 tracks
Almost the same :), but a little strange.

Going to test again... Changed the sort order and got the right results here. Going to send you another version...

And I'll also look at the track count. I don't think you're missing something though but that its just the counter within ACC. I don't think you can check which one of the 21984 tracks is missing (just kidding)

Frank

stof77
2010-01-06, 06:55
I have had this issue as well. Have you tracked down what is 'faulty' in the tagging that causes this?

I tried a few things in Mp3tag, like renaming the Album & artists for all songs, or removing all tags then retag just the artist but it didn't do anything better after the new collection scan in SBS,

so I let go, so far it's the only album where this problem occurs.

SilverRS8
2010-01-06, 06:56
I tried a few things in Mp3tag, like renaming the Album & artists for all songs, or removing all tags then retag just the artist but it didn't do anything better after the new collection scan in SBS,

so I let go, so far it's the only album where this problem occurs.

Sometimes a clearing of the library and full rescan is required to clean up the database. Have you tried that?

fphredd
2010-01-06, 07:15
I tried a few things in Mp3tag, like renaming the Album & artists for all songs, or removing all tags then retag just the artist but it didn't do anything better after the new collection scan in SBS,

so I let go, so far it's the only album where this problem occurs.

I'm wondering if this isn't an SBS issue, as my iPeng shows some albums without the name, but as a list of

Disc 1
Disc 1
Disc 1,etc.
(All the albums DO have a Disc# tag, but so do the ones that read fine...)

I will next check to see if it is the same albums that are mulit-listed in ACC...

...though this still doesn't solve the other problem of ACC missing an entire album in a directory with 4 in it...

lcjohnson
2010-01-06, 22:39
I've tried all of the suggested remedies on the homepage, on the Remote Server Options page, etc. to the best of my ability. The full error message I now get when I press the Test button is:

"Error connecting to 192.168.1.150
Possible reasons:
- The required mySQL OBCD driver is not installed.
- If you are accessing mySQL on a remote server please make sure remote access is allowed by the remote server (default - disabled). If you upgrade Squeezecenter, you mahave to re-enable remote access.
Refer to Help screen for more information.
Error description: [MySQL][ODBC 5.1 Driver]Can't connect ot MySQL server on '192.168.1.150' (10061)"

If anyone can help resolve this error it would be appreciated, otherwise I'm giving up.

- Thanks for any help, Larry Johnson


Sounds all good except that the full remote physical path is defined from the computer where SBS is running so this probably is not on drive M. Press the test button to get an example of a local path.

The 3716 problem is a Microsoft issue that pops up now and then. On the ACC homepage there are some tips on how to resolve this. Have you tried these yet?

Frank

SilverRS8
2010-01-07, 00:02
I've tried all of the suggested remedies on the homepage, on the Remote Server Options page, etc. to the best of my ability. The full error message I now get when I press the Test button is:

"Error connecting to 192.168.1.150
Possible reasons:
- The required mySQL OBCD driver is not installed.
- If you are accessing mySQL on a remote server please make sure remote access is allowed by the remote server (default - disabled). If you upgrade Squeezecenter, you mahave to re-enable remote access.
Refer to Help screen for more information.
Error description: [MySQL][ODBC 5.1 Driver]Can't connect ot MySQL server on '192.168.1.150' (10061)"

If anyone can help resolve this error it would be appreciated, otherwise I'm giving up.

- Thanks for any help, Larry Johnson

I do not know what the initial error message was but and what steps you have taken but maybe this is of any help:
1. If you use ACC on the same server on which SBS runs do not configure any remote server settings. ACC works out-of-the-box
2. If you use ACC on another machine than where SB is running do not try to connect unless you have modified the my.tt file on the SBS server as a connection would just be refused. Reason is SBS is configured to not allow access from any other computer than itself.

Have you modified the my.tt file?

Frank

Viragored
2010-01-07, 00:04
Hi everyone - sorry if this has already been answered and I've missed it.

I have Firefox as the default web browser on my PC, but also have IE8 installed. When I run ACC, the files ACC creates open in Internet Explorer. If I use Windows Explorer to locate the files they show as "Firefox files" and a double click will open them in Firefox.

Is there a setting somewhere in the PC that I need to change to make ACC open the files in Firefox?

I had the same behaviour in the previous version of ACC.

Any help would be appreciated, as I plan to get rid of IE in the near future. It's far too buggy for my liking.

Regards, Dave

SilverRS8
2010-01-07, 00:14
Hi everyone - sorry if this has already been answered and I've missed it.

I have Firefox as the default web browser on my PC, but also have IE8 installed. When I run ACC, the files ACC creates open in Internet Explorer. If I use Windows Explorer to locate the files they show as "Firefox files" and a double click will open them in Firefox.

Is there a setting somewhere in the PC that I need to change to make ACC open the files in Firefox?

I had the same behaviour in the previous version of ACC.

Any help would be appreciated, as I plan to get rid of IE in the near future. It's far too buggy for my liking.

Regards, Dave

Hi Dave,

ACC is a .HTA application which is executed by the MSHTA.exe process which is dependent on Internet Explorer components. So I would expect that if you deinstall or remove IE8, ACC will stop working. Ofcourse you could always use a sandbox environment (run a virtual machine with IE) so you can get rid of IE8 on the host.

It is not configurable by the GUI to change which browser will actually open the generated catalogs. But if you want you can look for the line below in the code:
'### Open Full catalog and quickref catalog in Internet Explorer
WshShell.run Chr(34) & "c:\Program Files\Internet Explorer\iexplore.exe " & Chr(34) & " " & Chr(34) & Replace(sTOutputfile,".CAT","") & Chr(34)
WshShell.run Chr(34) & "c:\Program Files\Internet Explorer\iexplore.exe " & Chr(34) & " " & Chr(34) & sTOutputfileShort & Chr(34)

All you'd have to do is change the full path to the browser executable.

P.S. 'Waihi Beach, New Zealand'.... you must be a very happy man :-)

Regards, Frank

tamanaco
2010-01-07, 04:59
I have Firefox as the default web browser on my PC, but also have IE8 installed. When I run ACC, the files ACC creates open in Internet Explorer. If I use Windows Explorer to locate the files they show as "Firefox files" and a double click will open them in Firefox.

Is there a setting somewhere in the PC that I need to change to make ACC open the files in Firefox?



I'm assuming you're using Windows, so if IE8 is installed correctly you can try right-clicking the .hta file in File Explorer and select Open with... and then select IE as the program to open the file.

fphredd
2010-01-07, 06:55
I used M:\10,000 Maniacs as the starting folder for ACC. This folder has 4 Albums with 87 Tracks. I also have a folder M:\Commercial\10,000 Maniacs with 3 more albums.

ACC showed 6 Total albums on its scan; the 3 in M:\Commercial\10,000 Maniacs, but only 3 of the 4 in the folder I actually was pointing to.

Any thoughts?

SilverRS8
2010-01-07, 07:07
Any thoughts?

Not yet but still awaiting your answer if:
1. You have used shortcuts within your directories?
2. You have performed a full DB rescan and checked again on what ACC reports?

Regards,

Frank

Rick B.
2010-01-07, 07:33
Balloon refers to the balloon tips used by ACC. The balloon tips are the windows that appear when you hover with your mouse over the blue question marks.

Balloon tips are programmed in javascript. Since ACC depends on the Internet Explorer settings it may be due to the fact that you have configured some javascript restrictions. Does this ring a bell?

Frank

Hi, Frank. I definitely have not made any javascript changes - wouldn't know how even if I wanted to.

I got the same "balloon" error with Windows Vista and IE7 and now with Windows 7 and IE8. Any ideas on what I could check re: java settings?

Thanks,

fphredd
2010-01-07, 09:39
Hi, Frank. I definitely have not made any javascript changes - wouldn't know how even if I wanted to.

I got the same "balloon" error with Windows Vista and IE7 and now with Windows 7 and IE8. Any ideas on what I could check re: java settings?

Thanks,


Sorry...didn't realize I was the bottleneck...

1. No
2. Yes

Now this may be a wrench, so pardon the long windedness following, but want to be sure this isn't 'user error'...

I am running SBS on a ReadyNAS Pro. I am running ACC on a Windows XP with SBS installed, but not running. MySQL ODBC driver installed on XP machine. Music on NAS mapped as M:\. Running ACC by just pointing at mapped directories, and 'ignoring' networking setup options in ACC. Can all this be the root of the headaches I'm causing you??

SilverRS8
2010-01-07, 10:45
Sorry...didn't realize I was the bottleneck...

1. No
2. Yes

Now this may be a wrench, so pardon the long windedness following, but want to be sure this isn't 'user error'...

I am running SBS on a ReadyNAS Pro. I am running ACC on a Windows XP with SBS installed, but not running. MySQL ODBC driver installed on XP machine. Music on NAS mapped as M:\. Running ACC by just pointing at mapped directories, and 'ignoring' networking setup options in ACC. Can all this be the root of the headaches I'm causing you??

If you don't have the remote server settings configured, ACC will use the local installation of SBS. Now SBS may not be running but maybe MySQL is. ACC will then retrieve the data from the local MySQL database instead of the remote. Considering the huge differences in both album and track count this seems very likely.

To determine if this is the case try one of the following:
1. deinstall SBS on the local machine. ACC will not be able to retrieve any data and hence ACC was using the local DB
2. disable MySQL on the machine where ACC is running. ACC will then not be able to retrieve data and hence was using the local DB
3. Configure remote server settings in ACC. For this however you first need to modify the my.tt file on the readynas box to allowe remote access to the database. I don't know how this must be done on a readynas box as I don't have one. Maybe others users can help here a this configuration has been used many times.

An easy solution maybe to enable SBS on the local machine, configure it to scan drive M: and then run ACC against the local DB (ofcourse don't configure the remote server settings). As a new scan will get the DB up to date with the readynas DB I don't think you will see any differences between ACC en SBS on the readynas anymore.

regards,

Frank

Viragored
2010-01-08, 00:11
Hi Dave,

ACC is a .HTA application which is executed by the MSHTA.exe process which is dependent on Internet Explorer components. So I would expect that if you deinstall or remove IE8, ACC will stop working. Ofcourse you could always use a sandbox environment (run a virtual machine with IE) so you can get rid of IE8 on the host.

It is not configurable by the GUI to change which browser will actually open the generated catalogs. But if you want you can look for the line below in the code:
'### Open Full catalog and quickref catalog in Internet Explorer
WshShell.run Chr(34) & "c:\Program Files\Internet Explorer\iexplore.exe " & Chr(34) & " " & Chr(34) & Replace(sTOutputfile,".CAT","") & Chr(34)
WshShell.run Chr(34) & "c:\Program Files\Internet Explorer\iexplore.exe " & Chr(34) & " " & Chr(34) & sTOutputfileShort & Chr(34)

All you'd have to do is change the full path to the browser executable.

P.S. 'Waihi Beach, New Zealand'.... you must be a very happy man :-)

Regards, Frank

Thanks, Frank, I'll try it.
And yes, happy is a good description. I wouldn't want to live anywhere else but here in beautiful NZ!
Dave

Viragored
2010-01-08, 00:13
I'm assuming you're using Windows, so if IE8 is installed correctly you can try right-clicking the .hta file in File Explorer and select Open with... and then select IE as the program to open the file.

Thanks for the input. I probably didn't make it clear enough that all is as I want it when I go to the files with Windows Explorer - a double click brings them up in Firefox, which is what I want. My goal was to get ACC to open the files in Firefox when it has finished creating them. Frank has shown that ACC is pointed towards IE but can be changed.

Regards. Dave

SilverRS8
2010-01-08, 00:26
Thanks for the input. I probably didn't make it clear enough that all is as I want it when I go to the files with Windows Explorer - a double click brings them up in Firefox, which is what I want. My goal was to get ACC to open the files in Firefox when it has finished creating them. Frank has shown that ACC is pointed towards IE but can be changed.

Regards. Dave

I'll put it on my to do list to change the default behaviour using Internet Explorer to using the default configured browser.

Rick B.
2010-01-08, 07:53
Hi, Frank. I definitely have not made any javascript changes - wouldn't know how even if I wanted to.

I got the same "balloon" error with Windows Vista and IE7 and now with Windows 7 and IE8. Any ideas on what I could check re: java settings?

Thanks,

The "balloon is undefined" error I get refers to line 23 of the app, which is:

var balloon = new Balloon

Any ideas?

Thanks,

SilverRS8
2010-01-08, 08:03
The "balloon is undefined" error I get refers to line 23 of the app, which is:

var balloon = new Balloon

Any ideas?

Thanks,

Not really yet as you are the only one reporting this issue so there must be something unique to your configuration. I'll put it on my bug list to investigate.

Can you list again:
1. OS version and SP
2. OS language settings
3. Internet Explorer version
4. Installed browser plugins to control scripts (focus is IE, not Firefox)?
5. AntiVirus/AntiSpam product used?
6. Did you lock down (configure/tighten security) your computer in any means (like security levels or advanced security settings in IE)?

Did you unzip the contents of the include folder in the zip file (is there a JS folder within the Include folder)?

The following files must exist in the folder otherwise the balloon object is not declared and results in the error message you state:
Includes/js/balloon.config.js
Includes/js/balloon.js
Includes/js/box.js
Includes/js/yahoo-dom-event.js
Includes/js/toggle.js


Frank

fphredd
2010-01-08, 08:14
If you don't have the remote server settings configured, ACC will use the local installation of SBS. Now SBS may not be running but maybe MySQL is. ACC will then retrieve the data from the local MySQL database instead of the remote. Considering the huge differences in both album and track count this seems very likely.


An easy solution maybe to enable SBS on the local machine, configure it to scan drive M: and then run ACC against the local DB (ofcourse don't configure the remote server settings). As a new scan will get the DB up to date with the readynas DB I don't think you will see any differences between ACC en SBS on the readynas anymore.

regards,

Frank

Hi Frank,

Went to the easy solution first, figuring if it works I'm good, no need for investigation.

New results.

SBS running on local XP accessing ReadyNAS Pro via mapped drive:
Total Tracks: 32,943
Total Albums: 2,592

ACC on same machine accessing mapped drive:
Total albums: 3194 Total tracks: 32005

SBS on ReadyNAS Pro:
2553 albums with 32899 songs by 490 artists

The album total issue is not as big to me as I'm sure it has to do with the tags on some multiple disc concerts...shouldn't matter on the track count though I find it interesting that the two SBS scan figures are different; subject for another post. For S&G's, going to run a scan with MediaMonkey, see what that one says...

Rick B.
2010-01-08, 10:00
Did you unzip the contents of the include folder in the zip file (is there a JS folder within the Include folder)?

Frank

That did it! Works now. Many thanks, from a dumb user.

lcjohnson
2010-01-08, 10:40
Again my system is configured as:

- Windows XP SP 3 w/ IE8. I have a simple shared network.
- Music folders are on a newly installed NetGear ReadyNAS Duo net attached server.
- Running Squeezebox Server Version: 7.4.1 at 192.168.1.150 (fixed IP addr)
- I have done the mod on the my.tt file on the server and rebooted the server.
- I have installed mysql-connector-odbc-5.1.6-win32.msi
- The media share on the server is mapped as drive M:
- Full remote path to music share is M:\Music

nas-D3-2B-F8:/usr/share/squeezeboxserver/MySQL/my.tt:

# $Id$
#
# Squeezebox Server specific MySQL Server config.

[mysqld]
innodb
skip-locking

# If you want to have user permissions - you need to setup a valid user, and
# remove this line below.
skip-grant-tables

basedir = [% basedir %]
datadir = [% datadir %]
tmpdir = [% datadir %]
language = [% language %]
port = [% port %]
socket = [% socket %]
pid-file = [% pidFile %]
log-error = [% errorLog %]
innodb_fast_shutdown = 1
max_connections = 4
thread_concurrency = 4
log-warnings = 0
#bind-address = [% bindAddress %]
default-character-set = utf8
default-collation = utf8_general_ci
key_buffer = 2M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K

[client]
socket = [% socket %]

I re-booted the NAS after modifying my.tt.
I'm getting the MySQL refusal error that I posted in my last message when I press the test button.

SilverRS8
2010-01-08, 11:02
Again my system is configured as:

- Windows XP SP 3 w/ IE8. I have a simple shared network.
- Music folders are on a newly installed NetGear ReadyNAS Duo net attached server.
- Running Squeezebox Server Version: 7.4.1 at 192.168.1.150 (fixed IP addr)
- I have done the mod on the my.tt file on the server and rebooted the server.
- I have installed mysql-connector-odbc-5.1.6-win32.msi
- The media share on the server is mapped as drive M:
- Full remote path to music share is M:\Music

nas-D3-2B-F8:/usr/share/squeezeboxserver/MySQL/my.tt:

# $Id$
#
# Squeezebox Server specific MySQL Server config.

[mysqld]
innodb
skip-locking

# If you want to have user permissions - you need to setup a valid user, and
# remove this line below.
skip-grant-tables

basedir = [% basedir %]
datadir = [% datadir %]
tmpdir = [% datadir %]
language = [% language %]
port = [% port %]
socket = [% socket %]
pid-file = [% pidFile %]
log-error = [% errorLog %]
innodb_fast_shutdown = 1
max_connections = 4
thread_concurrency = 4
log-warnings = 0
#bind-address = [% bindAddress %]
default-character-set = utf8
default-collation = utf8_general_ci
key_buffer = 2M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K

[client]
socket = [% socket %]

I re-booted the NAS after modifying my.tt.
I'm getting the MySQL refusal error that I posted in my last message when I press the test button.

That certainly looks good. If you have used the IP number as listed above in the remote server option screen everything is ok as it is. So, I can only imagine that there is something on the network level is blocking the traffic. Do you possibly have a firewall configured? Either on the PC or on the NAS?

SilverRS8
2010-01-08, 13:03
I made some changes which require some testing before release and hope some of you can do some tests? Therefor this beta is only posted on the forum.

What to test?
1. Various artist albums should be sorted by Album name
2. Artist names starting with ¡ or ¿ should be sorted by the first char of the name, not by ¡ or ¿ (Tamanaco ?)

http://acc.vanholt.nl/downloads/acc-v205-beta1.zip

Thx in advance...

Frank

SilverRS8
2010-01-08, 14:31
WOW, I didn't expect a 2.0 version that soon :) Works fine for me. Thanks very much.

Well, I just discovered an issue with sorting. If I select "TPE2 tag is AlbumArtist instead of band" and "Sort artist by ARTISTSORT tag", the albums that have an ALBUMARTIST set will be sorted by the ALBUMARTIST and not the ARTISTSORT tag. Example, 3 albums:

1.) ARTIST: Robert Plant, ARTISTSORT: Plant, Robert
2.) ARTIST: Robert Plant; Alison Krauss, ARTISTSORT: Plant, Robert; Krauss, Alison, ALBUMARTIST: Robert Plant & Alison Krauss
3.) ARTIST: Portishead

Now I would expect the sorting order to be as listed above, 1-2-3. But ACC sorts the albums in the order 1-3-2, because the ALBUMARTIST of the second album starts with "R".
Do you have a solution for this?

For test purposes I have added multiple artists to the ARTISTSORT tag however when I look in the database the second artist is not included. For AlbumArtist and Artist however this works as it should. So this leaves me unable to test your issue.

Two questions:
1. Can you answer the questions in http://forums.slimdevices.com/showpost.php?p=502893&postcount=58
2. Can you mail me an example file with the tagging you used?

Frank

Rick B.
2010-01-09, 06:20
I have a few albums that are being displayed in the report multiple times - once for each song.

They are single artist CD's - not various artists. I'm sure it's a tagging problem, but the tags look normal.

In SC, the albums appears normally. I have re-scanned twice, but still the same.

Any ideas on what to look for?

Thanks.

SilverRS8
2010-01-09, 06:36
I have a few albums that are being displayed in the report multiple times - once for each song.

They are single artist CD's - not various artists. I'm sure it's a tagging problem, but the tags look normal.

In SC, the albums appears normally. I have re-scanned twice, but still the same.

Any ideas on what to look for?

Thanks.

Most often this is due to using different cases for the album name.
Tracks with album name Jagged Little Pill and tracks with album name Jagged little pill. Squeezebox Server will store them as totally different albums and ACC will treat them this way. Correct the cases and the problem should be solved.

Rick B.
2010-01-09, 09:19
Thanks. Turns out there are lots of ways for things to go wrong:

- accidentally having the same songs in the artist folder and the album folder

- accidentally having an extra album cover from another album in the same folder

- having the album name in each song


I'm getting there! Really happy with this. Is there a place for donations on your site?

tamanaco
2010-01-09, 10:52
I made some changes which require some testing before release and hope some of you can do some tests? Therefor this beta is only posted on the forum.

What to test?
1. Various artist albums should be sorted by Album name
2. Artist names starting with ¡ or ¿ should be sorted by the first char of the name, not by ¡ or ¿ (Tamanaco ?)

http://acc.vanholt.nl/downloads/acc-v205-beta1.zip

Thx in advance...

Frank

Hi Frank, I just tested 2.05 beta 1 and the Various Artist (Belly Dance) Album that we talked about is still not listed as it should. The issue with the sorting of the Artist Names starting ¡ or ¿ is resolved, but the ¡ or ¿ characters are omitted in the Artist name in the Catalog. Not a big deal... I can live without the ¡ or ¿ printed in the Catalog.

Thanks again...

SilverRS8
2010-01-09, 11:54
Hi Frank, I just tested 2.05 beta 1 and the Various Artist (Belly Dance) Album that we talked about is still not listed as it should. The issue with the sorting of the Artist Names starting ¡ or ¿ is resolved, but the ¡ or ¿ characters are omitted in the Artist name in the Catalog. Not a big deal... I can live without the ¡ or ¿ printed in the Catalog.

Thanks again...

Hi Tamanaco,

For the ¡ or ¿ to appear in the artist name but exclude from sorting I need to add a column to the temporary ACC table. This however is quiet some work and may impact performance so this requires some more investigation.

The Belly Dance various artist issue is indeed due to the fact that ACC determines for itself if an album is correctly defined by SBS as various artist or not. However if you disable the option 'TPE2 tag is AlbumArtist instead of band' ACC does not perform this tasks so it should solve the issue.

You're welcome...
Regards,

Frank

SilverRS8
2010-01-09, 12:12
Thanks. Turns out there are lots of ways for things to go wrong:

- accidentally having the same songs in the artist folder and the album folder

- accidentally having an extra album cover from another album in the same folder

- having the album name in each song


I'm getting there! Really happy with this. Is there a place for donations on your site?

Glad things are working out fine for you. The quality of the catalog has a direct link with the quality of the tags and tagging, especially intially, is not that much fun ;-)

Maybe the folder structure I use can help you too:

/Albums/Artists/<ArtistName>/<AlbumName>

/Albums/SeparateTracks/

Using this I set the ACC starting folder to /Albums/Artists. This way the catalog only includes full albums and not the separate tracks.

For daily browsing usage on the squeezeboxes, I use Custom Browse from Erland. For this I have added the comment 'Full Album' to all albums within the folder /Albums/Artists/. This way you can browse only the full albums using custom browse without seeing all single file artist. You then also only have to focus all tagging effort primarily to the files within the /Albums/Artists/ folder structure.

About your donation request, there wasn't a place on my website but there is now (thanks for the idea but much more for the appreciation (with or without donation of course)).

Regards,

Frank

SilverRS8
2010-01-09, 12:22
I posted ACC v2.1 for download on http://acc.vanholt.nl

Change log:
ADDED - Option to sort albums by album name when primary sorting is Artist
FIXED - Special characters like ¡¿ are used in front of the artist or album name resulting in incorrect sorting. Although not configureable by GUI a method has been implemented coping with this issue which can be easily extended.
FIXED - An apostroph character in the genre was not displayed correctly in the quickref catalog
FIXED - Various Artist albums were sorted by date. This has been corrected to sort by album name when sort by Genre was not selected

Regards,

Frank

Viragored
2010-01-09, 19:57
Hi Frank - that worked fine for me, a total library of 1660 albums. Various Artists albums came out sorted by album title, and all other features seem fine too.

Well done, Dave

tamanaco
2010-01-12, 15:22
The Belly Dance various artist issue is indeed due to the fact that ACC determines for itself if an album is correctly defined by SBS as various artist or not. However if you disable the option 'TPE2 tag is AlbumArtist instead of band' ACC does not perform this tasks so it should solve the issue.

Hi Frank, I've been using ACC with the TPE2 option disabled and have tested with it enabled with the same result. What I can not understand is why is only happening with this specific Various Artist (Compilation) Album. There is a character of some tag there that is making ACC treat it differently. I use the same tag and folder naming scheme with all the other Various Artist (Compilations) Albums in my library and ACC displays them as expected. I must have over 100 compilations albums. As I said before, SC does not have any issues with this album and catalogs it along with the other compilations as expected.

SilverRS8
2010-01-13, 00:07
Hi Frank, I've been using ACC with the TPE2 option disabled and have tested with it enabled with the same result. What I can not understand is why is only happening with this specific Various Artist (Compilation) Album. There is a character of some tag there that is making ACC treat it differently. I use the same tag and folder naming scheme with all the other Various Artist (Compilations) Albums in my library and ACC displays them as expected. I must have over 100 compilations albums. As I said before, SC does not have any issues with this album and catalogs it along with the other compilations as expected.

Hmm the fact that if you disable the TPE2 option and the result stays the same surprises me. ACC will not alter the AlbumArtist when enabed. This is because TPE2 is an deliberate entered tag by someone and hence must not be altered. When enabled, ACC will determine - for various artist albums only - how often an artist on the album occurs.

If this is more than 1/3 this artist is expected to be the album artist. This logic is not rocket science of course but has proven to be doing its job almost perfect. ACC not doing so will result in SBS classifying if an album is a various artist album or not. SBS does so when more than one artist is defined in the artist tracks i.e. If an album has 10 tracks from which 9 are of artist1 and the last is by artist1 feat artist2 (both in artist tag) then SBS will classify this album as various artist album.

Now when TPE2 is disabled, ACC will not perform any logics on this front so falls back to SBS logics.

ACC does not alter any data besides 'various artists' to album artists. ACC does not change it the other way around i.e. artist albums to various artist.

Let me know if my answer clarify the reason why things are happening for the Belly album. If not i'll dive into the problem again.

Frank

tamanaco
2010-01-13, 08:23
Let me know if my answer clarify the reason why things are happening for the Belly album. If not i'll dive into the problem again.

Frank, I double checked my tags, but could not find anything... I email you more details.

DigitalMitch
2010-01-14, 09:57
Frank,

thanks for a great utility, upgarded this morning from 1.5ish which I hadn't got fully working and successfully emailed the QuickRef to my phone.

Few hours later, that prevented me buying a copy of an album I already had, so I'm donating you the cost of that album.

Interestingly, in past posts you didn't intend to support AlbumArtistSort, since it is an 'unofficial' tag, but is supported by SBS.
This seems to work at the moment for me:-

Album = "West Side Stoy"
Compilation = "1"
AlbumArtist = "Leonard Bernstein"
AlbumArtistSort = "ZZZZ OST"

sorts as ZZZZ OST in the midst of all my other soundtracks where AlbumArtist = "Various - OST" and AlbumArtistSort - "ZZZZ OST". I suspect that this is because SBS has translated AlbumArtistSort into an internal field that you are using.

Anyway, happy it works.

Mitch

DigitalMitch
2010-01-14, 10:47
just noticed that "Infected" by "The The" appears under an extra T heading prior to '0-9'.

it's only a minor niggle, but thought you ought to be aware. I remember iPeng having some trouble with this one.

SilverRS8
2010-01-14, 11:10
Frank,

thanks for a great utility, upgarded this morning from 1.5ish which I hadn't got fully working and successfully emailed the QuickRef to my phone.

Few hours later, that prevented me buying a copy of an album I already had, so I'm donating you the cost of that album.

Interestingly, in past posts you didn't intend to support AlbumArtistSort, since it is an 'unofficial' tag, but is supported by SBS.
This seems to work at the moment for me:-

Album = "West Side Stoy"
Compilation = "1"
AlbumArtist = "Leonard Bernstein"
AlbumArtistSort = "ZZZZ OST"

sorts as ZZZZ OST in the midst of all my other soundtracks where AlbumArtist = "Various - OST" and AlbumArtistSort - "ZZZZ OST". I suspect that this is because SBS has translated AlbumArtistSort into an internal field that you are using.

Anyway, happy it works.

Mitch

Hi Mitch,

Thank you very much for your donation! Really appreciate it.

ACC v2.1 - although not intended to be supported at first - does support the ArtistSort feature (lets say that it took some time for me to see the light ;-). In the advanced option screen you can turn this option on or off.

Frank

SilverRS8
2010-01-14, 11:11
just noticed that "Infected" by "The The" appears under an extra T heading prior to '0-9'.

it's only a minor niggle, but thought you ought to be aware. I remember iPeng having some trouble with this one.

Can you send the file to me by email? I'll look into it and make a fix if possible.

Frank

arubaluba
2010-01-14, 12:22
Hello,

I've got a minor problem when running ACC (v2.1). The output is allways showing "###CAPEND###" and "###CAPSTART###" in the album header. See attachment. It doesn't make a difference if I switch the option "Display starting capitals" on or off. I can fix it afterwards with a text editor but like to see the starting capitals. Does anybody know how to fix it? Thanks in advance. By the way: Great appliction!

Regards, Rene

SilverRS8
2010-01-14, 12:38
Hello,

I've got a minor problem when running ACC (v2.1). The output is allways showing "###CAPEND###" and "###CAPSTART###" in the album header. See attachment. It doesn't make a difference if I switch the option "Display starting capitals" on or off. I can fix it afterwards with a text editor but like to see the starting capitals. Does anybody know how to fix it? Thanks in advance. By the way: Great appliction!

Regards, Rene

Hi Rene,

Good thing you posted a picture. You discovered a bug. If you disable the option 'Use alternative header background image' the problem should be solved. I'll put it on my bugfix list. Thx for the report!

Frank

arubaluba
2010-01-14, 13:30
Thanks Frank for your quick reply! I'll give it a try tomorrow.

Regards, Rene

Update: Works like a charm! See screenshot. Thanks.

Rick B.
2010-01-25, 10:39
Hi, Frank. Thank you for this most useful tool. I have made a donation today.

SilverRS8
2010-01-25, 10:48
Hi, Frank. Thank you for this most useful tool. I have made a donation today.

Hi Rick,

Thank you very much. Really appreciate it! If you need any support or a tweak let me know.

BTW I posted ACC v3 in a new thread ( http://forums.slimdevices.com/showthread.php?t=74452 ). Use this tread for any questions and support...

Regards,

Frank

mps
2010-03-22, 15:33
I've installed 32-bit MySQL connector on 64-bit Windows 7, and modified my.tt on my ReadyNAS Pro, and disabled the firewall on my computer, but pressing test still gives me the error:

Error connecting to 169.254.1.37.
Possible reasons:
- The required mySQL ODBC driver is not installed.
- If you are accessing mySQL on a remote server please make sure remote access is allowed by the remote server (default=disabled).If you upgrade Squeezecenter, you may have to re-enable remote access.
Refer to Help screen for more information.
Error description:[MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '169.254.1.37' (10061)

What should I try next?

Thanks,

Mike

mps
2010-03-22, 19:25
I worked this out and posted the solution in the current thread Album Creator thread at http://forums.slimdevices.com/showthread.php?p=527361#post527361

Chunkywizard
2010-08-12, 04:49
Hi Frank,

I have just bought a new PC and am trying to get ACC up and running on it. I have copied the settings across from my old pc, but I can't get the ratings to show (see attached). My new PC is 64bit Windows 7 vs. 32bit XP SP3 on my old machine. Any ideas how I can get the ratings to show?

CW

SilverRS8
2010-08-12, 10:47
Hi Frank,

I have just bought a new PC and am trying to get ACC up and running on it. I have copied the settings across from my old pc, but I can't get the ratings to show (see attached). My new PC is 64bit Windows 7 vs. 32bit XP SP3 on my old machine. Any ideas how I can get the ratings to show?

CW

Looks like you didn't copy the full content of the 'Includes' sub folder of ACC.

Chunkywizard
2010-08-12, 11:33
Hi Frank,

thanks for the quick response. Not sure it's that. The 3.4 zip and my install both contain 49 files and 8 folders.

Any other ideas?

CW

SilverRS8
2010-08-12, 22:50
Hi Frank,

thanks for the quick response. Not sure it's that. The 3.4 zip and my install both contain 49 files and 8 folders.

Any other ideas?

CW

Does the includes folder contain the R1.gif R2.gif R3.gif R4.gif and R5.gif images? Otherwise send me:
1. The acc.log file
2. The generated catalog

P.S. Your using the old v2 ACC forum thread. Please use the v3 thread instead.

Chunkywizard
2010-08-13, 00:05
switching to the new thread...