PDA

View Full Version : Announce: Album Catalog Creator for SlimServer



Pages : 1 [2]

SilverRS8
2008-01-29, 01:03
Hi all,

My website is working again and I posted the RC3a version on http://www.vanholt.nl/acc/acc.htm .

There was a problem with the various artist albums when the option 'use folder structure to distinguish albums' option was selected which is fixed in this version.

Let me know if the automatic detection of verious artists albums works for you. Especially try to test ACC with the 'use folder structure to distinguish albums' option deselected.

Frank

MuckleEck
2008-01-29, 01:25
Frank,

Great work once again, I had to make a modification as shown below to the replace filepath line but after that it picked up all the covers...

sFilepath = Replace( rs("path"), "file:////n2100/itunes" ,"y:") 'Strip file:/// prefix

The only problem now is the "various Artists" albums that I have the album cover shows up for every different instance of Artist within the album, so for an album with 50 tracks by 50 different artists I have 50 covers.....can this be sorted, am happy to send you the log file if required.

Many thanks

SilverRS8
2008-01-29, 01:34
Frank,

Great work once again, I had to make a modification as shown below to the replace filepath line but after that it picked up all the covers...

sFilepath = Replace( rs("path"), "file:////n2100/itunes" ,"y:") 'Strip file:/// prefix

The only problem now is the "various Artists" albums that I have the album cover shows up for every different instance of Artist within the album, so for an album with 50 tracks by 50 different artists I have 50 covers.....can this be sorted, am happy to send you the log file if required.

Many thanks

Hi Muckleeck,

Thx for the feedback! The file:/// was added to make album covers work in Firefox but that is indeed causing problems when using UNC paths for NAS reference. Good thing you point that out. Is that the only change you made for getting it to work? I want to create some GUI settings so NAS users won't have to change the actual code. Can you provide me with an example path reference from your database and with the path mapping from your windows machine you run ACC from?
BTW Are you willing to do some testing if I implement the NAS GUI settings?

Regarding the Various artist issue:
1. The RC3 version with the option 'Use folder structure...' deselected should create good results for the various artists
2. The RC3a release (just posted, see previous post) fixes the various artist issue as described in 1 so you can use the 'Use folder structure...' option again for various artist albums
3. For multi CD albums either the Disc tag must be used or the album name should contain the disc number (a fair requirement I think;-) to prevent every artist getting its own album.

Frank

MuckleEck
2008-01-29, 01:59
Frank,

A sample entry from the dB (imported into excel) as below

file:////n2100/itunes/Music/B/Bach/Great%20Organ%20Works%20-%20Carlo%20Curley/01%20-%20Passacaglia%20and%20Fugue%20in%20C%20Minor,%20B MV%20582.flac

The path that I use from windows is

y:\music\b\bach\...etc

Tried rc3a...various artists works great, the log file is now only 85k instead of 600k.

I am happy to help with UNC path testing if you need it.

Finally some of the covers are coming up with the small red cross as shown in the attached pdf...the file exists any reason why it can't be displayed is there some size limits (small or large)?

Many thanks

SilverRS8
2008-01-29, 02:08
Hi MuckleEck,

Thx for the info regarding the paths. I'll use these as input for the changes to be made and send you the version for testing.

I had this once myself and it appeared to be a cover.jpg file which was actually a .png format. Can you check this? Irfanview reports such things on opening the file (I believe www.irfanview.com).
Very small but nice utility.

What character should be next to Josseph bonnet? I think I missed the conversion of that character.

Frank

SilverRS8
2008-01-29, 02:14
B.T.W. If you select 'Print background colors and images' from the Internet explorer Tools -> Extra -> Advanced options, the gradient background in the headers will also be printed to PDF (or printer).

Frank

MuckleEck
2008-01-29, 02:17
Frank

I think the character is an Πas in

Joseph Bonnet: Œuvres Complètes, Vol. 1

The folder.jpg is in there for that album but maybe can't be read because of the Œ.

Image of album attached.

Thanks

Alasdair

SilverRS8
2008-01-29, 02:21
Frank, The folder.jpg is in there for that album but maybe can't be read because of the Œ.

Your absolutely right. I'll see if I can fix this...

Frank

MuckleEck
2008-01-29, 02:35
Frank,

As far as the unknown images are concerned they work in firefox but not IE...

I have re-saved as foilder.jpg and they are ok in IE now

Kind Regards

Alasdair

SilverRS8
2008-01-29, 02:37
Frank,

As far as the unknown images are concerned they work in firefox but not IE...

I have re-saved as foilder.jpg and they are ok in IE now

Kind Regards

Alasdair

Sounds like the .png issue which Firefox is known to support better. Thx for the feedback.

Frank

tamanaco
2008-01-29, 07:21
Frank, albums that contain "double quotes" within their name in the tags are converted to 'single quotes' when the folder are created based on these tags. This 'placeyourquotehere' are interpreted by ACC as: "placeyourquotehere"

EDIT: Also, when using the folder structure albums with the same name are merged by ACC. I renamed a few of my albums to resolved this issue. I had five albums under different artists named "Greatest Hits".

jordi.c
2008-01-29, 17:54
Hi Frank,

thanks for making this wondefull add-on :)

I have some question concerning If i can use it.

-SlimServer (6.5.4) is running on a NAS where Linux is installed on.

-The work PC's OS is Windows Vista.

Is it possible for me to get this working?

thanks in advance.
Jordi

SilverRS8
2008-01-30, 00:03
Hi Frank,

thanks for making this wondefull add-on :)

I have some question concerning If i can use it.

-SlimServer (6.5.4) is running on a NAS where Linux is installed on.

-The work PC's OS is Windows Vista.

Is it possible for me to get this working?

thanks in advance.
Jordi

Yes, it should be no problem. As you might have read in this thread I will add some GUI options in a next version to make it easy for NAS users to configure ACC to work with a NAS.

There are a couple of things you need to do:
- Install the mySQL ODBC driver on your Vista machine
- Change the ODBC connector string
Your database is on the linux server so the connection string on line 48 should look like:
Const ConnectString = "DRIVER={MySQL ODBC 3.51 Driver};Server=<NAS IP NUMBER>;Port=9092;Database=slimserver;UID=slimserver;Pass word=;Option=3"

Replace <NAS IP NUMBER> with....your NAS ip number

- Map a drive from the windows machine you're running ACC from to the NAS music share

- Edit line 530
ACC will take the path to the track stored in the DB to look for cover files. When running ACC from a windows machine SS is also running from this is no problem. The path stored on your linux NAS however looks something like; file:////n2100/itunes/Music/B/Bach/Great%20Organ%20Works%20-%20Carlo%20Curley/01%20-%20Passacaglia%20and%20Fugue%20in%20C%20Minor,%20B MV%20582.flac (thx to MuckleEck for the example)
ACC can't use this path but needs a drive letter. So if you mapped drive y: to the path \\n2100\itunes, then you should change line 530 to look like:
sFilepath = Replace( rs("path"), "file:////n2100/itunes" ,"y:")

Hope this helps?

Frank

cnsmipe
2008-01-31, 14:35
Hi
I'm a bit confused here!!! What ID tags are You reading???
I've tagged all my music according to the instructions in the WiKi
so I do only have ID3v2 tags No APE or anything else...
But still i do get two different problems running your nice application/script.

First off:
AC/DC the tag is as that but still I get 2 different Artists ACDC and AC DC.

Then the other:
Some albums are showing up as 1 Album/song so an album with 12 songs will show up as 12 albums

BR
Mike

schatzy
2008-01-31, 15:11
Hi

Then the other:
Some albums are showing up as 1 Album/song so an album with 12 songs will show up as 12 albums

BR
Mike

Mike,

When this happens does SC7 or SS6.5.x show one album or multiple albums as well.

Check the track tags. If the tracks list as 1 then 2 then 3/12 then 4 then 5/12 then this can cause this to happen.

Schatzy

cnsmipe
2008-01-31, 15:25
Mike,

When this happens does SC7 or SS6.5.x show one album or multiple albums as well.

Check the track tags. If the tracks list as 1 then 2 then 3/12 then 4 then 5/12 then this can cause this to happen.

Schatzy
Server 6.5.X
This appears on more the one album...
My structure are as follows
Directory named: "Artist", subdirectory: "album"
files "1 - Title"

Track tag is 01 02 and so on

Mike

SilverRS8
2008-01-31, 20:56
Hi
I'm a bit confused here!!! What ID tags are You reading???
I've tagged all my music according to the instructions in the WiKi
so I do only have ID3v2 tags No APE or anything else...
But still i do get two different problems running your nice application/script.

First off:
AC/DC the tag is as that but still I get 2 different Artists ACDC and AC DC.

Then the other:
Some albums are showing up as 1 Album/song so an album with 12 songs will show up as 12 albums

BR
Mike

I'll do some checks on the AC/DC problem which can either be two things: 1. The way it is stored in the DB or 2. The '/' is causing problems. I'll get back on this one.

For the second problem; This can have the following reasons:
1. The albumname tag is different among the album tracks (a difference in case is enough to have SC/SS it stored as different albums
2. On an album with multiple track the albumnames are identical for every cd (so no CD number in albumname) AND the Disc tag is not used either.

So most often this is a tagging issue. Can you confirm this?

Frank

cnsmipe
2008-01-31, 23:45
I'll do some checks on the AC/DC problem which can either be two things: 1. The way it is stored in the DB or 2. The '/' is causing problems. I'll get back on this one.

For the second problem; This can have the following reasons:
1. The albumname tag is different among the album tracks (a difference in case is enough to have SC/SS it stored as different albums
2. On an album with multiple track the albumnames are identical for every cd (so no CD number in albumname) AND the Disc tag is not used either.

So most often this is a tagging issue. Can you confirm this?

Frank
Ok I suspect tagging aswell but I'm trying to understand what's happening :).
No the album name are identical, and as far as SS it's okey just one album (and 2 disc where this is aplicable), some of the albums have diffrent disc number and this is working fine for the albums hwho are presented the correct way, you get 2 albums with the same name and disc 1 and 2.

I've been using TAG&rename and the option F10 get tags from Amazon

/m

SilverRS8
2008-02-01, 02:29
Server 6.5.X
This appears on more the one album...
My structure are as follows
Directory named: "Artist", subdirectory: "album"
files "1 - Title"

Track tag is 01 02 and so on

Mike

Do you use the ACC RC3a release? RC3 had an issue regarding albums appearing multiple times.

Frank

cnsmipe
2008-02-01, 02:47
Do you use the ACC RC3a release? RC3 had an issue regarding albums appearing multiple times.

Frank
Yes I do use RC3a release, is there a later version?

And regarding the AC/DC and the / issue I'v tried to retag all to ACDC and AC DC but still I get the same result.

I reinstalled the mySQL ODCB after retagging but before running Your script

Mike

schatzy
2008-02-01, 05:57
Yes I do use RC3a release, is there a later version?

And regarding the AC/DC and the / issue I'v tried to retag all to ACDC and AC DC but still I get the same result.

I reinstalled the mySQL ODCB after retagging but before running Your script

Mike

I did some extensive testing last night by setting up a few albums for AC/DC, AC\DC, for the ACDC, AC DC problem you are having.

What I found was that no matter what I did it would always Come out as AC/DC. It did not matter which way the /\ went or if it had a space before or after it always got changed to "/".

So this morning I powered up a system from at work that runs a Spanish (sold in Spain) version of Windows XP Pro SP2 and made up some albums and then transfered them to a English (Sold in the US) version of Windows XP Pro SP2 and ran some tests. What i got was very inconsistent. Most of the time it would come out as ACDC but occasionaly it would come out as AC DC. It seems to me to be a difference in the language settings for characters.

You had stated that you downloaded some of the tagging from Amazon. Could it be that some of the AC/DC tags came from Amazon.

I would suggest opening each album with your tagging software. Bulk remove or change the artist tag to something completely different. Save this Close the tagging software. Reopen the tagging software and that album and and bulk change the artist tag to AC/DC. Remember that you will have to do a complete clear and rescan with SC/SS and the rerun ACC.

If this does not fix the problem then PM me and we can work off line of the forum to get this sorted out for you.

Schatzy

cnsmipe
2008-02-01, 14:01
I'll try that as soon as I get back home, i'm at my parents house for the weekend.

Mike

terry
2008-02-02, 10:16
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

Frank,
Since I am running XP x64 on the server, I needed to pursue this further. Like other aspects of X64 there are 32 and 64 bit structures.
I had been trying to get the native 64 bit MySQL code to work but ran into other issues where the drivers and code failed to communicate. Finally, I dropped back and installed the 32 bit MySQL connector code instead and finally got ACC to run!
In case anyone else is interested, the default ODBC administrator in x64 is 64-bit only. Therefore, you'll probably want to add %SystemRoot%\SysWOW64\odbcad32.exe to your Administrative Tools shortcuts for 32-bit DSN setup.

P.S. Nice app Frank!!!

venus light
2008-02-02, 15:33
Frank,

Thanks so much for all your hard work with this - it's exactly what I've been looking for.

I've got a couple of questions...

1) How is it supposed to handle Various Artists? I've tagged all my VA albums as:
Artist - Various Artists
Title - Artist / Song title
I've found it easiest for organization. Yet, ACC gives each track in each of the albums it's own album entry. Therefore, if I've got a VA album with 20 tracks, then I get 20 different albums with 1 track each in ACC.

2) Along the same lines as #1, I've got 2 albums in a collection of 551 that is split up in my ACC report as 10 different albums - each with 1 or 2 tracks in it. I can't seem to find anything in the tags that is causing this - SS treats it as a single album.

3) Artists with "The" at the beginning get alphabetized as such. Is there a way to make ACC ignore the leading "The"?

4) And finally, there are a couple of instances where the printout is cutting off an album listing in the middle of a list of songs. Is there anyway to fix this?


I apologize if any of these issues have already been covered in this thread - I didn't see any when I searched for them.

Thanks again for all your hard work!

SilverRS8
2008-02-03, 00:19
Frank,

Thanks so much for all your hard work with this - it's exactly what I've been looking for.

I've got a couple of questions...

1) How is it supposed to handle Various Artists? I've tagged all my VA albums as:
Artist - Various Artists
Title - Artist / Song title
I've found it easiest for organization. Yet, ACC gives each track in each of the albums it's own album entry. Therefore, if I've got a VA album with 20 tracks, then I get 20 different albums with 1 track each in ACC.

2) Along the same lines as #1, I've got 2 albums in a collection of 551 that is split up in my ACC report as 10 different albums - each with 1 or 2 tracks in it. I can't seem to find anything in the tags that is causing this - SS treats it as a single album.

3) Artists with "The" at the beginning get alphabetized as such. Is there a way to make ACC ignore the leading "The"?

4) And finally, there are a couple of instances where the printout is cutting off an album listing in the middle of a list of songs. Is there anyway to fix this?


I apologize if any of these issues have already been covered in this thread - I didn't see any when I searched for them.

Thanks again for all your hard work!

Hi Venus Light,

Thanks for using ACC and your feedback on it. I hope I can answer your questions. I assume that you are using the RC3a version on this.

1. How ACC treats VA albums; It performs a general DB query and then processes all VA albums and test if these are really true VA albums. SS/SC also tag an album as VA if one other artist is featuring or performing on the album. These cases are changed to the correct album artist by ACC.
Every track appearing as a single album can have the following causes;
- Not all album tags are exactly identical. Even a difference in character case somewhere causes SS/SC to assign a new album ID
- Multiple CDs must be distinguished either by using the Disc tag or by album name (put cd number in album name)

2. I think the same causes as described in (1)

3. This request has been made before and there even is a solution with code in this thread on it from Phil if i'm correct.
It is a personal preference I think but its on my future version option list. So yes, it is possible.

4. ACC has a printseperator function (can be disabled in the GUI) which inserts CSS code only used for printing so has no effect in Firefox or IE but you can see its effect in the print preview.
The function uses a number of criteria; maximum number of tracks that can be displayed on a page using the current Tracklisting font. Another criteria is the maximum of rows that can be displayed. In the ACC help screen there is some info about it and how you can solve issues with it which is mostly by using smaller page margins to be set from firefox or IE. There is also some info about getting rid of the ugly header/footer and how to place decend page numbers on the pages.

Please let me know if any of my answers are indeed true and helpfull. If not, maybe I can fix things with your feedback. Maybe you can send me (or post) a screenprint of the tags from the albums causing trouble from i.e. Tag&Rename/MP3Tag.

Frank

venus light
2008-02-04, 17:16
Frank,

Thanks for your response. I'll try and sort out the tagging issue on my own - if I can't figure it out, I'll post a screenshot of the tags.

I was indeed running RC3 instead of RC3a - after upgrading, it fixed the Various Artists issue.

I changed the code to sort by AlbumTitle, thanks for providing that.

And I found the code that Phil posted with regards to the leading "The":

-------
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

----


but I don't know where to insert and or/replace it...

Thanks again!

cnsmipe
2008-02-05, 03:43
I did some extensive testing last night by setting up a few albums for AC/DC, AC\DC, for the ACDC, AC DC problem you are having.

What I found was that no matter what I did it would always Come out as AC/DC. It did not matter which way the /\ went or if it had a space before or after it always got changed to "/".

So this morning I powered up a system from at work that runs a Spanish (sold in Spain) version of Windows XP Pro SP2 and made up some albums and then transfered them to a English (Sold in the US) version of Windows XP Pro SP2 and ran some tests. What i got was very inconsistent. Most of the time it would come out as ACDC but occasionaly it would come out as AC DC. It seems to me to be a difference in the language settings for characters.

