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-09-2013, 07:30 AM   #1
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,908
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
[GUI Plugin] Kobo Utilities

The Kobo Utilities Plugin adds extra function to calibre for working with Kobo ereaders. This will allow changes on the eReaders that either cannot otherwise be made or will make them easier to do.

The current functions of the plugin are:
  • Set/Remove font settings for specific books.
  • Dismiss tiles from tiled home screen.
  • Update metadata directly to the database on the device.
  • Change the reading status.
  • Manage series info for books on the device. This is mainly for books not in the calibre library including kepubs.
  • Store/record current reading position for ePubs. This can be done manually or automatically when the Kobo ereader is connected. Profiles can be used to manage the reading positions of multiple devices.
  • Upload/Remove covers for all books in the library. This includes kepubs.
  • A couple of annotations options that I'm not happy with.
  • List the books missing from the device database. This only lists the books that calibre thinks should be in the database.
  • Backup the device database.
  • Run integrity check on the database. It doesn't fix anything, but it tells you if the database is OK or not.
  • Clean up duplicate shelves.
  • Remove annotations files.
  • Set "Related books" for sideloaded books.

Warning
  • Almost all the functions of this plugin directly update the database on the Kobo device. If anything goes wrong, the database could get corrupted. It shouldn't happen, but it could. Before using any function of the plugin, it is recommended that you backup the database.
  • The plugin has been created by reverse engineering the function of the Kobo eReaders. This has been done by examining the database on the Touch and Glo and experimenting with it and the interface. There is a good chance that my conclusions from this are wrong. This is unlikely to damage the device, but it could result in the need to reset it.

Supported Devices

All Kobo e-ink ereaders are supported if calibre supports them. Some functions are not supported on the original Kobo eReader or the WiFi.

Supported calibre Versions

The intention is for the plugin to support all versions of calibre. But, the effort put in to support older versions will be minimal. Any changes in the plugin will be developed and tested with the most recent released version of calibre. They will also be tested with the last dot release of older calibre versions. But, this testing may be just validating that nothing has been obviously broken. At the point, this means that the plugin is fully supported in calibre version 5. Releases will be checked against version 4.23.0 and 3.48.0.

If problems are found with older versions, please report them and I will see what I can do. But, upgrading to one of the above versions will be the first suggestion.

Installation

Open Preferences -> Plugins -> Get new plugins and install the 'Kobo Utilities' plugin.

You may also download the attached zip file and install the plugin manually, then restart calibre as described in the Introduction to Plugins thread.

Configuration

Before use, some configuration of the plugin is needed. Pressing the toolbar button will display the configuration options, or it can be reached from the menu. Several custom columns are needed for the full function of the plugin. Pressing the help link will display the help for the plugin. This includes a full description of the columns needed.

Usage
  • Once installed, the usage for most functions is to select one or more books in the library or device list and select an option from the plugins menu. A dialog will be displayed to set options for the action. Pressing OK will run the actions and when finished display a message showing the results.
  • The functions available depend on whether you are looking at the library or the device list.
  • A full description of each function is available in the help. This can be seen by pressing the help link in the top right of corner of each dialog.

Acknowledgements
  • A large chunk of the code is borrowed from the plugins written by kiwidude. Without his work, this would have been a lot harder to do.
  • A few people have tried the beta versions of the plugin. Their reports, suggestions and encouragement have been important in getting it working.
Version History
Spoiler:


Version 2.16.13 - 11 Dec 2023 (changes and release by @chaley)
  • Fix rare error where the Kobo database contains invalid dates or times
Version 2.16.12 - 06 Dec 2023 (changes by @ownedbycats, release by @chaley)
  • Improvement of help string for storing bookmarks

Version 2.16.11 - 08 Nov 2023 (changes by @ownedbycats, release by @chaley)
  • Support for long-text/comment-type columns for storing reading position.

Version 2.16.10 - 12 July 2023 (changes & release by chaley)
  • Fix help file not displaying on Windows.

