Help with tricky library merge

[lairdb]

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.

[theducks]

Originally Posted by lairdb

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.

That term is not what we commonly use here for anything other the fetching news type pages.
Templates are used to control ADDING from FILES

BUT there is another way
2 things to make the project KISS

re: Tag (btw starting with a # might be confusing to some as Custom Colum lookup names MUST start with #)


preTag the original (other) Use Bulk Mode MDE to tag all desired books

Set Preferences: Adding Books (2 items) what to do when using Copy To Library AND decide What AUTOMERGE MODE to use

Then you aer ready to do it!
Select books in 'other': Right click Copy To Library: <destination>