gharris999 wrote: > PasTim: Have you looked at the records in the CONTRIBUTORS table? That > might give you a clue as to what's going on with the scan. The easiest > way I've found to do that is to copy the SQLite library.db from the LMS > cache folder to a windows machine and then use the free SQLite browser > software from http://sqlitebrowser.org/ > > If you can figure out what's going on with the scan and offer a bug-fix, > that would, of course, be preferable to the work-around kludge of using > PostScan. > > But, if it comes to it, and before you start, as you say, "committing to > hundreds of PostScan patches", please be aware that PostScan allows you > to do regular expression based search and replace in update queries. > So, for instance, I tag my genres with entries like: > > a_Medieval > b_Renaissance > c_Early_Baroque > > ..etc. Any genres that don't have a alpha_ prefix, I like to ghettoize > to the bottom of the genre list. This generalized update query does the > trick: > > Code: -------------------- > > > UPDATE genres > SET namesort = psreplace(namesort, 's/^(.*)$/"ZZZZZ $1"/') > WHERE namesort != psmatch(namesort, 'm/^([[:alpha:]])\1* .*$/') and name != 'No Genre'; > -------------------- > > > > Also, you can use case-based queries. E.g.: > > Code: -------------------- > > > UPDATE genres > set name = CASE > when name = 'English Italian Baroque' then 'Italian & English Baroque' > when name = 'Italian and English Baroque' then 'Italian & English Baroque' > when name = 'Spanish Latin American Baroque' then 'Spanish & Latin-American Baroque' > when name = 'Spanish and Latin-American Baroque' then 'Spanish & Latin-American Baroque' > when name = 'Post-Romantic-Nationalist' then 'Post-Romantic Nationalist' > when name = 'Central European Modernism' then 'Central-European Modernism' > when name = 'Italian-Spanish Modernism' then 'Italian & Spanish Modernism' > when name = 'American-English Modernism' then 'English & American Modernism' > when name = 'English and American Modernism' then 'English & American Modernism' > when name = 'Post Modern Contemporary' then 'Contemporary Post-Modernism' > when name = 'Post Modern Aleatoric' then 'Aleatoric Post-Modernism' > when name = 'Post Modern Minimalist' then 'Minimalist Post-Modernism' > when name = 'Jazz and Blues' then 'Jazz & Blues' > Else name > End ; > -------------------- > > > > So..rather than having to have hundreds of individual PostScan update > queries, you may be able to generalize them down to a handful. Thanks very much. I had no idea PostScan supported regex. If it comes to that I will see if I can use that to set my namesorts.
Meanwhile I will try to understand what is going on with my namesort fields. LMS 7.9 on VortexBox Midi, Xubuntu 14.04, FLACs 16->24 bit, 44.1->192kbps. LMS & Squeeze2upnp to MF M1 CLiC (to MF amp & ESLs) & Marantz CR603 UPnP renderers. Minimserver (server) & upplay (control point) to same renderers & to upmpdcli/mpd PC renderers. Squeezelite to Meridian USB Explorer DAC to speakers/phones. Wireless Xubuntu 14.04 laptop with firefox/upplay or Android 'phone with Squeeze-Commander/BubbleUPnP controls LMS/Minimserver. Have a Touch with EDO, and a spare, but don't use. ------------------------------------------------------------------------ PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642 View this thread: http://forums.slimdevices.com/showthread.php?t=103454 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
