|
Fair enough ....
You DID warn me. I am guilty of not having read the instructions thoroughly enough.
Accepted.
Having said that, can you help me? I need to compare two columns and mark the ones that fail to be equal. Something along the lines of (pseudo code follows, NOT operational code)
strcmp('title','#origtitle',lt,eq,gt) <> eq
or
select * from library where (uppercase(title) <> uppercase(origtitle))
MCS does already find the ones where a SERIES of books got renamed to one or another volume in the series. That happened in 1.3 per cent of the instances in my test data. But unfortunately, mass metadata downloading is failing in other ways, renaming books to something completely unrelated. Sometimes taking a non-fiction book and having it be something very fictional and very different. Those errors push the error in mass metadata downloading in my test sample to something in excess of 7 per cent. Which is NOT good.
But MCS might be able to find those problems and let me fix them, making the use of mass metadata downloading a worthwhile endeavour.
Thanks again, GM
|