|
Personally I wouldn't get hung up on Harry Potter being repeated in the series name and the book title. What % of books does this normally occur on? I would suggest a ridiculously miniscule amount of times. Trying to complicate your plugboards and custom column requirements just to cater for this one scenario is OTT.
If you really can't sleep at night because Harry Potter appears twice, then do this - put the title as it needs to be for metadata lookups, do your metadata downloading to get your cover how you like it, and then rename the title to shorten it to remove Harry Potter from the front. That way you don't need to have a custom column with a shortened title in it, and can just use a standard plugboard that appends the series and title.
|