[Koha] Koha Export ISBN

[Eric Bégin]

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 at 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 at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>