Register Guidelines E-Books Today's Posts Search

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

Notices

Reply
 
Thread Tools Search this Thread
Old 08-11-2024, 08:43 PM   #1756
DooMWhite
Junior Member
DooMWhite began at the beginning.
 
Posts: 1
Karma: 10
Join Date: Feb 2023
Device: PW 10th
How does the columns works? The date and progress ones aren't being updated, both of them are "Undefined", this is how I set it up:
https://i.imgur.com/ZoFxoMQ.png (For some reason, the IMG tag doesn't work in the preview...)
DooMWhite is offline   Reply With Quote
Old 08-22-2024, 03:18 PM   #1757
MrSorTyke
Junior Member
MrSorTyke began at the beginning.
 
Posts: 1
Karma: 10
Join Date: Aug 2024
Device: Kindle
Still don't know what to do

Hello,

I read a lot of the messages here, but I still don't know what to do with this:

calibre, version 7.16.0

ERROR: Goodreads Failure: The request contacting Goodreads has failed.
If it reoccurs you may have exceeded a request limit imposed by Goodreads.
In which case wait an additional 5-10 minutes before retrying.

URL: https://www.goodreads.com/shelf/add_to_shelf.xml
Response Code: 201
b'<?xml version="1.0" encoding="UTF-8"?>\n<shelf>\n <id type="integer" nil="true"/>\n <review-id type="integer" nil="true"/>\n <updated-at type="dateTime" nil="true"/>\n <created-at type="dateTime" nil="true"/>\n <position type="integer" nil="true"/>\n <user-shelf-id type="integer">596858431</user-shelf-id>\n <name>calibre-library</name>\n <exclusive type="boolean">false</exclusive>\n</shelf>\n'
MrSorTyke is offline   Reply With Quote
Old 08-23-2024, 02:42 AM   #1758
alva
Junior Member
alva began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Jul 2024
Device: kobo Clara color
As the message says the request limit to the goodreads api has exceeded the limit. There is nothing you can do besides waiting, it is just the goodreads api.
alva is offline   Reply With Quote
Old 09-04-2024, 07:44 AM   #1759
Rellwood
Library Breeder (She/Her)
Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.
 
Rellwood's Avatar
 
