12-07-2017, 11:25 AM | #1 |
Junior Member
Posts: 8
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 |
12-07-2017, 06:32 PM | #2 |
Grand Sorcerer
Posts: 24,908
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
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. |
12-08-2017, 02:02 AM | #3 |
Junior Member
Posts: 8
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 02:08 AM. |
12-08-2017, 03:21 AM | #4 |
Junior Member
Posts: 8
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 |
12-08-2017, 12:23 PM | #5 |
Junior Member
Posts: 8
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 |
12-08-2017, 06:18 PM | #6 | |
Grand Sorcerer
Posts: 24,908
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
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. |
|
12-09-2017, 12:31 PM | #7 | |
Junior Member
Posts: 8
Karma: 10
Join Date: Dec 2017
Device: Kobo Aura One
|
Quote:
|
|
12-09-2017, 06:45 PM | #8 |
Grand Sorcerer
Posts: 24,908
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
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.
|
12-10-2017, 01:20 PM | #9 | |
Junior Member
Posts: 8
Karma: 10
Join Date: Dec 2017
Device: Kobo Aura One
|
Quote:
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. |
|
12-10-2017, 02:45 PM | #10 |
Guru
Posts: 917
Karma: 417282
Join Date: Jun 2015
Device: kobo aura h2o, kobo forma
|
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. |
12-10-2017, 05:54 PM | #11 | |||
Grand Sorcerer
Posts: 24,908
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
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:
Quote:
Quote:
|
|||
12-14-2017, 09:17 AM | #12 |
Resident Curmudgeon
Posts: 73,650
Karma: 127838196
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
|
If this really wasn't safe and it really did corrupt the database, many people would be posting about it. Given that's not the case, it's user error.
|
12-15-2017, 02:09 AM | #13 |
Junior Member
Posts: 8
Karma: 10
Join Date: Dec 2017
Device: Kobo Aura One
|
well it can be user error but I was paying attention to eject and stuff.
The fact is that I've end up with an import loop : so it is not safe by definition. I'm not complaining here I did mess up my kobo ;p I think some of you are over protective with calibre lol I do love open source. I m managing web servers. but I also admit that some times things can be messy. And kobo + calibre is messy : lots of wikis are outdated, some options are redundant (metadata plugboard vs driver options). I m sure it will do well at some point but with some efforts and some factory reset. |
12-15-2017, 08:23 AM | #14 | |
Wizard
Posts: 2,700
Karma: 6254413
Join Date: May 2016
Location: Ontario, Canada
Device: Kobo Mini, Aura Edition 2 v1, Clara HD
|
Quote:
My biggest dislikes about calibre is: it's folder structure, how it is hard to version with git, it's meta tags (except for series, and I'm a purist), it's calibre# classes (again, I'm a purist), it's black boxness (I don't know exactly what goes in and out of the db), and it's too many features. I still use calibre for certain tasks, but then I clean the ebook up afterwards. For the calibre developers: don't feel bad, I am like this about quite a few other tools. I'm the kind of person who like manually editing ebooks with bash, grep, sed, vim, and vscode. I also still use calibre, a bit in an indirect way. |
|
12-15-2017, 01:16 PM | #15 |
Junior Member
Posts: 8
Karma: 10
Join Date: Dec 2017
Device: Kobo Aura One
|
@geek1011 share yout tools -> I love command line tools with bash and the joy of gawk lol
|
Thread Tools | Search this Thread |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Set progress read of a book | fabrice91 | Kobo Reader | 3 | 01-21-2017 12:46 PM |
Show always read progress | encol | Kindle Developer's Corner | 4 | 05-04-2016 08:39 AM |
Using two custom columns to manage books I'm reading/have read/want to read. | LisaAlissa | Library Management | 3 | 07-07-2014 07:08 PM |
How do you manage your read queue with ebooks? | DuncanWatson | General Discussions | 7 | 05-14-2010 01:30 PM |
How do YOU manage read and borrowed books? | SimonSays | Reading and Management | 8 | 02-15-2010 07:17 AM |