Version 2.16.9 - 4 July 2023 (changes by @ownedbycats, release by @chaley)
  • Added Rakuten Sans/Serif support for the fonts dialog

Version 2.16.8 - 4 July 2023 (changes by @Terisa de morgan, release by @chaley)
  • Fix: Error when checking for firmware updates.

Version 2.16.7 - 11 May 2023 (by @chaley)
  • Fix: Problem when updating the ToC.

Version 2.16.6 - 01 August 2022
  • Fix: Qt6 compatiblility - Connecting actions to Radio buttons works differently.

Version 2.16.5 - 20 July 2022
  • Fix: Qt6 compatiblility - Prefs viewer tab stops and file chooser for database backup.
Version 2.16.4 - 13 July 2022
  • Fix: Qt6 compatibility - Error if copies to keep option in configuration is not set.
Version 2.16.3 - 28 May 2022
  • Fix: Error when opening configuration and device specific options were being used.
Version 2.16.2 - 25 May 2022
  • Change: Allow device to be renamed when it is not connected.
  • Fix: Error when using custom date column when setting metadata in library.
Version 2.16.0 - 10 May 2022
  • Fix: Fix removing the rating when rating is set.
  • Change: Add option to not set font if already set on the device.
Version 2.15.1 - 06 January 2022
  • Fix: In some places the text for the rating and last read code was swapped.
  • Change: Handle cancelling the custom column creation better.
  • Change: Calibre v6/Qt6 migration - code cleanup
Version 2.15.0 - 04 January 2022
  • New: Use CreateNewCustomColumn to create custom columns in the configuration dialog.
  • Change: Update importing of some Qt classes as part of preparation for calibre v6/Qt6.
Version 2.14.4 - 28 December 2021
  • Change: Some code and comments cleanup.
  • Fix: If there were multiple copies of a book on the device, setting and removing fonts, only did one.
  • Fix: ToC rebuild for kepubs failed if the contentID had a dash followed by numbers in it. Should have anchored the regex to the end of the line.
Version 2.14.1 - 18 July 2021
  • Fix: "DateModified" not qualified in query used in Order Shelves.
Version 2.14.0 - 01 June 2021
  • New: ToC updater.
Version 2.13.1 - 28 March 2021
  • Fix: Error fetching reading status when there are multiple copies of the book on the device and the first has not been opened.
Version 2.13.0 - 19 March 2021
  • Change: Change how books are queued when automatically fetching reading locations.
  • Change: Sort the results when getting the reading locations.
  • New: Choose colour used for letterboxing in covers.
  • Fix: Fix handling of epub locations for recent firmware.
  • Fix: Error in Manage series on device.
Version 2.12.3 - 12 January 2021
  • Fix: Better handling when configuration of custom columns doesn't match existing columns.
  • Fix: Validate selected profile when restoring/fetching reading status.
  • Change: Only display tile related and the set related menu items for firmware before 4.4.0.
  • Change: Only show menu items that will might do something in current view.
Version 2.12.0 - 05 January 2021
  • Fix: Not updating series info properly if the series number in the database is null.
  • Fix: Error in Manage Series on device if the book selected had a series, but no series index.
  • Fix: Add some more logging in reading status fetch.
  • Fix: Handle when percent read column doesn't exist when storing the bookmark.
  • Fix: Update code in store bookmark when not run in background.
  • Fix: Python 3 error slipped through when updating the foreground store bookmark.
  • Fix: Fix handling when location is null on device but not in library.
  • New: Add function to set the time on the device.
  • Fix: Disable "Clear if unread" if "Not if finished in library" is selected.
  • Fix: Another change to the handling when book is finished.
Version 2.11.8 - 8 October 2020
  • Fix: Python 3 related problem with ordering shelves.
Version 2.11.7 - 7 October 2020
  • Fix: Problem fetching the status if the LastReadDate is null.
  • Fix: Correct string handling in about and help options.
