Daniel, Tomas's suggestion is good, but I would like to propose to switch its SELECT for using ExtractValue(marcxml, '//datafield[@tag="020"]/subfield[@code="a"]') The reason is that the isbn column in the database contains concatenated ISBNs and the field length is limited, so the list of ISBNs could be truncated. The SELECT assume that you are using MARC21. In addition, you could also get invalid ISBN using the subfield z The final query would be : SELECT ExtractValue(marcxml, '//datafield[@tag="020"]/subfield[@code="a"]') as ISBN FROM biblioitems where ISBN <>"" Note that some lines may content more than 1 ISBN. Cheers, Eric Bégin Solutions inLibro inc. 7240, Waverly St. Montreal (Quebec) Canada 888 604-2627 | www.inLibro.com On 2016-04-18 15:57, Tomas Cohen Arazi wrote:
You should create a guided report for this. Do it at Reports > Create from SQL, and paste this into the SQL field:
SELECT title, author, isbn
FROM biblio
LEFT JOIN biblioitems
ON (biblio.biblionumber=biblioitems.biblionumber)
Choose an apropriate name for the report.
2016-04-18 16:39 GMT-03:00 Daniel Glendening <danieljglendening@gmail.com>:
Hi all,
Running into something that seems like it should be simple, but I'm running in circles trying to figure it out -- is there a simple (or not simple) way to export a document containing titles, authors, and isbn numbers?
In truth, all I really need are the isbns -- stocktaking and inventory exports don't seem to include isbn numbers as a field. I could make a "List" and export that as csv, but I want ALL the isbns in my library, in which case it seems like i'd have to add all titlesmanually to a list.
So, in short, my goal is: a document, preferably CSV, containing all isbns in my koha library of approx 3000 items.
Any tips?
Many thanks, Daniel
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha