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 01-15-2012, 05:36 PM   #1
diddy
Connoisseur
diddy began at the beginning.
 
Posts: 93
Karma: 12
Join Date: Feb 2011
Device: Sony PRS-650
Is it possible to import highlights with Calibre?

Hi,
I am thinking about starting using Calibre to manage my T1. Does Calibre support importing annotations (highlights, notes) from the T1?
Thanks,
Diddy
diddy is offline   Reply With Quote
Old 01-15-2012, 09:42 PM   #2
vxf
Guru
vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.
 
vxf's Avatar
 
Posts: 934
Karma: 1414252
Join Date: Jun 2010
Location: Norman, OK
Device: Sony PRS 350, 900, 950; iPad3, iPad Mini; Kindle Touch, Paperwhite
To my knowledge, not. That has led me to NOT use calibre and stick with SONY's software - despite all its flaws.
vxf is offline   Reply With Quote
 
Advertisement
Old 01-15-2012, 09:55 PM   #3
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 37,836
Karma: 18755150
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Sony Reader PRS-650, iPad, nook STR
Actually, the correct term is export. You are exporting the highlights from the T1.
JSWolf is offline   Reply With Quote
Old 01-16-2012, 07:56 AM   #4
diddy
Connoisseur
diddy began at the beginning.
 
Posts: 93
Karma: 12
Join Date: Feb 2011
Device: Sony PRS-650
Thanks for the answers! Yes, export - thanks for clarifying.
diddy is offline   Reply With Quote
Old 01-16-2012, 12:23 PM   #5
geoffwood
Addict
geoffwood ought to be getting tired of karma fortunes by now.geoffwood ought to be getting tired of karma fortunes by now.geoffwood ought to be getting tired of karma fortunes by now.geoffwood ought to be getting tired of karma fortunes by now.geoffwood ought to be getting tired of karma fortunes by now.geoffwood ought to be getting tired of karma fortunes by now.geoffwood ought to be getting tired of karma fortunes by now.geoffwood ought to be getting tired of karma fortunes by now.geoffwood ought to be getting tired of karma fortunes by now.geoffwood ought to be getting tired of karma fortunes by now.geoffwood ought to be getting tired of karma fortunes by now.
 
Posts: 217
Karma: 499588
Join Date: Sep 2011
Device: K4NT+K4T+PRST1
Quote:
Originally Posted by JSWolf View Post
Actually, the correct term is export. You are exporting the highlights from the T1.
Good lord, how pedantic, the intent of the original question was perfectly clear. Surely if you are "Importing into Calibre" that is the functional equivalent of Exporting from the T1.
geoffwood is offline   Reply With Quote
Old 01-16-2012, 07:04 PM   #6
slieveen
Couch Potato
slieveen began at the beginning.
 
Posts: 8
Karma: 10
Join Date: Jan 2011
Location: Ottawa
Device: Kindle 3G & PaperWhite, Sony 350C & Sony PRST1, Kobo Touch & AuraHD
Quote:
Originally Posted by geoffwood View Post
Good lord, how pedantic, the intent of the original question was perfectly clear. Surely if you are "Importing into Calibre" that is the functional equivalent of Exporting from the T1.
In fairness, I read the title and also first understood the question to refer to a transfer to the device and not from. So it wasn't "perfectly clear".
slieveen is offline   Reply With Quote
Old 01-16-2012, 07:09 PM   #7
vxf
Guru
vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.vxf ought to be getting tired of karma fortunes by now.
 
vxf's Avatar
 
Posts: 934
Karma: 1414252
Join Date: Jun 2010
Location: Norman, OK
Device: Sony PRS 350, 900, 950; iPad3, iPad Mini; Kindle Touch, Paperwhite
Doesn't make a difference. Either way, you can't do it.
vxf is offline   Reply With Quote
Old 01-16-2012, 11:06 PM   #8
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 37,836
Karma: 18755150
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Sony Reader PRS-650, iPad, nook STR
Quote:
Originally Posted by slieveen View Post
In fairness, I read the title and also first understood the question to refer to a transfer to the device and not from. So it wasn't "perfectly clear".
I read it the same way the first time I read the thread title. That's why I clarified it.

Quote:
Originally Posted by vxf View Post
Doesn't make a difference. Either way, you can't do it.
Well stated. Thanks.
JSWolf is offline   Reply With Quote
Old 01-17-2012, 02:47 AM   #9
Bookworm_Girl
E-reader Enthusiast
Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.
 
Bookworm_Girl's Avatar
 
Posts: 2,989
Karma: 10212813
Join Date: Aug 2010
Location: Southwest, USA
Device: Sony 350, T2; KPW2; iPad Mini Retina; Nooks
Annotations is one reason why I was hesitant to switch to calibre. However, I decided the other benefits out-weighed it. Here is what I plan to do. I am going to manage my library with calibre. The Sony software has a feature that allows you to transfer books from the T1 to Reader for Mac/PC. You select the book and then click on the button called "Copy to My Library". I just tried it, and my notes were copied along with the book. So at least I can still export notes through the Sony software as needed.