Version 2.11.5 - 25 September 2020
  • Fix: More fixes for Python 3.
  • The plugin should still be compatible with most versions of calibre, though I have only test recently with 3.48 and 4.23.
Version 2.11.4 - 17 July 2020
  • Fix: Updating parsing of firmware update file name to get the version number.
  • Change: Display lookup name for columns in Date added choice in Update metadata dialog.
  • Change: Add custom date columns and file timestamp option to Date added choices in Update metadata dialog.
  • Fix: More fixes for Python 3.
  • Fix: Error if setting font in config file if no "Reading" section.
Version 2.11.0 - 03 March 2020
  • New: Set SeriesID and SeriesNumberFloat for Series Tab support in 4.20.x.
Version 2.10.0 - 08 February 2020
  • Update: Changes for Python 3 support in calibre.
  • Update: Rework some query building.
  • Fix: Wasn't handling case were device specific settings were being used, but, there were none.
  • Fix: Disable "Get Shelves From Device" when in the device list.
  • Fix: Problem in sorting when using "Order Series Date"
Version 2.9.0 - 13 October 2019
  • Update: Set "get_cover" to as appropriate when getting metadata. This should improve performance in some places.
  • Update: Handle changed reading location for epub starting with 4.17.13651. Should be backwardly compatible with currently stored locations and older firmware.
  • New: Add options to cover updating for dithering, letterboxing and PNGs to match the driver change. Based on work from @NiLuJe.
  • New: Add option to remove the full sized cover image.
Version 2.8.0 - 20 April 2019
  • Fix: Missed a change in the annotation builder to handle recent change in BeautifulSoup in calibre.
  • Fix: Improve layout of results when displaying annotations.
  • Update: Add new font "AR UDJingxihei" to font settings dialog.
Version 2.7.0 - 28 March 2019
  • New: Option to open cover image directory.
  • Fix: Set the ___SyncTime when setting the LastDateRead if the ___SyncTime is later.
  • Fix: Change annotation builder to handle recent change in BeautifulSoup.

Older changes:
Spoiler:
Version 2.6.0 - 6 September 2017
  • New: Add setting sync date from calibre added or modified dates, or published date.
  • New: Add French translation of help. Thanks to Frenchdummy.
  • Fix: Error opening configuration if no devices and backup is set to individual configuration.
Version 2.5.2 - 10 January 2017
  • Fix: Button wasn't opening driver configuration if device wasn't connected.
Version 2.5.1 - 9 January 2017
  • Fix: Reenable "About Plugin"
  • New: French translation from Eric (Infernoweb) and Alain (FrenchDummy)
Version 2.5.0 - 5 January 2017
  • Fix: Error if cleaning cover for book on device but not in database.
  • Change: Button can be set to opening driver configuration or swapping drivers when no device connected.
  • Fix: Exception during backup as WinError is not on non-Windows machines.
  • Update: Latest Spanish translations from Terisa
Version 2.4.1 - 25 Aug 2016
  • Fix: Error creating trigger to block analytics.
Version 2.4.0 - 20 Aug 2016
  • Fix: Error deleting trigger.
  • Fix: No progress bar for series management.
  • Change: Change database reading to use the apsw library instead of sqlite3 library.
  • Change: Better handling of the progress bar.
  • Fix: Timestamp issues when updating metadata.
Version 2.3.2 - 24 May 2016
  • Fix: Error updating metadata if the comments was empty.
Version 2.3.1 - 18 May 2016
  • Fix: Error when setting description but not using a template.
Version 2.3.0 - 16 May 2016
  • Change: Use template for subtitle.
  • Change: Use template editor for comments and subtitle templates
