Quote:
Originally Posted by CraftingGrandma
I apologize, but I did not follow much of that.
As far as I know the information is not messed up on the reader. As it shows up when I look at the connected device in calibre and can see the cover, the author, and tags.
I plug in my sony. Start calibre and then let it load the sony into calibre. I click on the devices button and transferred over the books. When it was done. there were about 400 that transfered over but do not have the check mark for on device and have all the missing and messed up information I talked about. When I click on device and find the same book missing it's cover tags and different author name in calibres main library I see everything there and the way it should be when looking at the book in the on device button. I can see the cover in the preview panel and it's tags.
Plus all the books on my sony were originally from calibre. So everything that was there came from calibre in the first place.
As for patterns. I notice that all the changed files tat are of a .txt nature have their titles changed to the entire first line of the book. and the author is changed to the entire second line.
.pdf has the title fine, but the author names are correct except they have a 3 digit number behind the correct name.
All of the files no matter what (at least the ones that did not transfer properly without that check mark for on device) are missing their covers, tags, and series. They are all missing/blank.
|
TXT as a format does not support any metadata at all.
If the books all have metadata in the filename, e.g. they are called "title - authors.txt" then you can delete those books, go to Preferences ==> Import/Export ==> Adding books, and
uncheck "Read metadata from file contents rather than filename".
Then reimport all the TXT books, and they will be imported with that metadata at least. If the filenames are something different, tell me what they look like and I can give you a "regular expression pattern to use when trying to guess ebook metadata from filenames".
PDF is also a bit awkward in handling metadata. For those, I recommend just going to the Tag Browser (right side) and clicking Formats ==> PDF.
That will select all PDF books.
Then click CTRL+A (select all) and click the Edit Metadata toolbar. Select the last tab (Search and Replace) and enter the following settings:
Search Mode: Regular Expression
Search Field: Authors
Destination Field: Authors
Search for:
Replace with:
That should remove all the three digit numbers at the end in bulk.
Finally, I would use the download metadata feature to download covers and series info. You can get tags too (personally, I have never found a useful tag
)
Go to Preferences ==> Sharing ==> Metadata download, setup the right sources you trust (Goodreads is important, they should have series info) and then select all books and press CTRL+D (there should be a toolbar icon to start a Metadata download, but I always use the shortcut key
).
calibre will take a while and then popup with the results for you to approve one-by-one (or you can choose to accept all).
I don't know of any way to get that info from the Sony database.