ISBN-x to ISBN-13 conversion / sort

[PvanG]

As a collector of epubs, 21.5k books now, and fixing all entries to todays standards e.g as correct as possible meta-data.
I am looking for a plugin that converts a selected ISBN to ISBN13 or a plugin that allows to sort/select all none-ISBN13.
Is there any work in progress that would help in that or does anyone now the trick to sort?
Conversion tools are available outside Calibre as
here: https://www.boek.nl/content/nurcode

[chaley]

To search for any isbn that isn't an ISBN-13 (isn't 13 characters long), put this in the search bar. It is a regular expression search that matches any 13-long ISBN, then negates the match. See the calibre manual for search expression syntax.

not identifiers:isbn:~^.{13}$

This python template converts ISBN-10 values to ISBN-13, or at least it does for the few tests I ran. You can use it in the Action Chains plugin using a Single Field Edit to convert the value for specific books. Ask in that thread if you need help.

python:
def evaluate(book, context):
	isbn = book.get('identifiers').get('isbn', '')
	isbn = isbn.strip('-')
	if len(isbn) == 10: # poor man's isbn-10 validation.
		isbn = '978' + isbn[:-1]
		chk = sum(int(c) for c in isbn[0::2]) + sum(int(c)*3 for c in isbn[1::2])
		isbn += str((10 - (chk % 10)) % 10)
	return isbn

[theducks]

Not exact what you asked for. Maybe you can run with this in the mean time.

This search finds ISBN13

identifiers:"=isbn:97"

this finds ISBN13 because ISBN13 start with 97

While some books had ISBN10 and ISBN13, not all did and many ISBN10 are different editions, so what does conversion to a nonresistant number get you?


I will bite: Why sort? AFAIK nobody 'shelves' books by ISBN, so the sort has no obvious use.
ISBN was created to aid a bookseller in ordering. They are basically just a serialized order number by Publisher. language-publisher-sequence-check digit (mod10)

[chaley]

Originally Posted by theducks

This search finds ISBN13

identifiers:"=isbn:97"

this finds ISBN13 because ISBN13 start with 97

That search finds any isbn containing 97, not starting with 97.

This search fixes it:

identifiers:isbn:~^97

[theducks]

Originally Posted by chaley

That search finds any isbn containing 97, not starting with 97.

This search fixes it:

identifiers:isbn:~^97

oops
I pasted the wrong search

[PvanG]

Great! Part-1 did a lot for me already!! Returned 2680 out of 21.5K entries with a no-13 ISBN.

Reading the manual (RTFM) would do the job probably but would take me much more time!

Takes me to step 2 ;-)

[ownedbycats]

Originally Posted by chaley

To search for any isbn that isn't an ISBN-13 (isn't 13 characters long), put this in the search bar. It is a regular expression search that matches any 13-long ISBN, then negates the match. See the calibre manual for search expression syntax.

not identifiers:isbn:~^.{13}$

I had to use

identifiers:"=isbn:" AND not identifiers:isbn:~^.{13}$

otherwise I got a bunch of books with no ISBN at all

[chaley]

Originally Posted by ownedbycats

I had to use

identifiers:"=isbn:" AND not identifiers:isbn:~^.{13}$

otherwise I got a bunch of books with no ISBN at all

The OP asked for a search that returned anything that wasn't an ISBN-13, which includes empty ISBNs.

[DNSB]

For what little it is worth, I simply searched for any ISBN not starting with 978 (group: books). I didn't have any books in my library with the 4-6 digits being 978 though I did find 11 that did not have any ISBN in the metadata.

[ownedbycats]

979 ISBNs are becoming more common -- I have them on a few of my books, the earlest one from 2020.

[PvanG]

To all,
thanks for your input!
The: not identifiers:isbn:~^.{13}$
did the job for me, @chaley thanks for that!