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 02-17-2017, 07:49 AM   #1246
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: 12,437
Karma: 18869148
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo: Touch, Glo, Aura H2O, Glo HD
Quote:
Originally Posted by oren64 View Post
This is only a request, and if you have the time to do it, I don't know if it's even possible.

To take the book status (Read, Unread, Finished), from sqlite file (I didn't find where it's in sqlite file), and to load it, into a custom column.
So if you finished a book on your device, when you connect the device to calibre, it will change to Finished in the custom column.
I don't know how it will work if somebody have more than one device.
Um, the plugin has been able to do that from the very start. But, it isn't getting the state, it gets the reading percentage. The state is also used, but, the percent read will be 100 if the book has been finished. The fetch can be run at connect time and can also check date and current status before doing the fetch. I also use column icons rules to display different icons in the percent read column based on the percent read.

For owners of multiple devices, you can either use the last read timestamp and state to decide if you update the state. Or you define a profile for each device and store the reading status in different sets of columns for each device.

And in the database, on the table "content", the column "ReadStatus" contains the reading status. 0 means unread, 1 is reading and 2 is finished. 3 is "Closed" but I don't think that is used in any recent firmware, and I never worked out exactly what it meant.
davidfor is offline   Reply With Quote
Advert
Old 02-17-2017, 09:42 AM   #1247
oren64
I need a chapter break
oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.
 
oren64's Avatar
 
Posts: 2,864
Karma: 37886418
Join Date: Mar 2015
Location: Israel
Device: kobo glo
Quote:
Originally Posted by davidfor View Post
Um, the plugin has been able to do that from the very start. But, it isn't getting the state, it gets the reading percentage. The state is also used, but, the percent read will be 100 if the book has been finished. The fetch can be run at connect time and can also check date and current status before doing the fetch. I also use column icons rules to display different icons in the percent read column based on the percent read.
I missed that

Last edited by oren64; 02-17-2017 at 09:51 AM.
oren64 is offline   Reply With Quote
Old 02-19-2017, 05:40 PM   #1248
oren64
I need a chapter break
oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.
 
oren64's Avatar
 
Posts: 2,864
Karma: 37886418
Join Date: Mar 2015
Location: Israel
Device: kobo glo
I want to use the percentage column to build status read column (text), but I find it a little difficult to make a template function.

If percentage is 1-99 return "Read".
If percentage is 100 return "Finished".

Edit: I managed to make the function.

Last edited by oren64; 02-20-2017 at 12:58 AM.
oren64 is offline   Reply With Quote
Old 02-23-2017, 08:43 PM   #1249
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: 9,841
Karma: 56938177
Join Date: Nov 2007
Location: Toronto
Device: Wife: Touch, Arc, Vox Me: Nexus 7, Glo
@davidfor Would it be practical to have either the device driver or the plugin check to see if the user has columns defined for shelving, but has left metadata management at anything other than automatic, and alert them?
PeterT is offline   Reply With Quote
Old 03-04-2017, 03:52 AM   #1250
iostrym
Connoisseur
iostrym began at the beginning.
 
Posts: 63
Karma: 10
Join Date: Mar 2015
Device: kobo
Quote:
Originally Posted by davidfor View Post
The Kobo devices do annotations in two ways. They store annotations for all book formats in the internal database. For epubs and PDFs, annotations are also stored in files. The two annotations functions in the plugin work on these two different different mechanisms.

Personally, I don't recommend either of these. The "Backup Annotation File" was a quick and dirty addition that I don't find very useful. The "Copy Annotations" was intended for copying and pasting the annotations elsewhere. Depending on what you want, a better method to extract the annotations is the Annotations plugin. It copies them to a column in calibre with some reasonable formatting. But, if the purpose is to back them up and restore them later, there isn't an automatic way to do this. Some people have written scripts to extract the data from the database. A search of the Kobo subforum should find them.
Hello, I thought that Kobo devices were not able to do annotation in PDF ? And for epub I was said that annotation are stored in a different file. Is there a major modification concerning this for Kobo devices ?
iostrym is offline   Reply With Quote
Advert
Old 03-04-2017, 06:18 AM   #1251
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: 12,437
Karma: 18869148
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo: Touch, Glo, Aura H2O, Glo HD
Quote:
Originally Posted by iostrym View Post
Hello, I thought that Kobo devices were not able to do annotation in PDF ? And for epub I was said that annotation are stored in a different file. Is there a major modification concerning this for Kobo devices ?
For PDFs, you can make a bookmark by tapping the top right-corner of the screen. Then you can add a note to this from the annotations list. You cannot mark text in a PDF to save as a highlight.

