A few things you can try:
- Import the books again into a separate library, reading metadata from books rather than file names. This may solve the puzzle of the author names mysteriously appearing, and will give you a second set of metadata to complement the first: If you copy the books from one library to the other, Metadata will be merged, i.e., Calibre will keep the author names from one libray and fill the empty series data from the copied books.
- 'Search and replace' in the Edit metadata-dialogue lets you pick apart the merged title data you got (Title: Game of Thrones - 01 - A Game Of Thrones.mobi). A powerful function, might take some trial and error if you haven't used the function before. You'll need multiple runs: Copy the series name to the series field, then # to #field, then title to tile field. If you haven't used it, you'll want to copy your books into an empty library first - there is no undo-option!
- Calibre can update the metadata online using isbn-numbers, which you can auto-extract from many books: Install the plugin 'extract isbn', run it on all books with no isbn (search for 'isbn:false'), then do an online metadata search (select all books with incomplete metadata, ctrl+d, download only metadata. I use goodreads, amazon and b&n as sources, and rarely see problems with incorrect isbns or downloaded metadata. You can verify against the book covers to be sure.
- (once your library is restored: Use the 'polish books' function (or plugin?) to update the metadata in your books. If you have to ever re-import them again, Calibre will read back the metadata from the books)
Good luck!
|