Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 09-30-2020, 02:35 PM   #1
AfterHours
Junior Member
AfterHours began at the beginning.
 
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.
AfterHours is offline   Reply With Quote
Old 09-30-2020, 03:43 PM   #2
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
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')
theducks is offline   Reply With Quote
Advert
Reply


Forum Jump

Similar Threads
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


All times are GMT -4. The time now is 09:21 PM.


MobileRead.com is a privately owned, operated and funded community.