Exporting annotations, bookmarks and reading progress to the cloud - Page 2

NiLuJe · 10-18-2022, 12:08 PM

You could simply check if wpa_supplicant managed to associate with an AP via wpa_cli, that should work just as well, will only block as long as necessary, and doesn't require actual WAN connectivity.

c.f., https://github.com/koreader/koreader...sync.sh#L8-L20

Or, in a similar fashion, poke sysfs until the network IF is up:

c.f., https://github.com/koreader/koreader...ce.lua#L15-L27

(Except don't hardcode the IF name, use the ${INTERFACE} env var).

Leonatus · 10-18-2022, 12:35 PM

I would be very interested in this, but as I'm no technic, I've got some difficulties: Where do I find the extracting location /mnt/onboard/.adds/notes/? I suppose it should be in the Kobo?

qkqw · 10-18-2022, 06:06 PM

Quote:

Originally Posted by Leonatus

I would be very interested in this, but as I'm no technic, I've got some difficulties: Where do I find the extracting location /mnt/onboard/.adds/notes/? I suppose it should be in the Kobo?

That location points to a hidden folder on your Kobo, ie. when you plug it into your computer you'd have to create it at

Code:

.adds/notes

. For this script to work though you'd need NickelMenu and if you want to sync it, KoboCloud.

Leonatus · 10-19-2022, 04:03 AM

Quote:

Originally Posted by qkqw

For this script to work though you'd need NickelMenu and if you want to sync it, KoboCloud.

Thank you! I'll fail on this, as I have neither NickelMenu nor KoboCloud. Pity!

qkqw · 02-16-2023, 08:10 PM

I've uploaded a small update that removes the KoboCloud dependency (none of you guys were using it anyways) and renames notes with their current date. That allows you to have a history of exported notes, of which currently only 21 (worth for at least 3 weeks) are kept. That number can be configured.

qkqw · 08-04-2023, 03:33 AM

I've uploaded a small update to the script, allowing to export the book progress of PDFs as well.

qkqw · 10-16-2023, 01:53 PM

Fixed a bug in reading progress that didn't list a book when it doesn't have any chapter titles (e.g. PDFs or automatically generated Epubs).

Cyril Gabard · 03-17-2024, 05:06 PM

Hello, i've discover your script and i find it pretty awesome. Thanks for your work !

I'm working to get into the world of scripts and database queries. I modified your script to translate it and to sort notes by the most recent, everything works fine but i noticed that some books that I highlighted or "dogeared" dont show in my md file.

I noticed that the book that is not showing is a book that has no chapter names. But the same book is shown in "reading progress".

All my books are converted to kepub by Calibre.

Any clue ?

qkqw · 03-18-2024, 12:08 PM

Sqlite is pretty finicky when it comes to NULL values. You could try to modify the query and do a

Code:

SELECT * FROM Bookmark b...

and see if anything shows up. If so, we'd need to update the formatting, if not, the query would have to be adjusted.

Cyril Gabard · 03-18-2024, 03:22 PM

Quote:

Originally Posted by qkqw

Sqlite is pretty finicky when it comes to NULL values. You could try to modify the query and do a

Code:

SELECT * FROM Bookmark b...

and see if anything shows up. If so, we'd need to update the formatting, if not, the query would have to be adjusted.

Sorry, I'm not geek enough. Where do i put this code ? What is after b... ?

qkqw · 03-18-2024, 04:19 PM

Quote:

Originally Posted by Cyril Gabard

Sorry, I'm not geek enough. Where do i put this code ? What is after b... ?

It's the main SQL query in the script which fetches all results

Cyril Gabard · 03-18-2024, 06:07 PM

Quote:

Originally Posted by qkqw

It's the main SQL query in the script which fetches all results

Could you show me the script rewritten ? I think i cannot do it, sorry

DNSB · 03-18-2024, 08:08 PM

Quote:

Originally Posted by Cyril Gabard

Could you show me the script rewritten ? I think i cannot do it, sorry

If you look around line 67 in notes.sh file from the 20231016 .zip file, you will see a line starting:

Code:

  FROM Bookmark b

I think what was meant in the @qkqw's post is that for testing, the line should be modified to:

Code:

SELECT * FROM Bookmark b

Good luck!

Cyril Gabard · 03-19-2024, 05:01 AM

Quote:

Originally Posted by DNSB

If you look around line 67 in notes.sh file from the 20231016 .zip file, you will see a line starting:

Code:

  FROM Bookmark b

I think what was meant in the @qkqw's post is that for testing, the line should be modified to:

Code:

SELECT * FROM Bookmark b

Good luck!

Tx ! i'll try and come back here to tell !

Cyril Gabard · 03-20-2024, 05:02 PM

Quote:

Originally Posted by Cyril Gabard

Tx ! i'll try and come back here to tell !

Hi, I tried this change but it emptied the bookmarks part of the markdown

03-17-2024, 05:06 PM	#23
Cyril Gabard Connoisseur Posts: 54 Karma: 10 Join Date: Oct 2019 Location: France Device: Clara HD	Hello, i've discover your script and i find it pretty awesome. Thanks for your work ! I'm working to get into the world of scripts and database queries. I modified your script to translate it and to sort notes by the most recent, everything works fine but i noticed that some books that I highlighted or "dogeared" dont show in my md file. I noticed that the book that is not showing is a book that has no chapter names. But the same book is shown in "reading progress". All my books are converted to kepub by Calibre. Any clue ? Last edited by Cyril Gabard; 03-17-2024 at 05:17 PM.

03-18-2024, 12:08 PM	#24
qkqw Connoisseur Posts: 67 Karma: 143000 Join Date: Apr 2022 Device: Kobo Libra 2	Sqlite is pretty finicky when it comes to NULL values. You could try to modify the query and do a Code: SELECT * FROM Bookmark b... and see if anything shows up. If so, we'd need to update the formatting, if not, the query would have to be adjusted.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
import of annotations and reading progress	Percivale	Kobo Developer's Corner	3	12-20-2017 09:21 PM
Reading app with freehand annotations and cloud sync (Dropbox, Google Drive, ...)	sjvs	Reading and Management	1	08-30-2013 04:18 PM
Any way of exporting bookmarks in Shubooks?	robinson	Apple Devices	4	03-31-2013 12:23 PM
Importing/exporting bookmarks	riki	Library Management	0	01-18-2012 11:25 AM
Exporting Annotations	musemj6	Kindle Developer's Corner	0	12-03-2008 02:01 PM

10-18-2022, 12:08 PM	#16
NiLuJe BLAM! Posts: 13,506 Karma: 26047202 Join Date: Jun 2010 Location: Paris, France Device: Kindle 2i, 3g, 4, 5w, PW, PW2, PW5; Kobo H2O, Forma, Elipsa, Sage, C2E	You could simply check if wpa_supplicant managed to associate with an AP via wpa_cli, that should work just as well, will only block as long as necessary, and doesn't require actual WAN connectivity. c.f., https://github.com/koreader/koreader...sync.sh#L8-L20 Or, in a similar fashion, poke sysfs until the network IF is up: c.f., https://github.com/koreader/koreader...ce.lua#L15-L27 (Except don't hardcode the IF name, use the ${INTERFACE} env var).

