Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Readers > Kobo Reader

Notices

Reply
 
Thread Tools Search this Thread
Old 12-07-2017, 12:25 PM   #1
quazardous
Junior Member
quazardous began at the beginning.
 
Posts: 6
Karma: 10
Join Date: Dec 2017
Device: Kobo Aura One
Manage epub and keep read progress

Hi,

I want to move the files on my Kobo Aura One but read progress is reset.

Is there a way to move files without loosing read progress.

Maybe with the SQLite dB ?


Thx
quazardous is offline   Reply With Quote
Advert
Old 12-07-2017, 07:32 PM   #2
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: 13,395
Karma: 21883484
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo: Touch, Glo, Aura H2O, Glo HD, Aura ONE
What do you mean by "move"? Do you mean you want to rearrange the directory structure of your sideloaded kepubs?

If that is the case, the simplest way to do it is using calibre. My Kobo Utilities plugin has a method to store and restore the reading status of all books on the device. You can use this to store the reading status, then remove the books and resend them using calibre. After the device process them, you can connect again and restore the reading positions.

The plugin is doing this by reading and updating the database on the device. That means you could do it yourself. It wouldn't be that hard, but you need to modify at least two table for each book, and potentially five or six. And if you get it wrong, then the status will be lost and the book treated as a new book.

I can take you through how to do this, but it will take time. If you are already a calibre user, look at the plugin. It should be able to do what you want.
davidfor is online now   Reply With Quote
Old 12-08-2017, 03:02 AM   #3
quazardous
Junior Member
quazardous began at the beginning.
 
Posts: 6
Karma: 10
Join Date: Dec 2017
Device: Kobo Aura One
thx,

I'll try calibre again but that was not very strait forward (internal library, device, etc).

is there some explanation on the table ? I've looked into the readdable sqlite with sqlite browser but I was not able to spot a simple Book table...

I'm a dev, for me it's easier to quick dev some simple tool VS using 1% of calibre process...

EDIT : yes I meant move btw

Last edited by quazardous; 12-08-2017 at 03:08 AM.
quazardous is offline   Reply With Quote
Old 12-08-2017, 04:21 AM   #4
quazardous
Junior Member
quazardous began at the beginning.
 
Posts: 6
Karma: 10
Join Date: Dec 2017
Device: Kobo Aura One
well I'll toy with calibre. the kepub format seams an improvement.

My use cae :

- download epub on the go from my Kobo
- start reading
- manage epub / convert etc trying to keep read progression
- finish reading ;p

I ll see if I can manage with calibre
quazardous is offline   Reply With Quote
Old 12-08-2017, 01:23 PM   #5
quazardous
Junior Member
quazardous began at the beginning.
 
Posts: 6
Karma: 10
Join Date: Dec 2017
Device: Kobo Aura One
little feedback

so I've played around with Calibre and manage to move and clean up all the epub

basically the steps are
- import all epub in Calibre
- install / config Kobo driver/plugin (create needed fields, map them, etc)
- save progression
- edit metadata
- remove all changed ePub from Kobo (because metadata are read once by Kobo)
- regenerate epub or kepub
- export to device
- unplug / plug Kobo
- put progression back
quazardous is offline   Reply With Quote
Advert
Old 12-08-2017, 07:18 PM   #6
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: 13,395
Karma: 21883484
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo: Touch, Glo, Aura H2O, Glo HD, Aura ONE
Quote:
Originally Posted by quazardous View Post
little feedback

so I've played around with Calibre and manage to move and clean up all the epub

basically the steps are
- import all epub in Calibre
- install / config Kobo driver/plugin (create needed fields, map them, etc)
- save progression
- edit metadata
- remove all changed ePub from Kobo (because metadata are read once by Kobo)
- regenerate epub or kepub
- export to device
- unplug / plug Kobo
- put progression back
Yes, that's basically right. You don't have to do it all in one go, but that will really depend on how many books are involved.

The remove and resend steps are not that needed if you just want to update the metadata. The utilities plugin can update the metadata on the device. But, as you want to rearrange the files on the device it is needed this time.
davidfor is online now   Reply With Quote
Old 12-09-2017, 01:31 PM   #7
quazardous
Junior Member
quazardous began at the beginning.
 
Posts: 6
Karma: 10
Join Date: Dec 2017
Device: Kobo Aura One
Quote:
Originally Posted by davidfor View Post
Yes, that's basically right. You don't have to do it all in one go, but that will really depend on how many books are involved.