Other than that, it works as I said. The annotations/bookmarks/highlights are stored in the database for all formats. For PDF and epubs on the main memory of the device, the are also stored in a file. It has been like this all the time I have been using Kobo device and I haven't seen any recent changes.
davidfor is offline   Reply With Quote
Old 03-04-2017, 12:20 PM   #1252
iostrym
Connoisseur
iostrym began at the beginning.
 
Posts: 63
Karma: 10
Join Date: Mar 2015
Device: kobo
Quote:
Originally Posted by davidfor View Post
For PDFs, you can make a bookmark by tapping the top right-corner of the screen. Then you can add a note to this from the annotations list. You cannot mark text in a PDF to save as a highlight.

Other than that, it works as I said. The annotations/bookmarks/highlights are stored in the database for all formats. For PDF and epubs on the main memory of the device, the are also stored in a file. It has been like this all the time I have been using Kobo device and I haven't seen any recent changes.
Thanks. I was used to do this to annote pdf but I stop doing this since I notice that very often annotation were deleted. So I think myself that this tips was more a bug than a feature...

This kind of PDF annotation can be retrieved using the Kobo driver calibre like epub ?

Without calibre I could be able to retrieve also the annotation as there are stored by Kobo also inside the epub or the pdf ? Using official metadata ? Like xmp ?
iostrym is offline   Reply With Quote
Old 03-05-2017, 04:22 AM   #1253
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: 12,437
Karma: 18869148
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo: Touch, Glo, Aura H2O, Glo HD
Quote:
Originally Posted by iostrym View Post
Thanks. I was used to do this to annote pdf but I stop doing this since I notice that very often annotation were deleted. So I think myself that this tips was more a bug than a feature...
I don't think it is a bug. Allowing bookmarks in PDF should be OK. Then attaching a note to that should work as well.
Quote:
This kind of PDF annotation can be retrieved using the Kobo driver calibre like epub ?
The annotations fetch that the driver does reads the database. It should fetch any annotations for any book format.
Quote:
Without calibre I could be able to retrieve also the annotation as there are stored by Kobo also inside the epub or the pdf ? Using official metadata ? Like xmp ?
Only if the device copies the annotations from the book to the database. I haven't looked to see what happened.
davidfor is offline   Reply With Quote
Old 03-05-2017, 03:52 PM   #1254
iostrym
Connoisseur
iostrym began at the beginning.
 
Posts: 63
Karma: 10
Join Date: Mar 2015
Device: kobo
thanks but I don't understand the last part : "Only if the device copies the annotations from the book to the database. I haven't looked to see what happened. "

did I correctly understand previous messages when you said that kobo store annotation of epub and pdf in internal database of kobo AND inside the file itself ?

