[GUI Plugin] Library Codes

DaltonST · 11-03-2015, 11:33 AM

Moderator Notice
Please see also Updated Plugin for new API

[GUI Plugin] Library Codes

Functions and Features:

[1] Automatically creates new Custom Columns (if desired) for Dewey Decimal Code and/or Library of Congress Code and/or OCLC-OWI and/or FAST Tags.

[2] Derives the desired Library Codes using a book's ISBN or ISSN [Selected Books].

[3] Optionally creates Identifiers: OCLC-OWI; OCLC-WORLDCAT; and VIAF_AUTHOR_ID. This allows the use of composite Custom Columns to be shown in the Book Details as a hot-link to the respective URLs.

[4] Optionally Converts ISBN-10 to ISBN-13 [Selected Books]. This function will also automatically "sanitize" ISBNs to remove any dashes, etc. even if the ISBN is already an ISBN-13.

[5] Optionally extracts ISSNs from PDFs for Magazines and Periodicals. The other LC functionality then may be executed for the PDFs for which ISSNs were extracted. View the LC Menu ToolTips for more information.

[6] Optionally maps either a LCC or a DDC for each book to a 'Genre', and updates a Text custom column with that mapping. LC comes preloaded for DDC mappings, but a template .csv file for LCC mappings is attached below.

Please read the ToolTips in the LC customization settings.

For a full Open Source DDC listing for your own use: https://raw.githubusercontent.com/Jo...master/fdc.txt

Code décimal de Dewey en français: https://www.mobileread.com/forums/sh...4&postcount=94

Versión en español/Spanish Language version: https://www.mobileread.com/forums/sh...7&postcount=24

Requires Minimum Calibre Version: 6.0.0

Version History:

Spoiler:

Krazykiwi · 11-13-2015, 07:49 AM

I've been wanting this for a long time to try to help wrangle my non-fiction books, so thank you!

I have a couple of ideas/feature suggestions which you should of course feel free to ignore.

- could the ddc column be optionally hierarchal? Since the DDC is, and conveniently already has a . in it, that would be pretty neat.
- Firstly thank you for making the dialog box non-modal, but once it's set up, is there any need to show the dialog every time? I'm thinking once you've configured the columns etc the first time, perhaps it could work like the count pages plugin, where you can set the button to run a default action when you click it, and it offers alternatives on right click on the toolbar icon.
- This one's probably a big ask, but most e-books have the LC/DDC info in the frontmatter. I always meant to ask the ISBN scanner plugin author if he could get that to pull the library codes out of there while it's looking for ISBN's, perhaps you could do the other way around instead?

In general, thanks very much for this plugin, it's pretty solid for a first release (and I can crash about anything but haven't broken this yet) and does exactly as advertised, and the few books I've had that failed to pull info were either ancient and obscure, or had dodgy ISBN's (box set ISBN vs individual volumes, etc.)

DaltonST · 11-13-2015, 10:05 AM

Quote:

Originally Posted by Krazykiwi

I've been wanting this for a long time to try to help wrangle my non-fiction books, so thank you!

I have a couple of ideas/feature suggestions which you should of course feel free to ignore.

- could the ddc column be optionally hierarchal? Since the DDC is, and conveniently already has a . in it, that would be pretty neat.
- Firstly thank you for making the dialog box non-modal, but once it's set up, is there any need to show the dialog every time? I'm thinking once you've configured the columns etc the first time, perhaps it could work like the count pages plugin, where you can set the button to run a default action when you click it, and it offers alternatives on right click on the toolbar icon.
- This one's probably a big ask, but most e-books have the LC/DDC info in the frontmatter. I always meant to ask the ISBN scanner plugin author if he could get that to pull the library codes out of there while it's looking for ISBN's, perhaps you could do the other way around instead?

In general, thanks very much for this plugin, it's pretty solid for a first release (and I can crash about anything but haven't broken this yet) and does exactly as advertised, and the few books I've had that failed to pull info were either ancient and obscure, or had dodgy ISBN's (box set ISBN vs individual volumes, etc.)

@Krazykiwi:

You can manually change the ddc and lcc columns in "Calibre > Preferences > Add your own columns" to be "partitioned" however you please.

Good suggestions. I'll consider them.

DaltonST

Krazykiwi · 11-13-2015, 05:18 PM

Quote:

Originally Posted by DaltonST

@Krazykiwi:

You can manually change the ddc and lcc columns in "Calibre > Preferences > Add your own columns" to be "partitioned" however you please.