Version 2.2.0 - 9 April 2016
  • New: Option to show Goodreads Sync "Update reading progress" dialog
  • Update: After storing book status, select them in the library view
  • New: Metadata uppdate - Update comments using a "jacket" or plugboard style template.
  • New: Metadata uppdate - Option to update downloaded kepubs as well sideloaded books.
  • New: Metadata uppdate - Option to set or clear the subtitle on the device.
  • Update: Display progress dialog when getting book list for updating metadata.
  • New: Submenu for driver configuration
  • New: Menu option to swap between main and extended driver.
  • New: Menu option to open driver configuration. If a device is connected, will open its configuration. Otherwise, it opens whichever is enable of the main and extended drivers.
  • New: Display device name, firmware version and the driver name in tooltip of button.
Version 2.1.0 - 6 December 2015
  • New: Add "Display Extras Tiles".
  • Fix: Error in getting reading settings from device configuration.
  • Change: Disable tiles related menu items if firmware doesn't support them.
  • Change: Update font names used for firmware 3.19.x
Version 2.0.7 - 29 April 2015
  • Fix: Profile name wasn't being passed to the reading status update dialog
  • Fix: Messed up logging in jobs
Version 2.0.6 - 26 April 2015
  • Fix: Handle missing files in the backup properly.
  • Change: Add select/clear all buttons to reading status update dialog.
Version 2.0.5 - 30 January 2015
  • Fix: Fix another error in migrating the settings.
Version 2.0.4 - 21 January 2015
  • Fix: Wasn't correctly doing the daily backup if the database in the zip file option was selected.
Version 2.0.3 - 20 January 2015
  • Fix: Error if iOS device plugged in and iOS reader applications and Marvin plugins are active
  • Change: Updated way backup files were deleted to handle when setting for putting database in the zip file is changed.
  • Change: Turn on debug logging for backup job.
Version 2.0.2 - 4 January 2015
  • Fix: More errors reading configuration after the migration
  • Fix: Opening the configuration shortly after ejecting the device gave an error
Version 2.0.1 - 4 January 2015
  • Fix: Errors reading configuration after a migration
Version 2.0.0 - 3 January 2015
  • New: Handling of multiple Kobo devices through profiles and recognition of the devices.
  • New: Remove Annotation files
  • New: Set Related Books.
  • Fix: Data written to db_prefs_backup.json file.
Version 1.8.5 - 13 December 2014
  • Fix: Latest duplicate shelves has all timestamps set to "1970-01-01T00:00:00Z". Need to use ids if all the dates are the same.
  • New: Display progress bar when removing the duplicate shelves.
Version 1.8.4 - 2 December 2014
  • Update: Spanish translation updated for recent changes.
Version 1.8.3 - 22 November 2014
  • Fix: Correct the name of the option for the backup on connection
Version 1.8.2 - 21 November 2014
  • New: Add option to do backup each time the device is connected.
  • Fix: Error building list of shelves when fetching from device.
  • Fix: Update menu handling for calibre 2.10 and later.
Version 1.8.1 - 9 November 2014
  • Fix: Added trigger for UPDATE to the Activity table
  • Fix: Change way debug logging is handled in jobs
Version 1.8.0 - 5 October 2014
  • New: Copy shelves from device to one column
  • Change: Backup config, affiliate.conf and version files and ADE registration
Version 1.7.3 - 19 August 2014
  • Fix: Wasn't correctly removing old backup files.
Version 1.7.2 - 28 July 2014
  • Change: Support for upcoming calibre 2.0
Version 1.7.1 - 5 July 2014
  • Fix: Error in metadata update when setting series and using plugboard
Version 1.7.0 - 16 June 2014
  • Change: Changed the series shelf ordering to allow ordering of other shelves and different sorting.
Version 1.6.9 - 21 May 2014
  • Fix: Commented out job logging as it was causing problems.
Version 1.6.8 - 13 May 2014
  • Fix: Fix the problem with Series management and metadata updating properly.
Version 1.6.7 - 12 May 2014
  • Fix: Series management from device list was not updated for new options in metadata updating.
  • Change: Background job logging as seem to be blowing the size of a buffer.
Version 1.6.6 - 10 May 2014
  • Change: When storing book status, use the status from the furtherest along copy if there are multiple copies. This is latest status, date or percent read.
  • Change: Make jobs DeviceJobs so they won't get run at same time as initial device jobs.
