author sort

Rellwood · 01-23-2022, 05:17 PM

Is there a place in the Calibre folders/.db files anywhere where the author sort is listed? for the information found in manage authors. I would like to find it and somehow copy it over to other areas so that all the author sorts are the same in all libraries. I hope that makes sense.

It's easy for me to copy from one place to another exactly, my file manager and other programs make it so that whatever I am copying over will be precise, so it's not a problem.

I'm weeding out old libraries and making catalogs, but I want to make sure all the sorts are the same values as the ones in my main library. Some authors end up sorting differently.

Thanks!

itimpi · 01-23-2022, 05:59 PM

Author Sort values are only stored in the database associated with a given library.

davidfor · 01-23-2022, 10:15 PM

As @itimpi said, the author name and sorts are stored in the database. It's possible that one of @DaltonST's plugins has something for this. Otherwise, you could extract the data and create an update to apply to the other databases. If you have any SQL knowledge, it would not be that hard. But, keeping them in sync is going to be an ongoing problem.

theducks · 01-24-2022, 04:35 AM

There is no way to match a table between Libraries.
All these kinds of values are assigned as used, and deleted when no longer needed. They all have index numbers that are what is link-referenced by a book, not the actual value.
No books, No Authors (or sorts),No Publishers, No Tags, Nothing to populate pick lists until once used and still in use.

davidfor · 01-24-2022, 09:01 PM

Honestly, I wouldn't have suggested it if I hadn't checked. There is no need to use the ids as we want to update the author sort associated with an authors name.

The rough steps are:

Export the 'authors' table to a file.

Edit the file to produce update statements. Each would look like:

Code:

UPDATE authors SET sort = '<sort value from file>' WHERE name = '<name value from file>';

Run each of these statements on the other database. If the author exists, it gets updated. If it doesn't, nothing will happen.

I don't really suggest it, as it needs to be redone as you add books with new authors the libraries. But, as a one off to clean up past crimes, it would work. And if course, anyone who did this, would need to make sure they knew what they were doing and had a good backup.

01-23-2022, 05:17 PM	#1
Rellwood Library Breeder (She/Her) Posts: 1,300 Karma: 1937893 Join Date: Apr 2015 Location: Fullerton, California Device: Paperwhite 2015 (2), PW 2024 (12 GEN), PW 2023 (11 GEN), Scribe (1st)	author sort Is there a place in the Calibre folders/.db files anywhere where the author sort is listed? for the information found in manage authors. I would like to find it and somehow copy it over to other areas so that all the author sorts are the same in all libraries. I hope that makes sense. It's easy for me to copy from one place to another exactly, my file manager and other programs make it so that whatever I am copying over will be precise, so it's not a problem. I'm weeding out old libraries and making catalogs, but I want to make sure all the sorts are the same values as the ones in my main library. Some authors end up sorting differently. Thanks!

01-24-2022, 09:01 PM	#5
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	Honestly, I wouldn't have suggested it if I hadn't checked. There is no need to use the ids as we want to update the author sort associated with an authors name. The rough steps are: Export the 'authors' table to a file. Edit the file to produce update statements. Each would look like: Code: UPDATE authors SET sort = '<sort value from file>' WHERE name = '<name value from file>'; Run each of these statements on the other database. If the author exists, it gets updated. If it doesn't, nothing will happen. I don't really suggest it, as it needs to be redone as you add books with new authors the libraries. But, as a one off to clean up past crimes, it would work. And if course, anyone who did this, would need to make sure they knew what they were doing and had a good backup.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sort by author and then publish date (multi-column sort)?	badbob001	Library Management	7	07-22-2020 06:45 PM
Sort by Author doesn't then sort by title	jmcging	Library Management	7	07-02-2017 10:16 PM
'Title Sort' & 'Author Sort' Search/Report	Funkybassman	Calibre	3	04-17-2016 12:31 PM
Update 'title sort' and 'author sort' through CLI	wladdy	Library Management	1	07-16-2015 05:12 PM
author → author sort ∀ books ⇒ long time!	Geremia	Calibre	2	04-17-2013 09:57 AM

01-23-2022, 05:59 PM	#2
itimpi Wizard Posts: 4,553 Karma: 950151 Join Date: Nov 2008 Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)	Author Sort values are only stored in the database associated with a given library.

01-23-2022, 10:15 PM	#3
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	As @itimpi said, the author name and sorts are stored in the database. It's possible that one of @DaltonST's plugins has something for this. Otherwise, you could extract the data and create an update to apply to the other databases. If you have any SQL knowledge, it would not be that hard. But, keeping them in sync is going to be an ongoing problem.

01-24-2022, 04:35 AM	#4
theducks Well trained by Cats Posts: 31,201 Karma: 60406678 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	There is no way to match a table between Libraries. All these kinds of values are assigned as used, and deleted when no longer needed. They all have index numbers that are what is link-referenced by a book, not the actual value. No books, No Authors (or sorts),No Publishers, No Tags, Nothing to populate pick lists until once used and still in use.

Advert

Advert