Tag: Koha Software

09/09/2021

How to Customize MARC Framework in Koha Software| Download Customize Bibliographic Framework

Download Customized Bibliographic Framework Koha MARC Framework Customization:  Before we start cataloging in Koha Software, we need a customized MARC bibliographic framework. MARC Framework is a templates for creating new bibliographic records in Koha Software. Koha comes with some predefined marc frameworks and librarians can create their own frameworks for content specific to their libraries. Predefined frameworks has lots of fields and all these fields are […]

27/08/2020

Koha Reports – SQL Reports for Koha 20.05, 20.11 & 21.05

Koha Reports: You can easily add customized SQL reports in Koha Report Module. Accession Register – Sorted by Barcode SELECT CONCAT(”,biblio.biblionumber,”) AS biblionumbers, items.barcode, items.itemcallnumber, biblioitems.isbn, biblio.author, biblio.title, biblioitems.pages, biblioitems.publishercode, biblioitems.place, biblio.copyrightdate,items.price FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) ORDER BY LPAD (items.barcode,40,’ ‘) ASC Detailed Accession Register SELECT oo.dateaccessioned AS ‘Date’, oo.barcode AS ‘Acc. No./Barcode’, ooo.title AS ‘Title’, ooo.author […]