[GUI Plugin] Author Book Count Hierarchy

[DaltonST]

Originally Posted by mariaclaudia

How can I do it for all the authors? There are 2,485

I did not say to do it for all of the authors. I said:

The job log proves that there are 39 corrupt authors.

You must select all of the books for all of those 39 corrupt authors.

Easy way to do that: run the MultiColumnSearch as for before, but this time check the checkbox "All Authors" also. It will select all of the books for all of the 39 authors.

Then, do what I said in my previous post about changing the author names, and then changing them back.

Check the ABCH log again. Also, run MCS again to see how many are left.

You must do it for all of the books, good or bad, for all of the 39 authors.

All books, good and bad, for each author, must be done simultaneously.

If an author has 3 bad books and 1 good book, and you just fix the 3, then it will not work. You must fix all 4 at the identical time using Bulk Edit Metdata.

Please reread my posts above.


DaltonST

[mariaclaudia]

I do it before, but now I found that some books with 2, 3 or 4 authors, one of them have the issue, the others not. Honestly, I'm feel sad about this situation, you help me very patiently, and I take much of your time

[DaltonST]

@mariaclaudia:

Find all of the books for all of the authors that MultiColumnSearch says are bad. Fix them as discussed above.

After fixing them, run the ABCH job.

How many corrupt authors are left? There were 39. How many now?

You could copy the remaining books for the remaining authors to the new library, delete them from the old library, and then copy them back again.

Or, you could export the books via Save to Disk, and then delete them from Calibre. Then, import them.


DaltonST

[DaltonST]

@mariaclaudia:

If you copy and paste the following code into the DB Browser for SQLite "Execute SQL" Tab as shown in the attached image, and then run it via the >>> button, it will fix some or all of your corrupt authors. After running it, you must click the "write changes" button at the top.

Obviously, you should not be running Calibre when you do this.

If you have an author with 2 entries in the authors table, 1 correct and 1 corrupt, this will not be able to change the corrupt entry because there is already a correct entry. In that case, you must manually change the bad author as described in previous posts.

UPDATE OR IGNORE authors 
SET name =  REPLACE(name,',','|') 
WHERE name = sort
   AND name NOT LIKE '%| %'
   AND name LIKE '%, %'
   AND name NOT LIKE '%, Jr%' 
   AND name NOT LIKE '%, Sr%' 
   AND name NOT LIKE '%, PhD%' 
   AND name NOT LIKE '%, Ph.D%' 
   AND name NOT LIKE '%, MD%' 
   AND name NOT LIKE '%, M.D.%' 
   AND name NOT LIKE '%, Junior%' 
   AND name NOT LIKE '%, Senior%'

Please try this in your "new" library first. If it works for you, it will be safe to do in your "real" library.


DaltonST

[mariaclaudia]

First of all I want to thank you for the time you've offered to help and your patience with me, because although I can write well in English, and even use a translator to understand what you've written, sometimes I do not understand well the context. Thank you so much. I had not answered before, because I was ashamed to have followed in his footsteps and not achieve the expected results, and maybe it could be because he had done in the past an unfortunate action, and now the consequences are these, and yet were still helping me.

That said I tell you that finally the issue was solved. I executed ABCH twice, in both cases I checked the corresponding log, and then executed MCS for errors, and in all cases, zero matches.

It's very simple these words "thank you very much", but I offer you with sincere appreciation.

Best regards from Lima, Perú
Blessings

and of course, sorry my grammar, I always checked it with Google Translator, so if there's a mistake, it's not mine, it's Google

[JGB]

So for a given count(eg 10 books)
it seems to mix the authors up who have that many books published.
Is there a way to have a sort priority.
EG: Sort on ABC column first, then within that sort sort by author?

So it would go
Bob title 10
bob title 10
bob title 10
fred title 10
fred title 10
george title 10
george title 10

instead of
bob title 10
bob title 10
george title 10
fred title 10
bob title 10

[DaltonST]

Neither ABC nor ABCH have anything to do with sorting your library view. That is a standard Calibre function and a View Manager plug-in function.


DaltonST

[DaltonST]

Version 1.1.9 - 26 May 2019 Python 3 compatibility; minimum Calibre version now 3.41.3. If necessary, upgrade Calibre first.



DaltonST

[DaltonST]

Version 1.2.0 - 23 July 2019 Miscellany


DaltonST

[DaltonST]

Version 1.2.1 - 16 December 2019 Technical Tweaks after compiling with Python 3.8

[DaltonST]

Version 1.2.2 - 19 December 2019 Technical changes after Python 3.8 testing with Calibre 4.99.2

DaltonST

[DaltonST]

Version 1.2.3 - 18 December 2020 Miscellany.


DaltonST

[DaltonST]

Latest ABCH Version Works Fine in Calibre 5.99.3 for Qt6.


DaltonST

[madame_newbie]

Hi, sorry but this plugin had stopped working for me since I upgraded to calibre 6.15+. The ABC plugin works but the ABC_Hierarchy doesn't calculate and shows 0 authors counted.

Exception in Execute_mysql_with_commit_generic(my_db, my_cursor, mysql, log)
table custom_column_45 has 3 columns but 2 values were supplied
INSERT OR IGNORE INTO custom_column_45 SELECT id, abc FROM zabc WHERE id > '0' ;
Job Failure. Terminated.
Custom_Column Tables Populated

It gave me this in the jobs box.

[DaltonST]

Originally Posted by madame_newbie

Hi, sorry but this plugin had stopped working for me since I upgraded to calibre 6.15+. The ABC plugin works but the ABC_Hierarchy doesn't calculate and shows 0 authors counted.

Exception in Execute_mysql_with_commit_generic(my_db, my_cursor, mysql, log)
table custom_column_45 has 3 columns but 2 values were supplied
INSERT OR IGNORE INTO custom_column_45 SELECT id, abc FROM zabc WHERE id > '0' ;
Job Failure. Terminated.
Custom_Column Tables Populated

It gave me this in the jobs box.

Version 1.2.5 - 15 April 2023 Links now in normalized custom column tables.




DaltonST