[SlimDevices: Plugins] COMPOSERSORT. How to activate?
Hi, looking for help on user a sort field. I have updated COMPOSERSORT in my music files. Thus I have tags such as COMPOSER = Alberto Ginastera COMPOSERSORT = Ginastera, Alberto COMPOSER = Wolfgang Amadeus Mozart COMPOSERSORT = Mozart, Wolfgang Amadeus I have performed a full scan (Clear Library and rescan everything). I have created some menus using Erland's Custom Browse using the Composers and Dynamic Tags templates. In neither case are the menu results being sorted by COMPOSERSORT. E.g. Alberto Ginastera is at the beginning rather then with the "G"s and Wolfgang Amadeus Mozart is at the end rather than with the "M"s. What else do I have to do in order to get COMPOSERSORT recognised? I have read somewhere that *SORT tags are picked up automatically but this does not seem to be the case for me. I'm running SB Sever 7.5.3 and also the Custom Tags and Mixed Tags plugins to pick up a WORK tag. This is working ok (I'm not using a WORKSORT tag). ThanksPaul -- Zetlandpaul Zetlandpaul's Profile: http://forums.slimdevices.com/member.php?userid=42692 View this thread: http://forums.slimdevices.com/showthread.php?t=85475 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] COMPOSERSORT. How to activate?
I'm not sure if COMPOSERSORT is supported by standard SBS. If it isn't, you probably need to do as follows to get it through Custom Scan. 1. In Custom Scan/Custom Tag scanning module, make sure the fields contains: - Sort tag mapping: COMPOSER=COMPOSERSORT - Tags to scan: COMPOSER 2. In Custom Scan/Mixed Tag scanning module, make sure to empty the "Composer tags" setting. 3. Perform a rescan with Custom Scan. This should result in that the Custom Browse based menus are sorted according to COMPOSERSORT. -- erland Erland Isaksson ('My homepage' (http://erland.isaksson.info)) (Developer of 'many plugins/applets' (http://wiki.slimdevices.com/index.php/User:Erland). If my answer helped you and you like to encourage future presence on this forum and/or third party plugin/applet development, 'donations are always appreciated' (http://erland.isaksson.info/donate)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=85475 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] COMPOSERSORT. How to activate?
Erland, Thanks for the suggestions. Unfortunately they did not work. So here is some further information. WITHOUT MAKING ANY CHANGES TO CUSTOM SCAN. I think that COMPOSERSORT is being scanned by the standard SB scanner as I can see the tag (with correct values) when selecting "+ > more info > view tags" from the Duet Controller. I have tried several different custom menus to display the COMPOSER and none of them pick up the sort using COMPOSERSORT. If I create a menu using one the templates that allows a sort tag to be entered and use COMPOSERSORT the result is the same; sorting is by COMPOSER not COMPOSERSORT. SO THEN I TRIED YOUR SUGGESTIONS. Settings for Custom Scan / Custom Tag: Module is enabled and possible to use [ ticked ] Include in automatic scans and "Scan All" [ ticked ] Scanning order in automatic and "Scan All" (1-100) [ 30 ] Tags to Scan[ WORK,COMPOSER ] Sort tag mapping[ COMPOSER=COMPOSERSORT ] (other entries blank) Settings for Custom Scan / Mixed Tag: Module is enabled and possible to use [ ticked ] Include in automatic scans and "Scan All" [ ticked ] Scanning order in automatic and "Scan All" (1-100) [ 60 ] Artist tags [ ARTIST ] Album Artist tags [ ARTIST,ALBUMARTIST ] Track Artist tags [ TRACKARTIST ] Conductor tags [ CONDUCTOR ] Composer tags [ ] Band tags [ BAND ] Album tags [ ALBUM ] Genre tags [ GENRE ] Year tags [ YEAR ] Include custom tags [ ticked ] Excluded custom tags[ ] Names to show for user [ ALBUM(Album:Albums),...,WORK(Work:Works)] Following a full rescan (Clear Library and rescan everything) none of the menus displing COMPOSER are being sorted by COMPOSERSORT. Any other clues as to what I need to do? Thanks.Paul -- Zetlandpaul Zetlandpaul's Profile: http://forums.slimdevices.com/member.php?userid=42692 View this thread: http://forums.slimdevices.com/showthread.php?t=85475 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] COMPOSERSORT. How to activate?
I just tested it with both Flac and Mp3 files and COMPOSERSORT (TSOC in Mp3s) is not recognized. I can look at the database and see that the sort field is set to the same value as that found in the COMPOSER field. -- JJZolx JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=85475 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] COMPOSERSORT. How to activate?
Zetlandpaul;609217 Wrote: > > Following a full rescan (Clear Library and rescan everything) none of > the menus displing COMPOSER are being sorted by COMPOSERSORT. > > Any other clues as to what I need to do? > > Thanks.Paul > Did you wait for the Custom Scan scanning to finish ? It starts after the standard scanner has finished, so you have to goto Custom Scan settings page to see if it's still running. Also, the COMPOSERSORT only affects the Custom Browse created menus, so you won't see any difference in the standard Artists and Genres menu. If you still doesn't get it to work, can you post the Custom Browse configuration for a menu which contains composers but doesn't work and I'll take a look at it. -- erland Erland Isaksson ('My homepage' (http://erland.isaksson.info)) (Developer of 'many plugins/applets' (http://wiki.slimdevices.com/index.php/User:Erland). If my answer helped you and you like to encourage future presence on this forum and/or third party plugin/applet development, 'donations are always appreciated' (http://erland.isaksson.info/donate)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=85475 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] COMPOSERSORT. How to activate?
Erland, I definately waited for the scan to complete. Last line of the server log shows: (and this is the only mention of CustomScan in the log) [11-02-09 03:21:17.9305] Plugins::CustomScan::Scanner::refreshData (1839) CustomScan: Synchronizing Custom Scan data, please wait... [11-02-09 03:21:44.9330] Plugins::CustomScan::Scanner::refreshData (2159) CustomScan: Synchronization finished These are the last lines of the Sb scanner log: [11-02-09 03:12:17.5772] Slim::Music::Import::endImporter (700) Completed Slim::Music::MusicFolderScan Scan in 715 seconds. [11-02-09 03:12:17.7742] Slim::Music::Import::runScanPostProcessing (429) Starting merge of various artists albums [11-02-09 03:12:25.9639] Slim::Music::Import::endImporter (700) Completed mergeVariousAlbums Scan in 8 seconds. [11-02-09 03:12:26.0227] Slim::Music::Import::runScanPostProcessing (437) Starting artwork scan [11-02-09 03:20:37.3728] Slim::Music::Import::endImporter (700) Completed findArtwork Scan in 491 seconds. [11-02-09 03:20:37.4835] Slim::Music::Import::runScanPostProcessing (483) Starting Database optimization. [11-02-09 03:20:52.5716] Slim::Music::Import::endImporter (700) Completed dbOptimize Scan in 15 seconds. The menu is the one packaged with Custom Browse titled "Composers". I have not made any changes other than those available as options on the panel. Menu name = Composers Menu group = Classical Music Menu Sort Order = 50 Pay all songs in selected album = ticked Libary = Classical Music All Other fields = blank Classical Music Composers 50 artist Albums artist sql alpha select contributors.id,contributors.name,substr(contributors.namesort,1,1) from contributors,contributor_album,multilibrary_contributor where contributors.id=multilibrary_contributor.contributor and multilibrary_contributor.library=1 and contributor_album.contributor=contributors.id and contributor_album.role in (2) group by contributors.id order by contributors.namesort asc album Songs album album sql ^(.*)\s\((.*)\)$ select albums.id,albums.title from contributor_album,albums,multilibrary_album where albums.id=multilibrary_album.album and multilibrary_album.library=1 and albums.id=contributor_album.album and contributor_album.role in (2) and contributor_album.contributor={artist} group by albums.id order by albums.titlesort asc,albums.disc asc track track track all sql select tracks.id,tracks.title from tracks,contributor_track,albums,multilibrary_track where tracks.id=multilibrary_track.track and multilibrary_track.library=1 and tracks.audio=1 and contributor_track.track=tracks.id and tracks.album={album} and contributor_track.role in (2) and contributor_track.contributor={artist} group by tracks.id order by tracks.disc,tracks.tracknum asc,tracks.titlesort asc
Re: [SlimDevices: Plugins] COMPOSERSORT. How to activate?
Try creating the Custom Browse menu using the "Custom Tags Albums" menu template instead and enter "COMPOSER" in "Tag name" parameter and leave the "Sort tag name" parameter empty. The "Composers" or "Artists" menu template which you have used, uses the standard SBS scanner data and won't use data scanned with Custom Scan, for example the COMPOSERSORT tag. -- erland Erland Isaksson ('My homepage' (http://erland.isaksson.info)) (Developer of 'many plugins/applets' (http://wiki.slimdevices.com/index.php/User:Erland). If my answer helped you and you like to encourage future presence on this forum and/or third party plugin/applet development, 'donations are always appreciated' (http://erland.isaksson.info/donate)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=85475 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] COMPOSERSORT. How to activate?
Hi Erland. Thanks for continuing to look at this. Looks like there is an issue somewhere in the scanning. Either the scanner is not saving the information correctly or perhaps it cannot read the TAGs due to format errors? Is there any way to diagnose what the scanner is doing? Any verbose messages that could be turned on? Is there a way of clearing the custom scan tables and starting again. I'm not sure that the SBS "Clear Library and rescan everything" does based on the run times of the plugins? I can create a menu using the "Custom Tags Album" template and this does display the composers sorted as I wish. E.g. Carl Philipp Emanuel Bach Johann Sebastian Bach Antonin Dvorak George Gershwin Franz Joseph Haydn However the list is not complete. There should be 108 composers listed but only 14 are shown. A dynamic menu does not display anything. This might be related or completely different. I have loaded your "Database Query" plugin and looked at the "Custom Scan Statistics" Only 316 songs are listed having COMPOSER or COMPOSERSORT. There should be over 1000. The "Multi Library" for "Classical Music" tells me I have 1123 songs. Nearly all of which have both COMPOSER and COMPOSERSORT tags. In fact all songs with a COMPOSER will have a COMPOSERSORT as I have used an action in MP3TAG to do this and they all display in MP3TAG. The music files in question are all FLAC by by the way. Output from "Database Query": Number of song attributes1159 Number of artist attributes0 Number of album attributes0 Number of songs with attributes316 Number of songs without attributes0 Number of artists with attributes0 Number of artists without attributes3219 Number of albums with attributes0 Number of albums without attributes456 Number of songs with attributes from customtag316 Number of song attributes from customtag1159 Number of songs without attributes from customtag4317 Number of songs without attributes from mixedtag4633 Number of albums without attributes from csamazon456 Number of artists without attributes from cslastfm3219 Number of songs with customtag attributes of type COMPOSER316 Number of songs with customtag attributes of type COMPOSERSORT316 Number of songs with customtag attributes of type WORK23 Thanks...Paul -- Zetlandpaul Zetlandpaul's Profile: http://forums.slimdevices.com/member.php?userid=42692 View this thread: http://forums.slimdevices.com/showthread.php?t=85475 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] COMPOSERSORT. How to activate?
If you configure a menu in Custom Browse with the menu template "Custom Scan Info", you will be able to browse the individual tracks and see which tags it has picked up. Look at the SBS Song Info page in the web interface and its "View tags" link. If the tag show up in "View tags" but not in the "Custom Scan Info", it would be great if you could send me such file so I can take a look at it. -- erland Erland Isaksson ('My homepage' (http://erland.isaksson.info)) (Developer of 'many plugins/applets' (http://wiki.slimdevices.com/index.php/User:Erland). If my answer helped you and you like to encourage future presence on this forum and/or third party plugin/applet development, 'donations are always appreciated' (http://erland.isaksson.info/donate)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=85475 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] COMPOSERSORT. How to activate?
Hi, Thanks for you help. Much appreciated. I can confirm that COMPOSERSORT is now working as wanted when using "Custom Browse" "Custom Tag" menus (The ones that are added when installing the Custom Scan plug-in). As for the other issue of an apparent incomplete scan. That was a user error. Another member of the household had switched the server off and on whilst the manually scheduled scan was running. Grrr! That will teach me to leave the room. They thought it had stopped working as some of their menus had gone blank. The scheduled overnight scan has restored normality. RegardsPaul -- Zetlandpaul Zetlandpaul's Profile: http://forums.slimdevices.com/member.php?userid=42692 View this thread: http://forums.slimdevices.com/showthread.php?t=85475 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] COMPOSERSORT. How to activate?
Hi, all this doesn't work for me. It siply will not change the order the composers are displayed. I did the following: Module settings custom tag: Module enabled - Include in automatic scans and "Scan All" Tags to scan: COMPOSERS Sort tag mapping: COMPOSER=COMPOSERSORT Module settings mixed tag: Cleared the Field Composer tags, else nothing changed. Build Menu with Template custom tags albums: Komponisten (Klassik) 50 customtag Albums sql select distinct customscan_track_attributes.value,customscan_track_attributes.value from customscan_track_attributes where module='customtag' and attr='COMPOSER' and value='{context.itemid}' customtagCOMPOSER sql alpha select customscan_track_attributes.value,customscan_track_attributes.value, substr(ifnull(customscan_track_attributes.valuesort,customscan_track_attributes.value),1,1) from customscan_track_attributes join multilibrary_track on customscan_track_attributes.track=multilibrary_track.track and multilibrary_track.library=1 where customscan_track_attributes.module='customtag' and customscan_track_attributes.attr='COMPOSER' group by customscan_track_attributes.value order by ifnull(customscan_track_attributes.valuesort,customscan_track_attributes.value) asc album Songs album album sql bytitle Sort by title alpha byyear Sort by year number ^(.*)\s\((.*)\)$ select albums.id,albums.title,substr(albums.titlesort,1,1) from tracks,albums,customscan_track_attributes,multilibrary_track where tracks.id=multilibrary_track.track and multilibrary_track.library=1 and tracks.audio=1 and albums.id=tracks.album and tracks.id=customscan_track_attributes.track and customscan_track_attributes.module='customtag' and customscan_track_attributes.attr='COMPOSER' and customscan_track_attributes.value='{customtag}' group by albums.id order by {orderby} track track track all sql select tracks.id,tracks.title from tracks,albums,customscan_track_attributes,multilibrary_track where tracks.id=multilibrary_track.track and multilibrary_track.library=1 and tracks.audio=1 and tracks.album={album} and
Re: [SlimDevices: Plugins] COMPOSERSORT. How to activate?
Fried;610837 Wrote: > Hi, > all this doesn't work for me. > It siply will not change the order the composers are displayed. > I did the following: > > Module settings custom tag: > Module enabled - Include in automatic scans and "Scan All" > Tags to scan: COMPOSERS > Sort tag mapping: COMPOSER=COMPOSERSORT > > Module settings mixed tag: > Cleared the Field Composer tags, else nothing changed. > Build Menu with Template custom tags albums: > > Besides that it should be: Tags to scan: COMPOSER and not Tags to scan: COMPOSERS It looks correct to me, I'm guessing this was just a spelling error in your forum post ? Are you sure you have COMPOSERSORT tags in your music files ? Do you see them if you goto the Song Info page in SBS web interface and select the "View Tags" link ? -- erland Erland Isaksson ('My homepage' (http://erland.isaksson.info)) (Developer of 'many plugins/applets' (http://wiki.slimdevices.com/index.php/User:Erland). If my answer helped you and you like to encourage future presence on this forum and/or third party plugin/applet development, 'donations are always appreciated' (http://erland.isaksson.info/donate)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=85475 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] COMPOSERSORT. How to activate?
Sorry for the Typo, it is COMPOSER as you have guessed correctly. And yes, when I look into the details of a song with view tags, I see the COMPOSERSORT field correctly. I tried also to make a menu with Template custom tags albums and the COMPOSERSORT as tag, but this leeds to the error "No matching songs, albums or artists were found". -- Fried Fried's Profile: http://forums.slimdevices.com/member.php?userid=3 View this thread: http://forums.slimdevices.com/showthread.php?t=85475 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] COMPOSERSORT. How to activate?
Fried;610968 Wrote: > Sorry for the Typo, it is COMPOSER as you have guessed correctly. > And yes, when I look into the details of a song with view tags, I see > the COMPOSERSORT field correctly. > I tried also to make a menu with Template custom tags albums and the > COMPOSERSORT as tag, but this leeds to the error "No matching songs, > albums or artists were found". > Strange, are you sure Custom Scan completed its scanning or could you have shutdown SBS in the middle ? Could there be a file for the same composer that don't have a COMPOSERSORT tag ? If you don't get it to work you can send me a small file or upload it somewhere where I can get it, but based on your description it sounds like there is something else that's wrong. -- erland Erland Isaksson ('My homepage' (http://erland.isaksson.info)) (Developer of 'many plugins/applets' (http://wiki.slimdevices.com/index.php/User:Erland). If my answer helped you and you like to encourage future presence on this forum and/or third party plugin/applet development, 'donations are always appreciated' (http://erland.isaksson.info/donate)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=85475 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] COMPOSERSORT. How to activate?
Thx again Eralnd for looking into this. I have attached a small file with 2 dummy albums that represent my environment. I use the default skin for the SBS, the server running on a WHS. Music is also stored on The WHS. I have tried the custom menus on this cofiguration, it stiil won't sort the composers according to the composersort field. BTW perhaps it would be uselful to build a small test environment similar to the one I've made and publish it on the forum so everyone can test the plugin behaviour using a defined environment. I would be glad to help to do this. I have just seen that my zip file is to big for an attachment, I will send it by mail. -- Fried Fried's Profile: http://forums.slimdevices.com/member.php?userid=3 View this thread: http://forums.slimdevices.com/showthread.php?t=85475 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] COMPOSERSORT. How to activate?
Fried;611248 Wrote: > Thx again Erland for looking into this. > I have attached a small file with 2 dummy albums that represent my > environment. > I use the default skin for the SBS, the server running on a WHS. > Music is also stored on The WHS. I have tried the custom menus on this > cofiguration, it stiil won't sort the composers according to the > composersort field. > Your problem is caused by a bug in Custom Scan, currently it seems like the sort tags has also to be added to the "Tags to scan" field to make it work. So if you add COMPOSERSORT to the "Tags to scan" field it should work correctly. I'll correct it in the next Custom Scan release so this isn't necessary. Fried;611248 Wrote: > > BTW perhaps it would be uselful to build a small test environment > similar to the one I've made and publish it on the forum so everyone > can test the plugin behaviour using a defined environment. I would be > glad to help to do this. > Any help that makes it possible to test Custom Scan and/or Custom Browse is greatly appreciated. There is two parts in this: 1. Have a set of music files with various tagging and file formats. It could be really small files to save storage space as we don't need to be able to play them, we only want to test the scanning and browsing. Also, it obviously can't be audio data under copyright as that wouldn't be possible to publish without violating the copyright. 2. Have a script or something similar that can be executed after the scanning to verify the contents of the database or even better the contents of the browse menus in Custom Browse. I suspect it easier test the database contents, so it might be a good idea to start with that. Currently I have a set of music files which I've collected from various users but I don't have any automatic testing so this results in that sometimes things breaks as it just did with the sorting functionality. -- erland Erland Isaksson ('My homepage' (http://erland.isaksson.info)) (Developer of 'many plugins/applets' (http://wiki.slimdevices.com/index.php/User:Erland). If my answer helped you and you like to encourage future presence on this forum and/or third party plugin/applet development, 'donations are always appreciated' (http://erland.isaksson.info/donate)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=85475 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] COMPOSERSORT. How to activate?
Thanks Erland, all works fine now. The custom scanning (as also th normal scanning) takes quite a lot of time (SBS ca. 3h for 38000 songs, custom scan 4h+). -- Fried Fried's Profile: http://forums.slimdevices.com/member.php?userid=3 View this thread: http://forums.slimdevices.com/showthread.php?t=85475 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins