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
- 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)
- Once DiskAid set up is done, Connect your iPhone or iPad with Pc/Mac and open DiskAid.
- Open DiskAId ->; Preferences from menu-bar
- Go on Advanced Tab and check option Display All Apps.
- Expand Apps in left Navigation pane.
- Select iBooks and expand Documents->;BkLibrary_database , select iBooks_v10252011_2152.sqlite and drag and drop to Desktop
- Select Documents->;storeFiles and select AEAnnotation_v10312011_1727_local.sqlite and drang and drop to Desktop
- Then go and open extract tool by clicking here
- choose both files ( AEAnnotation_v10312011_1727_local.sqlite & iBooks_v10252011_2152.sqlite) from desktop and press Extract my highlights button
- 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…
parthiv777
Experimental geek's Blog 
Zack
May 12, 2012 at 11:35 pm
The websites in step 9 do not work….
parthiv777
May 13, 2012 at 1:18 pm
Please use one with ip address , i have to fix website address
anthonyroper
May 28, 2012 at 8:24 pm
Hi Parthiv777, Great work man. I posted this question on Quora today – I wonder if you have some ideas? :
I use mindmaps to summarize book reviews and apply creative thinking around the book content.
Increasingly I am reading epub eBooks on my Ipad2 and highlighting information/typing notes as I read instead of making physical notes.
I want to be able to :
Export my highlights/notes, in a structured way that links them to the headings/chapter sections of each book, in a format that can be summarised in a text doc and/or the template of a mindmap format.(e,g, Freemind, IthoughtsHD)
Anyone know of an app or simple workaround that would work with iBooks, Stanza or any popular Ipad eBook reader?
parthiv777
May 29, 2012 at 10:39 am
well i don’t think so that such app would exist on ios
,as Apple don’t like other Apps to mess around with there apps(fetching data from ibooks .sqlite files) …except this kind of software made externally (like tool above) and used by manually feeding database files (.sqlite)…
and about chapters i have to drill more in and get one more cached .sqlite file ..(they made it more complicated structure after iBooks .1.5)
if you read book from start (ch 1 , ch 2 , ch 3 and so on) than i have sorted bookmarks according date and time….
Mario
July 12, 2012 at 1:31 am
Hello,
I follow all the steps and when I upload the two files to http://118.139.182.210/EEP/, after a few minutes, I get this error. Step 9
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a “web.config” configuration file located in the root directory of the current web application. This tag should then have its “mode” attribute set to “Off”.
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the “defaultRedirect” attribute of the application’s configuration tag to point to a custom error page URL.
thanks
parthiv777
July 12, 2012 at 7:39 am
I am not sure how u came across this error as i tried it myself and worked for me…
have u tried it second time
Matt
July 20, 2012 at 5:35 pm
http://118.139.182.210/EEP/ is unavailable, is this temporary??
parthiv777
July 21, 2012 at 12:07 pm
its up again …..well its humble request please donate if you guys like and use my tool as i can’t keep it up for more time now as i have to pay 40$ per month for its virtual private hosting to godaddy…
Mario
July 21, 2012 at 6:55 pm
i still with the same problem:
could you send files by mail for you to try your with your system.
thanks
When upload files is 100% after two minutes tell me:
Server Error in ‘/EEP’ Application.
Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a “web.config” configuration file located in the root directory of the current web application. This tag should then have its “mode” attribute set to “Off”.
parthiv777
July 21, 2012 at 7:59 pm
Ok Mario i get it , i guess u r with older version of ibooks so , update it first then try once more , i tried this morning it worked for me
Mario
July 22, 2012 at 6:28 pm
I use the April version ibook , is the last that is in iTunes. I tried with mac osx and windows with chrome and explorer and tell me the same. The files sizes are 115 Kb for iBooks_v10252011_2152.sqlite , and 4 MB for AEAnnotation_v10312011_1727_local.sqlite
thanks
parthiv777
July 22, 2012 at 6:34 pm
If u dont mind then send me ur files on parthiv777@gmail.com i will test system with them
Greg Waddell
July 23, 2012 at 8:25 am
Thank you. Worked like a charm!
Michael
August 19, 2012 at 9:46 pm
Worked fabulously. Any chance you could turn it into a stand-alone application to run on Windows and charge a small fee for it?
Many thanks for doing this!
parthiv777
August 20, 2012 at 9:32 am
thanks , i guess it can be done for sure ,but right now i am out of time as running around between uni and job …will think about it in future…
Rick
September 4, 2012 at 12:53 pm
a fantastic guide and tool! Many thanks
parthiv777
October 2, 2012 at 9:10 am
thanks Rick…
TS
October 1, 2012 at 10:28 pm
Hi Parth, does this work with .iBooks files?
parthiv777
October 2, 2012 at 9:15 am
I afraid it doesn’t work with ibooks file……… except ibooks file’s highlights are saved in same .sqlite database as other epub ebooks ….
brian fox
October 3, 2012 at 1:29 pm
pretty impressive. Thanks.
David Pimentel
October 18, 2012 at 6:06 am
“You have not specified a file.” Any guess?
parthiv777
October 18, 2012 at 6:53 am
Which file u r talking about ? Where it applies in above process?
David
October 18, 2012 at 8:57 am
Sorry. I get that error after selecting the two files and clicking on “Extract my Highlights”.
parthiv777
October 18, 2012 at 9:00 am
Can you send me screenshot of error on parthiv777@gmail.com
parthiv777
October 18, 2012 at 9:05 am
r u checking “Terms and conditions” checkbox?
David
October 18, 2012 at 9:10 am
Yes
parthiv777
October 18, 2012 at 10:08 am
i don’t know whats happening here as its working fine for my files
if you don’t mind send me your sqllite files on my email id above…
i will try to get u ur highlights and will also troubleshoot this tool…
David
October 18, 2012 at 10:26 am
It’s OK. I found another way to do it. Thanks anyway.
John Smolenski
October 22, 2012 at 4:05 am
I am a scholar who is in the midst of replacing my paper library (1000+) books with e-books. I would be very interested in donating money to keep the website going, and *very* interested in buying a standalone app. If donating more helps, I’d be willing to do that!
Alex
January 18, 2013 at 8:36 am
THANK YOU SO MUCH KEEP GOING ON 😉
golf school phoenix arizona
April 21, 2013 at 4:36 pm
You made some really good points there. I looked
on the internet for more info about the issue and found
most people will go along with your views on this web site.
nataliedwilson
May 7, 2013 at 6:46 am
Is DiskAid free? Shareware? Limited Use Trial? I see that I can download it, but there’s also information about buying a license.
parthiv777
May 7, 2013 at 7:16 am
Hi Natalie there are 2 versions of diskaid free and premium. I did put free version here on my site , so no need to buy it. If you want to use diskaid for copy things back on phone then u need full version.
nataliedwilson
May 7, 2013 at 7:54 am
Ah, thank you for your reply and clarification! I think this will work perfectly for what I need.
Heiko
May 12, 2013 at 2:46 am
… Do you think it works also with kindle highlights, silly question probanly … The kindle highlights are stored online on amazon servers & you can extract them with readmill.com, but some books have restrictions – for example: after 30 highlights you can’t highlight anymore … So it would be nice to export kindle highlights directly from the app “database” … What Do you think?
Heiko Idensen, @web2write
parthiv777
May 12, 2013 at 8:36 am
Hi my knowledge about kindle highlight is limited , now if u r saying that some kindle books restricts u to 30 highlights.
I think that can be removed by killing its DRM try to search on this topic some free open source software will help u to do that.
Refugio
June 8, 2013 at 3:33 pm
Hello, its nice paragraph about media print, we all be familiar with
media is a enormous source of information.
Eric
July 3, 2013 at 12:46 pm
Anything that can be done to keep this going? Can we donate money to cover the cost? What can be done to make you reconsider? This is such a great service and hate to see it go away.
parthiv777
July 3, 2013 at 1:57 pm
thanks Eric,
for last 2 month i have not seen much usage ,and it needs Virtual private server from windows (doesn’t run on normal hosting account) which are expensive ,so i thought to shut it down.
at this point my virtual server is deleted (in hosting account) ,so have to setup all over again.
little donation will also help it live (i am happy to pay 50% from my pocket),
if i get at least 7 comments in next 10 days ,saying they want it up and running (I am putting words on top of blog post to comment below) with some donations then I am happy to set it up again.
otherwise are you familiar with IIS and asp.net ? (i can give you code to set it up at home would be bit tricky though)
Eric
July 20, 2013 at 12:36 am
parthiv777, know we didn’t get the response we were looking for but wondering if there’s something we can still work out? I would be willing to help support the expense to get this back up and running. Let me know what you need to restart this service. Thanks!
parthiv777
July 22, 2013 at 9:46 am
thanks a lot Eric for your support , if you guys can donate 15$ per month then I am happy to bare rest of expense…
we can get it up running in august(1st week)….
thanks….
katejstanley@gmail.com
July 8, 2013 at 7:05 am
This tool has been *invaluable* to my work and I would be happy to donate to bring it to life again. Many thanks!
parthiv777
August 2, 2013 at 3:37 pm
it’s up and running on http://118.139.160.67/…..
nataliedwilson
July 16, 2013 at 4:59 am
I do hope you will put this back up as it was valuable to me as an author to get notes from beta readders.
parthiv777
August 2, 2013 at 3:37 pm
it’s up and running on http://118.139.160.67/…..
Eric
July 24, 2013 at 9:40 am
Sure. What’s the best way to donate?
parthiv777
July 24, 2013 at 1:39 pm
hi Eric i have updated post , please find donate button on top of post …thanks
parthiv777
August 2, 2013 at 3:37 pm
hi Eric it’s up and running on http://118.139.160.67/…..
thanks once again for your generous donation
eric
August 3, 2013 at 10:44 am
Thank you! Appreciate your willingness to reactivate. Hope others will continue to support as well. Take care!
curlyandblonde
August 21, 2013 at 6:02 pm
Thank you very much man! If you’re not counting on making money out of it, why don’t you release it as open source?
parthiv777
August 22, 2013 at 3:16 pm
do you think doing so will help it, in further development ?
curlyandblonde
December 9, 2013 at 1:38 am
Mostly, I think it would free you of the responsibility to update it in the future, or pay for its hosting, while still keeping your work around. Also, don’t underestimate the effect of open-sourcing!
Pratik
August 6, 2014 at 3:05 am
Step 8 website doesnt work anymore – http://118.139.160.67/
Can you fix this?
parthiv777
August 6, 2014 at 8:06 am
As mentioned above, I needed financial support to run server where step 8 website resided. I couldn’t get enough support so I closed it