You may not be aware that the Sony software has a limitation on the number of characters per highlight that can be exported to the RTF file. It is best to highlight in small consecutive segments. The maximum is 100 characters per each highlight in a DRM'ed book. It is ~200 characters for a non-DRM'ed book. The limit on the non-DRM'ed book is really small. In the old Sony software it was 2000 characters!
Bookworm_Girl is offline   Reply With Quote
Old 01-17-2012, 04:33 AM   #10
diddy
Connoisseur
diddy began at the beginning.
 
Posts: 93
Karma: 12
Join Date: Feb 2011
Device: Sony PRS-650
Thanks. So you keep all your books which have annotations always on the T1 unless you copy it to the Reader library? Is this correct?
Thanks for pointing out the limitations as well ... I wasn't aware of this.
diddy is offline   Reply With Quote
Old 01-17-2012, 09:53 PM   #11
Bookworm_Girl
E-reader Enthusiast
Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.
 
Bookworm_Girl's Avatar
 
Posts: 2,989
Karma: 10212813
Join Date: Aug 2010
Location: Southwest, USA
Device: Sony 350, T2; KPW2; iPad Mini Retina; Nooks
Quote:
Originally Posted by diddy View Post
Thanks. So you keep all your books which have annotations always on the T1 unless you copy it to the Reader library? Is this correct?
Thanks for pointing out the limitations as well ... I wasn't aware of this.
I think that's the only option. However, I am one of those people who like to keep all of my books on my ereader. Why not if I can? When I am done reading the book, then I typically export the notes to an RTF document. Because of the character limitation I usually spend time expanding the notes in a text editor (sort of defeats the point!). Then I delete the notes from my ereader. On the old Sony models sometimes the ereader could slow-down if you had too many notes (like over 100). So far nobody is complaining about the T1 in this regard. For books that I want to keep the notes permanently (which is really just a handful), then I think I'll keep copies of them in the Reader for Mac library. It was easier with the older models to also copy the annotations from the ereader and make backups such that you could easily restore notes to a "fresh/blank" ebook file if you needed to. That data seems to be built into the database files on the T1.
Bookworm_Girl is offline   Reply With Quote
Old 01-18-2012, 04:22 AM   #12
diddy
Connoisseur
diddy began at the beginning.
 
Posts: 93
Karma: 12
Join Date: Feb 2011
Device: Sony PRS-650
It seems like all the highlights of all books are stored in books.db. This wouldn't be a big problem if Sony had decided to only store the start and end position of one highlight. But actually the text itself gets stored in this file. So if you make really a lot of highlights, this one books.db file can get really big which might slow down the ereader.
diddy is offline   Reply With Quote
Old 01-19-2012, 12:16 AM   #13
Bookworm_Girl
E-reader Enthusiast
Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.Bookworm_Girl ought to be getting tired of karma fortunes by now.
 
Bookworm_Girl's Avatar
 
Posts: 2,989
Karma: 10212813
Join Date: Aug 2010
Location: Southwest, USA
Device: Sony 350, T2; KPW2; iPad Mini Retina; Nooks
I don't have any experience with SQLite databases. I imagine that if you had the right software to open the database file (and knew what you were doing) that you could read the records and export the notes.
Bookworm_Girl is offline   Reply With Quote
Old 01-19-2012, 07:01 AM   #14
diddy
Connoisseur
diddy began at the beginning.
 
Posts: 93
Karma: 12
Join Date: Feb 2011
Device: Sony PRS-650
Yes, this should be doable. If I find some time one day I might look into this.
diddy is offline   Reply With Quote
Old 01-20-2012, 12:59 PM   #15
BooksBooks
Junior Member
BooksBooks for a long time would go to bed early.BooksBooks for a long time would go to bed early.BooksBooks for a long time would go to bed early.BooksBooks for a long time would go to bed early.BooksBooks for a long time would go to bed early.BooksBooks for a long time would go to bed early.BooksBooks for a long time would go to bed early.BooksBooks for a long time would go to bed early.BooksBooks for a long time would go to bed early.BooksBooks for a long time would go to bed early.BooksBooks for a long time would go to bed early.
 
Posts: 5
Karma: 17960
Join Date: Jan 2012
Device: Sony PRS-T1
SQLLiteSpy works great

SQLLiteSpy works great:
connect the ereader
open SQLLiteSpy
file - open
choose reader - sony_reader - database - books.db
doubleclick on the annotations table
select the records you want.
And copy/paste them to excel...



(Far more reliable than the sony software: I never got anything out of that.)

Last edited by BooksBooks; 01-20-2012 at 01:07 PM.
BooksBooks 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
Does Calibre have the ability to do highlights & annotations? mobi555 Library Management 0 06-22-2011 01:36 AM
Import failed Error:404 when attempting to import from Calibre to Stanza dvond Apple Devices 0 05-13-2011 04:00 PM
Feature Req: Sync notes and highlights back to Calibre lvovsky Calibre 4 12-02-2010 10:58 PM
Able to see highlights in Calibre ? mharrop19 Calibre 2 01-05-2010 05:28 PM
Can't import into Calibre 6.26 Winter57 Calibre 8 12-05-2009 03:05 PM


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


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