07-07-2018, 10:50 PM | #1 |
Junior Member
Posts: 8
Karma: 10
Join Date: Jul 2018
Device: Nook Color, Samsung Tab A6, Kindle
|
Import and update author, title, and other metadata
I have a library that has grown over time to a few thousand books. My standards for the library have also evolved over time and now I find that I would like to go back and clean up a lot of the data. This will include changes to authors, titles and other metadata (genre, tags, ratings, comments, etc).
I have used the "Create a catalog of books" function to export a CSV file containing all the data I would like to update. My question is, is there a way to edit the data in the CSV file - including all of the columns mentioned above - and then re-import it into Calibre and have it make the appropriate updates? Making all the changes manually using the Metadata editor screen will be, given the number of books needing updating, very painful. Given the presence of an ID and UUID field in the export CSV, I believe that the CSV does contain the information needed to accurately determine which book in the library each line in the CSV refers to even if author and title are altered. Is this do-able? Thanks! |
07-07-2018, 11:30 PM | #2 |
null operator (he/him)
Posts: 20,568
Karma: 26954694
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
@KnotHolme see the Import List plugin, here's the Index of plugins ==>> Index of plugins, there are other plugins that may help - such as the Quality Check plugin's Fix options for Author names etc
BR |
Advert | |
|
07-08-2018, 12:14 AM | #3 |
Grand Sorcerer
Posts: 12,166
Karma: 73448616
Join Date: Nov 2007
Location: Toronto
Device: Nexus 7, Clara, Touch, Tolino EPOS
|
You could also edit the csv file to create a script that would use the calibredb command vhttps://manual.calibre-ebook.com/generated/en/calibredb.html
I'm not sure though it can change author or title |
07-08-2018, 12:51 AM | #4 |
Junior Member
Posts: 8
Karma: 10
Join Date: Jul 2018
Device: Nook Color, Samsung Tab A6, Kindle
|
@BetterRed - Thanks for the suggestion but it did not seem to do what I am looking for - but perhaps I just do not understand its purpose/capabilities. It seemed that it wanted to match on author/title - not UUID - meaning that each line in the incoming CSV would need to be manually matched to the exiting book in Calibre - again a labor intensive effort I am trying to avoid (yes, I am lazy). Also, Once I did match the few test books I tried, it seemed that it would display the data, and perhaps re-export it for use in other applications, but I did not find a way to actually rename books and update metadata in the Calibre database. Did I miss something?
Thanks, |
07-08-2018, 12:52 AM | #5 |
Junior Member
Posts: 8
Karma: 10
Join Date: Jul 2018
Device: Nook Color, Samsung Tab A6, Kindle
|
@PeterT - thanks for the tip, I was not aware of that functionality. I'll explore it further.
|
Advert | |
|
07-08-2018, 02:48 AM | #6 | ||
null operator (he/him)
Posts: 20,568
Karma: 26954694
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Quote:
Quote:
But it's unlikely you'll find a one-slick-click-and-it's-done solution. Fixing messy libraries mostly gets done progressively, rather than in one fell swoop. BR |
||
07-08-2018, 05:49 AM | #7 | |
Grand Sorcerer
Posts: 24,907
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
@KnotHolme: Depending on the changes you are making, you might also want to look at the Quality Check plugin. It can find problems with metadata and fix them. As an example, it can find all books with authors in style "LN, FN" and change this to "FN LN". That plus the search and replace part of the Bulk metadata editor can clean up a lot of problems. |
|
07-08-2018, 11:53 AM | #8 |
Junior Member
Posts: 8
Karma: 10
Join Date: Jul 2018
Device: Nook Color, Samsung Tab A6, Kindle
|
Thank you all very much for the helpful responses.
@davidfor - While Python is not my strongest language, I am always looking for new challenges and opportunities and I would love to be able to contribute in some way to the Calibre community. I am reading the IL thread now and will take any further questions there. Thanks again! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Import Author And Title From Filename & Import Other Tags And Cover From File | DazJWood | Library Management | 25 | 10-06-2021 10:18 AM |
Import Author and Title from Filename & Cover from File | Alcohol | Library Management | 3 | 06-25-2017 11:19 AM |
Calibre fills automatically title and author metadata in books without any metadata? | thosedays | Library Management | 5 | 10-28-2016 03:33 PM |
author-title metadata and file name | annoporci | Calibre | 14 | 11-08-2012 01:53 PM |
Title and author's Metadata is switched | Student1 | Library Management | 8 | 01-23-2011 10:35 PM |