custom metadata field vanished

[theducks]

AFAIK using the wrong method to transfer is a sure-fire method to lose metadata YOU added. Using Add Books to transfer to another Library. That reads the BOOK for metadata. If you did not Polish or Embed metadata, the filed (Library stored) version is pretty much as it was added originally.

Metadata is inside the DB. This is why you MUST use Calibre for most things.
Only Calibre changes the DB. The user tells Calibre to do things. If you use something non-Calibre aware to make partial (file or folder) changes. Calibre is kept in the dark and loses sync with where it put things.

While I distrust "Otto" doing transfers, I can't believe it would change relative locations of files (mix things up).
"Oh! this metadata.db is newer (Library 2), so I will replace the older one (belongs to Library 1) BTW that should produce way more errors unless it was from an older backup, where the books were still named exactly the same.
Calibre uses 2 (file system) Locations (1 Library Users) for data. The Library folder and the User settings (configuration) folder . The Configuration does NOT contain Book Specific Metadata.
Something rebuilt the DB WITHOUT using the Recovery data kept with each Library and Book. (the JSON file in the Library folder has the DB Structure. Metadata.opf, WITH in the Title folder) has the data for that books entry.)

[ownedbycats]

Originally Posted by theducks

While I distrust "Otto" doing transfers, I can't believe it would change relative locations of files (mix things up).

Something I wondered was whether it failed to transfer the metadata.db and left just the book files themselves, but that normally results in an empty library.

[Sirtel]

Originally Posted by ownedbycats

Something I wondered was whether it failed to transfer the metadata.db and left just the book files themselves, but that normally results in an empty library.

And some books are also missing.

To me, it looks like calibre now has either an old copy (from before creating the review column) or a different library altogether - I can't imagine what else would delete a custom column. But if the OP is sure this is their one and only library...

And we still don't know whether things vanished before or after transfer.

[ownedbycats]

Yeah, an old version of metadata.db sounds plausible.

[deliquate]

Hello! I'm home for the holidays and finally had a chance to open up my old computer--and all my reviews and other custom metadata is still in Calibre there!

Can anyone point me to instructions about how to properly transfer my library, including metadata, to a new computer?

[BetterRed]

Originally Posted by deliquate

Hello! I'm home for the holidays and finally had a chance to open up my old computer--and all my reviews and other custom metadata is still in Calibre there!

Can anyone point me to instructions about how to properly transfer my library, including metadata, to a new computer?

I already told you in post #12:

Which 'it' did the 'automatic transfer' - there's no such thing in the calibre software,

see ==>> How do I move my calibre data from one computer to another?

BR