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
-- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F