I don't think it is a trivial task to generate ISBD straight out of an SQL query. There are just too many conditions... In Koha 3.20 you can allow exporting from the OPAC on ISBD format (check the OpacExportOptions system preference). With that set, you can craft URL's that look like this: http://bmayor.biblio.unc.edu.ar/cgi-bin/koha/opac-export.pl?op=export&bib=4540&format=isbd to download a text file containing the ISBD card for the desired biblionumber (4540 in this case). Now you know this, you could write a script that retrieves a csv from a public report and extracts the biblionumbers in it, and downloads the desired ISBD files. Just my two cents. PS remember the ISBD format can be (re)defined using the ISBD system preference. 2015-07-16 17:06 GMT-03:00 Partha Mukhopadhyay <psm_vu@india.com>:

Dear All

I would like to generate Catalogue Report in Koha in ISBD format (not in tabular format) for around 2500 books. The report required to be sorted by Author (as first sort key), then by Title (second sort key). Is there any available SQL report staremenet to perfor this job? I searched Koha-Wiki report library but failed to retrieve anything close to my requirement. Any suggestions?

Regards

-- ----------------------------------------------------

Dr. Parthasarathi Mukhopadhyay

Associate Professor

Department of Library and Information Science

University of Kalyani (WB, India)

------------------------------------------

_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/

-- Tomás Cohen Arazi Prosecretaría de Informática Universidad Nacional de Córdoba ✆ +54 351 5353750 ext 13168 GPG: B76C 6E7C 2D80 551A C765 E225 0A27 2EA1 B2F3 C15F