[GUI Plugin] Kobo Utilities

[Majutsushi]

Originally Posted by roncio

Tried now, nothing.
No backup generated.

I'm on the last version of Calibre and the plugin.
Am i missing some setting?

If you're sure that the plugin hasn't done a backup already on the same day, please provide a debug log (right-click on the Calibre preferences icon and select "Restart in debug mode"). The relevant part of the log starts with "auto_backup_device_database - start".

[Majutsushi]

Originally Posted by DNSB

Getting an error with some books when I attempt to use the Kobo Utilities Update Metadata in Device Library.

calibre, version 7.26.100
ERROR: Unhandled exception: <b>TypeError</b>:strptime() argument 1 must be str, not None

calibre 7.26.100*  embedded-python: True
Windows-10-10.0.26100-SP0 Windows ('64bit', 'WindowsPE')
('Windows', '10', '10.0.26100')
Python 3.11.5
Windows: ('10', '10.0.26100', 'SP0', 'Multiprocessor Free')
Interface language: None
EXE path: C:\Program Files\Calibre2\calibre-debug.exe
Successfully initialized third party plugins: LCPL Input (0, 0, 5) && Gather KFX-ZIP (from KFX Input) (2, 20, 0) && DeDRM (10, 0, 9) && AZW6 Image Merge (1, 1, 1) && Package KFX (from KFX Input) (2, 20, 0) && DeACSM (0, 0, 20) && Apple Books covers (0, 2, 0) && Backup Configuration Folder (1, 1, 2) && Barnes & Noble (1, 5, 6) && Count Pages (1, 13, 6) && DeACSM (0, 0, 20) && Diaps Editing Toolbag (0, 5, 0) && EpubCheck (0, 2, 5) && EpubMerge (3, 2, 0) && EpubSplit (3, 10, 0) && FanFicFare (4, 42, 0) && Find Duplicates (1, 10, 9) && Generate Cover (2, 3, 5) && Goodreads (1, 8, 2) && Job Spy (1, 0, 239) && KFX metadata reader (from KFX Input) (2, 20, 0) && From KFX (2, 20, 0) && KFX Input (2, 20, 0) && Set KFX metadata (from KFX Output) (2, 14, 0) && KFX Output (2, 14, 0) && KePub Metadata Reader (3, 4, 3) && KePub Output (3, 7, 3) && Kindle hi-res covers (0, 5, 1) && KindleUnpack - The Plugin (0, 83, 7) && Kobo Metadata (1, 10, 0) && Kobo Utilities (2, 18, 2) && KoboTouchExtended (3, 7, 3) && Modify ePub (1, 8, 5) && Obok DeDRM (10, 0, 9) && Open With (1, 8, 4) && OverDrive Libby (0, 2, 3) && Quality Check (1, 13, 16) && Resize Cover (1, 2, 1) && ScrambleEbook (0, 6, 0) && SmartEject (2, 6, 0) && Smashwords Metadata (1, 0, 2)
Traceback (most recent call last):
  File "calibre_plugins.koboutilities.action", line 1173, in update_metadata
  File "calibre_plugins.koboutilities.action", line 4899, in _update_metadata
  File "calibre_plugins.koboutilities.common_utils", line 321, in convert_kobo_date
TypeError: strptime() argument 1 must be str, not None

2 books in my Intake library which do not have a Published date (field is blank) trigger this error repeatably.

If I open the Metatdata Editor, the pub date shows as Jan. 2000 but editing it does not seem to make any difference.

The code tried to log the published date from the device database, but since that's empty it failed to convert it to a readable string. Does the attached version work for you?

[JSWolf]

Originally Posted by Karellen

You need to enable the setting "Backup the device database on each connection".
Probably overrides the setting "Backup the device database daily" so you can uncheck that one.

I have the daily setting checked and backups work.

[roncio]

Originally Posted by Karellen

You need to enable the setting "Backup the device database on each connection".
Probably overrides the setting "Backup the device database daily" so you can uncheck that one.

As i wrote before, both modes don't work unfortunately.

[roncio]

Originally Posted by Majutsushi

If you're sure that the plugin hasn't done a backup already on the same day, please provide a debug log (right-click on the Calibre preferences icon and select "Restart in debug mode"). The relevant part of the log starts with "auto_backup_device_database - start".

There's no "auto_backup_device_database - start" string in the log.
There are the loaded settings of auto backup thou.

[roncio]

Okay, found the cause.
Apparently the added device was broken, solved by re-adding the device.
Everything is working now.

[ownedbycats]

Ah yeah, that can happen. Mostly when reset the device.

[JSWolf]

Originally Posted by roncio