You had stated that you downloaded some of the tagging from Amazon. Could it be that some of the AC/DC tags came from Amazon.

I would suggest opening each album with your tagging software. Bulk remove or change the artist tag to something completely different. Save this Close the tagging software. Reopen the tagging software and that album and and bulk change the artist tag to AC/DC. Remember that you will have to do a complete clear and rescan with SC/SS and the rerun ACC.

If this does not fix the problem then PM me and we can work off line of the forum to get this sorted out for you.

Schatzy


So strange, I tried yesterday, ( i did a system restore due to a different problem) and had to reinstall both ACC and MYsql ODBC. And the AC/DC problem was solved!!!
So my question is where does ACC get the Tag info from? Is't from the SS db or is't from the IDtag within the MP3 file it self? So if it's the SS db you have to rebuild the db before trying!

Then regarding the Album problem it still remains

Micke

schatzy
2008-02-05, 05:13
So strange, I tried yesterday, ( i did a system restore due to a different problem) and had to reinstall both ACC and MYsql ODBC. And the AC/DC problem was solved!!!
So my question is where does ACC get the Tag info from? Is't from the SS db or is't from the IDtag within the MP3 file it self? So if it's the SS db you have to rebuild the db before trying!

Then regarding the Album problem it still remains

Micke

It gets the tag info from the SS database, so exactly why it was doing what it was with the AC/DC. Well it's Windows. It should not take rebuilding the data base but there may have been another issue in Windows that was causing the problem as Everything in Windows Will affect how other things happen in Windows.

AS fro your album problem PM me and i will give you my e-mail address and the you can send me one of your albums and i will check it out with my system and try to figure out what is wrong.

Schatzy

Rick B.
2008-02-05, 08:50
Frank, I had an older version of your script and it worked perfectly. I downloaded your latest version yesterday and for about a half of my 800 albums it doubles all of the song titles - i.e., each song is repeated twice in a row. And, for some Various Artists' albums the songs are repeated 3 or 4 times!. The rest look perfect.

I don't think it's my tags as I don't fool around with them very much - I just rip with EAC to flac and that's it. I'm on Windows XP. I'm also running Music IP concurrently.

Any ideas what might be happening here? Thanks.

venus light
2008-02-05, 15:05
Frank, I had an older version of your script and it worked perfectly. I downloaded your latest version yesterday and for about a half of my 800 albums it doubles all of the song titles - i.e., each song is repeated twice in a row. And, for some Various Artists' albums the songs are repeated 3 or 4 times!. The rest look perfect.

I don't think it's my tags as I don't fool around with them very much - I just rip with EAC to flac and that's it. I'm on Windows XP. I'm also running Music IP concurrently.

Any ideas what might be happening here? Thanks.

Frank or one of the other guys might have a better answer, but I would guess it is Music IP.

I was running it and if I did anything to my tags or moved files and rescanned with SlimServer, it always showed multiple instances of songs and/or albums. It's something about Music IP that it wants to cache older versions even if they don't exist. I would turn off Music IP, do a clear and rescan with SS and then run ACC and see what happens.

Rick B.
2008-02-06, 06:44
Thanks for the suggestion, venus light. In fact, I had just done a complete re-scan in SS but had left MusicIP running.

I'll report back after I do what you suggest.

mkgolden1
2008-02-06, 22:01
...this script; it is EXACTLY what I have been hacking around with off and on, or been lazy and looking for someone to have created a solution, for years. Unfortunately for me, I had a drive failure last night and when the rescan occurred my db was empty, so I am doing a rebuild of the RAID and a rescan as we speak. I can hardly wait to run this.

Again, thanks, a very nice addition and a real need met.

Rick B.
2008-02-08, 05:32
Frank or one of the other guys might have a better answer, but I would guess it is Music IP.

I was running it and if I did anything to my tags or moved files and rescanned with SlimServer, it always showed multiple instances of songs and/or albums. It's something about Music IP that it wants to cache older versions even if they don't exist. I would turn off Music IP, do a clear and rescan with SS and then run ACC and see what happens.

My problem with multiple listings of song titles remains after following the suggestions. I get multiple songs with the new version of ACC, but everything is correct if I use older version 1 of ACC.

SilverRS8
2008-02-08, 09:43
My problem with multiple listings of song titles remains after following the suggestions. I get multiple songs with the new version of ACC, but everything is correct if I use older version 1 of ACC.

ACC access the DB directly. It determine is a track belongs to a new album based on albumid or folderstructure. If musicIP inserts its own data into the DB (don't know if it does), then multiple occurences of the same track exists but with different albumids or folderreference and hence albums/tracks appear multiple times.

I suspect MusicIP is causing the problem since others users have not reported this problem before.

Just as wild guess you can try the following;
- Try different results by enabling/disabling the 'use folder structure...' option
- by changing the line in the script (just do a search for it):
sql = "Create table ACC " &_

into:
sql = "Create table ACC DISTINCT " &_

Note the space after DISTINCT is mandatory. I can't test this my self but small change this can resolve the issue.

Frank

Donzi
2008-02-11, 19:18
Frank, I had an older version of your script and it worked perfectly. I downloaded your latest version yesterday and for about a half of my 800 albums it doubles all of the song titles - i.e., each song is repeated twice in a row. And, for some Various Artists' albums the songs are repeated 3 or 4 times!. The rest look perfect.

I don't think it's my tags as I don't fool around with them very much - I just rip with EAC to flac and that's it. I'm on Windows XP. I'm also running Music IP concurrently.

Any ideas what might be happening here? Thanks.

I had the same thing happening with RC3 and noticed the albums that have duplicate song lines are albums that I have tagged with multiple genre tags. I just tried ACC for the first time today so do not have experience with the older versions to know if this is a new issue.

Are you sure you didn't tag some albums with multiple genres? For example I have Rock/Christmas albums that are tagged both as 'Rock' and as 'Christmas'. Those albums would have duplicate track listings. When I added 'Christmas' to the 'Exclude Genre' box the duplicate tracks disappeared.

SilverRS8
2008-02-12, 00:01
I had the same thing happening with RC3 and noticed the albums that have duplicate song lines are albums that I have tagged with multiple genre tags. I just tried ACC for the first time today so do not have experience with the older versions to know if this is a new issue.

Are you sure you didn't tag some albums with multiple genres? For example I have Rock/Christmas albums that are tagged both as 'Rock' and as 'Christmas'. Those albums would have duplicate track listings. When I added 'Christmas' to the 'Exclude Genre' box the duplicate tracks disappeared.

Thanks Donzi for the hint on duplicate tracks when using multiple genre tags. I'll try to simulate it and do some troubleshooting.

Frank

venus light
2008-02-13, 17:17
I am getting a red X Album Cover for 2 albums in my collection. I saw someone was having that problem because they were actually pngs. I checked with irfanview and they are jpgs. In fact, for one of them, I have the exact same file as art for another album and it displays fine. The artwork displays perfectly in SlimServer - both are being viewed in IE.


Any ideas?

I have attached screenshots if you care to see.

SilverRS8
2008-02-14, 00:29
I am getting a red X Album Cover for 2 albums in my collection. I saw someone was having that problem because they were actually pngs. I checked with irfanview and they are jpgs. In fact, for one of them, I have the exact same file as art for another album and it displays fine. The artwork displays perfectly in SlimServer - both are being viewed in IE.


Any ideas?

I have attached screenshots if you care to see.

Hi Venus light,

I think the first red X may be caused by the '/' in the year field. I don't see any problem with the other one regarding tags. You tested for the PNG issue which only leaves a special character in the full path to the albumcover file. Can you confirm if this is the case?

I haven't had any spare time lately to do some bug fixing but this weekend I'm planning to solve some posted issues. The '/' in year problem is easy to fix (just never accounted for a year notation with month and ay in it).
I'll also try to fix the multiple album issue for every track.

Rick B. Can you maybe send me some files or create a download for it causing the problem? It could be very helpfull in trying to fix the issue. I don't have MusicIP though so can't test for the effect of it which as I read the post from Venus Light can be quiet large.

Frank

Edit: Just noticed that the '/' in the very last album creates no problem so the '/' should not be the issue. I'll create a seperate version logging some additional information in an attempt to pinpoint the problem.

venus light
2008-02-14, 06:45
Edit: Just noticed that the '/' in the very last album creates no problem so the '/' should not be the issue. I'll create a seperate version logging some additional information in an attempt to pinpoint the problem.


Frank, yeah I was going to say I've got lots of live recordings that have '/' in the album title and there's no problem with missing artwork.

Let me know if I can do any debugging for you.

SilverRS8
2008-02-14, 12:21
Frank, albums that contain "double quotes" within their name in the tags are converted to 'single quotes' when the folder are created based on these tags. This 'placeyourquotehere' are interpreted by ACC as: &quot;placeyourquotehere&quot;

EDIT: Also, when using the folder structure albums with the same name are merged by ACC. I renamed a few of my albums to resolved this issue. I had five albums under different artists named "Greatest Hits".

I fixed the double qoute issue (to be incorporated in next release).

The 'greates album' problem I can't reproduce. I myself also have multiple 'greatest albums' which, when 'use folder structure...' is selected sort fine.
When this option is selected the albums are distinguished based on the full folder path to the album. Can you confirm that the albums giving problems all reside in the same folder?
If this is the case then it is not a bug of acc. The 'use folder structure...' option requires every album to reside in its own directory.

Frank

tamanaco
2008-02-14, 12:36
I fixed the double qoute issue (to be incorporated in next release).

The 'greates album' problem I can't reproduce. I myself also have multiple 'greatest albums' which, when 'use folder structure...' is selected sort fine.
When this option is selected the albums are distinguished based on the full folder path to the album. Can you confirm that the albums giving problems all reside in the same folder?
If this is the case then it is not a bug of acc. The 'use folder structure...' option requires every album to reside in its own directory.

Frank

Hi Frank... thanks for fixing the "quotes" problem. In regards to my folder structure... all my albums are in separated folders. Including my "Various" artists compilations. I think this happened when I sorted either by artist or by album name... It's been some time, so I don't remember exactly.

SilverRS8
2008-02-14, 12:43
Frank, yeah I was going to say I've got lots of live recordings that have '/' in the album title and there's no problem with missing artwork.

Let me know if I can do any debugging for you.

Hi Venus light,

Can you download the debug version I created on http://www.vanholt.nl/acc/downloads/acc-v1-RC3b-Debug.zip ?

and post or PM the line(s) in the acc.log for the troublesome albumcovers and the corresponding line for the album(s) in the generated .html file?

The log line should look something like:
STATUS : 20:32:22 D:/_Music/_Full Albums/30 & Seconds To Mars/A Beautifull Lie/;file:///D:/_Music/_Full%20Albums/30%20&%20Seconds%20To%20Mars/A%20Beautifull%20Lie/01%2030%20seconds%20to%20mars%20-%20attack.mp3;30 seconde & mars;A "Beautiful" Lie;ROCK;2005

This should provide enough information to determine the real problem.

Frank

SilverRS8
2008-02-15, 11:52
My problem with multiple listings of song titles remains after following the suggestions. I get multiple songs with the new version of ACC, but everything is correct if I use older version 1 of ACC.

Do you use multiple tags alot? i.e. multiple genre tags seperated by a ';' (or other character)?

I can confirm this is currently an issue with ACC causing every track to appear multiple times. I'm working on resolving it but this may take a bit longer...

EDIT: Question; When multiple genres are used for an album (or all albums), how would sorting on genre need to work?

SilverRS8
2008-02-17, 02:13
I just posted RC4 on www.vanholt.nl/acc/acc.htm.

Changes for this release:
- FIXED: Double quotes in album name resulted in &quot; in generated catalog.
- ADDED(or fixed if you like): Support for multiple genre tags. In previous ACC versions the use of multiple genre tags resulted in the track appearing multiple times in the album and the incorrect display of all genres in the album title. This has been corrected now.

To support the multiple genre tags is was necessary to perform a seperate query for every album is needed. This will result in a performance degrade when comparing to previous releases. But since a catalogue isn't created every day or so I think performance is less of an issue.

For very large collections, windows may report that ACC is not responding. This however is not true. It is just too busy generating the catalog not updating windows status info frequently enough to prevent this message.

If you have any issues, please reply on this thread...

Frank

Secret Squirrel
2008-02-17, 09:59
Frank,

I just downloaded and ran RC4a. The run time wasn't much longer, but the results were a little disappointing. I still get the same results of multiple listings for some albums. As an example, Alanis Morrisette's "Jagged Little Pill". I get four listings: the first with one track (track one) and album art, the second with just track two & "No Cover Available", the third with tracks 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, & 12 with art, the fourth with just track 13 no art, and the fourth with just track 13 with art.

I checked the tags in MP3Tag. There is only one genre per track. The album name has no special characters.

I'm stumped. RC2a worked the best for me so far.

Sorry for my bad results!

SS

PS I'm willing to attach any files you would like to see.

SilverRS8
2008-02-17, 10:38
Frank,

I just downloaded and ran RC4a. The run time wasn't much longer, but the results were a little disappointing. I still get the same results of multiple listings for some albums. As an example, Alanis Morrisette's "Jagged Little Pill". I get four listings: the first with one track (track one) and album art, the second with just track two & "No Cover Available", the third with tracks 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, & 12 with art, the fourth with just track 13 no art, and the fourth with just track 13 with art.

I checked the tags in MP3Tag. There is only one genre per track. The album name has no special characters.

I'm stumped. RC2a worked the best for me so far.

Sorry for my bad results!

SS

PS I'm willing to attach any files you would like to see.

:-(
I'm very interested in the files of Alanis so I can use it as test set. They are probaly to large to send by mail. Is it possible for me to download them somehow?

Can you also send me the log file of the RC3b debug version (see my request to venus light at top of page)? That would really be helpfull because it includes the path as stored in the DB.

Thx in advance !!

Frank

Rick B.
2008-02-17, 11:26
Do you use multiple tags alot? i.e. multiple genre tags seperated by a ';' (or other character)?

I can confirm this is currently an issue with ACC causing every track to appear multiple times. I'm working on resolving it but this may take a bit longer...

EDIT: Question; When multiple genres are used for an album (or all albums), how would sorting on genre need to work?

Hi, Frank. Yes, I do have fair number of albums with multiple tags. I can't think of how to sort on genres in any way other than alpha. Please note: I only get multiple songs with your newest version - version V1-b5 works correctly. Thanks.

tamanaco
2008-02-17, 17:13
I just posted RC4

Changes for this release:
- FIXED: Double quotes in album name resulted in &quot; in generated catalog.
- ADDED(or fixed if you like): Support for multiple genre tags. In previous ACC versions the use of multiple genre tags resulted in the track appearing multiple times in the album and the incorrect display of all genres in the album title. This has been corrected now....
Frank

Frank, as advertized the double quotes issue is fixed, but there still remain a couple "cosmetic" enhancements that I'd like to see.
1. As I mentioned before, the tracks' least significant digit is left justified. 2. The albums' CD header should go before the Track header. e.g.

CD 1
Tracks
1. Track Name
.
.
.

Instead of

Tracks
CD1
1. Track Name
.
.
.

Btw, I think the issue I had with albums with the same name being merged happened when I selected "Use folder structure to distinguish albums".
If you have any issues, please reply on this thread...

The tool is getting better and better every week.

Thanks again...

SilverRS8
2008-02-18, 02:02
Frank, as advertized the double quotes issue is fixed, but there still remain a couple "cosmetic" enhancements that I'd like to see.
1. As I mentioned before, the tracks' least significant digit is left justified.

Thx again for your feedback! I forgot to mention that I already did some experimenting on this but the font used is proportional which results in a misalignment when all single digit tracknumber are indended by a space. They will align properly with the two digit ones. One space is a little too short and two is a bit too far. So I didn't implement it yet because I though the current version is preferred over a misaligned one.
There is a solution though and that is that the tracklisting should be placed in a table allowing to align by column.
I have to experiment with that but i think it will serious degrade performance of the HTML page in the browser for huge collections because the table structure and nesting tend to have this effect.


2. The albums' CD header should go before the Track header. e.g.

CD 1
Tracks
1. Track Name
.
.
.

Instead of

Tracks
CD1
1. Track Name
.
.
.

Good suggestion. First guess is that this would be fairly easy to implement. I'll take it into account for the next version.


Btw, I think the issue I had with albums with the same name being merged happened when I selected "Use folder structure to distinguish albums".
If you have any issues, please reply on this thread...

The tool is getting better and better every week.

Thanks again...

I'll take a look if I can reproduce it and thanks again for your regular feedback. Hope to make this a one -works-for-all tool.

Frank

tamanaco
2008-02-18, 06:32
Thx again for your feedback! I forgot to mention that I already did some experimenting on this but the font used is proportional which results in a misalignment when all single digit tracknumber are indended by a space. They will align properly with the two digit ones. One space is a little too short and two is a bit too far. So I didn't implement it yet because I though the current version is preferred over a misaligned one.
There is a solution though and that is that the tracklisting should be placed in a table allowing to align by column.
I have to experiment with that but i think it will serious degrade performance of the HTML page in the browser for huge collections because the table structure and nesting tend to have this effect.
Frank

Frank, what about an "option" for inserting a leading "0" Zero for the first nine digits? Would this be easier to implement? I doubth that many folks have albums with more than 99 tracks.

Phil Leigh
2008-02-18, 06:58
Frank, what about an "option" for inserting a leading "0" Zero for the first nine digits? Would this be easier to implement? I doubth that many folks have albums with more than 99 tracks.

Just make the insert conditional on the string initial length (ie only pad with zero if len=1)

MuckleEck
2008-02-18, 08:13
Frank, what about an "option" for inserting a leading "0" Zero for the first nine digits? Would this be easier to implement? I doubth that many folks have albums with more than 99 tracks.

UNfortunately I have a number of 100+ track compilations...however I have already numbered them with the leading zeroes.....

tamanaco
2008-02-18, 10:44
UNfortunately I have a number of 100+ track compilations...however I have already numbered them with the leading zeroes.....

As per my post, adding a leading "0" should be "Optional" because "most" folks rip each of their CDs to corresponding "CD-specific" folders. Also, "most" CDs in the commercial market do not exceed 99 tracks per CD.

tamanaco
2008-02-19, 16:33
Frank, all the tracks in my Various Artists albums list the mame of the artist before the track. e.g. Track#. - ArtistName - TrackName (Time). Can this order be reversed?

Thanks...

SilverRS8
2008-02-21, 12:33
Frank, all the tracks in my Various Artists albums list the mame of the artist before the track. e.g. Track#. - ArtistName - TrackName (Time). Can this order be reversed?

Thanks...

Sure. No problem. But, same as the 0 prefix for track numbers, this is a user specific preference. I'll implement both as an option...

Frank

matthijskoopmans
2008-02-21, 17:49
Frank: this script is great! It takes a while, but you only need to update it when you have a new album :)


One tip for the Vista users: if you are like me and want everything that runs/executes in the Program Files or Program Files (x86) directory: don't... the script creates a folder, and it does not have permission to do so in Vista (unless you turn off that validation, which I would not recommend). I have moved it to my music directory.... but you can have it under any directory that is allocated to your user.

Frank: if you are going to rewrite this to use Documents and Settings, or ProgramData directories, or a selectable directory for output, than it would be really perfect. The work around described above works well too... :)

