Hi Cab, If it's of any help, the 'carousel of book covers' system we use at library.pbc.wa.edu.au is available. Rather than generating a report, we chose to extract the data directly from SQL... A (slightly old - if you want the latest version I can get it when I'm back on site next week) version of our carousel-generating code is attached. (Also availabe in the newsgroup archives from 19 August 2011.) The changes that have been made since then are mostly cosmetic and to do with tidying the code... but I guess that's what important! If all you're looking for is the SQL, this is what we were using: SELECT items.biblionumber AS biblionumber, isbn, title, author, coverlocation FROM ((items JOIN biblio ON items.biblionumber = biblio.biblionumber) JOIN biblioitems on items.biblionumber=biblioitems.biblioitemnumber AND items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN bibliocovers on items.biblionumber = bibliocovers.biblionumber WHERE dateaccessioned > SUBDATE(SYSDATE(), INTERVAL 31 DAY) AND iType='BOOK' ORDER BY dateaccessioned DESC"; There's some extra stuff in there, because our cover system generates "fake" covers for books that don't actually have an image available. (As you'll notice on our library page). Hope this might be of at least *some* help! God bless, Nick
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/