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!

BetterRed · 12-11-2023, 06:05 PM

Did you try the calibredb set_metadata option?

BR

capink · 12-11-2023, 11:40 PM

You will have to re-extract the csv file with uuids instead of ids, after which you can import the data using the Import List plugin, where you can match the books using the identifier ID:uuid.

shocampo · 12-12-2023, 03:44 PM

Quote:

Originally Posted by capink

You will have to re-extract the csv file with uuids instead of ids, after which you can import the data using the Import List plugin, where you can match the books using the identifier ID:uuid.

That did trick. Many 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!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
CSV import	jmt31	Conversion	2	04-12-2020 11:09 AM
Inputting of metadata in file for itunes import	MrArtifex	Library Management	8	06-24-2012 05:25 PM
Import from CSV	JCSullivan	Library Management	0	04-12-2012 07:02 AM
Import metadata from file	Vinavil	Library Management	2	01-28-2012 03:48 PM
Import books from a CSV file	EricBr	Library Management	1	12-02-2011 11:35 AM

12-11-2023, 06:05 PM	#2
BetterRed null operator (he/him) Posts: 21,720 Karma: 29711016 Join Date: Mar 2012 Location: Sydney Australia Device: none	Did you try the calibredb set_metadata option? BR

12-11-2023, 11:40 PM	#3
capink Wizard Posts: 1,196 Karma: 1995558 Join Date: Aug 2015 Device: Kindle	You will have to re-extract the csv file with uuids instead of ids, after which you can import the data using the Import List plugin, where you can match the books using the identifier ID:uuid.

Advert