Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Plugins

Notices

Reply
 
Thread Tools Search this Thread
Old 06-10-2016, 08:21 PM   #46
DaltonST
Deviser
DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!
 
DaltonST's Avatar
 
Posts: 1,294
Karma: 100614
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
Quote:
Originally Posted by mariaclaudia View Post
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:

Quote:
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
DaltonST is offline   Reply With Quote
Old 06-10-2016, 08:36 PM   #47
mariaclaudia
Zealot
mariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of light
 
Posts: 149
Karma: 12316
Join Date: Jul 2014
Device: none
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
mariaclaudia is offline   Reply With Quote
Advert
Old 06-10-2016, 08:44 PM   #48
DaltonST
Deviser
DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!
 
DaltonST's Avatar
 
Posts: 1,294
Karma: 100614
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
@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 is offline   Reply With Quote
Old 06-11-2016, 11:41 AM   #49
DaltonST
Deviser
DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!
 
DaltonST's Avatar
 
Posts: 1,294
Karma: 100614
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
@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.


Code:
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
Attached Thumbnails
Click image for larger version

Name:	abch_sql.jpg
Views:	127
Size:	225.0 KB
ID:	149340  

Last edited by DaltonST; 06-11-2016 at 11:56 AM. Reason: Added info.
DaltonST is offline   Reply With Quote
Old 06-12-2016, 11:17 AM   #50
mariaclaudia
Zealot
mariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of lightmariaclaudia is a glorious beacon of light
 
Posts: 149
Karma: 12316
Join Date: Jul 2014
Device: none
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
mariaclaudia is offline   Reply With Quote
Advert
Old 10-17-2017, 09:07 PM   #51
JGB
Groupie
JGB ought to be getting tired of karma fortunes by now.JGB ought to be getting tired of karma fortunes by now.JGB ought to be getting tired of karma fortunes by now.JGB ought to be getting tired of karma fortunes by now.JGB ought to be getting tired of karma fortunes by now.JGB ought to be getting tired of karma fortunes by now.JGB ought to be getting tired of karma fortunes by now.JGB ought to be getting tired of karma fortunes by now.JGB ought to be getting tired of karma fortunes by now.JGB ought to be getting tired of karma fortunes by now.JGB ought to be getting tired of karma fortunes by now.
 
Posts: 168
Karma: 1010000
Join Date: Jul 2008
Device: PRS505
My authors seem to get jumbled up

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

Last edited by JGB; 10-17-2017 at 09:10 PM. Reason: Oops psoted to wrong thread, meant to post to ABC not ABCH
JGB is offline   Reply With Quote
Old 10-17-2017, 09:38 PM   #52
DaltonST
Deviser
DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!
 
DaltonST's Avatar
 
Posts: 1,294
Karma: 100614
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
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 is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[GUI Plugin] Count Pages kiwidude Plugins 1241 12-14-2018 07:27 AM
[GUI Plugin] Author Book Count DaltonST Plugins 36 08-12-2018 01:51 PM
[GUI Plugin] Copy book covers as Standby images (Sony/PocketBook/Kindle/Nook) jackie_w Plugins 123 06-19-2016 11:44 PM
[GUI Plugin] Manage Sony x50 Reader Book List kpw Plugins 170 10-02-2014 09:23 PM
[GUI Plugin] Book Sync **Deprecated** kiwidude Plugins 111 06-07-2011 08:47 PM


All times are GMT -4. The time now is 07:54 AM.


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