Thread: transfering bought kepub from device to PC
View Single Post
Old 09-09-2013, 07:56 AM   #4
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by anacreon View Post
Thanks for the answer, but my problem is I can't find it on the device: I have 829 folders, most created by calibre, and have tried to sort it by date, name (first and last of the author and title), then to look into the kobo folder, but can't see it. I know it is there since I can read it.

I've even tried to look at the SQLite database, and it seems that for one book (probably the calibre sideloaded one, content id = book id is something lije /mnt/onboard/author name etc., while for the other it is a series of number and digits (20f5der...)
All purchased kepubs are stored in the directory ".kobo/kepub". The file name is the string of numbers and letters you saw in the database. They don't have an extension. As you use calibre, I think the easiest way to find the file is what I described before. Find the book in the device list, select it and look the path displayed in the book details.

If you look in the database, the ContendId is the key. For a sideloaded book, this is the full path with "file:///mnt/onboard/" added as a prefix. For purchased kepubs, it is the letters and number. This is the file name inside ".kobo/kepub". The rows with "ContentType=6" and "IsDownloaded='true'" are all the books on the device. You need to find row for the book you want and use the ContentID to find the file.
davidfor is offline   Reply With Quote