Quote:
Originally Posted by Ersatzreifen
I'm learning Calibre little by little, and have seen the section on creating hierarchical genres. That's all fine and dandy, but when you have a lot of books setting up genres by hand is a daunting task.
So I'm wondering if anyone has managed to figure out how to create a genres column which can be automatically populated based on the DDC? I have the LC plugin installed, and it does a fair job of finding the DDC codes and putting them in the #dcc column (although it fails with the LCC codes). I tossed together a spreadsheet with the summary of the DDC codes (DDC.xml) which can probably be used to make a lookup table, (it's a start). I suppose that templates could be used to do this, but it's all way over my head.
Has anyone done this already, or would anyone know how to go about it?
 ...in advance! |
Use the 'Derive Genres' function in either CALM (recommended) or Quarantine And Scrub. DG uses Boolean Tag rules to populate #genre. Add a Tag for each DDC to your books, and a Boolean rule for each Tag in the DG Tag Rules table. Run DG. Done.
Or, if you know SQL, simply upload your csv data into metadata.db using a SQLite tool, then run update queries using that new table matched against each book's custom column table value for DDC.
LCC and DDC are obtained using ISBNs by the Library Codes plug-in. If the web source for LCC has no data for a particular ISBN, then nothing can be done about it except try another ISBN. Regardless, most Fiction ISBNs will find nothing.
DaltonST