07-25-2010, 11:50 AM | #16 | ||||
Wizard
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
I recall being told that size is rounded off. If true, they may still have a small book.
Quote:
If all the leftovers have books in them, you could just auto-add them and the automatic merge would put them with the matching entries that have correct dates and other metadata. Quote:
Quote:
Quote:
|
||||
07-25-2010, 03:15 PM | #17 | |||
Guru
Posts: 897
Karma: 950683
Join Date: Oct 2009
Device: Kobo Libra2
|
Quote:
Quote:
Quote:
-Marcy |
|||
07-25-2010, 03:30 PM | #18 | |
Wizard
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
Now I'm confused. I thought you had entries for each book, and good metadata in those entries, but they pointed to directories that have no actual files (book formats) in them. Are you saying you have no records and no metadata? I use the term "book" to refer to a record in Calibre with metadata. I use the term "format" to refer to a file associated with the book record in a particular format (PDF, TXT, LIT, etc.) Calibre can easily have books without formats (empty records). You can have leftover formats, without an associated book, but Calibre won't know about them.
Quote:
|
|
07-25-2010, 04:01 PM | #19 | |
Guru
Posts: 897
Karma: 950683
Join Date: Oct 2009
Device: Kobo Libra2
|
Quote:
What I don't understand is how the auto merge picks the correct info. I'm very paranoid about losing my info after this. If the dates get screwed up I'm not sure how to reconstruct things. -Marcy |
|
07-26-2010, 08:53 AM | #20 | ||
Wizard
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
Quote:
Quote:
You say you "have all 1700 books backed up in locations calibre doesn't realize they are at." That could refer to the original books before they were ever imported into Calibre (and before your problem occurred) or it could refer to the 1700 entries that Calibre first made, after your first import, but before your problem. You didn't say which. The reason I suggested you re-import from the latter (the first Calibre library locations), and not the former (before the first entry into Calibre's database) was because Calibre always creates a filename with author/title. That means you can use a regex in Preferences|Add/Save that will always get the correct author/title metadata and that means Calibre will be able to do the match it needs to do during auto merge. Last edited by Starson17; 07-26-2010 at 11:10 AM. |
||
07-27-2010, 05:10 AM | #21 |
Connoisseur
Posts: 68
Karma: 479602
Join Date: Aug 2006
Device: Kindle DX
|
This thread worries me...
I never paused to ask myself what would happen to my +1000 books if the database got corrupted. I would never start again fine tuning everything if it happened to me! So I just started making backups - metadata.db is just under 4MB, not a big deal. But - suppose I had to restore it due to corruption, and in the meantime I've added some books to my library, how does it work? I will find myself just with the new books missing (not a big deal) or with metadata.db completely unable to make sense of my library? alessandro |
07-27-2010, 05:33 AM | #22 | ||
US Navy, Retired
Posts: 9,865
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Nexus 7
|
Quote:
Then again if the thought bothers you, in addition to backing up your library / metadata.db file you could always save your books to disk w/metadata. 1. Go to Preferences - Add/Save - Saving books tab 2. Ensure that the following are checked. Save cover separately 3. Click OKUpdate metadata in saved copy Save metadata in OPF file 4. In your calibre library select all books you wish to (backup) save to disk. 5. Select Save to Disk, create a new directory to export these books to, click OK. Quote:
In the event of catastrophic failure you could start fresh and add these to calibre with the all of the metadata following along. Personally, I just backup my library, the metadata.db file and the config directory. Last edited by DoctorOhh; 07-27-2010 at 05:36 AM. |
||
07-27-2010, 05:42 AM | #23 |
Wizard
Posts: 4,553
Karma: 950151
Join Date: Nov 2008
Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)
|
Sounds like there might be room for a complementary function to the Database Integrity check function that looks through all the folders in the calibre library, and if it finds any books there that are not in the database adds them back in (if necessary renaming the folder).
Does anyone see any fundamental issues with such an idea (Kovid in particular), or is someone else already looking at doing this? If not it might be a good excuse for me to start a little programming project along these lines. If I DO start this I would be thinking of also making a change to write the .opf file to a folder whenever the metadata changes as this would be useful in reconstructing entries in the Calibre database, and also means there is a copy of the metadata external to the database itelf if the database ever gets corrupted without the need to do a "Save to Disk" function. Feedback welcomed on the idea. |
07-27-2010, 08:54 AM | #24 | |
Wizard
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
This is correct. I've done it a few times.
Quote:
|
|
07-27-2010, 09:09 AM | #25 | |||
Wizard
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
Quote:
Quote:
Quote:
|
|||
07-27-2010, 09:48 AM | #26 | |
Wizard
Posts: 4,553
Karma: 950151
Join Date: Nov 2008
Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)
|
Quote:
|
|
07-27-2010, 10:01 AM | #27 |
creator of calibre
Posts: 44,346
Karma: 23661992
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
I'd say moving unknown files to a temporary folder is the best solution.
As for writing metadata to an OPF file, that can be done, but I would suggest making it optional as it entails a performance penalty. Once its implemented we can decide if the performance penalty is severe enough to warrant it being default off or on. Also as Starson pointed out, currently the code for writing custom column metadata to OPF files is non-existant. |
07-27-2010, 10:11 AM | #28 |
curmudgeon
Posts: 1,487
Karma: 5748190
Join Date: Jun 2006
Location: Redwood City, CA USA
Device: Kobo Aura HD, (ex)nook, (ex)PRS-700, (ex)PRS-500
|
There's a variant of this feature that would be neat to have: Optionally (on command) updating the actual ebook files in the calibre database with the latest metadata available for those files.
Some thoughts along the way:
|
07-27-2010, 10:14 AM | #29 | |
Wizard
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
Quote:
Unless I've missed something, moving a library, followed by checking SQL integrity should leave a pretty clean library. |
|
07-27-2010, 10:19 AM | #30 | |
Wizard
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
Quote:
I don't see how you can do this without new db fields to track these dates. |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Corrupted File? | StealthyScribe | Kobo Reader | 8 | 07-21-2010 10:09 PM |
corrupted dbase | hnoto | Related Tools | 43 | 05-17-2010 11:27 AM |
Corrupted DB on Reader | djwoodard | Kobo Reader | 7 | 05-10-2010 01:13 AM |
Library corrupted | rozie123 | Sony Reader | 1 | 05-26-2009 07:02 AM |
metadata.db corrupted | Philantrop | Calibre | 9 | 01-05-2009 09:34 PM |