Okay, found the cause.
Apparently the added device was broken, solved by re-adding the device.
Everything is working now.

The ID for the device is in one of the calibre files on the device. If that file gets changed, deleted, or correct, then your device won't be recognized.

[billmandy]

Hello.
I am using the 2.18 version.
When I check the device library in Calibre I see a bunch of books that were already deleted.
If I try to remove them via Calibre, I get this error:

calibre, version 7.24.0
ERROR: Error: Error communicating with device

CorruptError: database disk image is malformed

Traceback (most recent call last):
File "calibre\gui2\device.py", line 112, in run
File "calibre\gui2\device.py", line 671, in _delete_books
File "calibre\devices\kobo\driver.py", line 570, in delete_books
File "calibre\devices\kobo\driver.py", line 2419, in delete_via_sql
File "calibre\devices\kobo\driver.py", line 504, in delete_via_sql
File "C:\t\t\apsw-42s16m2x\src\cursor.c", line 240, in resetcursor
apsw.CorruptError: CorruptError: database disk image is malformed

If I run the database check I get this:

Result of running 'PRAGMA integrity_check' on database on the Kobo device:


*** in database main ***
Tree 3 page 12116 cell 48: 2nd reference to page 12787
Tree 3 page 12116 cell 114: Rowid 8870 out of order
Tree 3 page 12116 cell 114: 2nd reference to page 12786
Tree 3 page 12116 cell 113: 2nd reference to page 12785
Tree 3 page 12116 cell 112: 2nd reference to page 12784
Tree 3 page 12116 cell 111: 2nd reference to page 12783
Tree 3 page 12116 cell 110: 2nd reference to page 12781
Tree 3 page 12116 cell 109: 2nd reference to page 12780
Tree 3 page 12116 cell 108: 2nd reference to page 12779
Tree 3 page 12116 cell 107: 2nd reference to page 12776
Tree 3 page 12116 cell 106: 2nd reference to page 12775
Tree 3 page 12116 cell 105: 2nd reference to page 12774
Tree 3 page 12116 cell 104: 2nd reference to page 12773
Tree 3 page 12116 cell 103: 2nd reference to page 12772
Tree 3 page 12116 cell 102: 2nd reference to page 12771
Tree 3 page 12116 cell 101: 2nd reference to page 12770
Tree 3 page 12116 cell 100: 2nd reference to page 12768
Tree 3 page 12116 cell 99: 2nd reference to page 12767
Tree 3 page 12116 cell 98: 2nd reference to page 12766
Tree 3 page 12116 cell 97: 2nd reference to page 12765
Tree 3 page 12116 cell 96: 2nd reference to page 12764
Tree 3 page 12116 cell 95: 2nd reference to page 12762
Tree 3 page 12116 cell 94: 2nd reference to page 12761
Tree 3 page 12116 cell 93: 2nd reference to page 12760
Tree 3 page 12116 cell 92: 2nd reference to page 12759
Tree 3 page 12116 cell 91: 2nd reference to page 12758
Tree 3 page 12116 cell 90: 2nd reference to page 12755
Tree 3 page 12116 cell 89: 2nd reference to page 12754
Tree 3 page 12116 cell 88: 2nd reference to page 12753
Tree 3 page 12116 cell 87: 2nd reference to page 12752
Tree 3 page 12116 cell 86: 2nd reference to page 12751
Tree 3 page 12116 cell 85: 2nd reference to page 12750
Tree 3 page 12116 cell 84: 2nd reference to page 12749
Tree 3 page 12116 cell 83: 2nd reference to page 12748
Tree 3 page 12116 cell 82: 2nd reference to page 12747
Tree 3 page 12116 cell 81: 2nd reference to page 12745
Tree 3 page 12116 cell 80: 2nd reference to page 12743
Tree 3 page 12116 cell 79: 2nd reference to page 12742
Tree 3 page 12116 cell 78: 2nd reference to page 12741
Tree 3 page 12116 cell 77: 2nd reference to page 12740
Tree 3 page 12116 cell 76: 2nd reference to page 12739
Tree 3 page 12116 cell 75: 2nd reference to page 12738
Tree 3 page 12116 cell 74: 2nd reference to page 12737
Tree 3 page 12116 cell 73: 2nd reference to page 12736
Tree 3 page 12116 cell 72: 2nd reference to page 12734
Tree 3 page 12116 cell 71: 2nd reference to page 12733
Tree 3 page 12116 cell 70: 2nd reference to page 12731
Tree 3 page 12116 cell 69: 2nd reference to page 12730
Tree 3 page 12116 cell 68: 2nd reference to page 12729
Tree 3 page 12116 cell 67: 2nd reference to page 12728
Tree 3 page 12116 cell 66: 2nd reference to page 12727
Tree 3 page 12116 cell 65: 2nd reference to page 12726
Tree 3 page 12116 cell 64: 2nd reference to page 12724
Tree 3 page 12116 cell 63: 2nd reference to page 12723
Tree 3 page 12116 cell 62: 2nd reference to page 12722
Tree 3 page 12116 cell 61: 2nd reference to page 12721
Tree 3 page 12116 cell 60: 2nd reference to page 12720
Tree 3 page 12116 cell 59: 2nd reference to page 12718
Tree 3 page 12116 cell 58: 2nd reference to page 12717
Tree 3 page 12116 cell 57: 2nd reference to page 12716
Tree 3 page 12116 cell 56: 2nd reference to page 12714
Tree 3 page 12116 cell 55: 2nd reference to page 12712
Tree 3 page 12116 cell 54: 2nd reference to page 12709
Tree 3 page 12116 cell 53: 2nd reference to page 12705
Tree 3 page 12116 cell 52: 2nd reference to page 12703
Tree 3 page 12116 cell 51: 2nd reference to page 12701
Tree 3 page 12116 cell 50: 2nd reference to page 12699
Tree 3 page 12116 cell 49: 2nd reference to page 12693
Tree 3 page 12116 cell 48: 2nd reference to page 12692
Tree 3 page 12116 cell 47: 2nd reference to page 12686
Tree 3 page 12116 cell 46: 2nd reference to page 12685
Tree 3 page 12116 cell 45: 2nd reference to page 12683
Tree 3 page 12116 cell 44: 2nd reference to page 12681
Tree 3 page 12116 cell 43: 2nd reference to page 12679
Tree 3 page 12116 cell 42: 2nd reference to page 12677
Tree 3 page 12116 cell 41: 2nd reference to page 12676
Tree 3 page 12116 cell 40: 2nd reference to page 12674
Tree 3 page 12116 cell 39: 2nd reference to page 12673
Tree 3 page 12116 cell 38: 2nd reference to page 12671
Tree 3 page 12116 cell 37: 2nd reference to page 12670
Tree 3 page 12116 cell 36: 2nd reference to page 12669
Tree 3 page 12116 cell 35: 2nd reference to page 12668
Tree 3 page 12116 cell 34: 2nd reference to page 12667
Tree 3 page 12116 cell 33: 2nd reference to page 12666
Tree 3 page 12116 cell 32: 2nd reference to page 12664
Tree 3 page 12116 cell 31: 2nd reference to page 12663
Tree 3 page 12116 cell 30: 2nd reference to page 12662
Tree 3 page 12116 cell 29: 2nd reference to page 12660
Tree 3 page 12116 cell 28: 2nd reference to page 12659
Tree 3 page 12116 cell 27: 2nd reference to page 12658
Tree 3 page 12116 cell 26: 2nd reference to page 12657
Tree 3 page 12116 cell 25: 2nd reference to page 12656
Tree 3 page 12116 cell 24: 2nd reference to page 12654
Tree 3 page 12116 cell 23: 2nd reference to page 12653
Tree 3 page 12116 cell 22: 2nd reference to page 12652
Tree 3 page 12116 cell 21: 2nd reference to page 12646
Tree 3 page 12116 cell 20: 2nd reference to page 12643
Tree 3 page 12116 cell 19: 2nd reference to page 12638
Tree 3 page 12116 cell 18: 2nd reference to page 12633
Tree 3 page 12116 cell 17: 2nd reference to page 12628

Do I need to reset the device?

[ownedbycats]

If you have a backup you can restore. If not, signout then signin. You'll lose annotations and bookmarks on sideloaded books.

[billmandy]

Sign out of what?

[JSWolf]

Originally Posted by billmandy

Sign out of what?

Sign out of your Kobo account on your Reader and set it up again.

[billmandy]

Ohh, the repair option you mean.
I went ahead with the reset. All my books are sideloaded so I do not care.

Help me understand something.
Do the statistics function work on sideloaded books? I only see the total reading time, the rest is set to zero.
If I mark a book as read, how can I tell it apart from the other books, outside the device's UI? In calibre or in Windows file explorer?

[nAhu]

Originally Posted by DNSB

Getting an error with some books when I attempt to use the Kobo Utilities Update Metadata in Device Library.

2 books in my Intake library which do not have a Published date (field is blank) trigger this error repeatably.

Same here, it was working previously and I had to uncheck the "published date" in the Kobo Utilities popup to pass the error.

[ownedbycats]

Originally Posted by billmandy

If I mark a book as read, how can I tell it apart from the other books, outside the device's UI? In calibre or in Windows file explorer?

You can't.