03-15-2016, 09:31 AM | #1 |
Bibliothekar
Posts: 38
Karma: 10
Join Date: Jun 2011
Location: San Jose City, Philippines
Device: Galaxy Tab S w/Bookari Premium
|
Genres using DDC, templates, and automation?
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! |
03-15-2016, 10:01 AM | #2 |
Ex-Helpdesk Junkie
Posts: 19,422
Karma: 85397180
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
|
For starters, try posting in the calibre forums.
I have reported this thread so the moderators can have it moved. Also, you might have more luck posting directly in the plugin thread -- I have no idea how it is supposed to work. |
03-15-2016, 10:12 AM | #3 |
Grand Sorcerer
Posts: 44,748
Karma: 55645321
Join Date: Jan 2007
Location: Peru
Device: Kindle: Oasis 3, Voyage WiFi; Kobo: Libra 2, Aura One
|
Please look over our site and post responsibly.
This thread has now been moved OUT of General Discussion. Don (Moderator) |
03-15-2016, 11:36 AM | #4 |
Bibliothekar
Posts: 38
Karma: 10
Join Date: Jun 2011
Location: San Jose City, Philippines
Device: Galaxy Tab S w/Bookari Premium
|
Why don't you use your influence to get the menu set up so I don't have to spend a week trying to find where to post? The ONLY choices presented to me were these:
* News * General Discussions * Deals, Freebies, and Resources (No Self-Promotion) * Self-Promotions by Authors and Publishers * Reading Recommendations * Writers' Corner Where the hell is this elusive "calibre forums" you speak of? If it's not obvious then don't blame me for not being able to find it!!! What plugin thread? I don't see that either. |
03-15-2016, 11:40 AM | #5 | |
Wizard
Posts: 4,552
Karma: 950151
Join Date: Nov 2008
Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)
|
Quote:
The headings you mention are in the General section. If you go further down to the software section then you will find that Calibre has a whole sub-forum of its own. Within the Calibre area is a sub-section on plugins. |
|
03-15-2016, 11:45 AM | #6 | |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Quote:
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 |
|
03-15-2016, 11:56 AM | #7 | ||
Ex-Helpdesk Junkie
Posts: 19,422
Karma: 85397180
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
|
Quote:
Seems fairly obvious to me, no one has hidden them so I don't need to use "my influence" ( -- I did what every single member is allowed to do. The moderators actually work around here.) Quote:
|
||
03-15-2016, 11:59 AM | #8 |
Ex-Helpdesk Junkie
Posts: 19,422
Karma: 85397180
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
|
And looking at your profile's post history, I see that every post and/or thread you have posted to date was in the calibre forums anyway -- so now I am really confused why you cannot find it. In fact, just last month you started this thread in the Calibre ==> Library Management sub-subforum.
|
03-15-2016, 11:59 AM | #9 |
Bibliothekar
Posts: 38
Karma: 10
Join Date: Jun 2011
Location: San Jose City, Philippines
Device: Galaxy Tab S w/Bookari Premium
|
|
03-15-2016, 12:04 PM | #10 |
Ex-Helpdesk Junkie
Posts: 19,422
Karma: 85397180
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
|
|
03-15-2016, 01:58 PM | #11 | |
o saeclum infacetum
Posts: 20,232
Karma: 222235366
Join Date: Oct 2010
Location: New England
Device: H2O, Aura One, PW5
|
Quote:
Help is a favor, not a right. Manners matter. |
|
03-18-2016, 07:36 AM | #12 | |||
Bibliothekar
Posts: 38
Karma: 10
Join Date: Jun 2011
Location: San Jose City, Philippines
Device: Galaxy Tab S w/Bookari Premium
|
Quote:
My libraries are named "Calibre Library", "Broken-Books", and the like, but trying to run load all libraries looks like this: Is it supposed to look like that, with 01, 02, 03 instead of full pathnames? What does Target Library mean? It seems to be used for different things, depending on where in the instructions it's being used. And why don't the tabs named Metadata tools and Library tools function? I wasn't able to find any Derive Genres function, perhaps that's within the two tabs that won't open. Quote:
Quote:
That seems strange, since the #lcc column is there. Maybe there's something wrong with it, I don't know. |
|||
03-18-2016, 08:34 AM | #13 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
@Ersatzreifen: Given your comments, I now suggest this: [1] LC: confirm the configuration of LC itself, plus your custom column configuration in Preferences > Add your own columns. [2] CALM: uninstall. [3] Using Calibre's standard functionality, copy #ddc into #genre, so the 'genre' is temporarily the ddc. [4] Sort by genre (which is temporarily ddc at this point). [5] Select all rows in the GUI that have the same 'genre'. [6] Using Calibre's Bulk Edit feature, change the #genre column of the selected books from the ddc into the real genre that you want to have. [7] Repeat [5] and [6] until finished. Good luck. DaltonST |
03-18-2016, 09:08 AM | #14 |
Bibliothekar
Posts: 38
Karma: 10
Join Date: Jun 2011
Location: San Jose City, Philippines
Device: Galaxy Tab S w/Bookari Premium
|
So.......
are you saying that it can't be automated? |
03-18-2016, 09:59 AM | #15 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
|
Tags |
automation, ddc, genres, templates |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Touch Kobo as home automation display | nubble | Kobo Developer's Corner | 7 | 03-28-2022 05:40 AM |
Calibre Automation? | UnderWaterHound | Calibre | 1 | 07-24-2012 09:38 PM |
Is it possible to turn off all automation in Sigil? | Iznogood | Sigil | 7 | 06-13-2012 04:05 AM |