MobileRead Forums - View Single Post - Import and Replace Metadata from CSV File

shocampo · 12-11-2023, 05:55 PM

Got a situation. I have two custom date fields in my Calibre library: Date Started and Date Finished. Somehow in the past two weeks, the Date Finished field for all 5862 records in my Calibre DB was overwitten with the date '0118-01-01'. Not sure how that happened, but I was able to pull a copy of the metadata.db file that had the correct Date Finished data from a backup. I extracted the metadata from the backup to a CSV file using calibredb catalog, so I have a list of calibre IDs and the associated Date Finished data. Is there a way, maybe using calibredb, to merge the Date Finished data back into my library? Thanks!

12-11-2023, 05:55 PM	#1
shocampo Member Posts: 11 Karma: 10 Join Date: Sep 2010 Device: Kindle	Import and Replace Metadata from CSV File Got a situation. I have two custom date fields in my Calibre library: Date Started and Date Finished. Somehow in the past two weeks, the Date Finished field for all 5862 records in my Calibre DB was overwitten with the date '0118-01-01'. Not sure how that happened, but I was able to pull a copy of the metadata.db file that had the correct Date Finished data from a backup. I extracted the metadata from the backup to a CSV file using calibredb catalog, so I have a list of calibre IDs and the associated Date Finished data. Is there a way, maybe using calibredb, to merge the Date Finished data back into my library? Thanks!