Hi Dalton,

Actually, I didn't mean partitioning, rather turning the tag browser into a tree, split on the period in the DDC. And I guess it would work in the LOC codes too, just less usefully). For some reason I thought it required a particular column type, and that's not editable post column creation, but I was misremembering.

It's not in partitioning though, so in case anyone else wants to do it, it's in ´Preferences -> Look and Feel -> Tag Browser, add the new column to the "Categories with hierarchal items" and restart Calibre. Since the DDC is a strictly hierarchal tree, it works well there.

ETA: link to the instructions in the Calibre manual: http://manual.calibre-ebook.com/sub_groups.html

DaltonST · 11-13-2015, 05:32 PM

Quote:

Originally Posted by Krazykiwi

Hi Dalton,

Actually, I didn't mean partitioning, rather turning the tag browser into a tree, split on the period in the DDC. And I guess it would work in the LOC codes too, just less usefully). For some reason I thought it required a particular column type, and that's not editable post column creation, but I was misremembering.

It's not in partitioning though, so in case anyone else wants to do it, it's in ´Preferences -> Look and Feel -> Tag Browser, add the new column to the "Categories with hierarchal items" and restart Calibre. Since the DDC is a strictly hierarchal tree, it works well there.

ETA: link to the instructions in the Calibre manual: http://manual.calibre-ebook.com/sub_groups.html

@Krazykiwi:

You can manually delete the ddc, lcc, and oclc custom columns that LC automatically created for you, and add whatever you want back manually, including new labels. You just have to update the #names in LC afterwards. The Data Types of your manually created custom columns must be compatible with the textual values for ddc, lcc and oclc, however.

DaltonST

Krazykiwi · 11-13-2015, 05:38 PM

Right, point was you don't need to, it works fine with the existing columns as created, the preference is just in another place than you might think.

DaltonST · 11-16-2015, 02:17 PM

Version 1.0.3 - New option to derive DDC and/or LCC indirectly using Author/Title via OCLC-OWI Identifiers for cases where ISBN/ISSN is not useful or reliable.

Step 1: Derive OCLC-OWI Identifier using Author/Title
Step 2: Derive DDC and/or LCC using OCLC-OWI

Step 1 is unnecessary if you have already attempted to derive DDC/LCC using ISBN/ISSN and had previously configured Library Codes to always add the OCLC-OWI Identifier as a new Identifier (à la ISBN). LC would already have the OCLC-OWI Identifier to use in Step 2.

Bear in mind that the format of the media is implicit in the ISBN/ISSN, whereas it is not at all implicit in a simple Author/Title lookup. For that reason, when doing an Author/Title derivation, Library Codes will always look for the OCLC-OWI with an associated format of "Book", since the DDC/LCC for a "Book" is often very different than for the format of, for example, "Audiobook". Calibre is, after all, first-and-foremost designed to be used for eBooks, although some use Calibre for all kinds of other things in highly creative and complex ways. If you are one of those folks, then you should use ISBN/ISSN for deriving DDC/LCC, and not use Author/Title, unless you want the "Book" DDC/LCC instead of the "Audiobook" DDC/LCC.

DaltonST

DaltonST · 11-17-2015, 03:16 PM

Version 1.0.4 - 2015-11-17 New option to convert ISBN-10s to ISBN-13s for selected books.

DaltonST

n.b. if you currently use the QuarantineAndScrub add-on, then this is done for you automatically as part of Book-Level Scrubbing.

cogitoxin · 11-18-2015, 07:36 PM

Thanks a lot for developing the plugin. I've been looking for it for years. But when I install it on my mac it went error when creating columns. Then I added the columns manually but still didn't work. Is there any way I can solve it?

DaltonST · 11-19-2015, 12:35 AM

Quote:

Originally Posted by cogitoxin

Thanks a lot for developing the plugin. I've been looking for it for years. But when I install it on my mac it went error when creating columns. Then I added the columns manually but still didn't work. Is there any way I can solve it?

@cogitoxin:

LC works perfectly in Windows 10 64bit. I can only guess that your Macintosh does not support submitting 'calibredb' via a spawned operating system subprocess using the particular Python parameters that LC uses.

Essentially, the above is what your attached left error-dialog message says. Your right error-dialog message says that since there "was a left message", you must create the custom column(s) manually.

