Jayne Castle messed me up!
I had started this evening with a "text, column shown in tab browser" (as even though it's for series info I didn't want the numbers). Thank goodness I sorted as series order and started with "A" because some of her books are Arcane
and Rainshadow, World of Harmony/Ghost Hunters, plus part of a trilogy! I was only 4 or 5 books in when I had to delete that column and create one that had comma separated text so it would handle more than one thing (you cannot simply change the column type, so I learned something new today).
I am actually amazed by how many books are affected by moving "extra" series info out of regular tags to my new "Ancillary" column. All those Tule Publishing books set in the fake town of Marietta that are also part of a multi-author series and sometimes their own series. (I have the ones by Kat Latham and Nicole Helm, possibly a few others I haven't gotten to yet).
Authors need to pick one series per book and stick to it
Kidding.
But it can be a PITA.
It was work to set up the new "Calibre Library" which was totally an unnecessary step. If I'd skipped it I would be done already. But I'm happy I did it. It feels like my virtual bookshelves have been dusted and and I am setting them to order.
I'm still working on the main library which should be the most time consuming. Then I'll check on my Vault library (there may be some books there that have dual series, but it won't be nearly as many) and Undetermined library (since these are all unread I may have to double-check the authors' websites, etc).
Then it's a matter of updating the info in my Warehouse library to match. I'm adding all of the changes to a Word document as I go so that will be easy.
Basically all I am doing is taking extra series info out of the regular tags and moving it to the custom column and then polishing the books. That's much less time consuming than adding new books.
I figure it will take me until tomorrow to get it all done. But I'm actually having fun getting it all 100% straightened out
. I've been pretty anal about my tags from the start so that certainly helps.
I and still debating if I should leave the Psy/Changeling and Psy/Changeling Trinity series alone since I have them combined in a virtual library and it seems redundant to me to add "Psy/Changeling" again to all of those books and short stories
. I am leaning toward just leaving it blank as this was more to fix connected series with unrelated names. (FTR, I actually have them listed as "Psy/Changeling Season 1: Silence" and "Psy/Changeling Season 2: Trinity" so that is already long enough
) The only benefit to adding a new tag would be to get them all to display in the same tag folder in Calibre Companion, but that's already easy enough to do with the author name. So, yeah, I will probably leave it blank.
ETA: I decided it looked weird blank so I added "Psy/Changeling" to the new column. I am still of two minds about it, but I suppose it is more consistent with my "rules."