Tag: Koha Software

13/02/2024

How to Install Latest Koha on Ubuntu 26.04 LTS | Install Koha on Ubuntu (with easy steps)

You can easily install Koha on Ubuntu Operating system using below process. In this process we will install latest stable version of Koha on Ubuntu. Open Terminal in your Ubuntu machine for Koha Installation. Update Ubuntu OS using below commands: sudo su apt-get update apt-get upgrade Install Leafpad Text Editor apt-get install leafpad Install MariaDB Server: We will use MariaDB server for Koha Database. Execute following […]

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 […]