Re: [slim] Announce: Album Catalog Creator v3
SilverRS8;526361 Wrote: > For ACC is is not necessary to create a DSN and hence it does not have > to show up in ODBC data sources. Ah, yes. I think this was created by my MySQL editor that I used to test the connection. It's a good idea to install Navicat Lite for MySQL or another editor. Then you can see if the connection to the slimserver database works or not. -- eyeball eyeball's Profile: http://forums.slimdevices.com/member.php?userid=5352 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
fphredd;525663 Wrote: > Any other solutions/suggestions/'way out there' ideas? This thing is too > good not to be able to use. Have a look at the ODBC data sources of Windows. Go to Start -> Control Panel -> Maintenance -> Data Sources (ODBC) (Sorry, if I don't use the correct translations) Under "Drivers" you should only see the "MySQL ODBC 5.1 Driver". The 3.51 driver should not be installed anymore. Under "System-DSN" you should see "slimserver" and the name of the MySQL 5.1 driver. -- eyeball eyeball's Profile: http://forums.slimdevices.com/member.php?userid=5352 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Hi, the sorting seems to work with version 3.2. Great :) But I found another error. If the last album in the collection starts with a new letter it will be listed under the letter of the previous album (see screenshots). When I then add an album that starts with an "R", the "Q" capital will be created but the "R" is missing. Best wishes. Dirk +---+ |Filename: acc2.jpg | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=9278| +---+ -- eyeball eyeball's Profile: http://forums.slimdevices.com/member.php?userid=5352 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Wow, you're very busy :) V3 works fine for me, except for the ALBUMARTIST sorting bug that I have reported for version 2. Best wishes. -- eyeball eyeball's Profile: http://forums.slimdevices.com/member.php?userid=5352 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v2
Any info on my sorting problem? See ' message #23' (http://forums.slimdevices.com/showpost.php?p=501573&postcount=23) -- eyeball eyeball's Profile: http://forums.slimdevices.com/member.php?userid=5352 View this thread: http://forums.slimdevices.com/showthread.php?t=73284 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v2
SilverRS8;500966 Wrote: > I just uploaded a new version of Album Catalog Creator. A tool to create > a HTML catalog of your Squeezebox server music catalog. WOW, I didn't expect a 2.0 version that soon :) Works fine for me. Thanks very much. -- eyeball eyeball's Profile: http://forums.slimdevices.com/member.php?userid=5352 View this thread: http://forums.slimdevices.com/showthread.php?t=73284 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v1.5 (ACC)
I didn't read the forum for a few weeks. Great to read about the improvements of ACC, esp. the ARTISTSORT feature! fphredd;499848 Wrote: > When I use the ARTISTSORT feature, the artists are listed correctly, but > in the 'Quick Reference' they show separation letters by first name. > IOW, 'Joan Armatrading' and 'Louis Armstrong' are both listed > alphabetically by their last name, before Joan Armatrading is a 'J' > separator, and while directly following her is Louis Armstrong, there is > an 'L' separator before his name and albums are listed. > > Make sense? Same here. The Album Catalog is correct but the Quickref isn't. -- eyeball eyeball's Profile: http://forums.slimdevices.com/member.php?userid=5352 View this thread: http://forums.slimdevices.com/showthread.php?t=66555 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v1.5 (ACC)
SilverRS8;482859 Wrote: > This is a beta version and I invite you to test it and provide feedback > for it to become a release version. > Download at: http://acc.vanholt.nl The beta is working well. I couldn't find any errors. The bitrate display is a nice feature. Multiple artists are also working. Great! -- eyeball eyeball's Profile: http://forums.slimdevices.com/member.php?userid=5352 View this thread: http://forums.slimdevices.com/showthread.php?t=66555 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v1.5 (ACC)
DigitalMitch;481106 Wrote: > eyeball, well done for fixing artistsort - are you sharing this code > back to Frank for wider distribution? > > at the same time, have you considered albumartistsort which SBS has > started supporting since 7.4 I'm still using version 7.3.3. It seems thet 7.4 is not that stable at the moment. As for the ARTISTSORT, it's quite simple. I extended the SELECT statement of the base sql query: sql = "Create table ACC " &_ "SELECT DISTINCT " &_ "CONVERT(album_artist.name USING UTF8) AS 'AlbumArtist'," &_ new=> "album_artist.namesort AS AlbumArtistSort," &_ ... Later in function fnCreateSQLQuery I replaced the AlbumArtist with AlbumArtistSort: sQOrderBy = "order by AlbumArtistSort,AlbumYear DESC,AlbumName,Disc,Tracknum;" Of course, you have to change the other ORDER statements, too (I didn't use them). BTW, if you set the squeezecenter option to ignore leading articles (The, Der, Die, Das, Le, La,...) you don't need the option in ACC, because in the database table the artists are stored without articles in the namesort field. -- eyeball eyeball's Profile: http://forums.slimdevices.com/member.php?userid=5352 View this thread: http://forums.slimdevices.com/showthread.php?t=66555 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v1.5 (ACC)
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? -- eyeball eyeball's Profile: http://forums.slimdevices.com/member.php?userid=5352 View this thread: http://forums.slimdevices.com/showthread.php?t=66555 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v1.5 (ACC)
Squeezecenter is using it and you wrote a Squeezecenter addon. So why not implementing it? I did some research with a db viewer. The ARTISTSORT information is stored in the contributors.namesort attribute, for example as "AMOS TORI". You just have to order your table by the namesort attribute. I tried to change your script but it didn't work. It should be easy for you. -- eyeball eyeball's Profile: http://forums.slimdevices.com/member.php?userid=5352 View this thread: http://forums.slimdevices.com/showthread.php?t=66555 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v1.5 (ACC)
SilverRS8;478369 Wrote: > Doe you mean with ARTISTSORT tag that this is an actual tag for e.g. mp3 > files? Personally i use tag&rename but can't find the ARTISTSORT field. > > Apart from that it should be easy to implement what you ask as it would > just be a sorting option in the query ACC performs. I think it's not official, but Squeezecenter uses it. I added it manually to my tagging programs (foobar2000, mp3tag). -- eyeball eyeball's Profile: http://forums.slimdevices.com/member.php?userid=5352 View this thread: http://forums.slimdevices.com/showthread.php?t=66555 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v1.5 (ACC)
SilverRS8;477878 Wrote:
> Can you explain what you mean with the ARTISTSORT tag? I've never used
> it myself?
That makes me wonder. The Squeezecenter is sorting the artists
according to the ARTISTSORT tag. So, although the artist is displayed as
written in the ARTIST tag ("Tori Amos"), the artist appears under "A",
because the ARTISTSORT tag is "Amos, Tori".
Would it be possible for your script to evaluate the ARTISTSORT
information?
--
eyeball
eyeball's Profile: http://forums.slimdevices.com/member.php?userid=5352
View this thread: http://forums.slimdevices.com/showthread.php?t=66555
___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v1.5 (ACC)
Great work! I just created my first catalog. Would it be possible to use the ARTISTSORT tag for sorting? I want Tori Amos to be listed under "A" and not under "T", for example. Would it be easy to change the .hta file? -- eyeball eyeball's Profile: http://forums.slimdevices.com/member.php?userid=5352 View this thread: http://forums.slimdevices.com/showthread.php?t=66555 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] SqueezeBox Power On Issue - Constantly Trying to Connect to Suspended SC
Hi, I'm glad to see that others are also annoyed by the new behavior. In my opinion, this is a bug and not a feature. My SB3 is powered on when I switch on my power supply. But when I don't start the Squeezecenter, I want it to go to sleep immediately. Greetings. -- eyeball eyeball's Profile: http://forums.slimdevices.com/member.php?userid=5352 View this thread: http://forums.slimdevices.com/showthread.php?t=52451 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: Displaying BAND or ARTIST
I like to ask again: is it possible to define something like (BAND ? BAND : ARTIST) in the title format, so that, if the BAND tag exists, the BAND will be displayed, and if the BAND tag does not exist the ARTIST will be displayed? -- eyeball eyeball's Profile: http://forums.slimdevices.com/member.php?userid=5352 View this thread: http://forums.slimdevices.com/showthread.php?t=24545 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Displaying BAND or ARTIST
Hi, I have several albums where I defined a BAND tag and an ARTIST tag, for example ARTIST="Pat Metheny" and BAND="Pat Metheny Group". Is it possible to define a title format, so that the BAND is being displayed if it exists, and otherwise the ARTIST? -- eyeball eyeball's Profile: http://forums.slimdevices.com/member.php?userid=5352 View this thread: http://forums.slimdevices.com/showthread.php?t=24545 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
