Library structure on PC and on Device

[mfsav2]

Team,
I've tried to find an answer but was not able to.

Let me explain, I've changed the rule to create the folders from the default one to this one (in the help):
{author_sort}/{series:||/}{series_index:|| - } {title}

as it suites me better to keep my books ordered when there are series.

Now the issue is that if I sync the books BEFORE I search or edit the metadata they are put in a certain folder.
How do I have them been put in the correct folder AFTER I've updated the metadata?

The only way I've found is to delete them from the ebook reader and re upload the book.

But this is bad as I lose the reading position, notes, etc...

Can you help me?
If the function is not there it would be really great to have a function like "re-order books" on the device if the path rule changes or the metadata changes.

The second point (less critical) is on the library structure on the PC.
I cannot change the structure (i.e. add the number and series)?

thank you
M

[eschwartz]

1. Annotations are stored in the sidecar files. On older devices it is in the *.(apnx|azw3r|azw3f|mbp1|mbs) files, and on the KT and later, all those files are in the *.sdr folder.
   The files must have a filename which matches the filename of the *.mobi or *.azw3
   
   You will have to move them yourself.
   
2. No you cannot. As per the sticky in this forum (do make sure to read the detailed answer).

[jgaiser]

Originally Posted by eschwartz

No you cannot. As per the sticky in this forum (do make sure to read the detailed answer).

What I don't get is folks don't understand that calibre is basically a database. Why would you worry about how the data is stored in the database? You have a front-end and tools to manage the data. Don't worry about how things look under the skirts.

[mfsav2]

Originally Posted by jgaiser

What I don't get is folks don't understand that calibre is basically a database. Why would you worry about how the data is stored in the database? You have a front-end and tools to manage the data. Don't worry about how things look under the skirts.

Very simple some asy reasons: because the database breaks, I change computer, I move disks, I access from remote/web and no db is usefull, etc...

So it would be perfect to be a database AND a tool to manage files and structures.

In fact Calibre does not only sotre the metadata but even moves files, creates new files etc...
so it would be lovely to have the two parts of it's core aligned

[theducks]

Originally Posted by mfsav2

Very simple some asy reasons: because the database breaks, I change computer, I move disks, I access from remote/web and no db is usefull, etc...

So it would be perfect to be a database AND a tool to manage files and structures.

In fact Calibre does not only sotre the metadata but even moves files, creates new files etc...
so it would be lovely to have the two parts of it's core aligned

Calibre includes extra files in the Library folder(s) in case Metadata.db breaks

metadata_db_prefs_backup ti reconstruct the Structure

and in each title folder:
metadata.opf and cover.jpg to put the Details (record) back into the DB

This is not proof against you destroying metadata with a serious misstep with the All (or a goodly number) using bulk mode S&R. If you shut down Calibre immediately, only a few dozen of those metadata.OPF will have been refreshed. Simply rebuild using the CLI calibredb restore_database [options]

Kovid really did think this through

[eschwartz]

Slightly

@theducks -- a new feature I have been looking at in source, "Export all calibre data".
Sounds interesting?

[theducks]

Originally Posted by eschwartz

Slightly

@theducks -- a new feature I have been looking at in source, "Export all calibre data".
Sounds interesting?

Yes it does!
(I assume, that it will export the Current Library as part of the process
I wonder if it will offer to walk the list (in the Library icon) of Libraries?

[eschwartz]

It lists the libraries and their sizes in a special dialog and asks you to select which ones you want exported.

Then it pops up an error. Hopefully that will be fixed by the time it is released, but I filed a bug report to make sure.

EDIT: Yeah, feature still in development. The fact that it was wired to the GUI already was what tricked me.
In other news, there won't be a release this week, until it's done.