[GUI Plugin] Kobo Utilities - Page 57

davidfor · 01-04-2015, 05:38 PM

Quote:

Originally Posted by howyoudoin

David, there's an issue with the "Related Content" feature.

I have one book by Author A and another co-authored by authors A and B. They don't show up as related when set to relate by author. IMO, they should.

Excellent work otherwise!

The related books uses the series and authors as defined on the device. It's done with a simple comparison of the strings stored in the database. Splitting up multiple authors is a lot of extra work. I'll put it down as something to look at in the future.

DJMOON · 01-05-2015, 10:55 PM

Hi David

I'm having trouble with the Series Sort, but it may be my lack of understanding.

In Help it says:

•The books also have to have a series number. Some books from Kobo do not have the number.

This sounds like the the series sort relies on a value supplied from Kobo and so would only work with some KEPUBS?

It doesn't use the series name and number that I enter in Calibre and the Utilities have successfully written to the GLO's database? The series name and number appears in the GLO's library for each book. I would have thought the value you set for "Date Added" would be based on that?

davidfor · 01-06-2015, 08:23 AM

Firstly, unless you are using an older firmware, forget about the series sort. The "Date added" sort for the collection is broken in the firmware. Because of that, using this function doesn't do anything useful.

But, the series and number the function uses is whatever is in the device database. If you look at a book and it has a series name and number, that is what is used. From memory, books without a number are sorted first.

Jellby · 01-06-2015, 12:32 PM

Quote:

Originally Posted by davidfor

And Terisa has been kind enough to update the Spanish translation.

Thanks to both of you.

Would it be possible to make the translations available in transifex, in the calibre-plugins project? In the meantime, in the remove anotations dialog, it says "antoaciones" instead of "anotaciones" (in the Spanish translation).

Terisa de morgan · 01-06-2015, 12:46 PM

Quote:

Originally Posted by Jellby

Thanks to both of you.

Would it be possible to make the translations available in transifex, in the calibre-plugins project? In the meantime, in the remove anotations dialog, it says "antoaciones" instead of "anotaciones" (in the Spanish translation).

The updated file is attached here.

translations.rar

Jellby · 01-06-2015, 03:23 PM

There's a problem with the backups, or there's something I don't understand.

I have checked the daily backup box (backup on every connection unchecked), number of backups to keep cheked and set to 5.

Today I have connected the device several times. The plugin has created a backup every time and has deleted older backups, so now I have only 5 backups of today, and nothing earlier (only some .sqlite files, which are not automatically deleted).

I would think that my settings mean that no additional backups should be created on a single day. And maybe, if multiple backups are created each day, there could be an option to keep the backups for a number of different days, rather than just a number of backups.

And by the way, I get this for any of the backup files:

Code:

zip -vT KoboReader-KoboAura-514A3A4900505-20150106-211543.zip 
Archive:  KoboReader-KoboAura-514A3A4900505-20150106-211543.zip
    testing: Kobo eReader.conf        OK
    testing: version                  OK
    testing: affiliate.conf           OK
    testing: .adobe-digital-editions/  
  error:  invalid compressed data to inflate
    testing: .adobe-digital-editions/device.xml   OK
    testing: KoboReader.sqlite        OK
At least one error was detected in KoboReader-KoboAura-514A3A4900505-20150106-211543.zip.
test of KoboReader-KoboAura-514A3A4900505-20150106-211543.zip FAILED

zip error: Zip file invalid, could not spawn unzip, or wrong unzip (original files unmodified)

Terisa de morgan · 01-06-2015, 03:38 PM

I don't have the problem with zip file (at least in Windows), but I have more than a backup for the same day, although I've checked daily backup only.

Terisa de morgan · 01-06-2015, 03:45 PM

I've unchecked "include configuration file" and no more backups although a strange glitch. I've unchecked the option with no device attached, and the next time there's a zip and a sqlite fail. I've open preferences with device the attached, I've disconnected it, I've connected it again and no additional backup.