Posts: 1,192
Karma: 1900479
Join Date: Apr 2015
Location: Fullerton, California
Device: Kobo Aura HD (1) PW3 (4) PW3 2019 new edition (1)
Quote:
Originally Posted by kiwidude View Post
Have a read of the couple of posts above yours (#66-68) where Jesscat and I discuss potential syncing of the date read column - it relies on "reviews" which also are where ratings come in. So in direct answer to your question the answer is no you can't do it today, but at some point I will take a look at it.

I too would be interested to hear about the workflows of how people are using this plugin.
Ok, so I would assume that your book is on a "read" column and has a date read in Goodreads, otherwise how would they have the date read? If you are having trouble getting a date read to sync, then perhaps you could create a custom column for "goodreads date read" and when creating sync rules, create a specific rule to "add to column" #goodreads_date_read" Date Read. Personally, if I re-read a book or read a book for the first time, I have a shelf "recently-read" and "recently-reread" and just sync from that shelf instead of my entire read shelf. If it's a book or two then you don't have to wait forever to get those read dates. I sync them into my "goodreads Date Read"

For whatever reason if you have multiple read dates in Goodreads they are supposed to send down the LAST read date, but sometimes they just send down the first read date, or the last time you updated a read in your kindle. If you update your Goodreads when you finish a book on your kindle and do it from there, it will always show up in the sync. If you do it manually on the site, sometimes it won't show. This is for multiple instances of read dates.

I am not sure if I understand why you aren't getting the read dates, because I never had a problem. I just send them to a specific column in case they come out wonky. I also have individual read date columns for each instance (dr1, dr2, dr3, dr4, dr5, etc.) If the latest read date comes down from Goodreads, I copy it over to the appropriate date read column.

I hope this is not something that you are already knowing and that this isn't already solved. I just saw this while hunting around for the update reading progress since GR limits that to 10 books.

ALSO - Avoid using the plugin to sync or add to your reviews. It will only upload a certain amount of characters. If you attempt to upload your review it will only upload part of it, and then if you sync the review to your review column, you will lose it and only get a partial review. ALWAYS do the review manually online, copy it into your column manually and NEVER let the plugin sync.

I have moved my reviews to a long text column "gr_reviews". I do not have it listed in the column, I don't sync or add to it.

I lost a bunch of reviews in the past because the plugin cuts out after a certain number of characters, or Goodreads won't send down or upload a certain number of characters. If you do a review on Goodreads and it only sends down a partial of that review, and you have an add rule to upload the review you will just overwrite that full review on goodreads with the shortened review you ended up with because of the plugin. You will lose the review both on Goodreads and in Calibre. Also, don't use your comments column for the review, have a special review column. Your comments column holds whatever metadata comments (blurb, etc) from your metadata downloads.

Just do the review on the site, copy and paste it into your review column. If you get a library export, using the import list plugin, import the review column into a special "long_comments_for_copy" column to initially see that your reviews are correct, then copy them over to the "gr_review" and then clear the holding column. Use the Calibre Spy plugin to mass delete the long comments column.

Last edited by Rellwood; 09-04-2024 at 08:09 AM.
Rellwood is offline   Reply With Quote
Old 09-04-2024, 07:59 AM   #1760
Rellwood
Library Breeder (She/Her)
Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.
 
Rellwood's Avatar
 
Posts: 1,192
Karma: 1900479
Join Date: Apr 2015
Location: Fullerton, California
Device: Kobo Aura HD (1) PW3 (4) PW3 2019 new edition (1)
Quote:
Originally Posted by MrSorTyke View Post
Hello,

I read a lot of the messages here, but I still don't know what to do with this:

calibre, version 7.16.0

ERROR: Goodreads Failure: The request contacting Goodreads has failed.
If it reoccurs you may have exceeded a request limit imposed by Goodreads.
In which case wait an additional 5-10 minutes before retrying.

URL: https://www.goodreads.com/shelf/add_to_shelf.xml
Response Code: 201
b'<?xml version="1.0" encoding="UTF-8"?>\n<shelf>\n <id type="integer" nil="true"/>\n <review-id type="integer" nil="true"/>\n <updated-at type="dateTime" nil="true"/>\n <created-at type="dateTime" nil="true"/>\n <position type="integer" nil="true"/>\n <user-shelf-id type="integer">596858431</user-shelf-id>\n <name>calibre-library</name>\n <exclusive type="boolean">false</exclusive>\n</shelf>\n'
Check to see if the book is still available in Goodreads. I noticed that I was unable to add older books that Goodreads has removed because they were blended into an omnibus.
Rellwood is offline   Reply With Quote
Old 09-30-2024, 08:28 AM   #1761
SASSBS
Connoisseur
SASSBS doesn't litterSASSBS doesn't litter
 
Posts: 93
Karma: 118
Join Date: Aug 2011
Device: Kindle Keyboard; Kindle Fire
Anyone else getting server 500 errors? Been getting it for the past 2 days.
SASSBS is offline   Reply With Quote
Old 10-04-2024, 03:49 AM   #1762
kiwidude
Calibre Plugins Developer
kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.
 
Posts: 4,679
Karma: 2162246
Join Date: Oct 2010
Location: Australia
Device: Kindle Oasis
Goodreads Sync v1.16.9

Release Notes:
https://github.com/kiwidude68/calibr...s_sync-v1.16.9

Thanks to ahegel for reporting the issue on GitHub. When linking books if your book has an ISBN that Goodreads doesn't like then there i a circumstance they give a 404 error back, which was tripping up the plugin. Now it will quietly ignore that and fallback to doing a title/author search instead.
kiwidude is offline   Reply With Quote
Old 10-07-2024, 10:03 PM   #1763
Smelsie
Junior Member
Smelsie began at the beginning.
 
Posts: 3
Karma: 10
Join Date: Aug 2010
Device: Kobo eReader
Hi there, I'm hoping someone can help me. My Goodreads sync plugin has been working perfectly for years and now suddenly everytime I try to sync (using the "Sync from Shelf" option) it's giving me an SSLHANDSHAKE error (see below). I found an old comment from 2019 with a similar message in the thread (page 83) and the state resolution was to visit the Goodreads site in IE or Edge. I tried that, but it didn't resolve the issue (also tried in Chrome and Firefox and that didn't help either.) I also tried deleting all my cookies and cache to see if that would resolve it and it did not. Does anyone know what I need to do to resolve this SSLHANDSHAKE issue?


Error message from Calibre:

calibre, version 7.19.0
ERROR: Unhandled exception: <b>SSLHandshakeError</b>:[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1006)

calibre 7.19 embedded-python: True
Windows-10-10.0.22631-SP0 Windows ('64bit', 'WindowsPE')
('Windows', '10', '10.0.22631')
Python 3.11.5
Windows: ('10', '10.0.22631', 'SP0', 'Multiprocessor Free')
Interface language: None
EXE path: C:\Program Files\Calibre2\calibre.exe
Successfully initialized third party plugins: Gather KFX-ZIP (from KFX Input) (2, 16, 0) && DeDRM (10, 0, 9) && Package KFX (from KFX Input) (2, 16, 0) && Count Pages (1, 13, 6) && EpubMerge (3, 2, 0) && EpubSplit (3, 9, 0) && FanFicFare (4, 39, 0) && Generate Cover (2, 3, 4) && Goodreads Sync (1, 16, 9) && KFX metadata reader (from KFX Input) (2, 16, 0) && From KFX (2, 16, 0) && KFX Input (2, 16, 0) && Obok DeDRM (10, 0, 9) && Prettify Cover (1, 6, 0)
Traceback (most recent call last):
File "calibre_plugins.goodreads_sync.httplib2.__init__" , line 1094, in connect
File "calibre_plugins.goodreads_sync.httplib2.__init__" , line 117, in _ssl_wrap_socket
File "ssl.py", line 517, in wrap_socket
File "ssl.py", line 1108, in _create
File "ssl.py", line 1379, in do_handshake
ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1006)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "calibre_plugins.goodreads_sync.config", line 1204, in authorize_plugin
File "calibre_plugins.goodreads_sync.core", line 237, in get_request_token_secret
File "calibre_plugins.goodreads_sync.core", line 129, in _oauth_request_get
File "calibre_plugins.goodreads_sync.oauth2.__init_ _", line 689, in request
File "calibre_plugins.goodreads_sync.httplib2.__init__" , line 1690, in request
File "calibre_plugins.goodreads_sync.httplib2.__init__" , line 1423, in _request
File "calibre_plugins.goodreads_sync.httplib2.__init__" , line 1343, in _conn_request
File "calibre_plugins.goodreads_sync.httplib2.__init__" , line 1120, in connect
calibre_plugins.goodreads_sync.httplib2.SSLHandsha keError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1006)
Smelsie is offline   Reply With Quote
Old 10-07-2024, 11:02 PM   #1764
Smelsie
Junior Member
Smelsie began at the beginning.
 
