[Published Date] question

gtriever · 08-28-2020, 12:07 PM

I have a 181-book series that was published monthly from 1933 - 1948. As you can imagine, Metadata is pretty much non-existent. I've managed to get them in series order, but I'd like to include the Published Date as well.

Is there any way to batch add the Published Date information, incrementing by Month from March 1933 - September 1948? Or, do I just need to edit the Metadata individually for each book?

kovidgoyal · 08-28-2020, 12:58 PM

There's no out-of-the-box way to do it, but if you know how to script, you can use the calibredb command to do it. https://manual.calibre-ebook.com/gen...calibredb.html

gtriever · 08-28-2020, 01:22 PM

Unfortunately, scripting is something I never learned. Thank you for your response , though.

capink · 08-28-2020, 05:03 PM

One possible solution for this without scripting:

export you data to csv using calibre catalogue feature.
add the pubdates in a spreadsheet. (You can google how to increment by month using excel).
save the spreadsheet as csv.
update book metadata in calibre by re-importing the csv using the Import List plugin.

08-28-2020, 12:07 PM	#1
gtriever Addict Posts: 286 Karma: 2125576 Join Date: Sep 2010 Device: Kobo Forma	[Published Date] question I have a 181-book series that was published monthly from 1933 - 1948. As you can imagine, Metadata is pretty much non-existent. I've managed to get them in series order, but I'd like to include the Published Date as well. Is there any way to batch add the Published Date information, incrementing by Month from March 1933 - September 1948? Or, do I just need to edit the Metadata individually for each book?

08-28-2020, 05:03 PM	#4
capink Wizard Posts: 1,196 Karma: 1995558 Join Date: Aug 2015 Device: Kindle	One possible solution for this without scripting: export you data to csv using calibre catalogue feature. add the pubdates in a spreadsheet. (You can google how to increment by month using excel). save the spreadsheet as csv. update book metadata in calibre by re-importing the csv using the Import List plugin.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to replace date with the published date	MegAnne	Calibre	6	02-25-2019 01:47 AM
Edit Metadata - Date and Published question	phossler	Calibre	4	04-10-2015 10:26 PM
'Published date' and 'originally published date'	Arrghus	Calibre	2	07-29-2011 12:43 AM
Date published	philandjan	Library Management	1	06-02-2011 11:43 AM
Bulk Changing Published Date To Date	hmf	Calibre	4	10-19-2010 10:19 PM

08-28-2020, 12:58 PM	#2
kovidgoyal creator of calibre Posts: 45,345 Karma: 27182818 Join Date: Oct 2006 Location: Mumbai, India Device: Various	There's no out-of-the-box way to do it, but if you know how to script, you can use the calibredb command to do it. https://manual.calibre-ebook.com/gen...calibredb.html

08-28-2020, 01:22 PM	#3
gtriever Addict Posts: 286 Karma: 2125576 Join Date: Sep 2010 Device: Kobo Forma	Unfortunately, scripting is something I never learned. Thank you for your response , though.

Advert