|
![]() |
|
Thread Tools | Search this Thread |
![]() |
#1 |
Junior Member
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() 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. |
![]() |
![]() |
![]() |
#2 |
Member
![]() Posts: 19
Karma: 10
Join Date: Nov 2023
Device: Sony PRS-T3
|
Thanks for sharing!
|
![]() |
![]() |
![]() |
|
![]() |
||||
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 |