davidfor · 01-07-2015, 08:11 PM

Hmm, there seems to be a problem with the backup. I knew there was a problem with exactly how many files were kept if you swap between including the database in the config zip file or not. I thought it sorted itself out after a few backups were made. I'll look at it over the weekend.

Umoxuy · 01-09-2015, 09:29 AM

I'm also seeing a device backup problem. I usually have it set at "backup daily, keep 5 copies", today I set it to "backup each connection keep 10 copies" because I was going to do some tidying up shelves and loading new stuff and I knew I'd be unplugging/plugging a lot.

In my backup directory I see:
KoboReader-KoboTouch-N905B1C305194-20150110-001411_CORRUPT.sqlite
KoboReader-KoboTouch-N905B1C305194-20150110-002359_CORRUPT.sqlite

Error message shows:

Code:

calibre, version 2.15.0 (win32, isfrozen: True)
Failed to backup device database: Failed: Backing up Kobo device database


*** in database main ***
Main freelist: 6 of 10 pages missing from overflow list starting at 33953

Traceback (most recent call last):
  File "site-packages\calibre\gui2\device.py", line 87, in run
  File "calibre_plugins.koboutilities.jobs", line 186, in do_device_database_backup
Exception: 
*** in database main ***
Main freelist: 6 of 10 pages missing from overflow list starting at 33953

I made a copy of the KoboReader.sqlite database so I could poke around with SqliteBrowser. No problems opening and browsing.

I couldn't find any stickies in this thread that explain how to fix (I haven't had much luck searching).

I have a sqlite backup from yesterday, how do I go about restoring it? It is as simple as replacing the KoboReader.sqlite db?

My environment is:
Calibre 2.15 64bit | Kobo Utilities 2.02 | Kobo Touch | FW 3.1.1.0 | Windows Vista Ultimate 64bit

PeterT · 01-09-2015, 10:07 AM

Actually yesterday on one sync I saw the infamous

Spoiler:

I said Oh HECK then realized I still had Kobo Dekstop running in addition to calibre.

Shut down Desktop, ejected and re-attached Kobo; no errors.

Would be their be any benefit to checking in either Kobo Driver or Kobo Utility for the presence of Desktop, and alerting the user?

Umoxuy · 01-09-2015, 10:31 AM

Follow up on my earlier message.

After posting I went searching the thread with fewer keywords and found some messages from last October. One of davidfor's messages mentioned a similar case where compressing the database might fix the problem (and if not, I'd be no worse off).

After running "Compress device database" I found that the fatal error I was receiving after plugging in had changed.

Code:

calibre, version 2.15.0 (win32, isfrozen: True)
Failed to backup device database: Failed: Backing up Kobo device database

wrong # of entries in index analytics_events_timestamp
wrong # of entries in index sqlite_autoindex_AnalyticsEvents_1

Traceback (most recent call last):
  File "site-packages\calibre\gui2\device.py", line 87, in run
  File "calibre_plugins.koboutilities.jobs", line 186, in do_device_database_backup
Exception: 
wrong # of entries in index analytics_events_timestamp
wrong # of entries in index sqlite_autoindex_AnalyticsEvents_1

Similar to what PeterT just found (although KoboDesktop is not the culprit in this case).

Bad indexes don't worry me as much as (potentially) missing data. I can probably rebuild the indexes if I can remember the SQL syntax...

Umoxuy · 01-09-2015, 10:48 AM

Happy camper now.

Rebuilding the indexes with Sqlite DB Browser was painless.

Code:

REINDEX analytics_events_timestamp

Query executed successfully: REINDEX analytics_events_timestamp (took 92ms)

REINDEX sqlite_autoindex_AnalyticsEvents_1

Query executed successfully: REINDEX sqlite_autoindex_AnalyticsEvents_1 (took 764ms)

