View Single Post
Old 09-29-2019, 09:35 AM   #5
Sirtel
Grand Sorcerer
Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.
 
Sirtel's Avatar
 
Posts: 13,503
Karma: 240526511
Join Date: Jan 2014
Location: Estonia
Device: Kobo Sage & Libra 2
Quote:
Originally Posted by Rellwood View Post
I have used the Job Spy custom column for all libraries matrix and (I'm so embarrassed) I have 46 active libraries. I use about half of them regularly. I finally broke up my "Main" library because it was getting out of control with all the metadata I throw in it. So I have libraries for each source, which re really stripped down to dates added, Original file Names, and sources. I kick books to those after importing them into Calibre.

Then libraries for Active reading - Series to read, Re-reads, Archived, Merged, Anthologies, etc.

And finally I have about 20 old libraries used for data mining or finding lost books. It's the old ones that have the wonky columns. Libraries with names like "October 2016 Main Library" or "Toshiba ML 2" where there is a grab bag. I have gone into them all and kind of weeded through them. But I am still left with some 2000 columns overall.

Also some libraries have columns others don't. I have 6 date read columns for my Re-reads and 3 extra series columns for my Series to Read. So copying and moving isn't a great idea. Plus I did that when I split my library up initially, and I ended up changing the columns.

Don't get me started on GoodReads syncing. Most of my major libraries have around 45 columns (including composite), the least I have is maybe 20. Pages, ratings, shelves, tags, genre - then my columns for just holding badges so I can skim down the list and see what's going on across without having to move the cursor. There are two columns for that alone.

then there are those set choice columns that have been altered across the years. So the columns may have the same heading and name, but the choices can be different. Read status and book styles are some that come to mind. I don't want to keep typing in, so I just use the drop down list. I have expanded them over time.

That was a long way of saying - I have almost 2000 active columns and I can see where they are being mixed up when I look at the exported .csv from Job Spy. I just want to go into the .db and quickly retype those names.


Don't even get me started on the hundreds of inactive libraries I just moved to an external drive to use with Calibre Portable. I haven't even linked them yet.
Hmmm... my condolences (I think).

Why you should feel the need to put your books in so many separate libraries, is a mystery for me. It's much easier to use virtual libraries or saved searches based on tags or custom columns. I do have separate libraries for sending books to my Nook and Kobo devices, but only because I send somewhat different versions of epub to each. My main library has always been the one and only (besides backups, of course).
Sirtel is online now   Reply With Quote