![]() |
#1 |
Junior Member
![]() Posts: 1
Karma: 10
Join Date: Sep 2020
Device: Calibre on Windows 10
|
Where can I find "author_name_suffixes" in recovered database
I entered a million of these "author_name_suffixes" in my Win10 Calibre program's settings (Preferences > Advanced > Tweaks > Author sort name algorithm) before my Windows 10 User Profile was corrupted back in March 2020. I recovered the old metadata.db of the library along with many of the configuration files and saved these to a backup drive. I've scanned these files by opening copies of them in Notepad++ but can't find my custom prefixes anywhere. All of the books I had & their Calibre folder structure was corrupted or lost but I had the books backed up to the cloud in pdf format w .opf files. I am now running Calibre 4.23.0. The built-in functions to open the metadata.db file aren't working out for me and I've also tried opening the old database in DB Browser for SQLite to no avail. I'm really just looking for a little bit of text, as I had customized these prefixes substantially over time.
Thanks in advance. |
![]() |
![]() |
![]() |
#2 |
Well trained by Cats
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 31,047
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
The suffix just affects processing (sorts)
The TWEAK tool is a front end to the file tweaks.py found in the settings folder Code:
#: Author sort name algorithm # ID: author_sort_copy_method # The algorithm used to copy author to author_sort # Possible values are: # invert: use "fn ln" -> "ln, fn" # copy : copy author to author_sort without modification # comma : use 'copy' if there is a ',' in the name, otherwise use 'invert' # nocomma : "fn ln" -> "ln fn" (without the comma) # When this tweak is changed, the author_sort values stored with each author # must be recomputed by right-clicking on an author in the left-hand tags pane, # selecting 'manage authors', and pressing 'Recalculate all author sort values'. # The author name suffixes are words that are ignored when they occur at the # end of an author name. The case of the suffix is ignored and trailing # periods are automatically handled. The same is true for prefixes. # The author name copy words are a set of words which if they occur in an # author name cause the automatically generated author sort string to be # identical to the author name. This means that the sort for a string like Acme # Inc. will be Acme Inc. instead of Inc., Acme author_sort_copy_method = 'invert' author_name_suffixes = ('Jr', 'Sr', 'Inc', 'Ph.D', 'Phd', 'MD', 'M.D', 'I', 'II', 'III', 'IV', 'Junior', 'Senior') author_name_prefixes = ('Mr', 'Mrs', 'Ms', 'Dr', 'Prof') author_name_copywords = ('Corporation', 'Company', 'Co.', 'Agency', 'Council', 'Committee', 'Inc.', 'Institute', 'Society', 'Club', 'Team') |
![]() |
![]() |
Advert | |
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to fix "Extra Titles" in Database in " Check Library - Problems Found | millan | Library Management | 33 | 07-16-2015 07:12 AM |
Kobo Aura HD: "database disk image is malformed" | cbrace | Devices | 3 | 01-21-2014 05:38 AM |
How to Find a 6" While Site is "Under Repairs" | jenifer.ezread | Astak EZReader | 31 | 10-29-2010 11:54 PM |
"Database Disk Image is malformed" when connecting to Calibre after adding new books | djorkboy | Calibre | 1 | 10-06-2010 08:59 PM |