Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Readers > Sony Reader

Notices

Reply
 
Thread Tools Search this Thread
Old 04-09-2024, 03:40 PM   #1
123Passa
Junior Member
123Passa is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.123Passa is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.123Passa is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.123Passa is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.123Passa is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.123Passa is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.123Passa is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.123Passa is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.123Passa is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.123Passa is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.123Passa is the 'tall, dark, handsome stranger' all the fortune-tellers are referring to.
 
Posts: 4
Karma: 91962
Join Date: Jan 2024
Device: Sony PRS T3
GUIDE: Sony PRS T3 (and possibly T1 and T2) export notes to laptop in 2024

Hi all,

I got a second hand T3 recently I asked some questions to the community already and now it is time to give back!

I wanted to read my notes in an easy way and share them through OneNote so I can read them and google them while I commute. The issue is that the Sony Reader Software did not work for me, as I guess it does not work for anyone else anymore

So after about an hour I figured out this simple trick. When you connect your reader to the laptop you should have the following file [your drive]:\Sony_Reader\database\books.db .
This is a dataset containing a lot of information about your device and your notes.

1. Download DB Browser for SQL lite and install
2. In DB Browser click on Open Database and select the file mentioned above
3. Select execute SQL and copy the following query:
SELECT title,AUTHOR,name,marked_text,page
FROM ANNOTATION
LEFT JOIN BOOKS
ON ANNOTATION.content_id= BOOKS._id

4. Select the query you just copied and press execute all (the little play button)


And like this you are done. You will have your notes in a table and you can export them to any other software like One Note or Excel just by copy pasting.

I hope this tricks saves someone's time and make these beautiful readers last longer!

***You can get more info out of the .db file but for me title, author, note title, marked text and page was enough. Let me know in the case you don't know how SQL works and you're looking for more info!

Last edited by 123Passa; 04-09-2024 at 03:42 PM.
123Passa is offline   Reply With Quote
Old 08-28-2024, 03:36 AM   #2
kwik
Enthusiast
kwik began at the beginning.
 
Posts: 25
Karma: 10
Join Date: Nov 2023
Device: Sony PRS-T3
Thanks for sharing!
kwik is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I export/print notes on STR? How about Sony PRS-T1 victw Barnes & Noble NOOK 0 12-21-2011 08:15 PM
[Old Thread] Export notes from sony PRS700 reader ogduartev Calibre 19 09-08-2011 11:14 AM
PRS-650 prs 650 notes annotation export pdf bjrnfrdnnd Sony Reader 8 03-10-2011 12:19 AM
In Dire Need of Workaround to Export Personal Docs with Notes Intact (Sony PRS-600) Secret Agent Man Sony Reader 7 03-23-2010 04:40 PM
Sony PRS-700 Possibly Discontinued mklynds News 55 07-27-2009 09:17 PM


All times are GMT -4. The time now is 04:05 PM.


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