Cheers

Matt

hifi-fan
2008-02-22, 06:22
I have been trying to get this wonderful utility to work, but I just can't seem to get the album art to show up. I am running squeezecenter on Xp sp2. The music resides in a NAS. I searched this thread for the various work arounds, and edited the program as suggested. I must be doing something wrong. It will help me a lot if someone would post step by step instructions on how you got the program to work for you. Please help.

Chasman666
2008-02-22, 07:20
Hey Frank,
Fab work on this, been a while since I first read through this thread and can't remember if a decision has been made on ignoring 'The' (and other spurious first words) for artist names like SqueezeCentre does.

Cheers,
Charlie

schatzy
2008-02-22, 07:49
I have been trying to get this wonderful utility to work, but I just can't seem to get the album art to show up. I am running squeezecenter on Xp sp2. The music resides in a NAS. I searched this thread for the various work arounds, and edited the program as suggested. I must be doing something wrong. It will help me a lot if someone would post step by step instructions on how you got the program to work for you. Please help.

Do you have a mapped drive letter for your NAS?

Also the cover art files should be named cover.jpg or folder.jpg for a standard install.

If you have all your cover art named say xxxxx.jpg then you can open the file AlbumCatalogCreator-V1.hta with note pad or some other text editor and add your cover art name to the list. It should be on line #78. There you will find a line looking like this

sCoverFilename = "cover.jpg,folder.jpg"

Just add your cover art name in the list like so

sCoverFilename = "cover.jpg,folder.jpg,xxxxx.jpg"


Schatzy

SilverRS8
2008-02-22, 08:04
Frank: this script is great! It takes a while, but you only need to update it when you have a new album :)


One tip for the Vista users: if you are like me and want everything that runs/executes in the Program Files or Program Files (x86) directory: don't... the script creates a folder, and it does not have permission to do so in Vista (unless you turn off that validation, which I would not recommend). I have moved it to my music directory.... but you can have it under any directory that is allocated to your user.

Frank: if you are going to rewrite this to use Documents and Settings, or ProgramData directories, or a selectable directory for output, than it would be really perfect. The work around described above works well too... :)

Cheers

Matt

Thx Matt for your positive feedback !! And good suggestion regarding a seperate directory for output files.

I hope to have some time in the weekend to do some coding. The idea is to create a small 'Preference' section in the GUI with the following options:
1. Choose an output folder (and store it as preferred folder)
2. Use 0 prefix for tracknumbers < 10
3. Use 'Track - Artist' instead of 'Artist - Track' for Various Artist albums
4. Ignore 'The' prefix when sorting
5. Beta NAS support

Maybe all options is a bit too much for this weekend but its on my ToDo list...

Frank

Secret Squirrel
2008-02-22, 08:38
Frank,

Did you get my PM about "Jagged Little Pill"?

SS

SilverRS8
2008-02-22, 08:50
Frank,

Did you get my PM about "Jagged Little Pill"?

SS

Hi SS,

Yes (and sorry for the delay. I needed to research something before replying but forgot to do this).

Although you send me some log data what i really need is the log information as logged from the RC3b-debug release. Although not up to date since RC4 is already out, i'm only interested in the log data.

Can you download the debug version I created on http://www.vanholt.nl/acc/downloads/...RC3b-Debug.zip ?

and post or PM the line(s) in the acc.log for the troublesome albumcovers and the corresponding line for the album(s) in the generated .html file?

The log line should look something like:
STATUS : 20:32:22 D:/_Music/_Full Albums/30 & Seconds To Mars/A Beautifull Lie/;file:///D:/_Music/_Full%20Albums/30%20&%20Seconds%20To%20Mars/A%20Beautifull%20Lie/01%2030%20seconds%20to%20mars%20-%20attack.mp3;30 seconde & mars;A "Beautiful" Lie;ROCK;2005

These lines are logged for every album AFTER the genre determination logging.

Depending on the results I may ask you to send some of the files causing the trouble...

Frank

Secret Squirrel
2008-02-22, 09:28
Frank,

I am attaching files for you review. Let me know what else I can supply for you.

As always, thanks for your work on this!

SS


Hi SS,

Yes (and sorry for the delay. I needed to research something before replying but forgot to do this).

Although you send me some log data what i really need is the log information as logged from the RC3b-debug release. Although not up to date since RC4 is already out, i'm only interested in the log data.

Can you download the debug version I created on http://www.vanholt.nl/acc/downloads/...RC3b-Debug.zip ?

and post or PM the line(s) in the acc.log for the troublesome albumcovers and the corresponding line for the album(s) in the generated .html file?

The log line should look something like:
STATUS : 20:32:22 D:/_Music/_Full Albums/30 & Seconds To Mars/A Beautifull Lie/;file:///D:/_Music/_Full%20Albums/30%20&%20Seconds%20To%20Mars/A%20Beautifull%20Lie/01%2030%20seconds%20to%20mars%20-%20attack.mp3;30 seconde & mars;A "Beautiful" Lie;ROCK;2005

These lines are logged for every album AFTER the genre determination logging.

Depending on the results I may ask you to send some of the files causing the trouble...

Frank

SilverRS8
2008-02-22, 11:00
Frank,

I am attaching files for you review. Let me know what else I can supply for you.

As always, thanks for your work on this!

SS

As see a couple of things. From the ACC log it appears that track 1 from Jagged little pill is located in the folder:
G:/Music - Large/Alanis Morissette - Jagged Little Pill/

Track 2 though is located in folder:
C:/Documents and Settings/All Users/Documents/My Music/Alanis Morissette - Jagged Little Pill/

Track 3 in the folder on the G drive, track 4 again in C:\Documents and settings.

Documents and setting is your Windows profile folder. Do you have indeed music files in the c:\..... folder?
What folder is configured in SC as your music folder? It appears to me, judging from the fact that multiple drives are stored in the database, that there are shortcuts defined pointing to other drives from the folder configured in SC. Can you confirm this?

So I think the album is actually spread over two drives instead of residing in a (single) folder. This is kind of a strange yet uncounted for situation by ACC.

The HTML files seems ok. Using the 'G:/Music - Large/Alanis Morissette - Jagged Little Pill/folder.jpg' file for album art. Does this display correctly?

Frank

EDIT: Track 2 and 4, the ones stored on the C drive are .mp3 files whereas the others on the G drive are .flac files. This actually means you have the albums stored twice I guess? One time in mp3 and in FLAC?
The Bug I see is that ACC should display the album twice instead of single track albums. Is it maybe an idea to select only the G drive as starting folder so every album is only listed once?

Secret Squirrel
2008-02-22, 12:55
You're correct, I have two complete libraries. I guess I'm being lazy doing that as I could use something like Media monkey for my MP3 players, but the MP3 files should not be in the Slim database. I'll have to check and see if a couple may have gotten in the playlists. Is your script looking at the playlists? I haven't reviewed your code, but will investigate my playlist regardless.

It sounds like it's just "noise" in my database that I need to correct. For now I'll use version 2 and it doesn't "see" that noise.

Thanks for looking into this for me!

Always a fan,

SS


As see a couple of things. From the ACC log it appears that track 1 from Jagged little pill is located in the folder:
G:/Music - Large/Alanis Morissette - Jagged Little Pill/

Track 2 though is located in folder:
C:/Documents and Settings/All Users/Documents/My Music/Alanis Morissette - Jagged Little Pill/

Track 3 in the folder on the G drive, track 4 again in C:\Documents and settings.

Documents and setting is your Windows profile folder. Do you have indeed music files in the c:\..... folder?
What folder is configured in SC as your music folder? It appears to me, judging from the fact that multiple drives are stored in the database, that there are shortcuts defined pointing to other drives from the folder configured in SC. Can you confirm this?

So I think the album is actually spread over two drives instead of residing in a (single) folder. This is kind of a strange yet uncounted for situation by ACC.

The HTML files seems ok. Using the 'G:/Music - Large/Alanis Morissette - Jagged Little Pill/folder.jpg' file for album art. Does this display correctly?

Frank

EDIT: Track 2 and 4, the ones stored on the C drive are .mp3 files whereas the others on the G drive are .flac files. This actually means you have the albums stored twice I guess? One time in mp3 and in FLAC?
The Bug I see is that ACC should display the album twice instead of single track albums. Is it maybe an idea to select only the G drive as starting folder so every album is only listed once?

Secret Squirrel
2008-02-22, 14:05
Frank,

That was it. I removed a couple of entries in the Zapped Play List for "Jagged Little Pill", rescanned, and ran RC4. The output looks perfect! Thanks a million! I love your product! It makes me think that I should learn Perl and translate your script, but there are a few too many things on the "Honey do" list at the moment ;)

Cheers,

SS

SilverRS8
2008-02-23, 12:44
Frank,

That was it. I removed a couple of entries in the Zapped Play List for "Jagged Little Pill", rescanned, and ran RC4. The output looks perfect! Thanks a million! I love your product! It makes me think that I should learn Perl and translate your script, but there are a few too many things on the "Honey do" list at the moment ;)

Cheers,

SS

Always good to hear positive feedback. Thx !! Glad it works...

Frank

SilverRS8
2008-02-23, 12:47
I just posted version RC5 with the following changes:
ADDED OPTION Screen
ADDED Option: Use 0 prefix for track numbers <10
ADDED Option: Use 'Track - Artist' instead of 'Artist - Track' for Various Artist albums
ADDED Option: Ignore preceding 'The' in artist names when sorting
ADDED Option: Alternative coverart filename
ADDED Option: Alternative catalog output folder
CHANGED Configuration file not created anymore. Settings are now stored in the registry (HKCU\Software\ACC)

I attached some screenshots. Let me know if it works for you or if the new features introduce new issues...

Frank

tamanaco
2008-02-23, 13:28
I just posted version RC5 with the following changes:
ADDED OPTION Screen
ADDED Option: Use 0 prefix for track numbers <10
ADDED Option: Use 'Track - Artist' instead of 'Artist - Track' for Various Artist albums
ADDED Option: Ignore preceding 'The' in artist names when sorting
ADDED Option: Alternative coverart filename
ADDED Option: Alternative catalog output folder
CHANGED Configuration file not created anymore. Settings are now stored in the registry (HKCU\Software\ACC)

I attached some screenshots. Let me know if it works for you or if the new features introduce new issues...

Frank

NICE Update!!!...

I think you missed the CD# before Tracks request.

What's next?

venus light
2008-02-23, 15:44
I just posted version RC5 with the following changes:
ADDED OPTION Screen
ADDED Option: Use 0 prefix for track numbers <10
ADDED Option: Use 'Track - Artist' instead of 'Artist - Track' for Various Artist albums
ADDED Option: Ignore preceding 'The' in artist names when sorting
ADDED Option: Alternative coverart filename
ADDED Option: Alternative catalog output folder
CHANGED Configuration file not created anymore. Settings are now stored in the registry (HKCU\Software\ACC)

I attached some screenshots. Let me know if it works for you or if the new features introduce new issues...

Frank


Frank,

Good stuff - I like the new options.

One thing, and I don't know if you intended this or not, but it did not create a .mht file for importing into Word if you can't get the page breaks to work correctly...

SilverRS8
2008-02-23, 18:03
Frank,

Good stuff - I like the new options.

One thing, and I don't know if you intended this or not, but it did not create a .mht file for importing into Word if you can't get the page breaks to work correctly...

Nope. You're right. It should have done this. Going to fix it... Thx for the report.
EDIT: Quickly fixed it. Download RC5 again for the fix...

Frank

SilverRS8
2008-02-23, 19:54
NICE Update!!!...

I think you missed the CD# before Tracks request.

What's next?

You're right. Indeed I forgot it. Just took a look if I can easy apply the change but it is not an as easy fix than it sounds like. On my todo list for RC6...

Frank

killie99
2008-02-24, 06:27
I don't appear to be having much success :(
Error message is "an error occured while connectin to the database. Error number : 3716. Safety settings on this computer prohibit accessing a data source on another domain" I'm using Mcafee but haven't a clue as to where or what settings I need to change. Anyone came across this before?

killie99
2008-02-24, 12:26
not sure what I did but I've got it working now.

SilverRS8
2008-02-27, 01:20
Just for me to get some idea if ACC is doing a good job i added a poll to this thread. I would also like to ask for any issues to be posted on this thread so I can try to resolve them.

Thanks all who use ACC and for the time to feedback on it.

Frank

MBSqueeze
2008-02-29, 20:16
Frank,

Thanks so much for a great product!!!

-Mark

MillmoorRon
2008-03-01, 03:29
RC3 worked OK for me but with RC5 I get the following on Start:

Error while performing general query (fnPreProcessing).
-2147217887 -- ODBC driver does not support the requested properties.

Any suggestions?

SilverRS8
2008-03-01, 05:01
@MBSqueeze; Thx. Much appreciated !!



RC3 worked OK for me but with RC5 I get the following on Start:

Error while performing general query (fnPreProcessing).
-2147217887 -- ODBC driver does not support the requested properties.

Any suggestions?

Which version of the MySQL ODBC driver do you have installed? ACC is tested on version 3.51. Can you maybe download and install the MySQL ODBC driver again to see if it solves the issue?

Link to download page:
http://dev.mysql.com/downloads/connector/odbc/3.51.html

Let me know the results. If this will not solve the problem I can create some additional logging which may be of any help to me to figure out what the problem is but I seriously suspect the ODBC driver.

Frank

Zaragon
2008-03-01, 06:18
I don't appear to be having much success :(
Error message is "an error occured while connectin to the database. Error number : 3716. Safety settings on this computer prohibit accessing a data source on another domain" I'm using Mcafee but haven't a clue as to where or what settings I need to change. Anyone came across this before?

I came across this error message or one very similar just last night in a completely different context. I don't know if it has any bearing on this but thought I'd mention it. I had just downloaded a few files from work. My PC is an XP SP2. Eventually I right clicked on the files and selected properties thinking it might have become read-only and discovered that there was an additional security item at the bottom of the properties pop-up basically asking if I trusted the file. Clicked that and applied and I could access the files without a problem then. I've never seen those items appear before and I don't get them on downloads from elsewhere.

killie99
2008-03-02, 02:30
I've got a problem when dealing with compilation albums. If I scan just the "various artists" folder with squeezecenter and then run the album catalog creator it works fine. Albums show as "various Artists" as the top line and then the album name below this.
If I scan my music folder so that "various artists" is a subfolder then the album isn't shown as "various artists" but as one of the artists on the album. I've attached the screenshots to show what's happening. Anyone help?

SilverRS8
2008-03-02, 03:34
Thats strange behavior indeed. Can you provide a screenshot from a tagging program display all tags from the album you used in your post?

This would really help trying to figure out where things went wrong.

Frank

MillmoorRon
2008-03-02, 09:12
@MBSqueeze; Thx. Much appreciated !!




Which version of the MySQL ODBC driver do you have installed? ACC is tested on version 3.51. Can you maybe download and install the MySQL ODBC driver again to see if it solves the issue?

Link to download page:
http://dev.mysql.com/downloads/connector/odbc/3.51.html

Let me know the results. If this will not solve the problem I can create some additional logging which may be of any help to me to figure out what the problem is but I seriously suspect the ODBC driver.

Frank

I have 3.51 installed. Reinstalling didn't make any difference.

After the first error message I get a couple more as per the attachments.

killie99
2008-03-02, 11:46
Here are the tags ...

killie99
2008-03-02, 14:11
I'm begining to think this is a squeezecenter problem. If I do a scan of my music directory, sometimes some of the compilation albums show as not being by "various artists" but show as by one of the artists on the album. When this happens the album catalog creator shows the compilation albums as by 1 of the artists on the album rather than various.

SilverRS8
2008-03-03, 07:52
I'm begining to think this is a squeezecenter problem. If I do a scan of my music directory, sometimes some of the compilation albums show as not being by "various artists" but show as by one of the artists on the album. When this happens the album catalog creator shows the compilation albums as by 1 of the artists on the album rather than various.

