08-06-2014, 02:37 PM | #16 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
ABC is designed to be used in the Tag Browser, and to be treated just like Tags are. It also can work hand-in-hand, if desired, with the ABC Hierarchy plugin. Both text values are combined for synergy.
Extract from the OP's Installation Notes: 1. Calibre > Preferences > Custom Columns > Add a new custom column called "author_book_count" with a title of "ABC" and with the default "text, with column shown in the tag browser". Uncheck the new column to hide it. Save your work and restart Calibre. 2. Calibre > Preferences > Plugins > Load Plugin from File and load the attached zip file. Save your work and restart Calibre. 3. Calibre > Preferences > Toolbar > Main Menu Toolbar and then add the icon for Author Book Count. Save your work. Close the window. 4. If you don't want to see the count in the Book Details view, go to Calibre > Preferences > Look and Feel > Book Details and customize the view to your taste. 5. The Calibre tag-browser defaults to sorting by Text instead of by Numbers within Text. To change this: Calibre > Preferences > Tweaks > Recognize Numbers Within Text When Sorting > and set numeric_collation = True. Last edited by DaltonST; 08-06-2014 at 02:54 PM. |
08-06-2014, 03:10 PM | #17 | |
eBook Junkie
Posts: 1,526
Karma: 1464018
Join Date: May 2010
Location: USA
Device: Kindle Fire 2020, Kindle PW2
|
Quote:
|
|
08-07-2014, 09:25 AM | #18 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
ABC Version 2.0.0 Released
Just for you, new in Version 2.0.0:
Optionally, you may create a second new custom column called “abc_numeric”. Choose the type as “integer”. This custom column will be populated with the integer version of author_book_count, but only if the column exists. Search criteria valid only for integers would then be possible, such as: #abc_numeric:">7" |
08-07-2014, 09:18 PM | #19 | |
eBook Junkie
Posts: 1,526
Karma: 1464018
Join Date: May 2010
Location: USA
Device: Kindle Fire 2020, Kindle PW2
|
Quote:
|
|
08-09-2014, 06:52 PM | #20 | |
Enthusiast
Posts: 31
Karma: 10
Join Date: Aug 2011
Device: none
|
THANKS
Great! I am looking forward to playing with it and will post some observations there soon.
Quote:
|
|
08-10-2014, 12:20 PM | #21 |
Resident Curmudgeon
Posts: 73,998
Karma: 128903378
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
|
Does ABC take into account Amazon's odd way of using last name, first name for author names? For example, would it find King, Stephen as a match to Stephen King?
|
08-10-2014, 12:41 PM | #22 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
It does not match anything to anything. It uses whatever Authors exist for each book. Bear in mind that although an Author may look like "Smith, George", Calibre stores it as "George Smith" in the name column of the authors table. "Smith, George" would be stored in the sort column of the authors table. ABC uses whatever Calibre has. Period.
In my Test Library, for example, Author ID 192 is (name,sort): "Brian W. Aldiss","Aldiss, Brian W." If a user somehow has tweaked or changed Calibre to make the name the same as the sort, then ABC would still use the value stored in the name column. It uses what Calibre uses for Author name. If "Brian W. Aldiss" is sometimes "Brian Aldiss" and also sometimes "Brian Wilson Aldiss" in your Calibre library, then there would be three (3) different ABC counts for him because there would be three (3) different versions of the same human being's name. Obviously, standardization of Author names is recommended via the excellent tools already available within Calibre. However, such standardization is totally out of the scope of ABC, which just counts books written by each Author in the authors table. It is up to the Calibre user to standardize their own libraries if they so choose. |
08-10-2014, 09:23 PM | #23 | |
Resident Curmudgeon
Posts: 73,998
Karma: 128903378
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
|
Quote:
Would these come out as the same author? I would hope so. |
|
08-11-2014, 08:00 AM | #24 | |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Books by Identical Author Share Identical Author Name Path in Library Folder
Quote:
You can answer this for yourself. For each book, with your mouse click the Path shown on the right side of Calibre's main screen within the Book Details. Note the name of the author embedded within the Path to the ebook. If the two books have the identical author from the perspective of Calibre, then they will share the same Path down to the author embedded within the Path. If not, they will be different. I would bet that these are analogous to the patterns to your Paths: "C:\Users\Public\Public eBooks\Calibre\Mariotte, Jeff\ABookName1(99999)\ABookName1 - Mariotte, Jeff.epub" "C:\Users\Public\Public eBooks\Calibre\Jeff Mariotte\ABookName2(99999)\ABookName2 - Jeff Mariotte.epub" If your 2 books are not within the same author-name subdirectory, then as far as Calibre is concerned, they do not have the same author. Calibre rules. ABC certainly uses who Calibre says is the author of each book based on the author id linked to each book in the books_authors_link table in the metadata.db database. 2 ids means 2 different authors. Period. Jeff Mariotte is also known as Jeffrey J. Mariotte. If you own his book River Run Red, check that book too. It will have yet a third different author as far as Calibre is concerned. This is the Plugin forum, not the Library Management forum, so I suggest that you get help in standardizing your author names from Library Management. Kiwidude's Quality Check plugin will gladly fix your author names having commas for you, resulting in Jeff Mariotte and Mariotte, Jeff being merged into a single Calibre author, Jeff Mariotte. If you want Jeff Mariotte merged with Jeffrey J. Mariotte, you will have to manually edit your author metadata. I suggest using Calibre > Alter Tag Browser > Manage Authors, Tags, etc. > Manage Authors. This tool could also be used to change Mariotte, Jeff into Jeff Mariotte, since Calibre places each unique author name on its own line within the Manage Authors tool. That would also be a way to prove that Calibre views the latter author names as different authors. After changing the author names, recheck the Paths to their books. They should be in the same parent author name directory/folder, such as "C:\Users\Public\Public eBooks\Calibre\Jeff Mariotte\..........................". The books would have the identical author id at that point. |
|
08-25-2014, 02:39 PM | #25 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
ABC Job Failure Caused by Corrupt metadata.db & How to Repair It
This is a "note to file" type of post regarding advice about resolving an ABC issue that may occur if your Calibre metadata.db ever becomes corrupted. The ABC job will fail with messages similar to those shown below, although the specific custom_column_n table will likely be different(i.e., not 4, but whatever was the next number available when you configured the custom column author_book_count).
To resolve the job failure as shown below, Quick Switch to the Calibre library that has the issue shown below, and then from the menu click: Library > Library Maintenance > Check Library. Calibre will do a Vacuum of your metadata.db in order to defragment it. It will then (if you allow it, which you should) compare what your metadata.db says should be in your library directory structure, and vice-versa. Let it fix all problems it finds, and then rerun Library > Library Maintenance > Check Library until there are no more errors to fix. It is a very good idea to run Library > Library Maintenance > Check Library at least once a month or so just on general principles. The particular Calibre library for which the job shown below failed had duplicate book/author entries in its metadata.db and metadata for books that did not exist in the directory structure. Library > Library Maintenance > Check Library repaired it. ------------------------------------------------------------------- Example: Job Failure Caused by Corrupt metadata.db ------------------------------------------------------------------- Starting job: Author Book Count ================================================== == Job: "Author Book Count" failed with error: Traceback (most recent call last): File "site-packages/calibre/gui2/threaded_jobs.py", line 83, in start_work File "calibre_plugins.author_book_count.main", line 57, in Get_all_author_book_counts File "calibre_plugins.author_book_count.main", line 81, in Refresh_author_book_count File "calibre_plugins.author_book_count.main", line 232, in Refresh_books_custom_column_x IntegrityError: Foreign key violation: value not in custom_column_4 Called with args: (, ) {u'notifications': , u'abort': , u'log': } ------------------------------------------------------------------- |
06-21-2015, 06:24 PM | #26 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
ABC Version 2.1.1 - Miscellaneous Performance Tweaks
Version 2.1.1 of ABC has been released. Upgrade to this version is highly recommended.
DaltonST |
11-24-2016, 04:09 AM | #27 | |
Fanatic
Posts: 515
Karma: 1470724
Join Date: Jul 2013
Location: Quebec CA
Device: android 4 (samsung tablet and asus tablet)
|
Quote:
|
|
11-24-2016, 12:57 PM | #28 |
Resident Curmudgeon
Posts: 73,998
Karma: 128903378
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
|
|
02-08-2017, 04:57 AM | #29 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
Can I use this plugin to do the following:
Compare the amount of stories based on the author column in calibre and an author ID Column. The Author ID column is an Custom column which is has the setup of a tags column? If not, is it possible to add it? Thanks Last edited by Tanjamuse; 02-08-2017 at 05:30 AM. |
02-08-2017, 06:15 AM | #30 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
My Author Book Count Hierarchy plug-in does co-author relationships already.
DaltonST |
Tags |
plugins |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
[GUI Plugin] Count Pages | kiwidude | Plugins | 1750 | 04-07-2024 01:20 AM |
[GUI Plugin] Copy book covers as Standby images (Sony/Kindle/Nook) | jackie_w | Plugins | 136 | 06-18-2020 03:27 AM |
[GUI Plugin] Manage Sony x50 Reader Book List | kpw | Plugins | 170 | 10-02-2014 08:23 PM |
[GUI Plugin] Plugin Updater **Deprecated** | kiwidude | Plugins | 159 | 06-19-2011 12:27 PM |
[GUI Plugin] Book Sync **Deprecated** | kiwidude | Plugins | 111 | 06-07-2011 07:47 PM |