Posts: 3
Karma: 10
Join Date: Aug 2010
Device: Kobo eReader
Quote:
Originally Posted by Smelsie View Post
Hi there, I'm hoping someone can help me. My Goodreads sync plugin has been working perfectly for years and now suddenly everytime I try to sync (using the "Sync from Shelf" option) it's giving me an SSLHANDSHAKE error (see below). I found an old comment from 2019 with a similar message in the thread (page 83) and the state resolution was to visit the Goodreads site in IE or Edge. I tried that, but it didn't resolve the issue (also tried in Chrome and Firefox and that didn't help either.) I also tried deleting all my cookies and cache to see if that would resolve it and it did not. Does anyone know what I need to do to resolve this SSLHANDSHAKE issue?


Error message from Calibre:

calibre, version 7.19.0
ERROR: Unhandled exception: <b>SSLHandshakeError</b>:[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1006)

calibre 7.19 embedded-python: True
Windows-10-10.0.22631-SP0 Windows ('64bit', 'WindowsPE')
('Windows', '10', '10.0.22631')
Python 3.11.5
Windows: ('10', '10.0.22631', 'SP0', 'Multiprocessor Free')
Interface language: None
EXE path: C:\Program Files\Calibre2\calibre.exe
Successfully initialized third party plugins: Gather KFX-ZIP (from KFX Input) (2, 16, 0) && DeDRM (10, 0, 9) && Package KFX (from KFX Input) (2, 16, 0) && Count Pages (1, 13, 6) && EpubMerge (3, 2, 0) && EpubSplit (3, 9, 0) && FanFicFare (4, 39, 0) && Generate Cover (2, 3, 4) && Goodreads Sync (1, 16, 9) && KFX metadata reader (from KFX Input) (2, 16, 0) && From KFX (2, 16, 0) && KFX Input (2, 16, 0) && Obok DeDRM (10, 0, 9) && Prettify Cover (1, 6, 0)
Traceback (most recent call last):
File "calibre_plugins.goodreads_sync.httplib2.__init__" , line 1094, in connect
File "calibre_plugins.goodreads_sync.httplib2.__init__" , line 117, in _ssl_wrap_socket
File "ssl.py", line 517, in wrap_socket
File "ssl.py", line 1108, in _create
File "ssl.py", line 1379, in do_handshake
ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1006)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "calibre_plugins.goodreads_sync.config", line 1204, in authorize_plugin
File "calibre_plugins.goodreads_sync.core", line 237, in get_request_token_secret
File "calibre_plugins.goodreads_sync.core", line 129, in _oauth_request_get
File "calibre_plugins.goodreads_sync.oauth2.__init_ _", line 689, in request
File "calibre_plugins.goodreads_sync.httplib2.__init__" , line 1690, in request
File "calibre_plugins.goodreads_sync.httplib2.__init__" , line 1423, in _request
File "calibre_plugins.goodreads_sync.httplib2.__init__" , line 1343, in _conn_request
File "calibre_plugins.goodreads_sync.httplib2.__init__" , line 1120, in connect
calibre_plugins.goodreads_sync.httplib2.SSLHandsha keError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1006)


Nvm, I was able to get it fixed. I did a full removal of the plugin and reinstalled it, but that still didn't work. What I ended up having to do was fully disable my VPN (Private Internet Access with Kill switch on). THEN when I clicked on the "Authorize Plugin with Goodreads", it loaded up the Goodreads website (into Chrome). At the top it displayed a message saying 'This app is already authorized", but then the Plugin started working in Calibre again!
Smelsie is offline   Reply With Quote
Reply

Tags
calibre, goodreads


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[GUI Plugin] Search the Internet kiwidude Plugins 434 09-30-2024 03:04 AM
[GUI Plugin] Clipboard Search kiwidude Plugins 29 04-02-2024 10:05 PM
[GUI Plugin] Open With kiwidude Plugins 403 04-01-2024 08:39 AM
[GUI Plugin] Quick Preferences kiwidude Plugins 62 03-16-2024 11:47 PM
[GUI Plugin] Book Sync **Deprecated** kiwidude Plugins 111 06-07-2011 07:47 PM


All times are GMT -4. The time now is 03:20 PM.


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