Updating Custom Field From CSV File

Kewa · Yesterday, 08:05 AM

Hi

I share my Calibre Library with family abroad by backing up my Library and restoring it to their laptop when we/they visit every couple of years.

Shortly before the last share I'd added a custom field "Done" which I use to note new books I've added and the cover/metadata has been tidied up.

They use that same field to show books they've read.

I'm about to remove their current library and replace it with my latest backup.

Before I start I plan to download a CSV catalogue of their library including the "Done" field so there is a record of the books they've read.

Once I've restored my library to their laptop and deleted everything in the "Done" column the next job is repopulate that field with TRUE for the books they've read.

Clearly this can be done manually from the CSV catalogue but is it possible to automate this somehow by bulk updating the field using the data in the CSV file and, is so, how do I do it please?

Many thanks in advance

Kewa

theducks · Yesterday, 11:15 AM

Have you looked at Import List (plugin): CSV file (the fields button)?

Yesterday, 08:05 AM	#1
Kewa Junior Member Posts: 4 Karma: 10 Join Date: Dec 2019 Device: none	Updating Custom Field From CSV File Hi I share my Calibre Library with family abroad by backing up my Library and restoring it to their laptop when we/they visit every couple of years. Shortly before the last share I'd added a custom field "Done" which I use to note new books I've added and the cover/metadata has been tidied up. They use that same field to show books they've read. I'm about to remove their current library and replace it with my latest backup. Before I start I plan to download a CSV catalogue of their library including the "Done" field so there is a record of the books they've read. Once I've restored my library to their laptop and deleted everything in the "Done" column the next job is repopulate that field with TRUE for the books they've read. Clearly this can be done manually from the CSV catalogue but is it possible to automate this somehow by bulk updating the field using the data in the CSV file and, is so, how do I do it please? Many thanks in advance Kewa

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
custom field based on multiple value field for export	nindotza	Calibre	0	01-02-2021 08:37 AM
Export HTML field to CSV	tycho	Library Management	0	10-03-2020 10:25 AM
Populating a custom Yes/No field based on results from bash command executed on file	Bhuvanesh	Calibre	1	05-17-2019 09:20 PM
Comments field results in bad characters upon saving to CSV	da_jane	Library Management	1	11-21-2012 05:29 PM
Import books from a CSV file	EricBr	Library Management	1	12-02-2011 11:35 AM

Yesterday, 11:15 AM	#2
theducks Well trained by Cats Posts: 31,076 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Have you looked at Import List (plugin): CSV file (the fields button)?