It would explain the strange behaviour of ACC. ACC really only queries the database. The query returns regular albums by artist as well as Various artists. The various artists are albums which are classified as various artist by SC. This however is often not true. A regular album with one or more featuring artists on it is classified by SC as Various Artist album.
ACC therefor determines for all Various artist albums the actual Artist. It does so by checking the artist performing most of the album songs. If this is true for more than half of the tracks it changes the Various artist to the orginal artist (in a temporary DB table). It works really well presenting 'true' results.
After all this is done it uses the temporary table to generate the actual catalog.

So having said this I can only say that the problem must be somewhere in the database i would say....

Frank

SilverRS8
2008-03-06, 06:06
I am currently working on NAS/remote server support. Support for a remote windows server is already working. For Windows servers, the file paths in the DB are stored using the drive letter the files are on.
For ACC to access the album art files on the remote Windows drive it needs to have the proper credentials. So for windows I implemented that a temporary drive mapping is made to the $ share of the drive where the path in the DB is pointing to. I did this because these shares are always available. They do require a local admin username password.

For a NAS device however the DB path is stored like //<servername>/<folder>/...
I myself haven't any expierence with mapping to a NAS device. What I would like to implement is a solution that does not require any input (besides username password) from the user. Therefor i prefer not to let the user map a drive first and use that to connect. It woudl require external pre-requirements to be met and that is not preferred.
Question; Is there a always, on every NAS device, available share which I can use to create a temporary mapping just for the use that authentication has been made against the NAS device? A bit like c$ is an always, default created, share for windows. Don't know if there is any such thing for NAS devices....?

If this is not the case i'm afraid I have to use a drive mapping and do some replacing (i.e. //server/folder/mymusic is mapped to drive X: using sharename \\server\music). For ACC to find the album art files ACC would have to replace the internal DB path references (//server/folder/mymusic/artist/album/cover.jpg) to (X:\artist\album\cover.jpg).

I just can't figure out how to implement that.
For this I need a drive letter, the mapped share name and the fysical directory path. Point is there doesn't have to be any relation between the share name and the directory path. So my problem would be, what do I need to replace with what in such a case? Any ideas on this one? <- Again not the preferred solution though.

Frank

tamanaco
2008-03-06, 07:27
I am currently working on NAS/remote server support. Support for a remote windows server is already working. For Windows servers, the file paths in the DB are stored using the drive letter the files are on.
For ACC to access the album art files on the remote Windows drive it needs to have the proper credentials. So for windows I implemented that a temporary drive mapping is made to the $ share of the drive where the path in the DB is pointing to. I did this because these shares are always available. They do require a local admin username password.

For a NAS device however the DB path is stored like //<servername>/<folder>/...
I myself haven't any expierence with mapping to a NAS device. What I would like to implement is a solution that does not require any input (besides username password) from the user. Therefor i prefer not to let the user map a drive first and use that to connect. It woudl require external pre-requirements to be met and that is not preferred.
Question; Is there a always, on every NAS device, available share which I can use to create a temporary mapping just for the use that authentication has been made against the NAS device? A bit like c$ is an always, default created, share for windows. Don't know if there is any such thing for NAS devices....?

If this is not the case i'm afraid I have to use a drive mapping and do some replacing (i.e. //server/folder/mymusic is mapped to drive X: using sharename \\server\music). For ACC to find the album art files ACC would have to replace the internal DB path references (//server/folder/mymusic/artist/album/cover.jpg) to (X:\artist\album\cover.jpg).

I just can't figure out how to implement that.
For this I need a drive letter, the mapped share name and the fysical directory path. Point is there doesn't have to be any relation between the share name and the directory path. So my problem would be, what do I need to replace with what in such a case? Any ideas on this one? <- Again not the preferred solution though.

Frank

Frank, I might be wrong, but given that "most" folks won't be using this tool that frequently you can leave this aspect as a "user configurable option". Once a user has already mapped their NAS to the SC Server the path and access rights (id/password) to this NAS resource should be obvious to them. I use ACC from the server so I just follow the SC mapping. I know that there are folks that want to access the db from a machine other than the server, but how often do they want to do this? I know, I know... there are probably folks out there that are printing their Album Catalog on an hourly basis from computers other than their SC server. Heck I print the catalog from a remote PC, but I use Remote Desktop to connect to my SC Server where ACC is installed.

This is just a thouhgt... so that you don't have to spent much time implementing a mapping that could change from user to user and from NAS to NAS. In the end, for me at least, the configurable options for the layout of the Catalog is what's most important.

EDIT: My bad... I was also assuming that most folks are not running SC on a NAS and need to access the db remotely.

SilverRS8
2008-03-06, 08:27
Frank, I might be wrong, but given that "most" folks won't be using this tool that frequently you can leave this aspect as a "user configurable option". Once a user has already mapped their NAS to the SC Server the path and access rights (id/password) to this NAS resource should be obvious to them. I use ACC from the server so I just follow the SC mapping. I know that there are folks that want to access the db from a machine other than the server, but how often do they want to do this? I know, I know... there are probably folks out there that are printing their Album Catalog on an hourly basis from computers other than their SC server. Heck I print the catalog from a remote PC, but I use Remote Desktop to connect to my SC Server where ACC is installed.

This is just a thouhgt... so that you don't have to spent much time implementing a mapping that could change from user to user and from NAS to NAS. In the end, for me at least, the configurable options for the layout of the Catalog is what's most important.

EDIT: My bad... I was also assuming that most folks are not running SC on a NAS and need to access the db remotely.

You do have a point but users who have a NAS running Linux don't have the ability to run ACC from the server. It would be nice to implement the ability to run it from a windows machine but use the NAS and remote SC DB to create the catalog.

Besides the 'CDx' indication for multiple disc can you indicate if you have other issues I should be aware of to fix in the next version?

P.S. I made it an option to generate the .MHT file or not. Speeds up things a lot when not created.

EDIT: Sorry, didn't see your last edit ;-)
Frank

killie99
2008-03-07, 05:57
If I view the output in MSword it works fine on the machine that slimserver is on but opening it on another machine results in the majority of the album art not to be displayed. Is this to be expected due to the album art not being embedded and is linked? Is there a way to embed the album art in a word document?