Obviously you must first delete any custom columns that might have been created by LC, if any. Exit from Calibre, then Restart Calibre. Then, add whatever custom columns you have selected in the LC Configuration dialog. They must be simple "text" custom columns, and the #names must be identical to the #names you specified in the LC Configuration dialog. Exit from Calibre, then Restart Calibre.

Next, test your work by manually adding, changing and deleting DDC/LCC values using Calibre's 'Edit Metadata' function for custom columns.

Finally, bear in mind that just because you have an ISBN does not mean that it is a 'good' ISBN from the perspective of deriving DDC/LCC codes. You can manually derive (or attempt to derive) problem ISBNs using http://classify.oclc.org/classify2/a.../classify.html .

Good luck.

DaltonST

DaltonST · 11-19-2015, 11:49 AM

Version 1.0.5 - 2015-11-19 Creation of 2 Identifiers, VIAF.org Author ID and Library of Congress Author Name ID, whenever OCLC-OWI Identifier is otherwise created. This allows the use of composite custom columns to hot-link to the respective URLs to view extended Author and Book information.

See the Original Post attachments for many images of how to locate these 2 new Identifiers in your Book Details.

DaltonST

Divingduck · 11-19-2015, 02:07 PM

I like this plugin. A big time saver. Thanks a lot

cogitoxin · 11-19-2015, 02:30 PM

Quote:

Originally Posted by DaltonST

@cogitoxin:

LC works perfectly in Windows 10 64bit. I can only guess that your Macintosh does not support submitting 'calibredb' via a spawned operating system subprocess using the particular Python parameters that LC uses.

Essentially, the above is what your attached left error-dialog message says. Your right error-dialog message says that since there "was a left message", you must create the custom column(s) manually.

Obviously you must first delete any custom columns that might have been created by LC, if any. Exit from Calibre, then Restart Calibre. Then, add whatever custom columns you have selected in the LC Configuration dialog. They must be simple "text" custom columns, and the #names must be identical to the #names you specified in the LC Configuration dialog. Exit from Calibre, then Restart Calibre.

Next, test your work by manually adding, changing and deleting DDC/LCC values using Calibre's 'Edit Metadata' function for custom columns.

Finally, bear in mind that just because you have an ISBN does not mean that it is a 'good' ISBN from the perspective of deriving DDC/LCC codes. You can manually derive (or attempt to derive) problem ISBNs using http://classify.oclc.org/classify2/a.../classify.html .

Good luck.

DaltonST