10-18-2022, 12:35 PM	#17
Leonatus Wizard Posts: 1,088 Karma: 11502975 Join Date: Mar 2013 Location: Guben, Brandenburg, Germany Device: Kobo Clara 2E, Tolino Shine 3	I would be very interested in this, but as I'm no technic, I've got some difficulties: Where do I find the extracting location /mnt/onboard/.adds/notes/? I suppose it should be in the Kobo?

02-16-2023, 08:10 PM	#20
qkqw Connoisseur Posts: 67 Karma: 143000 Join Date: Apr 2022 Device: Kobo Libra 2	I've uploaded a small update that removes the KoboCloud dependency (none of you guys were using it anyways) and renames notes with their current date. That allows you to have a history of exported notes, of which currently only 21 (worth for at least 3 weeks) are kept. That number can be configured.

08-04-2023, 03:33 AM	#21
qkqw Connoisseur Posts: 67 Karma: 143000 Join Date: Apr 2022 Device: Kobo Libra 2	I've uploaded a small update to the script, allowing to export the book progress of PDFs as well.

10-16-2023, 01:53 PM	#22
qkqw Connoisseur Posts: 67 Karma: 143000 Join Date: Apr 2022 Device: Kobo Libra 2	Fixed a bug in reading progress that didn't list a book when it doesn't have any chapter titles (e.g. PDFs or automatically generated Epubs).