if yes, I wonder if it is possible to do a copy paste of the epub or the pdf from the kobo to the pc and read the annotation using a windows pdf reader for instance.
iostrym is offline   Reply With Quote
Old 03-05-2017, 05:27 PM   #1255
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: 9,841
Karma: 56938177
Join Date: Nov 2007
Location: Toronto
Device: Wife: Touch, Arc, Vox Me: Nexus 7, Glo
Quote:
Originally Posted by PeterT View Post
@davidfor Would it be practical to have either the device driver or the plugin check to see if the user has columns defined for shelving, but has left metadata management at anything other than automatic, and alert them?
Any thoughts david?
PeterT is offline   Reply With Quote
Old 03-06-2017, 12:36 AM   #1256
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: 12,437
Karma: 18869148
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo: Touch, Glo, Aura H2O, Glo HD
Quote:
Originally Posted by iostrym View Post
thanks but I don't understand the last part : "Only if the device copies the annotations from the book to the database. I haven't looked to see what happened. "
The annotations are being retrieved from the database. If there are annotations elsewhere, such as in the PDF, they will not be retrieved. But, it is possible that sometime during the processing of the PDF, that any annotations inside it are copied to the database. If this happens, and I have no idea if it does, then these annotations would be copied by the plugin as well.
Quote:
did I correctly understand previous messages when you said that kobo store annotation of epub and pdf in internal database of kobo AND inside the file itself ?
All annotations created on the device are stored in the database. Annotations for epub and PDFs that are on the main memory are also stored in a file. This file is created by the Adobe RMSDK.
Quote:
if yes, I wonder if it is possible to do a copy paste of the epub or the pdf from the kobo to the pc and read the annotation using a windows pdf reader for instance.
Probably not. It depends on what the PDF reader is doing. The place it can work is in ADE on the PC. This uses the same format for the annotations as the file on the device. I have copied the file back to the ADE file directory and edited it to get some keys to match. Then ADE used this file for annotations while reading an epub.
davidfor is offline   Reply With Quote
Old 03-06-2017, 12:55 AM   #1257
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: 12,437
Karma: 18869148
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo: Touch, Glo, Aura H2O, Glo HD
Quote:
Originally Posted by PeterT View Post
Any thoughts david?
Just about anything is possible. I'm not sure whether it is worth doing or not. It would be possible to add something to the driver configuration to display a message when the collection options get set to remind them to do it. But I don't think that adding something that when the driver is actually doing something to remind them is a good idea. But, I might highlight it in the debug log so that it is easier to find.

The utilities plugin could also do something, but when is the question. I can't think of a good way or time to do it. Do I run a job each time that checks? What I have considered is adding status/debug data function. This would be a dialog to display all the info about the device and be easy to export or copy to the clipboard to past into a thread like this. Including this would make sense. It's been in the back of my mind for a while, but I just haven't gotten around to it.
davidfor is offline   Reply With Quote
Old 03-06-2017, 07:21 AM   #1258
iostrym
Connoisseur
iostrym began at the beginning.
 
Posts: 63
Karma: 10
Join Date: Mar 2015
Device: kobo
Quote:
Originally Posted by davidfor View Post

All annotations created on the device are stored in the database. Annotations for epub and PDFs that are on the main memory are also stored in a file. This file is created by the Adobe RMSDK.
Thanks, so I did not corretly understand. annotation are stored in the database and also in a file. but not inside the corresponding pdf or epub file. thanks for the precision
iostrym is offline   Reply With Quote
Old 03-09-2017, 05:00 PM   #1259
iostrym
Connoisseur
iostrym began at the beginning.
 
Posts: 63
Karma: 10
Join Date: Mar 2015
Device: kobo
I did a try to backup in calibre some annotations stored in a pdf file and it fails. nothing was retrieved, no error message also. It works perfectly with epub.
iostrym is offline   Reply With Quote
Old 03-18-2017, 01:32 PM   #1260
anacreon
Fanatic
anacreon ought to be getting tired of karma fortunes by now.anacreon ought to be getting tired of karma fortunes by now.anacreon ought to be getting tired of karma fortunes by now.anacreon ought to be getting tired of karma fortunes by now.anacreon ought to be getting tired of karma fortunes by now.anacreon ought to be getting tired of karma fortunes by now.anacreon ought to be getting tired of karma fortunes by now.anacreon ought to be getting tired of karma fortunes by now.anacreon ought to be getting tired of karma fortunes by now.anacreon ought to be getting tired of karma fortunes by now.anacreon ought to be getting tired of karma fortunes by now.
 
anacreon's Avatar
 
Posts: 522
Karma: 398310
Join Date: May 2012
Location: France
Device: Glo HD, H2o, Aura One
problems opening a catalog

moved to the appropriate thread (KoboTouchExtended)

Last edited by anacreon; 03-19-2017 at 01:32 AM.
anacreon is offline   Reply With Quote
Reply

Tags
kobo

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[GUI Plugin] Hyphenate This! SauliusP. Plugins 305 06-04-2017 04:29 AM
[GUI Plugin] EpubSplit JimmXinu Plugins 194 05-01-2017 01:51 AM
[GUI Plugin] KindleUnpack - The Plugin DiapDealer Plugins 402 03-05-2017 10:31 AM
[GUI Plugin] Wordpress frescogamba Plugins 11 04-06-2015 09:09 PM
[GUI Plugin] Plugin Updater **Deprecated** kiwidude Plugins 159 06-19-2011 12:27 PM


All times are GMT -4. The time now is 03:32 AM.


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