View Single Post
Old 03-14-2020, 10:18 AM   #12
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
Match on ISBN via JS Import CSV to Update Metadata Tool

Quote:
Originally Posted by adrianf View Post
I want to save all my tags at a specific moment in a file, and pass this one on to a friend who too, uses Calibre under macOS, like myself. How could my friend import this file, and thus overwrite his own tags? Can anybody help me with this?

Assuming your friend has mostly the same books as you, and assuming both you and he have the identical ISBN for the same book, this is easy to do.


See the attached image.


[1] You create a Calibre Catalog .csv file with only columns ISBN and Tags, and give it to your friend.


[2] Your friend creates a new custom column of type "comments-plain text-simple text", and then populates it using Bulk Metadata Edit Search & Replace from Identifier Type 'isbn'.

Important: the custom column must be "real", not "virtual" or "composite" or "built from others", since the JS Tool reads the metadata.db, not the GUI Cache, to do its work.


[3] Your friend imports your .csv file via the tool shown in the attached image, and matches the ISBN in the .csv to his ISBN in his new custom column. The column to update is Tags.



DaltonST




n.b. the easy way to copy all Tags (or any other Tag-like custom column) from one library to another is to use the Job Spy "Mega-Metadata Reference Dropdown Helper" tool to automatically add all Tags to a single book you pick, then export the book with .opf file to disk. Then import the book. Now, all of the Tags from the first library exist in the second library, but of course only in that special book.
Attached Thumbnails
Click image for larger version

Name:	js_import_csv_to_update_metadata_20191023.jpg
Views:	199
Size:	1.24 MB
ID:	177703  

Last edited by DaltonST; 03-14-2020 at 10:24 AM.
DaltonST is offline   Reply With Quote