At the moment I'm just writing a SQL script that looks for common issues and outputs the book's id, and the new title and author. It's progressing quite well as roughly half the books that couldn't be found are now found (we're talking 1000's).
Regexp : I can't quite see how to use regexp with sqlite - it seems I have to write it myself which seems a bit tough. This is a shame as I could write some quite fancy checks that might clear another few 100 items.
When I'm finished I'll just pass on the script and hopefully someone else will be able to put it into an add-on etc.
|