A simple bit of code can be used to get the first valid 10-digit ISBN. This is the php code we use - it could be adapted to perl quite easily, though.... (Actually, if I recall correctly, there is a C4 function to get the Normalised ISBN...) // Normalise the ISBN $isbn = preg_replace('/(.*) \| (.*)/', '$1', $isbn); // Get first isbn $isbn = preg_replace('/(.*) (.*)/', '$1', $isbn); // Get rid of text if (strlen($isbn) == 11) { if ($debugging) { print "Chopping 11 digit ISBN to a 10 digit ISBN"; } $isbn = substr($isbn,1,10); } else if (strlen($isbn) == 13) { $isbn = substr($isbn,3,9); $checksum = 0; $weight = 10; $isbnCharArray = str_split($isbn); foreach($isbnCharArray as $char) { $checksum += $char * $weight; $weight--; } $checksum = 11-($checksum % 11); if ($checksum == 10) { $isbn += "X"; } else if ($checksum == 11) { $isbn += "0"; } else { $isbn .= $checksum; } } else if (strlen($isbn) != 10) { if ($debugging) { print "<p>Illegal ISBN Found: $isbn</p>"; } exit; } if ($debugging) { print "Normalised ISBN: $isbn"; exit; } - Nick On 03/07/2012 05:50 AM, Cab Vinton wrote:
Hi, All --
For the purposes of creating a web-based carousel of book covers of our recent acquisitions, I'd like to run a report that generates a list of ISBNs of items added between 2 dates.
Amazon& therefore Koha rely on 10-digit ISBNs for book cover retrieval.
However, when I run a report using biblioitems.isbn, this is the output I get. Many truncated ISBNs, presumably because the max length = 30 restriction.
9780425243244 (pbk.) | 0425243 9780307718099 | 0307718093 0804840288 | 9780804840286 (tr 9780811876377 : | 0811876373 : 1569244677 9781400064588 (acidfree paper) 9780061429255 | 0061429252 9781451661064 (hardcover) | 14
Is there a way to run a report that outputs only the 10 digit ISBNs?
Many thanks,
Cab Vinton, Director Sanbornton Public Library Sanbornton, NH _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/