[Koha] Koha Export ISBN

[Tomas Cohen Arazi]

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
>



-- 
Tomás Cohen Arazi
Theke Solutions (http://theke.io)
✆ +54 9351 3513384
GPG: B2F3C15F