Thought it was strange though that some of the art is displayed (at a guess i'd say about 5%)

SilverRS8
2008-03-07, 06:08
If I view the output in MSword it works fine on the machine that slimserver is on but opening it on another machine results in the majority of the album art not to be displayed. Is this to be expected due to the album art not being embedded and is linked? Is there a way to embed the album art in a word document?

Thought it was strange though that some of the art is displayed (at a guess i'd say about 5%)

If you open the .html file in word then I guess most of the album art will not display correctly when opened from a different computer than from which ACC was executed from. This is because of all the links to the actual albumart files. The path to the album art should be exactly the same on both computers for it to display ok on both computers.

There are two things you can do about it;
1. Print the catalog to a PDF file using a (free) PDF printer.
2. Open the generated .MHT file in Word and save it as word file. The .MHT is a IE archive file. It will be much larger than a PDF file but it does its job.

Please note that Office 2007 (and i think 2003 also) use there own HTML renderer (not IE) and does not support i.e. the gradient background behind the artist/album names. In Word this will be solid gray.

Hope this is an answer to your question?

killie99
2008-03-07, 06:15
Ok thanks, I'll try that later. I was using a computer at work to view (and print) the output file as I din't fancy trying to print several hundred pages on my little epson printer at home ....but don't tell my boss!

SilverRS8
2008-03-07, 06:18
Ok thanks, I'll try that later. I was using a computer at work to view (and print) the output file as I din't fancy trying to print several hundred pages on my little epson printer at home ....but don't tell my boss!

My lips are sealed ;-) There is also a quickref output generated (no album art and tracklisting thought but a lot less paper).

Please let me know if there are any issues with the generated output.

MillmoorRon
2008-03-07, 10:50
Any ideas as to the cause of my problem? (post #332)

RC3 worked fine and I can't think what's changed since I used it!

SilverRS8
2008-03-07, 12:16
I have 3.51 installed. Reinstalling didn't make any difference.

After the first error message I get a couple more as per the attachments.

Sorry I didn't react on that one. The error reports that the ACC table can't be found. I compared the code of RC3 with RC5 and regarding the creation of the ACC table there isn't a real big change.
The only change is that in RC3 the genre was included in the query creating the ACC table whereas in RC5 is is left out after which a new query adds the Genre column (your first error). Then ACC queries every album to determine the genre and updates the genre column (your second error). This change was needed to support multiple genres for a track.

Can you PM me the logfile. Maybe it can be of any help otherwise I need to make some changes to create additional logging information....

Frank

amey01
2008-03-07, 16:42
Has anyone suggested auto download of missing cover art?

Otherwise, FANTASTIC!

elite1967
2008-03-17, 03:50
Hi,

I have SC7 running on FreeNAS (based on freeBSD) on IP address 192.168.1.99. Is there a way to run the ACC script from my windows machine (ip: 192.168.1.84) to query the SC7 database?

(I am not running the ACC script from the slimserver machine)

Thanks
Stefano

schatzy
2008-03-17, 04:53
Hi,

I have SC7 running on FreeNAS (based on freeBSD) on IP address 192.168.1.99. Is there a way to run the ACC script from my windows machine (ip: 192.168.1.84) to query the SC7 database?

(I am not running the ACC script from the slimserver machine)

Thanks
Stefano

This is currently being implemented but still has some testing to be done. I have been assisting SilverRS8 with the testing and should have some instructions with in the week on how best to implement this on NAS devices.

Schatzy

elite1967
2008-03-17, 05:26
This is currently being implemented but still has some testing to be done. I have been assisting SilverRS8 with the testing and should have some instructions with in the week on how best to implement this on NAS devices.

Schatzy

Thanks a lot.

I can't wait to use it on my library.

It looks wonderful!

RalphO
2008-03-17, 18:01
I tried a while back to get ACC to work for me but have never been successful. I am encouraged by how many of you have been successful with this obviously useful application. So I would like to try once again to get it to work.

My details are as follows:

Windows XP Media Edition
Music library is on a NAS Squeezecenter is on my C drive.
Currently trying ACC R5

ODBC settings are:
Datasource name "Squeezecenter"
Server "Localhost"
User "Squeezecenter
Port "9092.
This part ap[pears to be working as I get a successful connection.

When I try to run ACC I get error number 3716 and a message saying
"safety settings on this computer prohibit accessing a datasource on another domain"

Can anyone give me an idea what next to try?

SilverRS8
2008-03-17, 22:51
I tried a while back to get ACC to work for me but have never been successful. I am encouraged by how many of you have been successful with this obviously useful application. So I would like to try once again to get it to work.

My details are as follows:

Windows XP Media Edition
Music library is on a NAS Squeezecenter is on my C drive.
Currently trying ACC R5

ODBC settings are:
Datasource name "Squeezecenter"
Server "Localhost"
User "Squeezecenter
Port "9092.
This part ap[pears to be working as I get a successful connection.

When I try to run ACC I get error number 3716 and a message saying
"safety settings on this computer prohibit accessing a datasource on another domain"

Can anyone give me an idea what next to try?

Can you try out the following setting:
In Internet explorer -> Options -> Security Tab -> Local internet/trusted sites (do both) -> custom level -> Miscellaneous -> Enable : 'Access data sources across domains'

When searching the internet there is very little known about this error.

Frank

ElFishi
2008-03-18, 15:43
Just stumbled across this wonderful tool and tried it.
Apologies if I mention something already covered, but I just didn't get myself to work through 35 pages.

Page breaks are an issue, especially when including the tracks.
My current solution works in MS Word:
- Disable line breaks in the Rows tab of the table properties to keep albums on one page
- Use the replace command to replace all boldface font formats with boldface plus "keep with next" paragraph formats to keep headers with the albums

I don't know if these Word features are accessible from mhtml, but it sure was nice to have them included in the output already.

I like to have the table listed by Genre, but I don't need to have it mentioned (I only use three). But despite the fact I chose not to have the Genre displayed, I still get it. So I eliminate all instances of Genre, again by the replace command.

Finally, I know that it is the tracks that are listed - I delete the line that says "Tracks:"

Cheers

SilverRS8
2008-03-18, 22:21
Just stumbled across this wonderful tool and tried it.
Apologies if I mention something already covered, but I just didn't get myself to work through 35 pages.

Page breaks are an issue, especially when including the tracks.
My current solution works in MS Word:
- Disable line breaks in the Rows tab of the table properties to keep albums on one page
- Use the replace command to replace all boldface font formats with boldface plus "keep with next" paragraph formats to keep headers with the albums

I don't know if these Word features are accessible from mhtml, but it sure was nice to have them included in the output already.

I like to have the table listed by Genre, but I don't need to have it mentioned (I only use three). But despite the fact I chose not to have the Genre displayed, I still get it. So I eliminate all instances of Genre, again by the replace command.

Finally, I know that it is the tracks that are listed - I delete the line that says "Tracks:"

Cheers

Page breaks by default require that the page margins are narrowed. In the help screen there are some tips on printing. Point is, print margins etc can't be set from ACC. Also in the advanced browser setting the printing of background should be enabled to print the silver gradient behind the Artist and Album titles.

I'll fix the display genre issue. When selected not to display, it should well, not display it.

Frank

elite1967
2008-03-19, 11:59
I have managed to test the script using a local and temporary SC7 configuration.

The output is great.

I thought useful to report a couple of bugs that I have encountered:

1. When a single album has multiple artists (like in classical music or in jazz) the tracks are duplicated (or triplicated)

2. When an album has multiple genres, the scrips generates one album (with the relevant cover) for every track of the album.

GREAT WORK!
Stefano

SilverRS8
2008-03-19, 12:34
I have managed to test the script using a local and temporary SC7 configuration.

The output is great.

I thought useful to report a couple of bugs that I have encountered:

1. When a single album has multiple artists (like in classical music or in jazz) the tracks are duplicated (or triplicated)

2. When an album has multiple genres, the scrips generates one album (with the relevant cover) for every track of the album.

GREAT WORK!
Stefano

Often those problems are inconsistent tag related. Can you maybe post a screenshot from a tagging application of the tracks of the albums you used giving the problems?

Frank

elite1967
2008-03-20, 02:07
Often those problems are inconsistent tag related. Can you maybe post a screenshot from a tagging application of the tracks of the albums you used giving the problems?

Frank

Hi,
here is the result:

1. Multiple artists (image 1): when an album (and all its tracks) has multiple artists, ACC generates tracks replicated for each artist. You can have multiple artist in a album dividing the artist by a ";" in the artists field.
(To activate the multiple artist, you have to go into:
SC7 / Settings / Music Library
and write ";" in the "Separator for Multiple Items" field.)

[SqueezeCenter can extract multiple artist, album titles and genres from the tags inside your music files. If SqueezeCenter finds any of the words or characters below in your tags, it will create individual listings for each item. For example, if you put a semicolon in the list below, a song with an artist tag of "J. S. Bach;Michael Tilson Thomas" will appear in the artists area for both "J. S. Bach" and "Michael Tilson Thomas". Changing this setting will start a rescan of your music library.]

2. Album with the same name (image 2): if two album have the same name (for example: "Symphonie Fantastique"), ACC creates one cover for each track of the album and for every occurence of the same album name. For example if there are two albums with the same name with 5 tracks each, ACC will create 10 covers with one track each.

3. Multiple genres (image 3): when an album has multiple genres (divided by a ";") ACC generates two album covers for each track.
In my opinion this happens because ACC reads 2 albums with the same name from the library - same situation of point 2 above.

4. sorting by Genre (image 4): I found that if the Artist is "Various Artists" (written by myself not by SC7) the albums are not sorted correctly by genre but are put at the end of the list in alphabetical order.

Pictures:
1. In this case the tag Artist is: "Rosemary Clooney; John Pizzarelli; Diana Krall" which actually means 3 artist for this album. In SC7 the 3 artists appear separated.

2. In this case, I have 2 album names that are the same "Symphonie Fantastique". Of course this could easily happen for classical music.

3. In this case, the Genre tag is "Louge; Bossa Nova". The album appears in SC7 under 2 different genres

4. This picture shows that the album with the tag artist = "Various Artists" are at the end of the list and are not sorted by genre as they should.

Rick B.
2008-03-20, 04:33
I also have the same problem as noted in post #279. Problem does not happen in older versions.

elite1967
2008-03-20, 05:07
Hi,
please find attached the screenshots of MP3TAG for the situations above.

Thanks

SilverRS8
2008-03-20, 11:37
Hi,
here is the result:

1. Multiple artists (image 1): when an album (and all its tracks) has multiple artists, ACC generates tracks replicated for each artist. You can have multiple artist in a album dividing the artist by a ";" in the artists field.
(To activate the multiple artist, you have to go into:
SC7 / Settings / Music Library
and write ";" in the "Separator for Multiple Items" field.)

[SqueezeCenter can extract multiple artist, album titles and genres from the tags inside your music files. If SqueezeCenter finds any of the words or characters below in your tags, it will create individual listings for each item. For example, if you put a semicolon in the list below, a song with an artist tag of "J. S. Bach;Michael Tilson Thomas" will appear in the artists area for both "J. S. Bach" and "Michael Tilson Thomas". Changing this setting will start a rescan of your music library.]

Thx for posting the pictures. Really helps a lot trouble shooting. ACC supports this feature for multiple genres but doesn't support this for multiple artists (yet). No one has reported this problem yet so I don't think many people use tagging this way? I'll put it on my to do list to implement in a next version. In the mean I'm afraid disabling the multiple tag feature is the only solution to this problem.


2. Album with the same name (image 2): if two album have the same name (for example: "Symphonie Fantastique"), ACC creates one cover for each track of the album and for every occurence of the same album name. For example if there are two albums with the same name with 5 tracks each, ACC will create 10 covers with one track each.

I'll get back on this one because I need to review the code but I think this is related to the sorting option selected. Did you sort it by Genre?


3. Multiple genres (image 3): when an album has multiple genres (divided by a ";") ACC generates two album covers for each track.
In my opinion this happens because ACC reads 2 albums with the same name from the library - same situation of point 2 above.

I think your right in that it is related to problem 2 because multiple genres are supported by ACC. I tested it myself with multiple i.e. 'The greatest hits' albums. Have to figure out why it does not work in your case.


4. sorting by Genre (image 4): I found that if the Artist is "Various Artists" (written by myself not by SC7) the albums are not sorted correctly by genre but are put at the end of the list in alphabetical order.

This is by design I'm afraid. First all non VA albums are processed then the VA albums. The sorting method is applied to both runs.

SilverRS8
2008-03-20, 11:41
I also have the same problem as noted in post #279. Problem does not happen in older versions.

Elite addressed a problem that did not yet occured.... I though. Maybe you were the first. Do the albums with these problems contains multiple artists by using a ';' as seperator char in the Artist tags?

SilverRS8
2008-03-20, 11:54
Some tips;
- IE does not by default print the gradient background behind the album headers. You can enable this in the advanced IE options. Look much nicer...
- The IE header and footer can be modified as they look really ugly on a catalog page. In the ACC help screen there are some tips on how to do this.

Frank

elite1967
2008-03-20, 14:02
Frank,
thanks for your reply.


Thx for posting the pictures. Really helps a lot trouble shooting. ACC supports this feature for multiple genres but doesn't support this for multiple artists (yet). No one has reported this problem yet so I don't think many people use tagging this way?

Normally the multiple artists is used for Classical Music, as you can insert the composer, the orchestra and the performer.

Also consider that inside the same album you could have different artists: for example, in the same CD you could have the 5th Symphony of Beethoven and the one ouverture of Rossini; in this case, the first tracks will have the artist "Beethoven, Ludwig; Karajan, Herbert" while the last track will be "Rossini, Gioacchino; Karajan, Herbert".

I hope that ACC will support this feature as well, as for classical music is essential!



I'll get back on this one because I need to review the code but I think this is related to the sorting option selected. Did you sort it by Genre?

Yes, I sorted by Genre.



I think your right in that it is related to problem 2 because multiple genres are supported by ACC. I tested it myself with multiple i.e. 'The greatest hits' albums. Have to figure out why it does not work in your case.

ok


This is by design I'm afraid. First all non VA albums are processed then the VA albums. The sorting method is applied to both runs.

All right, but then maybe the VA albums should be sorted by the same field as the non-VA albums: in my file I have selected to sort by "Genre" but the VA are sorted by "Album".


Excellent work. Keep going.

Stefano

RalphO
2008-03-20, 16:40
Can you try out the following setting:
In Internet explorer -> Options -> Security Tab -> Local internet/trusted sites (do both) -> custom level -> Miscellaneous -> Enable : 'Access data sources across domains'

When searching the internet there is very little known about this error.

Frank

Thanks. I tried this and enabled "access database across all domains" still no progress for me.

Any other ideas?

Rick B.
2008-03-21, 08:27
Elite addressed a problem that did not yet occured.... I though. Maybe you were the first. Do the albums with these problems contains multiple artists by using a ';' as seperator char in the Artist tags?

No, I don't have ';' in any Artist tags, just for multiple genre tags, e.g. "Rock;Compilation". It looks like any with multiple genres are repeated.

Thank you.

SilverRS8
2008-03-27, 00:52
No, I don't have ';' in any Artist tags, just for multiple genre tags, e.g. "Rock;Compilation". It looks like any with multiple genres are repeated.

Thank you.

Can you post en send me by PM:
- a screenshot of the tags of the album with problems
- The ACC.log file (from the RC6 Beta version)
- A screenshot of the generated output

I'll look into the problem...

Frank

SilverRS8
2008-03-27, 01:25
I posted a RC6 beta version on (http://www.vanholt.nl/acc/acc.htm). It contains features to support a remote SqueezeCenter server allowing Linux/NAS users to run ACC from a windows machine while using the SC DB on the remote server.

Because I don't have the availability of a non-windows based NAS I haven't been able to test this personally so I need your help on this. A remote windows based server seems to work fine.

It has been tested by a few yet but to speed things up I would like to ask anyone who's interested in this feature to test it and provide me feedback on what when well or wrong ofcourse.

Frank

johari62
2008-04-19, 09:15
Frank,

thank very much for the great app. I've tested V6 successfully in a NAS setting (SSODS on a DS207+) with the script executed remotely on a WinXP PC.

My cover art has no fixed files names (cover.jpg, folder.jpg, ...), but is variably named (%artist% - %album%.jpg), though. Is there a way to get the files displayed without renaming?

Joachim

elite1967
2008-04-19, 09:38
Frank,

thank very much for the great app. I've tested V6 successfully in a NAS setting (SSODS on a DS207+) with the script executed remotely on a WinXP PC.

My cover art has no fixed files names (cover.jpg, folder.jpg, ...), but is variably named (%artist% - %album%.jpg), though. Is there a way to get the files displayed without renaming?

Joachim


Hi Joachim,
with the latest code the artwork is taken from the server itself not from the directories in your library.

So if Squeezecenter can display the images, so will ACC.

SP

browellm
2008-04-19, 10:05
Similar to Ralph, I just can't get this working. Get error 3716 all the time.

System is Vista 64-bit SP1. ODBC and 64bit Vista are not happy bunnies I think.

SilverRS8
2008-04-19, 11:17
Similar to Ralph, I just can't get this working. Get error 3716 all the time.

System is Vista 64-bit SP1. ODBC and 64bit Vista are not happy bunnies I think.

Sad but true....64 bit Vista with the 64 bit ODBC driver doesn't behave the same as its 32 bit version so I can't support the 64 bit version yet :-(

Frank

SilverRS8
2008-04-19, 11:23
Hi Joachim,
with the latest code the artwork is taken from the server itself not from the directories in your library.

So if Squeezecenter can display the images, so will ACC.

SP

The latest version also uses the artwork residing in the directory itself. The new code should be able to retrieve them from a remote server meaning a another computer then where ACC is executed from.

I have a version available actually retrieving the artwork from SqueezeCenter. This would also solve Johari62 problem but...(there always seems to be a but) the artwork is retrieved through a SqueezeCenter URL resulting in very sssslloooww performance (something like three album covers a second). For the larger collections I think it is totally unuseable.

I can post the code though if you like. It does solve a lot (if not all) album art problems.

Frank

johari62
2008-04-20, 01:08
Frank,
that would be great. I'd like to give it a try! Joachim

fast eddie
2008-04-20, 03:16
I am running SC7 on an dedicated pc running CC Community Edition server, I tried to run this using the remote server bit but I get the following error:

"Manual Pre-Requirement !!Default the MySQL DB installed with SqueezeCenter is configured not to allow remote connections. You have to manually enable remote connections by opening the my.tt file and disabling the 'bind-address = [% bindAddress %]' by entering a '#' sign in front of it. Save it and restart SqueezeCenter before using ACC with the remote server option.
Default locations for the my.tt file:
Windows: ?:\Program Files\SqueezeCenter\server\MySQL\
Linux: ???"

I have opened WinSCP and looked in the/etc/squeezecentre directory but cant find the "my.tt file".

Can someone point me in the right direction please.

Thanks for the help

Ramage
2008-04-20, 04:24
I am running SC7 on an dedicated pc running CC Community Edition server, I tried to run this using the remote server bit but I get the following error:

"Manual Pre-Requirement !!Default the MySQL DB installed with SqueezeCenter is configured not to allow remote connections. You have to manually enable remote connections by opening the my.tt file and disabling the 'bind-address = [% bindAddress %]' by entering a '#' sign in front of it. Save it and restart SqueezeCenter before using ACC with the remote server option.
Default locations for the my.tt file:
Windows: ?:\Program Files\SqueezeCenter\server\MySQL\
Linux: ???"

I have opened WinSCP and looked in the/etc/squeezecentre directory but cant find the "my.tt file".

Can someone point me in the right direction please.

Thanks for the help

You'll find my.tt in /usr/share/squeezecenter/MySQL

fast eddie
2008-04-20, 04:50
You'll find my.tt in /usr/share/squeezecenter/MySQL

Thanks for the quick reply.

Just to be sure, should it be like this:

#bind-address = [% bindAddress %]

or this

bind-address = [% #bindAddress %]

Ramage
2008-04-20, 04:57
Thanks for the quick reply.

Just to be sure, should it be like this:

#bind-address = [% bindAddress %]

or this

bind-address = [% #bindAddress %]

If the line has a # in front then it is dissabled, so it should look like:

#bind-address = [% bindAddress %]

when you're done

fast eddie
2008-04-20, 05:48
If the line has a # in front then it is dissabled, so it should look like:

#bind-address = [% bindAddress %]

when you're done

Thats what I had but just wanted to check.

Just need to shut down my server so SC restarts and hopefully it will work.

Thanks for the help Ramage - much appreciated

Ramage
2008-04-20, 06:21
Thats what I had but just wanted to check.

Just need to shut down my server so SC restarts and hopefully it will work.

Thanks for the help Ramage - much appreciated

You can restart squeezecenter by using a terminal and typing:

"service squeezecenter restart"

saves rebooting the server.

A good way to access a command line on CC is to use Putty, which uses ssh and complements WinSCP.

SilverRS8
2008-04-20, 10:30
Frank,
that would be great. I'd like to give it a try! Joachim

Hi Joachim,

I have just posted the version retrieving album art directly from SqueezeCenter instead as from the actual folder. let me know the outcome please.

BTW; It is much slower but does resolve some issues and enables support for embedded cover art in tags.

Frank

johari62
2008-04-20, 12:17
Hi Frank,

thanks for the upload! I just ran the script - it took about 5min for about 550 albums - no error message, but the covers are still not found.

I have the two script versions "acc-v1-RC6-beta" and "acc-v1-RC6-Alt1" installed in parallel dir's. The alt1 version still writes the output into "acc-v1-RC6-beta/AlbumCatalogs". The "AlbumCatalog - 20.04.2008 - QuickRef" file looks fine.

Joachim

johari62
2008-04-21, 12:32
Frank,

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

Thanks for the support, Joachim

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

SilverRS8
2008-04-21, 23:15
Frank,

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

Thanks for the support, Joachim

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

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

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

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

Frank

friediger
2008-05-05, 12:08
Hi,

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

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

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

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

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

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

Thanks in advance,
Kasper

Kuben72
2008-05-05, 12:32
I have the same problems. In the acc.log file I can see that it doesn't get to create the table it needs.

/Kuben72

SilverRS8
2008-05-05, 12:37
Hi,

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

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

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

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

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

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

Thanks in advance,
Kasper

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

Frank

Kuben72
2008-05-05, 13:00
Yep. Changed acc to ACC in the whole script and the Albums.id to albums.id in the create table statement and now it is running like mad on my computer :)

Edit: How long does it take ?

SilverRS8
2008-05-05, 13:19
Yep. Changed acc to ACC in the whole script and the Albums.id to albums.id in the create table statement and now it is running like mad on my computer :)

Edit: How long does it take ?

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

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

Frank

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

Should also be changed to:

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

/Kuben72

Kuben72
2008-05-05, 13:29
The mht file is also wrong. It uses the ip-adress 127.0.0.1 when it should use the ip-adress from the option.

/kuben72

SilverRS8
2008-05-06, 12:32
Just posted RC7 (http://www.vanholt.nl/acc/acc.htm) which should fix the issues with remote Linux servers.

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

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

Frank

Kuben72
2008-05-06, 12:52
I have tried it and it works as long I check the "Use album cover...." option. Otherwise I get a no-cover image for the albums.

SilverRS8
2008-05-06, 12:58
I have tried it and it works as long I check the "Use album cover...." option. Otherwise I get a no-cover image for the albums.

Thx for the quick feedback.

With the 'Use album cover' disabled you must have the proper drive mapping to the music share from the machine running ACC to the Linux machine. The full remote physical directory path also needs to be entered correctly for ACC to be able to access the file based covers. This path needs to be entered in the same syntax as it is stored in the DB. A sample path, retrieve from the DB, is displayed when pressing the TEST button and can be used as guidance to the syntax to be used. If all is done properly and the covers still aren't displayed than there is probably an issue with ACC and remote LINUX servers access the physical album covers.
On remote Windows servers this option seems to work fine.

Frank

Kuben72
2008-05-06, 13:15
In my opinion I have the path set correctly= mnt/Musikdisk/Musik/ OR should the last / be omitted?

Edit: Nope. It doesn't make a difference.

/Kuben72

SilverRS8
2008-05-06, 13:17
In my opinion I have the path set correctly= mnt/Musikdisk/Musik/ OR should the last / be omitted?

/Kuben72

Shouldn't there be a // be in front (//mnt/Musikdisk/Musik)? (UNC path notation)
I think the last / can be omitted. Curious about the results though. Can you test it?

Kuben72
2008-05-06, 13:21
I wil try with //

Kuben72
2008-05-06, 13:25
It doesn't work. Sorry.

/kuben72

friediger
2008-05-08, 07:42
Thanks for the update, I can now get the program to produce the album catalog. Unfortunately there is still some problems.

1. I can't get it to show the album covers, it doesn't matter which of the two options I use. Are there anyway I can sort this out myself?
2. There are some of my albums that split themselves up, so that all of the tracks but one is in the same square, and then there is one random song who got its own listing. I can't tell by looking at the tag, why this is. What could be the solution?

SilverRS8
2008-05-08, 09:00
Thanks for the update, I can now get the program to produce the album catalog. Unfortunately there is still some problems.

1. I can't get it to show the album covers, it doesn't matter which of the two options I use. Are there anyway I can sort this out myself?
2. There are some of my albums that split themselves up, so that all of the tracks but one is in the same square, and then there is one random song who got its own listing. I can't tell by looking at the tag, why this is. What could be the solution?


Great to hear it now works. Now up to solving the last problem

1. Can you tell something about your configuration? Remote Linux? remote IP number? How does the sample path look like when pressing the test button in the remote server option screen.

Can you send me or post the following files:
- ACC logfile or send it to me by mail.
- Sample of a generated catalog

2. This is probably due to inconsistency in character case usage in the tags. Check the case of the MP3 album tags carefully. There is probably a difference in it. This causes SqueezeCenter to store in under a different album id than the other tracks and hence ACC thinks its an other album.

Frank

friediger
2008-05-08, 13:04
Great to hear it now works. Now up to solving the last problem

1. Can you tell something about your configuration? Remote Linux? remote IP number? How does the sample path look like when pressing the test button in the remote server option screen.

Can you send me or post the following files:
- ACC logfile or send it to me by mail.
- Sample of a generated catalog

2. This is probably due to inconsistency in character case usage in the tags. Check the case of the MP3 album tags carefully. There is probably a difference in it. This causes SqueezeCenter to store in under a different album id than the other tracks and hence ACC thinks its an other album.

Frank

Hi Frank,

I have send you an email!

-Kasper

moley6knipe
2008-06-14, 05:18
Just tried version 1 of this, works great! Two very minor issues, though.

Under SqueezeCenter settings > Music Library > Articles to ignore when sorting I've entered "A An The" which means SC sorts the same as iTunes.

However, I've got three tracks by a band called "A", as in just a capital letter A on it's own. All three tracks are on different compilations, which are recongnised as comps by SC, and indeed are listed under Various Artists when I create a catalogue with ACC.

Also, I've got, as the very last entry on the catalog (the \Album Catalogue Creator\AlbumCatalogs\AlbumCatalog - 14-06-2008.html.mht view), a "missing image" placeholder; if I right-click it I get the attached info, which tells me it's address is <<my path>>\Album Catalogue Creator\AlbumCatalogs\ but there's nothing in there apart from the 3 catalogues. Any ideas? All my artwork shows correctly in SqueezeCenter.

I can e-mail you the catalogues and log files if that helps?

Win XP Pro SP2, Internet Explorer 7.

SilverRS8
2008-06-14, 10:39
Hi moley6knipe,

Currently ACC only has an option to ignore 'the' but it should be fairly easy to make this user defineable. I'll put it on my todo list for the next version update.

Can you mail me de catalogfile (the .HTML, not the .MHT as all the cover reference are replaced with internal references to allow everything to be stored in 1 file. Also the acc.log file please.

Best regards,

Frank

moley6knipe
2008-06-15, 02:41
Done! Thanks, Frank. ACC gets my "application of the week" award!!!!

ctbarr
2008-06-28, 11:56
This is an excellent application and I want to say thanks for taking the time to write it. Very very helpful!

I have two quick questions please:

1) Is there any way to sort the Artists by surname, perhaps by reading an Artistsort tag (this is how I force it in Squeezecentre), i.e. Bob Dylan would be under D, not B?
2) In my listings it does not seem to read the Discs tag. All albums just say CD1 at the top even if they have more than 1 CD: is this a problem with my tagging?

Again, thanks!

mrgothic
2008-06-29, 05:21
i would love have this program,how do i set it up my system is windows xp pro on main computer with all my music on z drive which is a hp media smart server 475 also my slimserver is installed on the hp media smart server,is it possible to just list the music without artwork

thank you

RichardL
2008-06-30, 09:47
I love this application, but I too have the problem of 'safety settings stop you from accessing a database in another domain'

Its all running locally on XP Pro. I have RC4 installed and it runs and produces lovely output. I am on SC7.0.1 and when I try the ACC V1.0 software I get the error - running against 127.0.0.1. I also tried from another machine to see if I could get it to run against the remote IP address, but I get the same error.

There isn't much on Google, I've tried setting the permission in IE7 options, but nothing seems to help.

Does anyone know what the problem is? Or a reasonable workaround (other than staying with older versions)?

Thanks

SilverRS8
2008-07-03, 12:02
I love this application, but I too have the problem of 'safety settings stop you from accessing a database in another domain'

Its all running locally on XP Pro. I have RC4 installed and it runs and produces lovely output. I am on SC7.0.1 and when I try the ACC V1.0 software I get the error - running against 127.0.0.1. I also tried from another machine to see if I could get it to run against the remote IP address, but I get the same error.

There isn't much on Google, I've tried setting the permission in IE7 options, but nothing seems to help.

Does anyone know what the problem is? Or a reasonable workaround (other than staying with older versions)?

Thanks

I looked up the differences in RC4 and v1.0 and I can only think of the connection string to the database which is different. You can try changing line 53 in version 1 to be the same as is RC4.

Line 53 (v1.0) looks like:
ConnectString3 = ";Port=9092;Database=slimserver;UID=slimserver;Pass word=slimserver;Option=3"

Change the Password=slimserver to Password= so you effectively leave the password blank. Then try to run it again.

Between RC4 and v1.0 are quick a lot of small changes. What is the first version above RC4 giving the problem? This would greatly simplify the troubleshooting process.

Frank

SilverRS8
2008-07-03, 12:07
This is an excellent application and I want to say thanks for taking the time to write it. Very very helpful!

I have two quick questions please:

1) Is there any way to sort the Artists by surname, perhaps by reading an Artistsort tag (this is how I force it in Squeezecentre), i.e. Bob Dylan would be under D, not B?
2) In my listings it does not seem to read the Discs tag. All albums just say CD1 at the top even if they have more than 1 CD: is this a problem with my tagging?

Again, thanks!

1) I believe not. The artist surname isn't stored in a seperate DB field (have to double check it) so determining the surname can't be easily done. At least not without errors. I'm currious though how SC performs this trick
2) Thanks for the report. I've but it on my bugfix list for the next update.

Frank

ntom
2008-07-09, 19:39
New to this thread but had a look at ACC info & looks just what I'm looking for.

Unfortunately I am getting the same 3716 error 'safety settings on this computer prohibit accessing a data source on another domain'.
I tried older versions with exactly the same problem right back to RC3.

With RC2a I get a different problem:
'An error occured while connection to the database. The error data is printed below. Error number: 0

I have tried it on both the SC machine & a remote machine with same result.
I am running XP Home Edition on the SqueezeCenter machine & XP Media Center on the remote machine. SC7.0.1

Have I missed anaything obvious?

Khuli
2008-07-10, 01:46
Is it possible to add an option to include:

- the path to the album
- the bit rate

I could really use that additional data!

RichardL
2008-07-10, 09:23
Change the Password=slimserver to Password= so you effectively leave the password blank. Then try to run it again.

Frank

Sorry for the delay in responding.

I tried this change on a test machine and it seems to have cured the problem. I will re-run tonight on my 'production' squeezecenter machine and see if it works there as well.

Thanks for the help

SilverRS8
2008-07-10, 22:46
Is it possible to add an option to include:

- the path to the album
- the bit rate

I could really use that additional data!

Sure but with very long path names I don't know how to format it nicely. Bit rate can be different per track. Would you like an option to display the bitrate in, lets say, brackets behind the track?

Frank

Khuli
2008-07-11, 03:26
Sure but with very long path names I don't know how to format it nicely. Bit rate can be different per track. Would you like an option to display the bitrate in, lets say, brackets behind the track?

The bitrate in brackets would be perfect!

I know what you mean about the length of paths... how about having a fixed-length field and showing the start and end of the path if it's too long?

e.g. D:\music library\Marillion\Marbles
D:\music library\Tom Pe......\Into The Great Wide Open

I would think that the path to the album would be sufficient, rather than to the song, so this would keep it shorter.

SilverRS8
2008-07-11, 03:57
The bitrate in brackets would be perfect!

I know what you mean about the length of paths... how about having a fixed-length field and showing the start and end of the path if it's too long?

e.g. D:\music library\Marillion\Marbles
D:\music library\Tom Pe......\Into The Great Wide Open

I would think that the path to the album would be sufficient, rather than to the song, so this would keep it shorter.

I'll put the bitrate option on my next version todo list.
As for the album path option I don't think it can be universally implemented. I agree with you that only the path would be sufficient but everybody uses its own path structure making it difficult to find a universal solution.

Frank

Khuli
2008-07-11, 08:19
One of the advantages for including the path is that it would make it easier to find duplicate files. Is there another way this could be done?

If displaying the path was optional, I'm not sure that nice formatting is vital!

AndrewFG
2008-07-11, 08:33
I tried your software on Vista but got the attached error dialog.

Any advice how to solve it?

SilverRS8
2008-07-11, 10:27
One of the advantages for including the path is that it would make it easier to find duplicate files. Is there another way this could be done?

If displaying the path was optional, I'm not sure that nice formatting is vital!

I would suggest that if you want to easily detect all duplicate file to use a tool for that. Total Commander is a very good tool on Windows to do that (I use it a lot).

SilverRS8
2008-07-11, 10:51
I tried your software on Vista but got the attached error dialog.

Any advice how to solve it?


This error is Windows related and is poorly documented by Microsoft. There is no real solution for it as far as I know other than try some options.

I'll list some here. Hopefully one of them will work.

1. Check if you have the latest MySQL ODBC driver installed !

2. Add the host running ACC to the trusted zone in Internet Explorer
so add http://localhost and http://127.0.0.1 to the trusted site zone. Ofcourse if you are using a remote server, add that IP number here.

3. Edit the AlbumCatalogCreator-V1.hta file with a text editor.

Line 53 (v1.0) looks like:
ConnectString3 = ";Port=9092;Database=slimserver;UID=slimserver;Pas sword=slimserver;Option=3"

Change the Password=slimserver to Password= so you effectively leave the password blank. Then try to run it again. This one is reported to work by another user.

4. ACC uses some parts of Internet Explorer to execute. Try the following from Internet Explorer:
Menu Tools -> Options -> Security TAB -> Local Intranet zone -> Custom...
Under the Miscellaneous section Enable 'Access data sources across domains' the try ACC again
If this does not work. Do it again for the other zones as the error report says to access a data source in ANOTHER domain is prohibited.

If one works please let me know so I can include in in the help file.

Frank

CB154
2008-07-12, 02:16
this is great

works perfect a great addition. as per another of my posts this picks up my album art no problem. why does my SC software not :(

mrgothic
2008-07-12, 17:35
hi

im a bit of a newbie with computers could anyboby explain in easy terms how to install this program

im running xp pro on my computer,my slimserver 7 is installed on a media smart server

ive downloaded the software do i extract it or what do i do once ive downloaded,also do i have to download a driver for this,sorry to sound stupid but im not very confident with computers

all help will be great as i would love to have this program,ive read the posts and it just goes over my head

thank you

SilverRS8
2008-07-12, 23:46
hi

im a bit of a newbie with computers could anyboby explain in easy terms how to install this program

im running xp pro on my computer,my slimserver 7 is installed on a media smart server

ive downloaded the software do i extract it or what do i do once ive downloaded,also do i have to download a driver for this,sorry to sound stupid but im not very confident with computers

all help will be great as i would love to have this program,ive read the posts and it just goes over my head

thank you

All information on getting it to work is actually in the help screen. Unzip the download to a directory en double-click the AlbumCatalogCreator-v10.hta file and the program starts. Then click the HELP button for the required information.
You do need to install the MySQL driver which you need to download from the MYSQL site but this is all described in the help screen.

If the help screen doesn't do it for you please let me know and do a forum post again.

mrgothic
2008-07-13, 03:59
All information on getting it to work is actually in the help screen. Unzip the download to a directory en double-click the AlbumCatalogCreator-v10.hta file and the program starts. Then click the HELP button for the required information.
You do need to install the MySQL driver which you need to download from the MYSQL site but this is all described in the help screen.

If the help screen doesn't do it for you please let me know and do a forum post again.

hi
ive downloaded the program and driver,ive been in help but im stuck now i need to enable remote access [Default location for Windows OS: ?:\Program Files\SqueezeCenter\server\MySQL\]were do i look for this

thank you

Khuli
2008-07-14, 01:46
I would suggest that if you want to easily detect all duplicate file to use a tool for that. Total Commander is a very good tool on Windows to do that (I use it a lot).

Looks like the duplicate file option is based on size and/or name. I don't think either is ideal since they may not be the same - it really needs a search to be by tag info too. I have an Excel app that reads tag info, so I guess I can use it to easily find duplicates.

SilverRS8
2008-07-14, 05:50
hi
ive downloaded the program and driver,ive been in help but im stuck now i need to enable remote access [Default location for Windows OS: ?:\Program Files\SqueezeCenter\server\MySQL\]were do i look for this

thank you

You need to look in the folder c:\Program Files\SqueezeCenter\server\MySQL\ on the remote machine for the file my.tt and edit this file using notepad or some text editor. This is the default location. Change it to your specific situation if applicable.

The my.tt file contains a line like below:
bind-address = [% bindAddress %]

Change this line to:
#bind-address = [% bindAddress %]

Then restart your computer (or the squeezecenter services). The squeezecenter database does now allow to remotly access the database. Follow the instructions in the remote option and help screen to configure ACC for remote usage. Again, post a message on this forum if you need any help.

ntom
2008-07-17, 15:14
Success!

I still haven't managed to get past the 3716 error 'safety settings on this computer prohibit accessing a data source on another domain' on my office PC or my musicserver. I am able to access the database from the office PC for tagging etc with no problem.

So as a last resort tried it on my laptop. I had an ODBC access problem at first. Disabling Windows XP firewall on the server solved this problem and I have produced my first reports! Needed a little tidying of tags to get repots looking good.

Brilliant application!

The only slightly odd looking thing I have left is where I have both a track and album artist defined, each track is listed twice, once for the track artist & once for the album artist.
e.g. Loudmouth -Best of Bob Geldof & the Boomtown Rats. Some tracks are credited to Bob Geldof (TrackArtist) & some to the Boomown Rats (TrackArtist) but I have AlbumArtist=Bob Geldof & the Boomtown Rats!

Is there a way of defeating this so that the track is only printed once for either AlbumArtist or TrackArtist?

SilverRS8
2008-07-17, 23:06
Success!

I still haven't managed to get past the 3716 error 'safety settings on this computer prohibit accessing a data source on another domain' on my office PC or my musicserver. I am able to access the database from the office PC for tagging etc with no problem.

So as a last resort tried it on my laptop. I had an ODBC access problem at first. Disabling Windows XP firewall on the server solved this problem and I have produced my first reports! Needed a little tidying of tags to get repots looking good.

Brilliant application!

The only slightly odd looking thing I have left is where I have both a track and album artist defined, each track is listed twice, once for the track artist & once for the album artist.
e.g. Loudmouth -Best of Bob Geldof & the Boomtown Rats. Some tracks are credited to Bob Geldof (TrackArtist) & some to the Boomown Rats (TrackArtist) but I have AlbumArtist=Bob Geldof & the Boomtown Rats!

Is there a way of defeating this so that the track is only printed once for either AlbumArtist or TrackArtist?

Great to hear everything is working now. Was disabling/modifying the firewall the solution to the problem (good to know)?

I believe that the problem you are facing with is due to the fact that squeezecenter actually stores two references to the album in the database.
The same thing occurs when you specify multiple artists by using the ';' as seperator char.

I'll see if I can create a fix for it. I need to build a query that could combine the different artist results for a single album but must admit my SQL knowledge is not quiet the level required here ;-) If anyone is able to help me out by a really intelligent SQL query, I would be most happy. Otherwise i have to create a workaround in the code processing the current results which would not benefit the performance I'm afraid. Anyway. Issues is on my to do list.

Frank

ntom
2008-07-19, 16:34
Disabling the firewall fixed the ODBC query error. Now runs OK on my laptop, but still get the 3716 error trying to run it on my Server & Office PC. I've tried to spot differences in the set-up between the machines but haven't spotted anything so still none the wiser why it should run OK on the laptop.


Yes: you are right if there are two artists listed (using the ; separator) the track is also printed twice.

I must confess that I have not been consistent in how I tag things with more than 1 artist.

MrPoison
2008-08-08, 11:37
This error is Windows related and is poorly documented by Microsoft. There is no real solution for it as far as I know other than try some options.

I'll list some here. Hopefully one of them will work.

1. Check if you have the latest MySQL ODBC driver installed !

2. Add the host running ACC to the trusted zone in Internet Explorer
so add http://localhost and http://127.0.0.1 to the trusted site zone. Ofcourse if you are using a remote server, add that IP number here.

3. Edit the AlbumCatalogCreator-V1.hta file with a text editor.

Line 53 (v1.0) looks like:
ConnectString3 = ";Port=9092;Database=slimserver;UID=slimserver;Pas sword=slimserver;Option=3"

Change the Password=slimserver to Password= so you effectively leave the password blank. Then try to run it again. This one is reported to work by another user.

4. ACC uses some parts of Internet Explorer to execute. Try the following from Internet Explorer:
Menu Tools -> Options -> Security TAB -> Local Intranet zone -> Custom...
Under the Miscellaneous section Enable 'Access data sources across domains' the try ACC again
If this does not work. Do it again for the other zones as the error report says to access a data source in ANOTHER domain is prohibited.

If one works please let me know so I can include in in the help file.

Frank

Hi!
I'm running my slimserver on a Qnap TS-209II NAS server and the ACC on a Windows Vista Home edition. Since I like the ACC appplication but I've been struggling to get this to work, I thought I would share my "thought":

Point 4 above: Since you add the IP-address of the NAS to the trusted zone in point 2, I believe you must enable 'Access data sources across domains' for your trusted zone. This is done under:
Menu Tools -> Options -> Security TAB -> Trusted zone -> Custom...
or, do as I, enable it for all 3 zones!

Point 5: On the Qnap, you also need to edit this line in the my.tt file:
bind-address = [% bindAddress %]

Change this line to:
#bind-address = [% bindAddress %]

Point 6: This will get you started BUT you will run out of tmp space on the Qnap. So, create another tmp directory on a disk with a lot of free space, for example /volume1/tmp and then add the following line to your my.tt file under the [mysqld] section:
tmpdir = /volume1/tmp/

Point 7: Stop and restart slimserver and MySQL on the Qnap.

Now you're ready to go! But it will take a while to get all the information! I have about 24000 tracks and it took a couple of hours to run the application. But, as Carlsberg would say, it's worth waiting for :)

Just a little note:
I'm swedish and I do have a couple of directories with swedish characters for my albums. ACC will not be able to get the album art for these albums if you use file based album arts (I haven't tried ID3-tag album arts yet but will do)

Hope this helps some of you to get the application running because it's a real nice application!

moley6knipe
2008-08-27, 11:44
Under "SqueezeCenter settings > Music Library > Articles to ignore when sorting" I've entered "A An The" which means SC sorts the same as iTunes.

However, I've got three tracks by a band called "A", as in just a capital letter A on it's own. All three tracks are on different compilations, which are recongnised as comps by SC, and indeed are listed under Various Artists when I create a catalogue with ACC

Just to follow up on this; I've now changed "SqueezeCenter settings > Music Library > Articles to ignore when sorting" from "A An The" to simply "The". I've just run another catalogue with version 1, and I still get the artist "A" showing at the start of the list even though they're tracks only present on comps.

I've done loads of clear and rescans since my previous post, and indeed have deleted the cache folder several times.

Any thoughts on how to fix?

SilverRS8
2008-09-19, 11:23
Disabling the firewall fixed the ODBC query error. Now runs OK on my laptop, but still get the 3716 error trying to run it on my Server & Office PC. I've tried to spot differences in the set-up between the machines but haven't spotted anything so still none the wiser why it should run OK on the laptop.


Yes: you are right if there are two artists listed (using the ; separator) the track is also printed twice.

I must confess that I have not been consistent in how I tag things with more than 1 artist.

I recently made the transition to a FreeNAS NAS. When I run ACC from the NAS, the 'Safety settings on this computer prohibit accessing a data source on another domain' message appear. No matter what solution I try it will not free me from this error. When I run ACC from the Windows machine directly - as in copy the stuff from the NAS to a local disk - it runs fine.

So this must be another Microsoft security issue but I though to post this so maybe other have some use for it.

In the meantime I've started to do some bugfixing like some users have requested in this thread.

Frank

SilverRS8
2008-09-19, 11:28
Just a note: It will take some time - as I currently don't have lots of spare time - to make ACC compatible with the upcoming version 7.3 of SC as in this version the whole database structure is redesigned.

TurnipMan
2008-10-05, 13:16
Hi Frank,
I keep my music on a couple of external USB disks and let SC know about them but having a couple of folder short cuts. SC follows these but your code does not. Any chance of an update.
Just a question - why do we have to tell your proggy where to start lookin? Can it not just get the info from SC settings?

Thanks
Tom

seerdekens
2008-10-16, 07:02
Hello Frank,

I'm also getting the 2147217887 error. (see attachement)
Using SS7.2 on my Synology NAS:

SqueezeCenter Version: 7.2 - 22900 @ Tue Aug 26 10:59:02 PDT 2008 - Linux - EN - iso-8859-1
Server IP address: 192.168.1.150
Perl Version: 5.8.6 MARVELL_88F5281
MySQL Version: 5.0.51b
Platform Architecture: MARVELL_88F5281
Hostname: DiskStation
Server Port Number: 9002
Total Players Recognized: 1

OBDC connector test from Vista is ok.
I also modified the connect string in the hta file.

I read somewhere in this tread that this problem may be caused due to the fact that mysql connect commands are case sensitive in Linux.
Should this be solved in the latest 1.0 version of ACC?

rbz5416
2009-01-04, 03:03
Forgive me if this has been answered in the previous 44 pages but life is short!

Can a portable database be created as it would be useful to have a copy on a portable device? Either copying the AlbumArtCatalogs folder or performing a File Save within the catalog breaks the artwork. The artwork only seems to load with AlbumArtCatalogs in the location where was originally created.

SilverRS8
2009-01-04, 05:06
Forgive me if this has been answered in the previous 44 pages but life is short!

Can a portable database be created as it would be useful to have a copy on a portable device? Either copying the AlbumArtCatalogs folder or performing a File Save within the catalog breaks the artwork. The artwork only seems to load with AlbumArtCatalogs in the location where was originally created.

I don't really understand the question and don't know if it is ACC related but ACC uses the references as stored in the squeezecenter database so ACC wil not use a copy of the album art elsewhere if one was made. Does this answer your question.

rbz5416
2009-01-04, 07:42
Yes it's AAC related, that's why I posted in your AAC thread.

After running AAC, a folder is created in the same directory where the AAC application is located. This folder is named "AlbumCatalogs". This folder contains 3 files:

AlbumCatalog - Date - QuickRef.html
AlbumCatalog - Date.html
AlbumCatalog - Date.html.mht

With my approx 1,000 album database the last file is around 4.5MB. This would seem to include the artwork images.

Moving the AlbumCatalogs folder to any other location results is the vast majority of art not displaying, but some does.

Performing a "File Save As" within a browser with the AlbumCatalog.html open creates a structure like so:

"Squeezebox Album Collection (by Artist).htm" & a folder name "Squeezebox Album Collection (by Artist)_files". The folder contains all of the artwork images in the format "folder(1).jpg".

Again, opening "Squeezebox Album Collection (by Artist).htm" results in the same result, most art is not displayed.

What I am try to achieve is a portable copy of the database as output by AAC complete with artwork. This would be useful to hold on a PDA (or similar device with a browser)to avoid duplicate purchases when browsing in a shop.

SilverRS8
2009-01-04, 08:53
Yes it's AAC related, that's why I posted in your AAC thread.

After running AAC, a folder is created in the same directory where the AAC application is located. This folder is named "AlbumCatalogs". This folder contains 3 files:

AlbumCatalog - Date - QuickRef.html
AlbumCatalog - Date.html
AlbumCatalog - Date.html.mht

With my approx 1,000 album database the last file is around 4.5MB. This would seem to include the artwork images.

Moving the AlbumCatalogs folder to any other location results is the vast majority of art not displaying, but some does.

Performing a "File Save As" within a browser with the AlbumCatalog.html open creates a structure like so:

"Squeezebox Album Collection (by Artist).htm" & a folder name "Squeezebox Album Collection (by Artist)_files". The folder contains all of the artwork images in the format "folder(1).jpg".

Again, opening "Squeezebox Album Collection (by Artist).htm" results in the same result, most art is not displayed.

What I am try to achieve is a portable copy of the database as output by AAC complete with artwork. This would be useful to hold on a PDA (or similar device with a browser)to avoid duplicate purchases when browsing in a shop.

The art work in the .HTML file directly links to the actual location where the art is stored and using the drive mapping used during the generation of it. Moving this file to another computer not having this mapping will result is art work being missing.

The .mht file though is a file which is portable and can either be stored anywhere else or send to someone else as all page content is included in the .mht file. It is a standard Internet Explorer feature and file format. Another way of making it portable is saving the catalog as PDF file (useful if you don't want to use the Internet explorer archive format).

SilverRS8
2009-01-08, 04:12
The AlbumCatalogCreator site has been moved to a different URL: acc.vanholt.nl

I changed the plugin wiki page URL reference also.

Frank

Kossu
2009-01-16, 08:00
Hi!
I'm running my slimserver on a Qnap TS-209II NAS server and the ACC on a Windows Vista Home edition. Since I like the ACC appplication but I've been struggling to get this to work, I thought I would share my "thought":

Point 4 above: Since you add the IP-address of the NAS to the trusted zone in point 2, I believe you must enable 'Access data sources across domains' for your trusted zone. This is done under:
Menu Tools -> Options -> Security TAB -> Trusted zone -> Custom...
or, do as I, enable it for all 3 zones!

Point 5: On the Qnap, you also need to edit this line in the my.tt file:
bind-address = [% bindAddress %]

Change this line to:
#bind-address = [% bindAddress %]

Point 6: This will get you started BUT you will run out of tmp space on the Qnap. So, create another tmp directory on a disk with a lot of free space, for example /volume1/tmp and then add the following line to your my.tt file under the [mysqld] section:
tmpdir = /volume1/tmp/

Point 7: Stop and restart slimserver and MySQL on the Qnap.

Now you're ready to go! But it will take a while to get all the information! I have about 24000 tracks and it took a couple of hours to run the application. But, as Carlsberg would say, it's worth waiting for :)

Just a little note:
I'm swedish and I do have a couple of directories with swedish characters for my albums. ACC will not be able to get the album art for these albums if you use file based album arts (I haven't tried ID3-tag album arts yet but will do)