Run the Kobo Utilities "Check the Device Database"

Code:

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

ok

Unplug and re-plug. Saw no error messages. I can see the proper .sqlite and .zip file in my backups directory as it used to be.

Terisa de morgan · 01-19-2015, 04:34 PM

I'm finding a problem with Kobo Utilities plugin when I attach my iPad and I join calibre with marvin, I get first the following exception:

Spoiler:

As I have the Reading List plugin active, some books are sent to the device and there's another exception:

Spoiler:

which breaks calibre. When I open calibre again (and the books has already been sent), the first exception happens and the second one too (when I disconnect the device), but calibre keeps on running.

davidfor · 01-19-2015, 06:44 PM

Terisa: I think the only think I can say is:

So much careful checking of the actual device connected and I don't even use that. I'll fix it in the next couple of days.

01-06-2015, 03:23 PM	#846
Jellby frumious Bandersnatch Posts: 7,557 Karma: 19500001 Join Date: Jan 2008 Location: Spaniard in Sweden Device: Cybook Orizon, Kobo Aura	There's a problem with the backups, or there's something I don't understand. I have checked the daily backup box (backup on every connection unchecked), number of backups to keep cheked and set to 5. Today I have connected the device several times. The plugin has created a backup every time and has deleted older backups, so now I have only 5 backups of today, and nothing earlier (only some .sqlite files, which are not automatically deleted). I would think that my settings mean that no additional backups should be created on a single day. And maybe, if multiple backups are created each day, there could be an option to keep the backups for a number of different days, rather than just a number of backups. And by the way, I get this for any of the backup files: Code: zip -vT KoboReader-KoboAura-514A3A4900505-20150106-211543.zip Archive: KoboReader-KoboAura-514A3A4900505-20150106-211543.zip testing: Kobo eReader.conf OK testing: version OK testing: affiliate.conf OK testing: .adobe-digital-editions/ error: invalid compressed data to inflate testing: .adobe-digital-editions/device.xml OK testing: KoboReader.sqlite OK At least one error was detected in KoboReader-KoboAura-514A3A4900505-20150106-211543.zip. test of KoboReader-KoboAura-514A3A4900505-20150106-211543.zip FAILED zip error: Zip file invalid, could not spawn unzip, or wrong unzip (original files unmodified)

01-09-2015, 09:29 AM	#850
Umoxuy Junior Member Posts: 5 Karma: 27 Join Date: Jul 2011 Device: Kobo Glo HD, Kobo Touch, Astak Mentor	I'm also seeing a device backup problem. I usually have it set at "backup daily, keep 5 copies", today I set it to "backup each connection keep 10 copies" because I was going to do some tidying up shelves and loading new stuff and I knew I'd be unplugging/plugging a lot. In my backup directory I see: KoboReader-KoboTouch-N905B1C305194-20150110-001411_CORRUPT.sqlite KoboReader-KoboTouch-N905B1C305194-20150110-002359_CORRUPT.sqlite Error message shows: Code: calibre, version 2.15.0 (win32, isfrozen: True) Failed to backup device database: Failed: Backing up Kobo device database * in database main * Main freelist: 6 of 10 pages missing from overflow list starting at 33953 Traceback (most recent call last): File "site-packages\calibre\gui2\device.py", line 87, in run File "calibre_plugins.koboutilities.jobs", line 186, in do_device_database_backup Exception: * in database main * Main freelist: 6 of 10 pages missing from overflow list starting at 33953 I made a copy of the KoboReader.sqlite database so I could poke around with SqliteBrowser. No problems opening and browsing. I couldn't find any stickies in this thread that explain how to fix (I haven't had much luck searching). I have a sqlite backup from yesterday, how do I go about restoring it? It is as simple as replacing the KoboReader.sqlite db? My environment is: Calibre 2.15 64bit \| Kobo Utilities 2.02 \| Kobo Touch \| FW 3.1.1.0 \| Windows Vista Ultimate 64bit