Version 1.6.5 - 22 April 2014
  • Fix: Debug statement had reference to "newmi" when it should have been "book"
Version 1.6.4 - 20 April 2014
  • Fix: Hard coded number of values in line spacing spin button.
  • Update: Line spacings changed with 3.2.0
  • Update: If store has "Not finished in library" selected, only fetch status for books that haven't been finished.
Version 1.6.3 - 12 April 2014
  • Fix: Setting reading status from device list was not updated for new options in metadata updating.
Version 1.6.2 - 29 March 2014
  • Fix: Older devices had the MAC address in the serial number field of the version file. Strip the colons from this so it can be used in the backup file name.
Version 1.6.1 - 22 March 2014
  • Fix: Removed a debug line that meant the database backup was named incorrectly.
Version 1.6.0 - 22 March 2014
  • New: Added tiles: "Release Note", "Categories"
  • New: Firmware check and download
  • New: Automatic backup of the device database
  • New: After batch reading position store, display list of changes.
  • Changed: Added options for using sort versions of title and author or the plugboard when updating metadata.
  • New: Spanish translation.
  • Fix: Clean images directory handles new images storage in FW2.9.0 and later
Version 1.5.0 - 18 December 2013
  • Update: Change reading location store to not update library if no changes.
  • New: Add auto store when device detected.
  • New: Added progress bars when creating store jobs and updating library
  • New: Added dismissing "In the cloud" tiles
  • New: If click button and no device connected, open configuration
Version 1.4.4 - 30 November 2013
  • Fix: Error displaying sizes after a database compression
Version 1.4.3 - 22 November 2013
  • Fix: Bad string handling in a debug statement.
Version 1.4.2 - 20 November 2013
  • New: Added code needed for internationalization
  • Fix: Issue with format of timestamps in device database. Needed to add timezone info.
Version 1.4.1 - 28 October 2013
  • Update: Option added when ordering series shelf to update shelf sorting in config file
Version 1.4.0 - 15 October 2013
  • New: For shelves that match a series name, change the date added to order by series order.
  • New: Add "Lock margins" checkbox to reader settings to set the right margin the same as the left
  • New: Add "Update config file" checkbox to reader settings to write the options to the "Kobo eReader.conf"
Version 1.3.0 - 3 October 2013
  • Update: Handling of line heights
  • New: Fix Duplicate shelves
Version 1.2.7 - 22 September 2013
  • Fix handling of older database versions with no ratings table.
Version 1.2.5 - 07 September 2013
  • New: Support for Kobo WiFi
  • Fix: Check for support of TIMESTAMP_STRING in device driver
  • Fix: Extra space after "false" in tile dismiss SQL
Version 1.2.3 - 08 August 2013
  • New: Add function to create trigger to remove AnalyticEvents
  • Fix: Spelling error in tooltip on Dismiss Tiles dialog
  • New: Add dismissing of new and finished books
  • Fix: Error when restoring reading location for kepubs
  • New: Changes to handle new db engine
Version 1.2.2 - 22 July 2013
  • Fix: Error in image directory checking of no SD card
Version 1.2.1 - 18 July 2013
  • Fix: Wasn't getting reading state from device for books that had been marked as read but never opened.
Version 1.2.0 - 16 July 2013
  • New: Change store to have option of background job
  • New: Check covers directory for extra image files
  • New: Added compress device database
  • Fix: Had "Gil Sans" instead of "Gill Sans"
Version 1.1.0 - 18 June 2013
  • New: Create/delete database trigger for dismissing tiles.
  • Update: Support sideloaded kepubs for reading location.
  • Fix: If rating wasn't set, attempted to divide None by 2.
  • Fix: Keep reference for all menu items to solve problem with OSX.
Version 1.0.0 - 9 June 2013
Initial release
Attached Files
File Type: epub KoboUtilities_Help.epub (18.9 KB, 3052 views)
File Type: zip KoboUtilities.zip (1.35 MB, 5480 views)