Hope this helps some of you to get the application running because it's a real nice application!

Thank you for this. I also have the same system setup. But I'm having difficulties in accesing the files mentioned above. Could someone please write a step by step quide, how do I do everything? Especially the part, where I need to find my.tt file. How do I find it, what tools do I need etc.? When I go to QNAP with filemanager all I see are the folders Public, Qusb, Qweb and so on...

So if someone could help me and maybe some others too, who have their thumbs in the middle of their palms when it comse to Linux -systems :)

SilverRS8
2009-01-17, 00:37
Thank you for this. I also have the same system setup. But I'm having difficulties in accesing the files mentioned above. Could someone please write a step by step quide, how do I do everything? Especially the part, where I need to find my.tt file. How do I find it, what tools do I need etc.? When I go to QNAP with filemanager all I see are the folders Public, Qusb, Qweb and so on...

So if someone could help me and maybe some others too, who have their thumbs in the middle of their palms when it comse to Linux -systems :)

I don't know how the QNAS works but from the sound of it you can OpenSSH to it. Download Putty and setup a SSH connection to the QNAS box. Login with the root/admin account. The my.tt file should be in the /usr/share/squeezecenter/MySQL folder. Edit the file using a editor (VI/NANO/ Other?). And restart the QNAS. You should now be able to remotely access the Squeezecenter database.