01-09-2015, 10:31 AM	#852
Umoxuy Junior Member Posts: 5 Karma: 27 Join Date: Jul 2011 Device: Kobo Glo HD, Kobo Touch, Astak Mentor	Follow up on my earlier message. After posting I went searching the thread with fewer keywords and found some messages from last October. One of davidfor's messages mentioned a similar case where compressing the database might fix the problem (and if not, I'd be no worse off). After running "Compress device database" I found that the fatal error I was receiving after plugging in had changed. Code: calibre, version 2.15.0 (win32, isfrozen: True) Failed to backup device database: Failed: Backing up Kobo device database wrong # of entries in index analytics_events_timestamp wrong # of entries in index sqlite_autoindex_AnalyticsEvents_1 Traceback (most recent call last): File "site-packages\calibre\gui2\device.py", line 87, in run File "calibre_plugins.koboutilities.jobs", line 186, in do_device_database_backup Exception: wrong # of entries in index analytics_events_timestamp wrong # of entries in index sqlite_autoindex_AnalyticsEvents_1 Similar to what PeterT just found (although KoboDesktop is not the culprit in this case). Bad indexes don't worry me as much as (potentially) missing data. I can probably rebuild the indexes if I can remember the SQL syntax...

01-09-2015, 10:48 AM	#853
Umoxuy Junior Member Posts: 5 Karma: 27 Join Date: Jul 2011 Device: Kobo Glo HD, Kobo Touch, Astak Mentor	Happy camper now. Rebuilding the indexes with Sqlite DB Browser was painless. Code: REINDEX analytics_events_timestamp Query executed successfully: REINDEX analytics_events_timestamp (took 92ms) REINDEX sqlite_autoindex_AnalyticsEvents_1 Query executed successfully: REINDEX sqlite_autoindex_AnalyticsEvents_1 (took 764ms) Run the Kobo Utilities "Check the Device Database" Code: Result of running 'PRAGMA integrity_check' on database on the Kobo device: ok Unplug and re-plug. Saw no error messages. I can see the proper .sqlite and .zip file in my backups directory as it used to be.

01-19-2015, 04:34 PM	#854
Terisa de morgan Grand Sorcerer Posts: 6,638 Karma: 12595249 Join Date: Jun 2009 Location: Madrid, Spain Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2	I'm finding a problem with Kobo Utilities plugin when I attach my iPad and I join calibre with marvin, I get first the following exception: Spoiler: calibre, version 2.16.0 ERROR: Excepción no considerada: <b>KeyError</b>:'main' calibre 2.16 isfrozen: True is64bit: False Windows-7-6.1.7600 Windows ('32bit', 'WindowsPE') 32bit process running on 64bit windows ('Windows', '7', '6.1.7600') Python 2.7.9 Windows: ('7', '6.1.7600', '', 'Multiprocessor Free') Successfully initialized third party plugins: DeDRM && Fantastic Fiction && Quality Check && Generate Cover && EpubMerge && Kobo Utilities && Goodreads && Obok DeDRM && Find Duplicates && Marvin XD && Annotations && Overdrive Link && Reading List && Extract ISBN && KoboTouchExtended && Import List && Diaps Editing Toolbag && Favourites Menu && Sort CSS && View Manager && Count Pages && EpubSplit && Goodreads Sync && Ex Libris && SmartEject && iOS reader applications && Barnes & Noble && Modify ePub && Overdrive Link Traceback (most recent call last): File "calibre_plugins.koboutilities.action", line 249, in _on_device_metadata_available File "calibre_plugins.koboutilities.action", line 1864, in get_device KeyError: 'main' As I have the Reading List plugin active, some books are sent to the device and there's another exception: Spoiler: calibre 2.16 isfrozen: True is64bit: False Windows-7-6.1.7600 Windows ('32bit', 'WindowsPE') 32bit process running on 64bit windows ('Windows', '7', '6.1.7600') Python 2.7.9 Windows: ('7', '6.1.7600', '', 'Multiprocessor Free') Successfully initialized third party plugins: DeDRM && Fantastic Fiction && Quality Check && Generate Cover && EpubMerge && Kobo Utilities && Goodreads && Obok DeDRM && Find Duplicates && Marvin XD && Annotations && Overdrive Link && Reading List && Extract ISBN && KoboTouchExtended && Import List && Diaps Editing Toolbag && Favourites Menu && Sort CSS && View Manager && Count Pages && EpubSplit && Goodreads Sync && Ex Libris && SmartEject && iOS reader applications && Barnes & Noble && Modify ePub && Overdrive Link Traceback (most recent call last): File "calibre_plugins.koboutilities.action", line 243, in _on_device_connection_changed File "calibre_plugins.koboutilities.action", line 287, in rebuild_menus File "calibre_plugins.koboutilities.action", line 1864, in get_device KeyError: 'main' which breaks calibre. When I open calibre again (and the books has already been sent), the first exception happens and the second one too (when I disconnect the device), but calibre keeps on running. Last edited by Terisa de morgan; 01-19-2015 at 04:37 PM.

