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 > -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