The remove and resend steps are not that needed if you just want to update the metadata. The utilities plugin can update the metadata on the device. But, as you want to rearrange the files on the device it is needed this time.
yes but not for all metadatas. Authors seam to be read from (k)epub at first import. So the no brainer way is to delete and import again... Of course won't do for big library....
quazardous is offline   Reply With Quote
Old 12-09-2017, 07:45 PM   #8
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: 13,395
Karma: 21883484
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo: Touch, Glo, Aura H2O, Glo HD, Aura ONE
Quote:
Originally Posted by quazardous View Post
yes but not for all metadatas. Authors seam to be read from (k)epub at first import. So the no brainer way is to delete and import again... Of course won't do for big library....
The metadata is only read when the book is first imported on the device. This, of course, includes the author, and is the same for all formats that include metadata. The Kobo Utilities plugin has a "Update metadata in device database" function that does exactly that. Including the author and metadata that isn't read during the import.
davidfor is online now   Reply With Quote
Old 12-10-2017, 02:20 PM   #9
quazardous
Junior Member
quazardous began at the beginning.
 
Posts: 6
Karma: 10
Join Date: Dec 2017
Device: Kobo Aura One
Quote:
Originally Posted by davidfor View Post
The metadata is only read when the book is first imported on the device. This, of course, includes the author, and is the same for all formats that include metadata. The Kobo Utilities plugin has a "Update metadata in device database" function that does exactly that. Including the author and metadata that isn't read during the import.
got the db corrupted toying with this driver option.

had to reset device...

Can't say it's safe.

series managment is very bad too even with title mapping...

I'll give it another try but for now I want to finish readding my novel lol.
quazardous is offline   Reply With Quote
Old 12-10-2017, 03:45 PM   #10
compurandom
Addict
compurandom can program the VCR without an owner's manual.compurandom can program the VCR without an owner's manual.compurandom can program the VCR without an owner's manual.compurandom can program the VCR without an owner's manual.compurandom can program the VCR without an owner's manual.compurandom can program the VCR without an owner's manual.compurandom can program the VCR without an owner's manual.compurandom can program the VCR without an owner's manual.compurandom can program the VCR without an owner's manual.compurandom can program the VCR without an owner's manual.compurandom can program the VCR without an owner's manual.
 
Posts: 206
Karma: 172556
Join Date: Jun 2015
Device: kobo aura h2o
I mess with updating metadata heavily using kobo/calibre.

The only way I've ever corrupted the database was by accidentally unplugging when the device wasn't properly ejected, or resetting the device when it hung.

The kobo utils have not corrupted the database on me. However, as some operations *do* require ejecting and letting the kobo scan the files, it's real easy to accidentally unplug without ejecting while doing that.

As to deleting/re-adding a book to update metadata, the only metadata that this is actually required for is:
* filename on device (who cares about this anyway?)
* table of contents within the book
* other formatting changes within the book

Some metadata like shelves and covers can be added when the book is added.
Most other metadata has to be added after the book is scanned by the device. using the calibre kobo utilities plugin.

I think covers are cached in ram when the book is on the home screen, so occasionally updating the cover doesn't take effect right away. A reboot of the device will fix that, but eventually it picks up the new cover without a reboot or remove/re-add.

I can't think of any other meta-data special cases, but I'm sure there are some.
compurandom is offline   Reply With Quote
Old 12-10-2017, 06:54 PM   #11
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: 13,395
Karma: 21883484
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo: Touch, Glo, Aura H2O, Glo HD, Aura ONE
Quote:
Originally Posted by quazardous View Post
got the db corrupted toying with this driver option.
It is unlikely that this actually caused a database corruption. And if it did, it will be the first time it has been reported. It is more likely that it showed an existing problem or that the problem was triggered by something else done at the time. For the latter, as compurandom suggested, the most likely reason is not safely ejecting the device.
Quote:
had to reset device...
By that do you mean a factory reset? If so, that is overkill. You can just sign out of the Kobo account on the device and that will fix things.
Quote:
Can't say it's safe.
If you think so, you probably want to avoid using any of the Kobo Utilities functions, or for that matter, calibre with the Kobo device.
Quote:
series managment is very bad too even with title mapping...
What do you mean by that? I set the series on the device and I create collections for each series. I can view those collections and sort by series or view the author and sort by series. I'm not sure what else is needed. Or do you mean in calibre?
davidfor is online now   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
Set progress read of a book fabrice91 Kobo Reader 3 01-21-2017 01:46 PM
PW3 Show always read progress encol Kindle Developer's Corner 4 05-04-2016 09:39 AM
Using two custom columns to manage books I'm reading/have read/want to read. LisaAlissa Library Management 3 07-07-2014 08:08 PM
How do you manage your read queue with ebooks? DuncanWatson General Discussions 7 05-14-2010 02:30 PM
How do YOU manage read and borrowed books? SimonSays Reading and Management 8 02-15-2010 08:17 AM


All times are GMT -4. The time now is 02:38 AM.


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