How to fix "Extra Titles" in Database in " Check Library - Problems Found

[eschwartz]

Originally Posted by millan

I appreciate your kind help and thank you eschwartz,

I'm kind of relieved that I could continue to drag and drop the new items
I have also installed the FreeFileSync now.
It's a great suggestion.

On the other hand, I have a question on copying through Calibre:
After I copy the latest entries in calibre and copy through calibre interface,
I seem to get "cleaner" Lib2
ie: Less number of folders (Perhaps all the empty folders are left in Lib1
So the total byte size of the Lib1 and Lib2 are exactly the same after copying although I could see less number of folders etc in Lib2

does that mean copying items from Lib1 to Lib2 gives a cleaner library all
together if done through calibre interface?

Copying through the library interface is no cleaner than keeping a synced backup (e.g. through FreeFileSync) -- the difference is that copying through calibre only transfers select items, and additionally will not copy any junk files which Check Library reports as not in the database.
File-syncing programs just copy the whole library folder.

So if Check library gives a clean bill of health then there should be no empty folders?
Either way, empty folders at least are not a big problem, all they cost is an inode (or NTFS equivalent) which is pretty cheap. They do make a visual mess, though.

[chaley]

Originally Posted by millan

On the other hand, I have a question on copying through Calibre:
After I copy the latest entries in calibre and copy through calibre interface,
I seem to get "cleaner" Lib2
ie: Less number of folders (Perhaps all the empty folders are left in Lib1
So the total byte size of the Lib1 and Lib2 are exactly the same after copying although I could see less number of folders etc in Lib2

does that mean copying items from Lib1 to Lib2 gives a cleaner library all
together if done through calibre interface?

If you are accumulating empty folders in your production library then something is still broken.

First thing to do is what eschwartz suggested: run check library. If it finds nothing then the question becomes "what is the difference in the file system between an FFS copy and a calibre copy-to-library copy?"

[theducks]

Originally Posted by millan

does that mean copying items from Lib1 to Lib2 gives a cleaner library all
together if done through calibre interface?

Copy to Library will only Copy Pieces that Calibre knows (and tracks) about.
Some knowledgeable folk store additional material in the folders, Copy To Library is Death to this additional material.

A number of side effects:
{Last_Modified} gets set to a current (timestamp) value
{id} are freshly assigned and the natural (un-sorted)
order changes

[millan]

Thank you all for your time and effort to get to the right truck.

PS 1: Dear Chaley, I run check library often and I cannot seem to see any problem, in the first check or the next (after OK'ing the first one).
I'll do my best to be extra careful from now on.

PS 2: Dear Eeschwartz, I have started using the FreeFileSync - Good and faster way to sync. Thank you

PS 3: Dear Theducks: Thank you for the side effects I wasn't aware of

Cheers to you all:
eschwartz, chaley, theducks