RSS

Extracting highlights & notes from iBooks (IPad or iPhone) via online tool

Note : Following tool is no longer available as I couldn’t pay for its Virtual server hosting. I would like to thank few generous users who donated for few months to keep it alive. Those who know codding can download and use code from GitHub.

Thanks again for using it guys.

please donate to support our server(where this tool is hosted) cost     

Hi guys if you use iBooks on Ipad or iphone than you also highlight some important text while reading ,and you wondered how good it can be to extract only highlighted part of that book which you want to revise in future …

I wondered same I would like to demonstrate a way to extract your all your highlighted text to a ebook (.epub)

so what we have

Software required

Steps
  1. Download DiskAId portable from Windows users Click here ( then jump to step 5 now),                                                                           MAC users please follow this link to download (http://www.digidna.net/products/diskaid/download)
  2. Once DiskAid set up is done, Connect your iPhone or iPad with Pc/Mac and open DiskAid.
  3. Open DiskAId ->; Preferences from menu-bar
  4. Go on Advanced Tab and check option Display All Apps.
  5. Expand Apps in left Navigation pane.
  6. Select iBooks and expand Documents->;BkLibrary_database , select iBooks_v10252011_2152.sqlite and drag and drop to Desktop
  7. Select Documents->;storeFiles and select AEAnnotation_v10312011_1727_local.sqlite and drang and drop to Desktop
  8. Then go and open   extract tool by clicking here
  9. choose both files ( AEAnnotation_v10312011_1727_local.sqlite & iBooks_v10252011_2152.sqlite) from desktop and press Extract my highlights button
  10. Wait for movement and on next page you can see your highlights which you can copy to word file or you can click on link to download ebook of your highlights (.epub file) which you can put it back in ibooks on your ipad and iphone

….Enjoy summary of books you read ….let me know any feedbacks and ideas…

 
55 Comments

Posted by on July 11, 2012 in Gadgets, Solutions

 

Extracting highlights from iBooks (IPad or iPhone)

NOTE: This post is outdated , Click here to view updated post 

Hi guys if you use iBooks on Ipad or iphone than you also highlight some important text while reading  ,and you wondered how good it can be to extract only highlighted part of that book which you want to revise in future ………

I wondered same I would like to demonstrate a way to extract your all your highlighted text to a word file.

(NOTE: If you are using iBOOKS 1.5 or later than method is bit different , please have a look in comments for more info )

so what we have

What we are going to achieve

Software required

  • iPhone backup extractor
  • Sqllite database browser
  • Microsoft office(Word and Excel)
Steps
  1.  Connect your iPhone or iPad with iTunes , so ITunes will have backup of it
  2. once you have backup finished close iTunes 
  3. open iPhone backup extractor and select device you want get highlighted bookmarks from and click on “Expert mode” button on bottom right
              4.  in Backup details select com.apple.iBooks and click on Extract selected  

5. select a folder you want to save extracted data and click ok, in my example it’s ibooks project

6. Now in that folder go to ibooks Project ->Application->com.apple.iBooks->Documents, you can see files shown in following pic
7. Open SqlLite Database Browser click on open database (see in following pic)
8. Now select file iBooks_revision-two.sqlite in Documents folder
9. Once file is open go to Browse data tab
10. select Table ZBKBOOKMARK from table drop down
11. once your are on ZBKBOOKMARK table go to File menu and Export Table as CSV file.
12. Save that CSV and open it
13. you can delete all columns except ZTEXTUALCONTENT 
14. You can filter that column to remove blank cells
15.  Copy whole column and paste to Word with Use Destination style which will give you this table form
16. Format it by giving it numbers and title
if you are a geek and want to go in depth you can go through ZBKBOOKMARK table and copy highlights with with particular Book it belongs to ,so in final form you can have it distributed Book wise as this are highlighted from all books in iBooks.
 
38 Comments

Posted by on August 28, 2011 in Gadgets, Solutions

 
 
Follow

Get every new post delivered to your Inbox.