search

OzzieIsaacs / cps-shelf-adder

Mass adding of books to a shelf in calibre-web
GNU General Public License v3.0
42 stars 6 forks source link

Not working with latest calibre-web #3

Closed vtulin closed 10 months ago

vtulin commented 10 months ago

Script showing that book was successfully added to a shelf, but it's not there. It's working very fast one book for less than a second, so I think that the problem is in new calibre-web.

OzzieIsaacs commented 10 months ago

For me it's still working. I tried to improve the code a bit to catch more errors, please use the newest version. Maybe the success message is a bit confusing, e.g. Book with id 10 was added to shelf with message: Invalid shelf specified, means it didn't work because the shelf number was invalid

If this doesn't help:

What is the exact output of the script? What exact version of calibre-web are you using? (nightly version date...) Could you please send me the import file you are using (I don't want you to paste it here, because I had also trouble with some invisible characters)

vtulin commented 10 months ago

Calibre web version 0.6.21, it returns that book was successfuly added. I was trying different scenarios. At first there was an error "unknown character", I delete all columns, leave just "id", script runs ok, but no book added, next, I modify script add utf-8 there csv_f = open(booklist, encoding='utf-8') with columns. Also runs ok, no book added. I sent you email with import file.

OzzieIsaacs commented 10 months ago

There is one issue with calibre-web, it didn't detect invalid book ids and responded with book successfully added. So I changed that, you should update calibre-web to the newest nightly version (in the UI there should be a button in the admin section, depending on how you installed it)

Other possibility would be that you applied some visibility restrictions: Books are archived, you only see books of a certain language, only certain tags are allowed or denied, or books having a certain entry in a custom column are visible or not visible (can be configured as admin per user, maybe you did this). In all other cases, if calibre-web states the book is added, than it is added according to my experience.

You could check the app.db file beloning to calibre-web with a sqlite database viewer (like from https://sqlitebrowser.org/) and check the content of the table book_shelf_link

I hope you also run the cps-sheld-adder script with python3 and not with python2 (I don't support this anymore) and calibre-web only runs on python3, I hope this is not a problem

vtulin commented 10 months ago

I will wait for further calibre-web version, I don't want to dive deeper into a code or DB, maybe it will will be fixed in new version. What version do you use now?

OzzieIsaacs commented 10 months ago

Okay, it's up to you. I doublechecked with the newest commit version, version 0.6.21 and 0.6.20 all of them are working for me. I didn't change the relevant code in the last months. So I still think it has something to do with your installation