For the 1st, a CSV/tab delimited file is viewable in any text editor or spreadsheet program. I really like using Libre Office (http://www.libreoffice.org) for that as it's pretty smart about dealing with CSV and Tab delimited files. You can use MS Excel if you File -> Open the file, but it's not quite as slick as LO. As for your 2nd question, I believe you have your parameter set up incorrectly. Try this:
SELECT sum(items.barcode),sum(biblio.title),sum(biblio.author),sum(biblio.datecreated), items.barcode,biblio.title,biblio.author,biblio.datecreated FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.itype=<<Item Type|itemtypes>> GROUP BY items.barcode,biblio.title,biblio.author,biblio.datecreated ORDER BY items.barcode asc,biblio.title asc,biblio.author asc,biblio.datecreated asc
You were missing an 's' on your itemtypes parameter declaration. :) Liz Rea NEKLS On Apr 25, 2011, at 1:37 PM, Caitlin McGurk wrote:
This is the SQL I'm trying to run and export in something other than .tab or .csv: SELECT borrowers.cardnumber,borrowers.surname,borrowers.firstname,borrowers.email, FROM borrowers WHERE borrowers.branchcode='H25C'
This is the SQL I'd like to run for cataloged books: SELECT sum(items.barcode),sum(biblio.title),sum(biblio.author),sum(biblio.datecreated), items.barcode,biblio.title,biblio.author,biblio.datecreated FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.itype=<<itype|itemtype>> GROUP BY items.barcode,biblio.title,biblio.author,biblio.datecreated ORDER BY items.barcode asc,biblio.title asc,biblio.author asc,biblio.datecreated asc
Regards, CM
On Mon, Apr 25, 2011 at 2:15 PM, Liz Rea <lrea@nekls.org> wrote:
On Apr 25, 2011, at 1:06 PM, Caitlin McGurk wrote:
When commanding a report to run, Koha asks me to "Enter parameters for report Cataloged Books:", with a bar below it that says "itype:" and has an empty scroll bar with no choices to pick from. When I click run, nothing happens. Anyone know what this means or how to fix it?
Also, is there a way to export reports in any format other than a .csv or .tab? Neither of these are viewable on my machine.
Thanks! Caitlin McGurk
-- Caitlin McGurk Librarian The Schulz Library The Center for Cartoon Studies McGurk@cartoonstudies.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Caitlin, Can you paste us the sql of the report you are trying to run?
Liz Rea NEKLS
-- Caitlin McGurk Librarian The Schulz Library The Center for Cartoon Studies McGurk@cartoonstudies.org