12-03-2017, 02:10 PM | #31 | |
Junior Member
Posts: 4
Karma: 338
Join Date: Nov 2017
Device: PocketBook HD
|
Quote:
|
|
01-09-2018, 04:08 PM | #32 | |
Junior Member
Posts: 4
Karma: 338
Join Date: Nov 2017
Device: PocketBook HD
|
Quote:
Last edited by Arni1; 01-09-2018 at 04:13 PM. Reason: Typos |
|
Advert | |
|
05-29-2018, 08:34 AM | #33 |
Junior Member
Posts: 6
Karma: 10
Join Date: May 2018
Device: PocketBook Inkpad 3 PB740 FW: 5.17
|
I just would like to say that I would appreciate if there was a way for Linux to extract annotations from PocketBook InkPad 3, preferably if it did not require to install any untrusted packages because as a student I am going to make many notes on my course materials which are in pdf. I don't need it right now but I will need it in the future.
|
05-29-2018, 10:50 AM | #34 |
Junior Member
Posts: 3
Karma: 12
Join Date: May 2018
Device: PRS-T2
|
Dear Reading Experts
As in the post before I am considering to purchase a PocketBook InkPad 3. Untill now I am using the Sony PRS-T2 and I do totally love the plugin annotation exporter of Toxaris, which is a great peace of work! Can anybody tell me, if the toxaris plugin will work on the Pocketbook InkPad 3? Or will there be the mentioned problems with the changed database structure? All the best; have a Perfect Day |
05-29-2018, 11:04 AM | #35 |
Junior Member
Posts: 3
Karma: 12
Join Date: May 2018
Device: PRS-T2
|
By the way:
I did as well experiment with the highlight exporter from https://www.aar-innovations.com. But the functionality seems to be very limited: - export without page numbers - only limited characters for the sony-prs series and no option to "expand the text" as with the annotations exporter from Toxaris - very complicated buying process with a company called PayPro, which will ask you for your phone number by mail and let you know, that you couldn't purchase for technical reasons 2 days later So you guys surely understand, that I am hoping for Toxaris' solution in that matter. All the best and have a Perfect Day Last edited by Perfect Day; 05-29-2018 at 11:07 AM. |
Advert | |
|
08-25-2018, 03:26 PM | #36 |
Member
Posts: 23
Karma: 50
Join Date: Jul 2018
Location: Amsterdam
Device: Onyx Boox Max 2 / PocketBook Inkpad 3 / Kindle Paperwhite 3
|
Sample code
It is pretty easy to get to those annotations. Here is an idea:
That file (books.db) is a simple sqlite database. You can query it using any sqlite3 client, but to do it properly you need the json1 extension installed as well. Here is a sample query that gives you a neatly formatted html table (see attached): Code:
echo "<HTML><BODY><TABLE>"$(sqlite3 --header --html books.db "select Title, Authors, json_extract(Highlight, '$.text') as Text from Books inner join (select OID as BookID, Highlight from Items inner join (select ParentID, Highlight from Items inner join (select ItemID, Val as Highlight from Tags where TagID = 104 and Val <> '{\"text\":\"Bookmark\"}') as Highlights on Highlights.ItemID = OID) as Highlights on Highlights.ParentID = OID) as Highlights on BookID = OID;")"</TABLE></BODY></HTML>" > highlights.html Last edited by retrography; 08-25-2018 at 03:32 PM. |
08-26-2018, 09:22 AM | #37 |
Junior Member
Posts: 3
Karma: 10
Join Date: Jul 2018
Device: PB InkPad3
|
Thanks @retrography. That is very useful script.
I ve tried to add default Unicode encoding for html to the script, but without success. Last edited by ubuntero; 08-26-2018 at 03:32 PM. |
08-26-2018, 01:39 PM | #38 | |
Member
Posts: 23
Karma: 50
Join Date: Jul 2018
Location: Amsterdam
Device: Onyx Boox Max 2 / PocketBook Inkpad 3 / Kindle Paperwhite 3
|
Quote:
As far as I know the default database encoding in SQLite is UTF8, and the exported HTML must be UTF8 encoded by default (see my sample file attached to my last post). Maybe your books are not UTF8 encoded, but as far as I know PocketBook should be able to take care of that. You can check your DB encoding using: Code:
PRAGMA encoding; But all in all, I am not a database or text encoding expert. I would personally never load anything non-Unicode on my reader first place so that I don't get into encoding issues afterwards. I have lost precious notes like that before. |
|
08-26-2018, 04:49 PM | #39 |
Junior Member
Posts: 3
Karma: 10
Join Date: Jul 2018
Device: PB InkPad3
|
Sorry, I didn`t clarify properly what I really wanted to achieve.
I wanted my browser to autorecognize encoding, which is finally possible by adding <meta> tag to your code. Code:
echo "<HTML><HEAD><META CHARSET="UTF-8"></HEAD><BODY><TABLE>"$(sqlite3 --header --html books.db "select Title, Authors, json_extract(Highlight, '$.text') as Text from Books inner join (select OID as BookID, Highlight from Items inner join (select ParentID, Highlight from Items inner join (select ItemID, Val as Highlight from Tags where TagID = 104 and Val <> '{\"text\":\"Bookmark\"}') as Highlights on Highlights.ItemID = OID) as Highlights on Highlights.ParentID = OID) as Highlights on BookID = OID;")"</TABLE></BODY></HTML>" > highlights.html |
09-01-2018, 03:11 AM | #40 |
Member
Posts: 17
Karma: 10
Join Date: Aug 2018
Device: Don't have
|
HI!!
I wanted to know if someone uses koreader and sync with evernote, to export the underlined parts, and if it works well? |
10-01-2018, 07:39 AM | #41 |
Member
Posts: 23
Karma: 50
Join Date: Jul 2018
Location: Amsterdam
Device: Onyx Boox Max 2 / PocketBook Inkpad 3 / Kindle Paperwhite 3
|
Hi @Noto! I just saw this. Koreader works pretty decently on Pocketbook, with only a few minor issues. The sync with Dropbox, though, is not amazing. Pocketbook’s “sync” module is actually not a real sync module, as it does not understand incremental updates. So, what happens is that each time you open a book, Koreader overwrites the sidefiles in the homonymous sdr directory, but when pocketbook tries to sync, it does not know which version is the best version (remote or local), so it renamed the local file and resyncs the storage with the remote. Put differently, it always considers the remote as the master in case if conflicts. Worse, pocketbook does this every time it syncs, even if there is no new modifications. At the end of the day you end up with hundreds of copies of the files in your sdr directory. If you try to embed the annotation inside the PDFs with Koreader, then you will end up with hundreds of copies of your PDF file.
So, not ideal. And just because of a terrible, amateur implementation. That doesn’t surprise me though. There are many small issues like that with the pocketbook reader. |
04-10-2021, 06:35 PM | #42 |
Junior Member
Posts: 4
Karma: 338
Join Date: Nov 2017
Device: PocketBook HD
|
Just to share my experience (do not get me wrong: not advertising anything): several months ago swiched to MacOS and had troubles finding something decent to extract my notes / highlights.
Ended up with Highlights Extractor which turned out to be the one doing the job well. |
05-08-2021, 07:05 AM | #43 |
Zealot
Posts: 120
Karma: 87007
Join Date: Apr 2021
Device: Lux 5, Libra 2, PRS-T2N
|
Calibre annotations plugin has pocketbook support added
Update: I developed a tool for interactively viewing annotations, see the mobileread 'AVATeR' thread.
The Calibre annotations plugin can now be used to extract Pocketbook annotations. It's currently only in the beta. Any testers are welcome, see below for the beta of 10 May 2021: https://www.mobileread.com/forums/sh...&postcount=945 Last edited by wold; 03-28-2022 at 12:38 PM. Reason: Linked new beta post |
06-26-2023, 03:18 PM | #44 | |
Junior Member
Posts: 5
Karma: 10
Join Date: Jul 2020
Location: France
Device: [PocketBook|Vivlio] Touch HD plus PB632
|
Quote:
To get all this, I reach the limit of my SQL skills, but I will prepare a small python code to get all this, and also to try to ADD notes. I have an old broken PB632 this many notes, and eventually manage to get its books.db file, so I want to add these notes & highlight into my new pb632... -- Frapi |
|
06-28-2023, 12:57 PM | #45 | |
Junior Member
Posts: 5
Karma: 10
Join Date: Jul 2020
Location: France
Device: [PocketBook|Vivlio] Touch HD plus PB632
|
READING / WRITING ANNOTATIONS
Quote:
Just make sure (for instance by rebooting the reader before) that all the wal (db logs, see https://www.sqlite.org/wal.html ) are actually synced into books.db, so no more books.db-wal or books.db-shm in /mnt/ext1/system/config/ Then copy books.db on a computer any sqlite editor allows you to add notes or highlights. 1) create a new item, ParentID : book's OID TypeID : 4 (book_mark) State : 0 (?) TimeAlt : a timestamp HashUUID : an UUID 2) Then create parts in Tags For note, : ItemId : item's OID you just created TagID : 101 (for book_mark) Val : json, eg {"anchor":"pbr:/word?page=1&offs=398","created":1687936650}, with pos on the book (page/offset) and same timestamp TimeEdt : same timestamp then TagId : 102 (for type) Val : note TagId : 104 (for quotation) Val : json, eg {"begin":"pbr:/word?page=1&offs=398","end":"pbr:/word?page=1&over=484","text":"Nous avons toujours cru que les vies de nos enfants seraient meilleures que les nôtres."} ( ! no timestamp there) TagID : 105 (for text) Val : json eg {"text":"Et maintenant en 2023 on en est encore plus sûrs que ça ne sera pas le cas !"} [optional I think] TagID : 106 (for color) val: cian For highlight : same, but no 105, and 102 is "highlight" Then copy back books.db on reader's /mnt/ext1/system/config/ (with a rooted reader it might be more convenient) reboot Definitely, it's not easy from a printed book to identify page & offset, but in my case I wanted to re-insert notes from a previous reader's books.db database, so it's OK. Some caveats : - Not quite sure how we should build UUID, when from scratch... might be dependent from other fields ? - books you want to add notes for MUST have been opened at least once on the reader (they are not listed in books table otherwise) For my usage, I will build a code - extracting all note and highlight from a books.db, - inserting all this in an other books.db Will give it somewhere, you may reuse/fork -- Frapi |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Annotations: Capture/Convert Kobo-Kindle (uses OpenWith and Annotations Plugins) | EnergyLens | Related Tools | 12 | 03-28-2020 01:04 PM |
Bin firmware extraction | druss67 | PocketBook | 4 | 08-25-2016 07:25 PM |
ISBN Extraction with OCR | Noobish | Related Tools | 1 | 04-13-2014 02:45 AM |
903 PDF annotations on Pocketbook 903 | bogdaniosif | PocketBook | 70 | 09-07-2011 09:59 AM |
302 Pocketbook 302 Highlighting / annotations | lotusmonk | PocketBook | 0 | 01-09-2011 01:00 PM |