[GUI Plugin] Kobo Utilities

[ownedbycats]

It might make sense to just copy SeriesNumberFloat from Calibre series_index without modification.

[chaley]

Discussion about separating series_index (float) and series_index (text) is now in Kobo: Separate series index (text) and series_index (float)?

[Quality]

Is there a way to edit or delete an already existing columns? I only have the option to create a new one or to select on that already exists.

[JSWolf]

Originally Posted by Quality

Is there a way to edit or delete an already existing columns? I only have the option to create a new one or to select on that already exists.

You need to attach your images. The [img] tag rarely works and in this case, it's not working and your image in not showing. You need to make sure you are in the advanced edition and then click the manage attachments button under your message and go from there.

[Quality]

Thank you for the info, here is the image.

[DNSB]

Originally Posted by Quality

Is there a way to edit or delete an already existing columns? I only have the option to create a new one or to select on that already exists.

Have you tried going into calibre's preferences? Preferences => Add your own columns then select the column you want to edit and click on the pen/paper icon to edit.

[Quality]

Oh I see thank you, I am not that well versed with calibre.

[DNSB]

Originally Posted by Quality

Oh I see thank you, I am not that well versed with calibre.

Like most Swiss army knife tools, finding where to do something can be a pain.

[Lavender]

Can someone explain the current annotation options with koboutilities? I would like to be able to back up annotations made on my kobo, and in the event that I delete the kepub from device then resync the file with calibre in the future I want to restore the annotation data to that book. Can this be done? Is it a desire for the project if not?

[targosh]

I am getting a template error for the time spent read column but am unsure why? Anyone has any ideas?

Originally Posted by Majutsushi

Time Spent Reading / Rest of Book Estimate formatting

If you want to show the "Time Spent Reading" and "Rest of Book Estimate" values in anything other than seconds, you will have to create two new columns that are based on the "seconds" columns and format the value differently.

Here is how you can do this:

• Open the Calibre preferences.
• Click on "Add your own columns".
• Click on "Add custom column" or the green "+" sign on the right.
• Enter a lookup name, like "#my_time_spent_reading".
• Enter a column heading, like "Time Spent Reading".
• For column type, choose "Column built from other columns".
• Right-click in the "Template" entry field and click "Open template editor".
• Enter the code to format the seconds to something else.
  
  Here is an example:
  

  program:
  
  total = $#kobo_time_spent_reading;
  hours = floor(total/3600);
  minutes = round((total-hours*3600)/60);
  
  def format(v, str):
      if v == 0 then return '' fi;
      return v & ' ' & str & ' '
  fed;
  format(hours, 'hr') & format(minutes, 'min')

  This will format the time as something like "3 hr 27 min".
  
  Make sure to replace "#kobo_time_spent_reading" with the actual lookup name of the seconds column you want to reference.
• Press "OK"/"Apply" to close all the dialogs and restart Calibre.

For more information about writing such a template check out https://manual.calibre-ebook.com/template_lang.html.

[chaley]

Originally Posted by targosh

I am getting a template error for the time spent read column but am unsure why? Anyone has any ideas?

It would be useful to have the actual template and the error. Otherwise we are wasting time guessing.

[DNSB]

As @chaley said, it would help if you posted what you used as the template and the column definition.

For what it may be worth, here's my variant which gives hours, minutes, seconds:

program:

	total = $#kobo_time_spent_reading;

	hours = floor(total/3600);
	minutes = floor(mod(total, 3600)/60);
	seconds = mod(total, 60);
	def format(v, str):
    if v == 0 then return '' fi;
    return v & ' ' & str & ' '
fed;
format(hours, 'hr') & format(minutes, 'min') & format(seconds, 'sec')

[chaley]

Originally Posted by DNSB

As @chaley said, it would help if you posted what you used as the template and the column definition.

For what it may be worth, here's my variant which gives hours, minutes, seconds:

program:

	total = $#kobo_time_spent_reading;

	hours = floor(total/3600);
	minutes = floor(mod(total, 3600)/60);
	seconds = mod(total, 60);
	def format(v, str):
    if v == 0 then return '' fi;
    return v & ' ' & str & ' '
fed;
format(hours, 'hr') & format(minutes, 'min') & format(seconds, 'sec')

FWIW: I've seen several posts over the years that discuss formatting a duration in seconds into some "human readable" string. I decided to add a template function

format_duration(value, template, largest_unit)

that given a duration is seconds can produce things like "2 weeks 4 days 20 minutes". I'll post the documentation in the template changes thread if and when Kovid accepts the change.

[DNSB]

Originally Posted by chaley

FWIW: I've seen several posts over the years that discuss formatting a duration in seconds into some "human readable" string. I decided to add a template function.

format_duration(value, template, largest_unit)

that given a duration is seconds can produce things like "2 weeks 4 days 20 minutes". I'll post the documentation in the template changes thread if and when Kovid accepts the change.

For me, I've only once had a reading time go over 17 hours (and that was an omnibus with over 1 million words).

OTOH, your new function looks good for some of my other uses and is much appreciated compared to my current multi-line mess for converting seconds to other time units.

Edit: downloaded calibre source and the format_duration seems to be working okay for me where a book has been opened to read. I still need to play handling entries where the book has not been opened.