View Single Post
Old 11-25-2015, 07:40 PM   #34
Gary_M_Mugford
Groupie
Gary_M_Mugford has a complete set of Star Wars action figures.Gary_M_Mugford has a complete set of Star Wars action figures.Gary_M_Mugford has a complete set of Star Wars action figures.
 
Gary_M_Mugford's Avatar
 
Posts: 180
Karma: 299
Join Date: Jul 2010
Location: Brampton ON
Device: Kobo, Kindle3
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
Gary_M_Mugford is offline   Reply With Quote