Last edited by chaley; 12-11-2023 at 05:40 AM. Reason: Update to version 2.16.10
davidfor is offline   Reply With Quote
Old 06-09-2013, 07:31 AM   #2
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,908
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Version History

Version 1.0 - 9 June 2013
Initial release
davidfor is offline   Reply With Quote
Advert
Old 06-09-2013, 07:33 AM   #3
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,908
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Suggestions

I'll add suggestion for future function. Being here is no promise that they will be done, but it means I'm not as likely to forget them.
  • Unpack firmware update from local file to device.

Last edited by davidfor; 06-23-2015 at 01:55 AM.
davidfor is offline   Reply With Quote
Old 06-09-2013, 07:34 AM   #4
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,908
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Reserved for later use

Just in case I want a second post near the top.
davidfor is offline   Reply With Quote
Old 06-09-2013, 08:27 AM   #5
PeterT
Grand Sorcerer
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
PeterT's Avatar
 
Posts: 12,103
Karma: 73447988
Join Date: Nov 2007
Location: Toronto
Device: Nexus 7, Clara, Touch, Tolino EPOS
I've been using this for some time and have found it to be very useful. It was very useful when my Touch died and I replaced it by a Glo. Because I had saved the reading locations with the driver I was able to restore to my Glo and pick up where I was.
PeterT is offline   Reply With Quote
Advert
Old 06-09-2013, 09:23 AM   #6
PeterT
Grand Sorcerer
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
PeterT's Avatar
 
Posts: 12,103
Karma: 73447988
Join Date: Nov 2007
Location: Toronto
Device: Nexus 7, Clara, Touch, Tolino EPOS
Here's one way I am using this plugin. After configuring it to store reading locations (four custom columns; koboreadpct integer, koborating integer, kobolastread date, and koboreadloc, text and associating them with the corresponding fields in the plugin setup), I added a new custom column
Code:
Name: finished
Column Heading: Finished
Column Type: Column built from other columns
Template: {:'cmp(field('#koboreadpct'),100,'','Finished','Finished')'}
and then added the field #finished to my shelf definitions which now read
Code:
#myshelves, #finished,  series
This has the effect of when I update the reading stats (I find the easiest way for ME at least) is to sort the Library view by the On Device field, select all the books shown as being on the Kobo and then select the plugin's option to store reading location, the Finished column gets set to the word Finished for all books at 100% read.

The next time I attach the device and the automatic metadata management runs, all the books I have finished now appear on a new shelf Finished.
PeterT is offline   Reply With Quote
Old 06-09-2013, 09:36 AM   #7
speakingtohe
Wizard
speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.
 
Posts: 4,812
Karma: 26912940
Join Date: Apr 2010
Device: sony PRS-T1 and T3, Kobo Mini and Aura HD, Tablet
Well this sounds wonderful. Especially the finished shelf. I have been wanting an Im_reading shelf and a finished shelf since I got a Kobo.

Day off tomorrow so will give it a try.

Thanks
Helen
speakingtohe is offline   Reply With Quote
Old 06-09-2013, 09:43 AM   #8
PeterT
Grand Sorcerer
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
PeterT's Avatar
 
Posts: 12,103
Karma: 73447988
Join Date: Nov 2007
Location: Toronto
Device: Nexus 7, Clara, Touch, Tolino EPOS
I've been playing with an I'm Reading shelf as well, but seem to be having problems getting it to sync. with the Kobo successfully. I do though expect to get this figured out soon
PeterT is offline   Reply With Quote
Old 06-09-2013, 10:09 AM   #9
taming
Trying for calm & polite
taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.
 
taming's Avatar
 
Posts: 4,012
Karma: 9455193
Join Date: May 2010
Location: Mostly in Canada
Device: kobo original, WiFI, Touch, Glo, and Aura
I do not have an option in the configuration for location. I set the columns up for 1.0 using Peter's choices. This was different from the way I had initially set them up. Somehow , I do not have a locations option that "draws from" koboreadloc. I have a blank line where that choice should be. I uninstalled the plugin, restarted, and then reinstalled--nothing changed. For the type of text file, I used the option that is like series.
taming is offline   Reply With Quote
Old 06-09-2013, 07:12 PM   #10
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,908
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
@taming: That was the wrong type for the location column. The four columns needed are
  • Current Reading Location: This is used to store the link to the current location in the book. It must be a "Text, column shown in the tag browser". It is recommended that the column is not shown in the column list and hidden in the tag browser.
  • Percent Read: This is the current percentage read for the book. It must be an "Integers" column.
  • Rating: This is the rating of the book. The standard "Rating" column in calibre can be used, or a custom used. If a custom column is used, it must be either a "Ratings, shown with stars" or an "Integers" type column.
  • Last Read Timestamp: This is the date the book was last read. This must be a "Timestamp" type column.

So, the column for the location has to be "Text, column shown in the tag browser". Any other won't work. And the configuration dialog will only display columns that are the right type for the usage.
davidfor is offline   Reply With Quote
Old 06-09-2013, 08:56 PM   #11
taming
Trying for calm & polite
taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.
 
taming's Avatar
 
Posts: 4,012
Karma: 9455193
Join Date: May 2010
Location: Mostly in Canada
Device: kobo original, WiFI, Touch, Glo, and Aura
Thanks David. How do I set it as hidden in the tag browser?
taming is offline   Reply With Quote
Old 06-09-2013, 09:31 PM   #12
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,908
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Right click on it in the tag browser and select the "Hide category" option.
davidfor is offline   Reply With Quote
Old 06-10-2013, 12:10 AM   #13
PeterT
Grand Sorcerer
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
PeterT's Avatar
 
Posts: 12,103
Karma: 73447988
Join Date: Nov 2007
Location: Toronto
Device: Nexus 7, Clara, Touch, Tolino EPOS
This custom column seems to work for adding a book to either a Reading or Finished shelf based on the pct read.

Code:
Lookup name:    readstatus
Column Heading: Reading Status
Column Type:    Column built from other columns
Template:       {#koboreadpct:'cmp($, 100, cmp($, 0, '', '', 'Reading'), 'Finished', '')'}
with of course the corresponding change to add #readstatus to the list of fields used for shelving in either the Kobo or ExtendedKobo drivers. (I tend to update them both even though the Extended driver is normally disabled on my system).

In effect this is saying if the Pct Read is 100, the book is Finished, else if it's greater than 0, then the status is Reading.
PeterT is offline   Reply With Quote
Old 06-10-2013, 06:38 AM   #14
taming
Trying for calm & polite
taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.
 
taming's Avatar
 
Posts: 4,012
Karma: 9455193
Join Date: May 2010
Location: Mostly in Canada
Device: kobo original, WiFI, Touch, Glo, and Aura
Quote:
Originally Posted by davidfor View Post
Right click on it in the tag browser and select the "Hide category" option.
Thanks, I did not know that the list on my far left was called the tag browser. How non-good at this can a oerson be. I kept trying to do something using the alter tag browser drop list.
taming is offline   Reply With Quote
Old 06-10-2013, 06:48 AM   #15
GeoffR
Wizard
GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.
 
GeoffR's Avatar
 
Posts: 3,821
Karma: 19162882
Join Date: Nov 2012
Location: Te Riu-a-Māui
Device: Kobo Glo
This is a very useful plugin, thanks! I use it mainly to correct metadata for kepub books (such as changing the author's name from LN,FN to FN LN format, removing redundant series info from the title, etc.), and for adding publisher/date/ISBN info to the database entries for sideloaded epubs. Much easier than editing the database manually.
GeoffR is offline   Reply With Quote
Reply

Tags
kobo, kobo utilities

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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


All times are GMT -4. The time now is 11:29 PM.


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