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 <[email protected]>:
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
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