SilverRS8
2009-01-17, 00:41
Hi!
I'm running my slimserver on a Qnap TS-209II NAS server and the ACC on a Windows Vista Home edition. Since I like the ACC appplication but I've been struggling to get this to work, I thought I would share my "thought":

Point 4 above: Since you add the IP-address of the NAS to the trusted zone in point 2, I believe you must enable 'Access data sources across domains' for your trusted zone. This is done under:
Menu Tools -> Options -> Security TAB -> Trusted zone -> Custom...
or, do as I, enable it for all 3 zones!

Point 5: On the Qnap, you also need to edit this line in the my.tt file:
bind-address = [% bindAddress %]

Change this line to:
#bind-address = [% bindAddress %]

Point 6: This will get you started BUT you will run out of tmp space on the Qnap. So, create another tmp directory on a disk with a lot of free space, for example /volume1/tmp and then add the following line to your my.tt file under the [mysqld] section:
tmpdir = /volume1/tmp/

Point 7: Stop and restart slimserver and MySQL on the Qnap.

Now you're ready to go! But it will take a while to get all the information! I have about 24000 tracks and it took a couple of hours to run the application. But, as Carlsberg would say, it's worth waiting for :)

Just a little note:
I'm swedish and I do have a couple of directories with swedish characters for my albums. ACC will not be able to get the album art for these albums if you use file based album arts (I haven't tried ID3-tag album arts yet but will do)

Hope this helps some of you to get the application running because it's a real nice application!

you can try to use the ' Use album cover stored in SqueezeCenter instead of physical file(slow)' option. Haven't checked it yet but album cover image links will than refer to a squeezecenter URL instead of pointing to the actual file. I expect album covers of albums with filepaths with special characters in it should display correctly.

Kossu
2009-01-17, 12:48
I don't know how the QNAS works but from the sound of it you can OpenSSH to it. Download Putty and setup a SSH connection to the QNAS box. Login with the root/admin account. The my.tt file should be in the /usr/share/squeezecenter/MySQL folder. Edit the file using a editor (VI/NANO/ Other?). And restart the QNAS. You should now be able to remotely access the Squeezecenter database.

Thanx! I managed to change the line in my.tt, but still I get an error message. I have installed the MySQL driver as in the instructions.

Here is the message I get:

SilverRS8
2009-01-17, 15:01
Thanx! I managed to change the line in my.tt, but still I get an error message. I have installed the MySQL driver as in the instructions.

Here is the message I get:

You must not add the two backslashes as prefix to the IP number. That is only required for UNC notations. Just enter the ip-address alone and try again.

Frank

Kossu
2009-01-18, 02:54
You must not add the two backslashes as prefix to the IP number. That is only required for UNC notations. Just enter the ip-address alone and try again.

Frank

Great! Thanx, it seems to be working.

Kossu
2009-01-20, 07:59
Great! Thanx, it seems to be working.

I was happy too soon :)

Test goes ok and the Catalog creation starts ok...I think. After a while (about 10-15 minutes) I get an error message. The message is in finnish, so I don't put it here, but it says something like "the script thats running in Explorer might make the pc work slower. Do you want to quit? YES - NO"

If I press No - the work seems to continue, but I get the same message over and over again. I've continued this for a couple of hours, but nothing happens. And finally I press the Yes -button and sometimes I get a html-page with headers, but nothing in it. Sometimes not eaven that.

I'm sorry if this has allready been answered previously, I haven't had the time to go through all the messages.

Thanks in advance for the possible solutions.

SilverRS8
2009-01-20, 08:13
I was happy too soon :)

Test goes ok and the Catalog creation starts ok...I think. After a while (about 10-15 minutes) I get an error message. The message is in finnish, so I don't put it here, but it says something like "the script thats running in Explorer might make the pc work slower. Do you want to quit? YES - NO"

If I press No - the work seems to continue, but I get the same message over and over again. I've continued this for a couple of hours, but nothing happens. And finally I press the Yes -button and sometimes I get a html-page with headers, but nothing in it. Sometimes not eaven that.

I'm sorry if this has allready been answered previously, I haven't had the time to go through all the messages.

Thanks in advance for the possible solutions.

Windows monitors processes. If processes become too busy, windows reports the message you reported. This can mean the scripts eithers hangs or the script is very busy making Windows thinks there is something wrong with it.
To check if ACC is really doing something while running, check if the log file is growing. If zo, ignore the Windows messages.

You can also mail me a logfile of a moment in time where ACC has been running for a while.

Frank

SilverRS8
2009-01-20, 08:14
Windows monitors processes. If processes become too busy, windows reports the message you reported. This can mean the scripts eithers hangs or the script is very busy making Windows thinks there is something wrong with it.
To check if ACC is really doing something while running, check if the log file is growing. If zo, ignore the Windows messages.

You can also mail me a logfile of a moment in time where ACC has been running for a while.

Frank

Did you try to narrow down the scope by setting the starting folder so just few albums are processed instead of the complete database? Please mail or post the logfile so I can get some insight.

Kossu
2009-01-20, 09:23
Did you try to narrow down the scope by setting the starting folder so just few albums are processed instead of the complete database? Please mail or post the logfile so I can get some insight.

I now set up the starting folder to just one album, so lets see what happens. Nothing yet, all though it has been runnin for couple of minutes now.

Where can I find the logfile?

EDIT: This is what happned. I answered Yes to terminate the script.

SilverRS8
2009-01-20, 10:15
I now set up the starting folder to just one album, so lets see what happens. Nothing yet, all though it has been runnin for couple of minutes now.

Where can I find the logfile?

EDIT: This is what happned. I answered Yes to terminate the script.

The logfile is in the same directory as ACC itself and is called acc.log

Kossu
2009-01-20, 10:26
The logfile is in the same directory as ACC itself and is called acc.log

That's what I thought, but there is no such file.

This is what I find:
AlbumCatalogCreator-V10 (html aplication)
history (text file)'

Folder called Includes

Kossu
2009-01-20, 10:35
That's what I thought, but there is no such file.

This is what I find:
AlbumCatalogCreator-V10 (html aplication)
history (text file)'

Folder called Includes

EDIT: Ok, I found the log file. It's in the folder i determined as output folder for the html page generated by ACC. I'll send it to you soon.

SilverRS8
2009-01-23, 00:45
Hi!
Just a little note:
I'm swedish and I do have a couple of directories with swedish characters for my albums. ACC will not be able to get the album art for these albums if you use file based album arts (I haven't tried ID3-tag album arts yet but will do)


I'm currently doing some fixing including this one. The problem is related to UTF-8 encoding. File paths are stored UTF-8 encoded in the database. International character are stored using 16 bytes (2 hex digits). Example: Björk is stored as Bj%C3%B6rk. ACC currently doesn't handle this.
I'll look into it but if anyone knows if mysql provides a native conversion function for this this would really be helpfull. VBS conversion code as alternative will also do.

Frank

SilverRS8
2009-01-25, 08:04
A new version of ACC is available (v1.1). Changelist is below:

ADDED: Display total albums and total tracks as last line of generated catalog
FIXED: Proper error handling for incorrectly specified remote folder (ACC would hang)
FIXED: No album covers displayed when international characters in physical path to cover file. The 'Use album cover stored in SqueezeCenter instead of physical file' option worked ok for these album covers though.
CHANGED: Display CDx (if used in the tags) in the header instead of tracklist otherwise when selecting the option not to display tracks, CD number would not be displayed.
CHANGED: When not using a '0' prefix for track number < 10, the tracknumber is correctly aligned with track numbers >10
CHANGED: Title suffix 'by artist', 'by album', or 'by genre' changed to small characters and next line

tamanaco
2009-01-28, 22:47
SilverRS8, is it possible to make the Display CDx an option even when the tag exists. All of my CDs have a DISCNUM 1/x tag which gets translated to DISC 1/x by SqueezeCenter. I don't want to see CD1 for albums where the tag is DISC 1/1.

SilverRS8
2009-01-29, 00:15
SilverRS8, is it possible to make the Display CDx an option even when the tag exists. All of my CDs have a DISCNUM 1/x tag which gets translated to DISC 1/x by SqueezeCenter. I don't want to see CD1 for albums where the tag is DISC 1/1.

A very good point! It should be an option whether the CD number is displayed or not. I'll make the changes and post an update.

MOMENTUM
2009-02-14, 18:40
Hello,
I can't seem to get by the below error
'safety settings on this computer prohibit accessing a data source on another domain'

I am running acc from the same pc that sc is runnign on.

Have gone through all the step and tricks i could find inn this post with no luck
any suggestions?
Thanks
- - - mo

MARC38
2009-02-23, 15:35
I have tried the tool which is great and run on my simple server where Squeeze center is running (old PC with win XP).
However, I never succeed with the remote connection even I tried to stop all the firewall (local + remote), follow the notice (bind address), ...
I also tried to connect to the Mysql server with Excel to make a query to the database : also without success.
I always got the following error message : can't connect to MySql server on '192.168.1.22' (10060).
Does anyone have some experience in such connection problems ?

Thank you.

Marc.

SilverRS8
2009-02-25, 12:27
I have tried the tool which is great and run on my simple server where Squeeze center is running (old PC with win XP).
However, I never succeed with the remote connection even I tried to stop all the firewall (local + remote), follow the notice (bind address), ...
I also tried to connect to the Mysql server with Excel to make a query to the database : also without success.
I always got the following error message : can't connect to MySql server on '192.168.1.22' (10060).
Does anyone have some experience in such connection problems ?

Thank you.

Marc.

Did you follow all the instructions in the remote server screen? Mysql has to be modified first to allow remote connections at all.

MARC38
2009-02-26, 06:38
Actually, yes. I have modified the mysql file to put the "Bind adress" as comment (the PC was also rebooted of course). I did not make any other modification (do I need to compile or restart something to load this modification ?)
So I do not know what else to check to know what is wrong :
- MySql modification at the server side : Done
- stop the firewalls on both sides loca + remote in case : Done

The tool works perfectly on local but not distant. It should be not a problem with the Album Catalog Creator tool, because I tried to connect trough Excel with the same error result when trying to connect.
==> Any idea ?

SilverRS8
2009-02-26, 06:53
Actually, yes. I have modified the mysql file to put the "Bind adress" as comment (the PC was also rebooted of course). I did not make any other modification (do I need to compile or restart something to load this modification ?)
So I do not know what else to check to know what is wrong :
- MySql modification at the server side : Done
- stop the firewalls on both sides loca + remote in case : Done

The tool works perfectly on local but not distant. It should be not a problem with the Album Catalog Creator tool, because I tried to connect trough Excel with the same error result when trying to connect.
==> Any idea ?

