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 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.
------------------------------------------------------------------------
gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115
View this thread: http://forums.slimdevices.com/showthread.php?t=103454
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
