When doing this kind of post processing you should be aware of that SlimServer can perform scanning of parts of the library. As an example this happens if choose to perform a scanning with "Look for new and changed music" or when you use the Browse/Music Folder to browse to a track that isn't in the SlimServer database.
The problem with this is and the genre post processing are doing is that you will probably end up with duplicate genres. This is what will happen: 1. On first SlimServer rescan "B_Renaissance" is created 2. Your post processing script runs and change this to "Renaissance" 3. When you browse Music Folder or perform a scan of new/changed files that contains a "B_Renaissance" genre this will result in a completely new "B_Renaissance" genre 4. Your post processing script runs and change this to "Renaissance". The result with this is that you will have two "Renaissance" genres in the database and both these will also be shown in the browse menus, when selecting one of the "Renaissance" genres you will se the old music and when selecting the other you will see the "Renaissance". The genres are stored with and id and name in the database, the id is used when browsing. I think you will be fine if you change the namesort column instead of the name column as JJZolx suggested, but I'm not completely sure. You could also of merge the duplicate genres in your post processing script, to do this you have to remove the duplicate entries from the genres table and also change the id's in the genre_track table, but this results in a bit more complex script. Everything will of course also work perfectly as long as you only perform full rescans and never use "Browse/Music Folder" to find new music. I think you also might have problem if you are using the iTunes or MusicIP integrations to scan your music, but I'm not completely sure about this. Is there a reason why you have the "ALTER TABLE" statements in the script ? Isn't the update possible to run towards a BLOB column ? -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and RandomPlayList plugins' (http://wiki.erland.homeip.net/index.php/Category:SlimServer)) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=35876 _______________________________________________ ripping mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/ripping