01-05-2015, 10:55 PM	#842
DJMOON Junior Member Posts: 5 Karma: 10 Join Date: Jun 2011 Location: Edmonton, Canada Device: Kobo Glo	Hi David I'm having trouble with the Series Sort, but it may be my lack of understanding. In Help it says: •The books also have to have a series number. Some books from Kobo do not have the number. This sounds like the the series sort relies on a value supplied from Kobo and so would only work with some KEPUBS? It doesn't use the series name and number that I enter in Calibre and the Utilities have successfully written to the GLO's database? The series name and number appears in the GLO's library for each book. I would have thought the value you set for "Date Added" would be based on that?

01-06-2015, 08:23 AM	#843
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	Firstly, unless you are using an older firmware, forget about the series sort. The "Date added" sort for the collection is broken in the firmware. Because of that, using this function doesn't do anything useful. But, the series and number the function uses is whatever is in the device database. If you look at a book and it has a series name and number, that is what is used. From memory, books without a number are sorted first.

01-06-2015, 03:38 PM	#847
Terisa de morgan Grand Sorcerer Posts: 6,638 Karma: 12595249 Join Date: Jun 2009 Location: Madrid, Spain Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2	I don't have the problem with zip file (at least in Windows), but I have more than a backup for the same day, although I've checked daily backup only.

01-06-2015, 03:45 PM	#848
Terisa de morgan Grand Sorcerer Posts: 6,638 Karma: 12595249 Join Date: Jun 2009 Location: Madrid, Spain Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2	I've unchecked "include configuration file" and no more backups although a strange glitch. I've unchecked the option with no device attached, and the next time there's a zip and a sqlite fail. I've open preferences with device the attached, I've disconnected it, I've connected it again and no additional backup.

01-07-2015, 08:11 PM	#849
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	Hmm, there seems to be a problem with the backup. I knew there was a problem with exactly how many files were kept if you swap between including the database in the config zip file or not. I thought it sorted itself out after a few backups were made. I'll look at it over the weekend.

01-19-2015, 06:44 PM	#855
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	Terisa: I think the only think I can say is: So much careful checking of the actual device connected and I don't even use that. I'll fix it in the next couple of days.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[GUI Plugin] Manga plugin	mastertea	Plugins	6	01-06-2022 02:43 AM
[GUI Plugin] Save Virtual Libraries To Column (GUI)	chaley	Plugins	14	04-04-2021 05:25 AM
Kobo Utilities Plugin Question	nikev	Kobo Reader	10	09-25-2018 11:55 PM
[GUI Plugin] Plugin Updater Deprecated	kiwidude	Plugins	159	06-19-2011 12:27 PM

Advert

Advert