Help with tricky library merge
I can describe clearly what I want to achieve, but I can't quite figure out a recipe.
Consider two libraries: Main and Other. Main has about 9000 books, with clean metadata and good epubs. Other has about 700 books, with decent metadata and no actual formats at all. By guesstimate, about half of the rows in Other are in Main.
What I would like to end up with is that everything in Other ends up in Main, with a tag (e.g. #fromOther) -- but if it was already in Main, it should just get the #fromOther tag added to the existing record.
I know I'm going to have to do a little hand-tidying of duplicates, where the metadata isn't close enough for the importer to auto-match -- but I don't want to hand-tidy all 700.
Thoughts? Thanks.
|