What location was the my.tt file in on your synology? I believe mysql maintains an active copy and a 'template' version. You must change the template versions otherwise the changes made get overwritten again. Can you verify that the file you modified still has a # sign before the bindaddress line?

Besides firewalls I don't have a clue why a connection attempt does not work.
You can download the mysql administration tools. Those are nice easy to use GUI tools, usefull for troubleshooting such things as these.

Frank

MARC38
2009-03-09, 14:41
I have solved my problem !
1/ I stopped the firewall on my server (actually, what is the port # used by Acc ?)
2/ I have simply deleted the line "BIND ADDRESS" from the my.tt file
3/ I have modified the Squeezecenter seetings :
In the advance TAB, Security, authorize the IP addresses by putting a * into the IP @ : eg. 192.168.1.2* to extend to other IP (I'm surprised, because I'm already accessing to the server from my main PC : http://pcserveur:9000/)
So It is now working well !
Thank you for developping this great and usefull tool !
Marc.

SilverRS8
2009-03-10, 05:11
I have solved my problem !
1/ I stopped the firewall on my server (actually, what is the port # used by Acc ?)
2/ I have simply deleted the line "BIND ADDRESS" from the my.tt file
3/ I have modified the Squeezecenter seetings :
In the advance TAB, Security, authorize the IP addresses by putting a * into the IP @ : eg. 192.168.1.2* to extend to other IP (I'm surprised, because I'm already accessing to the server from my main PC : http://pcserveur:9000/)
So It is now working well !
Thank you for developping this great and usefull tool !
Marc.

Thx for your positive feedback! Good to hear everything is working. Also good point you have there regarding the squeezecenter security settings. I personally don't use any security restrictions so it never came to mind.

ACC interacts only with the underlying MySQL database (except for album covers if the option is used to retrieve them through SqueezeCenter). Can you confirm for my understanding that step 3 is really necessarry for ACC to work?

Frank

MARC38
2009-03-10, 12:58
Your right : the point #3 is not necessary.
So now everythnig is working well, except if possible I would like to add an exception into the firewall. Do you now what port number is used ?
Thanks.
Marc.

SilverRS8
2009-03-10, 14:40
Your right : the point #3 is not necessary.
So now everythnig is working well, except if possible I would like to add an exception into the firewall. Do you now what port number is used ?
Thanks.
Marc.

Thanks for the feedback on #3. Port 9092 is used for the connection to mysql.

Album covers are either retrieved based on file level access (on Windows this is performed by SMB and uses netbios ports:
NetBIOS Datagram Service UDP 138
NetBIOS Name Resolution UDP 137
NetBIOS Session Service TCP 139

and SMB itself:
SMB TCP 445

or from squeezecenter itself (option in ACC) then this is being done by hypertext URL hence port 80.

Hope this is of any help.

Frank

Kossu
2009-03-12, 11:23
I still have some problems with this. I can get ACC to work, when I point it directly to one album folder. For example:

Starting folder:

Z:\Music -> does not give me anything but error message

but

Z:\Music\Z:\ABBA - The Definitive Collection ->

I get a ACC page with two albums (ABBA collection is a double album) but not the album art. I use FLAC files and the album art is in the FLAC, not a separate as a picture file.

Can anyone give a hint where I should try to find the solution?

SilverRS8
2009-03-12, 12:14
I still have some problems with this. I can get ACC to work, when I point it directly to one album folder. For example:

Starting folder:

Z:\Music -> does not give me anything but error message

but

Z:\Music\Z:\ABBA - The Definitive Collection ->

I get a ACC page with two albums (ABBA collection is a double album) but not the album art. I use FLAC files and the album art is in the FLAC, not a separate as a picture file.

Can anyone give a hint where I should try to find the solution?

For the album art that is embedded in the flac file you must use the option 'Use album cover stored in SqueezeCenter instead of physical file' to be set in the Option screen of ACC otherwise only file based cover files are supported.

For the first path problem i need some more information:
1- the acc.log file (you can send it by mail if you like)
2- Is Z: a mapped network drive or is it a local drive?
3- What does the path to the ABBA folder look like from windows?
Z:\Music\ABBA .... or Z:\ABBA.... ?
4- If on a remote server, what is the full path from server point of view to the ABBA album on the server?

Frank

Kossu
2009-03-14, 05:05
For the album art that is embedded in the flac file you must use the option 'Use album cover stored in SqueezeCenter instead of physical file' to be set in the Option screen of ACC otherwise only file based cover files are supported.

For the first path problem i need some more information:
1- the acc.log file (you can send it by mail if you like)
2- Is Z: a mapped network drive or is it a local drive?
3- What does the path to the ABBA folder look like from windows?
Z:\Music\ABBA .... or Z:\ABBA.... ?
4- If on a remote server, what is the full path from server point of view to the ABBA album on the server?

Frank


1.the log file will be in your mail
2.It's a network drive
3.Z:\ABBA
4./share/Public/Music/ABBA-...

Laz
2009-03-14, 23:13
Frank,

Some more info on 3716.

I am running my slimserver on a linux box on the 255.255.255.0 and I have been getting the 3716 error pretty well regardless of whether I include the server box in my trusted sites or not. The only way I have got the system to run is allow "Access to data sources across domains" for the internet zone (no effect in the other zones). In this case, I don't need to add the slimserver IP to the trusted sites list.

I presume this is because my windows box does not recognise my slimserver box as being in the same domain (and I'm too lazy to figure out what I need to change - I can live with doing this change as a one off to run acc).

Anyway, I hope this is helpful. Now I'm getting the report without cover art, so on to trouble shooting that!

Cheers

Larry

Mark Belden
2009-03-15, 21:34
I think this program is beyond my ken as far as debugging and cajoling to get it to work properly. Is there any kind of commercial program that will do this for me? I would love to have a pdf that I could get printed and bound at Staples or Kinko's to look at on the couch.

SilverRS8
2009-03-16, 12:49
Frank,

Some more info on 3716.

I am running my slimserver on a linux box on the 255.255.255.0 and I have been getting the 3716 error pretty well regardless of whether I include the server box in my trusted sites or not. The only way I have got the system to run is allow "Access to data sources across domains" for the internet zone (no effect in the other zones). In this case, I don't need to add the slimserver IP to the trusted sites list.

I presume this is because my windows box does not recognise my slimserver box as being in the same domain (and I'm too lazy to figure out what I need to change - I can live with doing this change as a one off to run acc).

Anyway, I hope this is helpful. Now I'm getting the report without cover art, so on to trouble shooting that!

Cheers

Larry

Thx for the tip. I added it as one of the solutions on the ACC download page. No cover art is often related to a wrong remote path.

Frank

SilverRS8
2009-03-16, 12:51
I think this program is beyond my ken as far as debugging and cajoling to get it to work properly. Is there any kind of commercial program that will do this for me? I would love to have a pdf that I could get printed and bound at Staples or Kinko's to look at on the couch.

I haven't seen a commercial program yet that generates a catalog from a squeezecenter music collection. But if you would like to get ACC to work please post details about the problem you're having and I should be able to help you out.

Frank

SilverRS8
2009-06-14, 05:35
Just posted Album Catalog Creator v1.2 on acc.vanholt.nl

Frank

SilverRS8
2009-06-26, 15:05
Just uploaded version 1.3 of Album Catalog Creator on acc.vanholt.nl

Changes are listed on the site.

Frank

stof77
2009-08-31, 03:03
hello

I can't access to your server to try out your album creator.
http://acc.vanholt.nl/


Maybe it's down ?

Please let me know.

Rick B.
2009-08-31, 17:19
None of the links work.

stof77
2009-09-01, 05:32
I just sent him a PM about it,

but maybe he's on holiday.

stof77
2009-09-12, 10:03
Still no response from Frank,

hope you're ok, though,

I had an "old" version (1.1), that I tried & it's working great here.

As I have a full back up of my music collection on my windows PC, I did run ACC there rather than from the NAS.

Congrats Frank, it's really a nice program, very usefull indeed.

So far I have properly tagged "only" my Flac files (more than 600 albums), but I will now work with the mp3, a lot of tag work has to be done...

If it's possible, could you please add the option of the codec format used : flac, mp3, wma or whatever.

It could be listed closed to the album or artist name.

andrek
2009-10-23, 00:36
I am so far a happy user of 1.5b version of Album Catalog Creator. Thanks Frank.

Two remarks:
1) Is it possible to add a filter for Artist such that by selecting "A*" I only get the artists starting with A, or by selecting "Jethro T*" I only get my Jethro Tull-albums as ouput ?

2) I have my Album Art separately in files, not as part of the Squeezebox database.
Both the files and the database is on a Synology NAS.
What I experience is that when I run AAC I must go through all option windows of ACC, just click OK (all options are already filled in correctly) for ACC to use the external Album Art-files.
If I just run ACC and click START then the catalog contains No Pictures.
Is this normal ?

SilverRS8
2009-10-23, 01:59
I am so far a happy user of 1.5b version of Album Catalog Creator. Thanks Frank.

Two remarks:
1) Is it possible to add a filter for Artist such that by selecting "A*" I only get the artists starting with A, or by selecting "Jethro T*" I only get my Jethro Tull-albums as ouput ?

2) I have my Album Art separately in files, not as part of the Squeezebox database.
Both the files and the database is on a Synology NAS.
What I experience is that when I run AAC I must go through all option windows of ACC, just click OK (all options are already filled in correctly) for ACC to use the external Album Art-files.
If I just run ACC and click START then the catalog contains No Pictures.
Is this normal ?

Hi AndreK and thanks.

Regarding your first point; I think it is a very interesting idea. What I mean is that it isn't hard at all to implement a filter like you suggest so consider that one added to my to do list. To some extend it is possible using the starting folder option in the main screen.

You're second point is due to an incorrectly set 'Full remote physical path to music share'. Set the starting folder to a single artist folder to make troubleshooting easyer. Press the TEST button n the remote server option screen and an example database entry is displayed on the bottom of the ACC screen. Use this syntax for the 'Full remote physical path to music share' setting.
The good news is you only have to find out this setting once.

If this does not help you send me an e-mail and I'll contact you and ask for some configuration information.

Frank

andrek
2009-10-31, 13:28
You're second point is due to an incorrectly set 'Full remote physical path to music share'. Set the starting folder to a single artist folder to make troubleshooting easyer. Press the TEST button n the remote server option screen and an example database entry is displayed on the bottom of the ACC screen. Use this syntax for the 'Full remote physical path to music share' setting.
The good news is you only have to find out this setting once.

Frank, I did some further testing and it has to do with the AlbumArtFilename in the Advanced Options, and not with the Remote Server options:
I use a strange filename Frontmini.jpg for my covers and have also entered that name in the ACC-GUI.
But every run of ACC I needed to press the OK button on the Advanced Options page, to get these Frontmini.jpg files found.

I have now added this filename in the AlbumCatalogCreator-V1.5b.hta script-file and the Frontmini.jpg-files are found without going through the Options/Advanced Options in the GUI.
So just run ACC and press Start. I am happy now :)!
Strangely enough, when I look the ACC.log file the correct filename is mentioned there, also when no pictures are found.

One other question:
In the listings for my "Diverse artiesten" CDs (My SqueezeCenter runs in Dutch) ACC does not add the artist (so it lists only Tracknumber - Title).
I think that this is caused by the fact that SC reports these CDs not as "Various Artists", but as "Diverse artiesten".
[EDIT: A global Search and Replace in the AlbumCatalogCreator-V1.5b.hta file of "Various Artists" by "Diverse artiesten" fixed it ! ]

I have printed my first complete catalog (~200 pages). I never had such a great looking printed overview of my Music Collection.
Thank you Frank !

SilverRS8
2009-10-31, 16:40
Frank, I did some further testing and it has to do with the AlbumArtFilename in the Advanced Options, and not with the Remote Server options:
I use a strange filename Frontmini.jpg for my covers and have also entered that name in the ACC-GUI.
But every run of ACC I needed to press the OK button on the Advanced Options page, to get these Frontmini.jpg files found.

I have now added this filename in the AlbumCatalogCreator-V1.5b.hta script-file and the Frontmini.jpg-files are found without going through the Options/Advanced Options in the GUI.
So just run ACC and press Start. I am happy now :)!
Strangely enough, when I look the ACC.log file the correct filename is mentioned there, also when no pictures are found.

One other question:
In the listings for my "Diverse artiesten" CDs (My SqueezeCenter runs in Dutch) ACC does not add the artist (so it lists only Tracknumber - Title).
I think that this is caused by the fact that SC reports these CDs not as "Various Artists", but as "Diverse artiesten".
[EDIT: A global Search and Replace in the AlbumCatalogCreator-V1.5b.hta file of "Various Artists" by "Diverse artiesten" fixed it ! ]

I have printed my first complete catalog (~200 pages). I never had such a great looking printed overview of my Music Collection.
Thank you Frank !

Hi Andre,

Great to hear you have now good results and thank you for reporting the problem which obviously is a bug which I'll fix in the next release. I also didn't know that SC stores 'various artists' also in a localized language. i would have expected that all database storage would be in english whereas localization would be performed in the GUI. Good to know. Don't know if i'll support the localized languages in the future though considering the effort...but again thanks for the reporting!!!

andrek
2009-11-03, 01:35
Another small issue I found.
I have some very long tracks on some of my albums.
Tracks longer than 1 hour are not listed correctly by ACC (v1.5b).

Example:
Klaus Schulze - The Dome Event has 2 tracks.
ACC lists them as:
01 - The Dome Event (3:32) => but correct length is 1:03:32 !
02 - After Eleven (10:44) => correct

Nothing dramatic, but it would be nice to fix in a next release (if easy).

SilverRS8
2009-11-03, 01:41
Another small issue I found.
I have some very long tracks on some of my albums.
Tracks longer than 1 hour are not listed correctly by ACC (v1.5b).

Example:
Klaus Schulze - The Dome Event has 2 tracks.
ACC lists them as:
01 - The Dome Event (3:32) => but correct length is 1:03:32 !
02 - After Eleven (10:44) => correct

Nothing dramatic, but it would be nice to fix in a next release (if easy).

That would be a small fix. Added to my TODO list :-)

andrek
2009-12-15, 07:29
I saw on the website that a version 1.6 was available. So I downloaded and tried it:
- bug with tracks longer than 1 hour is fixed. Thanks;
- I see that the addition of Codec and Bitrate is implemented. A very interesting option (now I can quickly see which albums still to upgrade from mp3 to flac);

I do see some things that from my taste can be improved:
- the word "Flac" or "mp3" is immediately written after the year, so no spaces in between;
- the codec & bitrate information is not in italic, rest of that line is;
- I personally like brackets better than the pipe-character (my taste);
- I have some problems with collections of random songs that I treat as various artist (example top2000) where I have put all track-numbers as 0.
In 1.5b that worked well, now I see that it is not recognized as compilation, or only 1 song is listed.
I will try to add tracknumbers and see if that helps.
NOTE: I have also upgraded from 7.3.3 to 7.4.1 squeezecenter, that may also affect the various artist albums.

I think I can modify the output format (spaces, italics) myself to make it fit my taste.

BTW: Is v1.6 an official release or was it just there to test-drive ?

SilverRS8
2009-12-15, 07:46
I saw on the website that a version 1.6 was available. So I downloaded and tried it:
- bug with tracks longer than 1 hour is fixed. Thanks;
- I see that the addition of Codec and Bitrate is implemented. A very interesting option (now I can quickly see which albums still to upgrade from mp3 to flac);

I do see some things that from my taste can be improved:
- the word "Flac" or "mp3" is immediately written after the year, so no spaces in between;
- the codec & bitrate information is not in italic, rest of that line is;
- I personally like brackets better than the pipe-character (my taste);
- I have some problems with collections of random songs that I treat as various artist (example top2000) where I have put all track-numbers as 0.
In 1.5b that worked well, now I see that it is not recognized as compilation, or only 1 song is listed.
I will try to add tracknumbers and see if that helps.
NOTE: I have also upgraded from 7.3.3 to 7.4.1 squeezecenter, that may also affect the various artist albums.

I think I can modify the output format (spaces, italics) myself to make it fit my taste.

BTW: Is v1.6 an official release or was it just there to test-drive ?

Does the K in your name stand for Kuijer? In that case we've worked together ;-) Anyway....

1.6 is an official release.
Can you provide a screen shot of a header as the header ACC generates looks like the attached image where FLAC and MP3 is printed on the next line, not after the year. Also only the album name and year line is in italic.

Album tracks are sorted by tracknumber. When all tracknumber are set to 0 I an imagine this going wrong. Do you include the list entry # in the track title?

andrek
2009-12-15, 08:31
Does the K in your name stand for Kuijer? In that case we've worked together ;-) Anyway.... No, the 'K' stands for Klap


Can you provide a screen shot of a header as the header ACC generates looks like the attached image where FLAC and MP3 is printed on the next line, not after the year. Also only the album name and year line is in italic.
No screen shot at hand. But my output has codec and bitrate on the same line as album name and year.
What you show with a separate line looks very nice.
But I do not use 'genre', is that maybe where the newline is started ?



Album tracks are sorted by tracknumber. When all tracknumber are set to 0 I an imagine this going wrong. Do you include the list entry # in the track title?
I have also set the tracknr in the filename to 00. I will change this later this week and see if that fixes the issue. :)

SilverRS8
2009-12-15, 08:41
What internet browser do you use?
Can you PM me the acc.log file and the catalog file so I can try to track the problem?

SilverRS8
2009-12-15, 08:45
Please go to http://forums.slimdevices.com/showthread.php?t=66555&highlight=album+catalog+creator for an up to date thread and examples of current catalog layout