eyeball;480756 Wrote: > The ARTISTSORT is working now (just three minor changes to your script > :) ). > But I discovered another problem. When an album is released by more > than one artist, like "Anderson Bruford Wakeman Howe" (which often > happens with jazz albums), I'm tagging the album with > ARTIST = "Jon Anderson; Bill Bruford; Rick Wakeman; Steve Howe" > ALBUMARTIST = "Anderson Bruford Wakeman Howe" > The ARTIST tagging lets Squeezecenter list the album under each of the > named artists and under the band name. When I use ACC and enable the > track listing, the album is correctly listed under the band name, but > each of the tracks is listed four times (as many times as artists are > involved). So I get: > Tracks: > 1 - Themes (5:58) > 1 - Themes (5:58) > 1 - Themes (5:58) > 1 - Themes (5:58) > 2 - Fist Of Fire (3:32) > 2 - Fist Of Fire (3:32) > 2 - Fist Of Fire (3:32) > 2 - Fist Of Fire (3:32) > 3 - Brother Of Mine (10:22 > ... > Do you have an idea why this happens and can you find a solution?
Good to hear you've got the Artistsort issue solved. As for the multiple track artist issue: SC creates a separate database entry for each performing artist in the database. A database query then results in multiple records for each track which is why ACC repeats a track multiple times as it does not yet cope with this. It would require considerable effort to provide this support which I would gladly invest however as of version 8 of squeezecenter, the whole database design is changed. To prevent a lot of work now and again on version 8 I will put the effort in the SC8 compatible version. To be honest, the transition to version 8 will make it more difficult to interface with and may even come to a scenario where the database file has to be copied first locally before ACC will be able to get the data out of it. ACC may become more user unfriendly but this is due to Logitechs choice to leave MySQL as database platform and use SQlite which doesn't support remote access natively. I'm wondering if the multiple artist issue can be solved within an SQL statement. That is that within the global query ACC performs which essentially creates a temporary database table, is it possible to combine multiple artists to a single string? If there are any ACC users who are really good in SQL and are willing to help me out on this one please drop me a mail. If it can be solved using SQL it would make the fix a lot easier to implement and I'll implement it in the version that support SC7.x instead of waiting for 8. -- SilverRS8 Author of -'AlbumCatalogCreator' (http://acc.vanholt.nl)- for SqueezeCenter '_' (http://www.badkamerpech.nl) SlimServer. 2xSB3, 1xDuet, 1xiPhone iPeng, Ubuntu NAS + SC, Denon PMA-1500AE + DacMagic + Monitor Audio Silver RS8 = :-) ------------------------------------------------------------------------ SilverRS8's Profile: http://forums.slimdevices.com/member.php?userid=12818 View this thread: http://forums.slimdevices.com/showthread.php?t=66555 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/discuss