Thanks a lot now it works well. ;-)

]c[

DaltonST · 11-20-2015, 12:14 PM

Version 1.0.6 - 2015-11-20 2 New Identifiers: ISNI and LCCN (derived via VIAF Author ID) to enable hot-linking to ISNI.org and Worldcat.org, respectively. This is done whenever a OCLC-OWI Identifier is otherwise created.

Refer to the many images attached to the Original Post, plus the .txt file with sample templates for composite custom columns. You can copy-and-paste the templates directly from the .txt file.

DaltonST

DaltonST · 11-20-2015, 03:04 PM

Version 1.0.7 - 2015-11-20 New option to delete all non-Library Codes Identifiers.

If you have Version 1.0.6, you must upgrade to Version 1.0.7 to resolve a 'cache db' error.

DaltonST

11-16-2015, 02:17 PM	#7
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	Version 1.0.3 - Derive DDC/LCC Using Author/Title Version 1.0.3 - New option to derive DDC and/or LCC indirectly using Author/Title via OCLC-OWI Identifiers for cases where ISBN/ISSN is not useful or reliable. Step 1: Derive OCLC-OWI Identifier using Author/Title Step 2: Derive DDC and/or LCC using OCLC-OWI Step 1 is unnecessary if you have already attempted to derive DDC/LCC using ISBN/ISSN and had previously configured Library Codes to always add the OCLC-OWI Identifier as a new Identifier (à la ISBN). LC would already have the OCLC-OWI Identifier to use in Step 2. Bear in mind that the format of the media is implicit in the ISBN/ISSN, whereas it is not at all implicit in a simple Author/Title lookup. For that reason, when doing an Author/Title derivation, Library Codes will always look for the OCLC-OWI with an associated format of "Book", since the DDC/LCC for a "Book" is often very different than for the format of, for example, "Audiobook". Calibre is, after all, first-and-foremost designed to be used for eBooks, although some use Calibre for all kinds of other things in highly creative and complex ways. If you are one of those folks, then you should use ISBN/ISSN for deriving DDC/LCC, and not use Author/Title, unless you want the "Book" DDC/LCC instead of the "Audiobook" DDC/LCC. DaltonST

11-17-2015, 03:16 PM	#8
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	Version 1.0.4: Optionally Convert ISBN-10 to ISBN-13 Version 1.0.4 - 2015-11-17 New option to convert ISBN-10s to ISBN-13s for selected books. DaltonST n.b. if you currently use the QuarantineAndScrub add-on, then this is done for you automatically as part of Book-Level Scrubbing.

11-18-2015, 07:36 PM	#9
cogitoxin Junior Member Posts: 4 Karma: 10 Join Date: Oct 2015 Device: kpw	Thanks a lot for developing the plugin. I've been looking for it for years. But when I install it on my mac it went error when creating columns. Then I added the columns manually but still didn't work. Is there any way I can solve it? Attached Thumbnails

11-19-2015, 11:49 AM	#11
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	Version 1.0.5 Creation of New LOC and VIAF.org Author Identifiers for URL Linking Version 1.0.5 - 2015-11-19 Creation of 2 Identifiers, VIAF.org Author ID and Library of Congress Author Name ID, whenever OCLC-OWI Identifier is otherwise created. This allows the use of composite custom columns to hot-link to the respective URLs to view extended Author and Book information. See the Original Post attachments for many images of how to locate these 2 new Identifiers in your Book Details. DaltonST

11-20-2015, 12:14 PM	#14
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	Version 1.0.6 ISNI.org and Worldcat.org Identifiers Version 1.0.6 - 2015-11-20 2 New Identifiers: ISNI and LCCN (derived via VIAF Author ID) to enable hot-linking to ISNI.org and Worldcat.org, respectively. This is done whenever a OCLC-OWI Identifier is otherwise created. Refer to the many images attached to the Original Post, plus the .txt file with sample templates for composite custom columns. You can copy-and-paste the templates directly from the .txt file. DaltonST

11-13-2015, 07:49 AM	#2
Krazykiwi Zealot Posts: 137 Karma: 2156958 Join Date: Jan 2013 Device: Too many random androids to list	I've been wanting this for a long time to try to help wrangle my non-fiction books, so thank you! I have a couple of ideas/feature suggestions which you should of course feel free to ignore. - could the ddc column be optionally hierarchal? Since the DDC is, and conveniently already has a . in it, that would be pretty neat. - Firstly thank you for making the dialog box non-modal, but once it's set up, is there any need to show the dialog every time? I'm thinking once you've configured the columns etc the first time, perhaps it could work like the count pages plugin, where you can set the button to run a default action when you click it, and it offers alternatives on right click on the toolbar icon. - This one's probably a big ask, but most e-books have the LC/DDC info in the frontmatter. I always meant to ask the ISBN scanner plugin author if he could get that to pull the library codes out of there while it's looking for ISBN's, perhaps you could do the other way around instead? In general, thanks very much for this plugin, it's pretty solid for a first release (and I can crash about anything but haven't broken this yet) and does exactly as advertised, and the few books I've had that failed to pull info were either ancient and obscure, or had dodgy ISBN's (box set ISBN vs individual volumes, etc.)

11-13-2015, 05:38 PM	#6
Krazykiwi Zealot Posts: 137 Karma: 2156958 Join Date: Jan 2013 Device: Too many random androids to list	Right, point was you don't need to, it works fine with the existing columns as created, the preference is just in another place than you might think.

11-19-2015, 02:07 PM	#12
Divingduck Wizard Posts: 1,166 Karma: 1410083 Join Date: Nov 2010 Location: Germany Device: Sony PRS-650	I like this plugin. A big time saver. Thanks a lot

11-20-2015, 03:04 PM	#15
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	Version 1.0.7 Version 1.0.7 - 2015-11-20 New option to delete all non-Library Codes Identifiers. If you have Version 1.0.6, you must upgrade to Version 1.0.7 to resolve a 'cache db' error. DaltonST

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[GUI Plugin] KindleUnpack - The Plugin	DiapDealer	Plugins	495	10-19-2024 07:06 AM
[GUI Plugin] SmartEject	JimmXinu	Plugins	105	08-15-2024 11:29 AM
[GUI Plugin] Consolidate All Library Metadata (CALM)	DaltonST	Plugins	333	12-15-2023 09:40 PM
[GUI Plugin] Astro-ph	iatheia	Plugins	14	07-26-2015 12:41 AM
[GUI Plugin] Plugin Updater Deprecated	kiwidude	Plugins	159	06-19-2011 01:27 PM

Advert

Advert