Category: Koha

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

13/02/2021

How to Install Koha on Ubuntu 20.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 Add Koha Community Repository & Trusted Repository Key sudo echo deb http://debian.koha-community.org/koha […]

28/08/2020

Koha OPAC Customization | How to Change OPAC Header in Koha 20.05

Koha OPAC Customization is very simple process in latest version of Koha. Koha OPAC has many sections i.e. Header, Left Navigation(Upper & Bottom), Main User Block, Right Navigation and Footer. We can easily customize these sections using HTML & CSS.(see below image) The above sections can be customized using Koha Administration->Global System Preferences->OPAC Preferences and Koha News Modules. Change Banner of Koha OPAC Header: 1. […]

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

04/08/2020

Enable SIP2 Server in Koha | How to Start SIP Server in Koha Software

You have to Enable SIP2 Server in Koha Software to integrate RFID System in your Library. Use following command to Enable SIP2 Server. Open Terminal and run below command to enable SIP2 Server sudo koha-enable-sip library (Here ‘library’ is instance name) Next, Start SIP2 Server sudo koha-start-sip library To Stop SIP2 Server, You can use below command sudo koha-stop-sip library OR Manual Start SIP2 Server […]

22/05/2020

How to Install Java, Tomcat, MySQL, phpMyAdmin on Ubuntu 20.04 in GCP/AWS Intance

Before you deploy any Web Application on your Ubuntu Server, You have to install Java , Tomcat Server, MySql Database, phpMyAdmin etc. First of all open Terminal on GCP Ubuntu Instance OR connect your AWS Ubuntu Instance in Putty Software through SSH. Login as root and update > sudo su > apt-get update Install JAVA (OpenJDK) Run below command to install OpenJDK 11 > sudo […]

06/02/2020

Koha Auto Increment Fix | How to fix Koha Auto Increment Problem

Follow these steps to apply the solution for the “library” instance for Koha Auto Increment Fix: sudo gedit /etc/mysql/my.cnf Locate the [mysqld] section and add: init-file=/var/lib/mysql/init-file_koha_fix.sql sudo gedit /var/lib/mysql/init-file_koha_fix.sql Copy following code and paste into “init-file_koha_fix.sql” file. USE koha_library;   SET @new_AI_borrowers = ( SELECT GREATEST( IFNULL( ( SELECT MAX(borrowernumber) FROM borrowers ), 0 ), IFNULL( ( SELECT MAX(borrowernumber) FROM deletedborrowers ), 0 ) ) + […]

30/01/2020

How to install Koha In Out Management System | Attendance Management System in Koha 20.05

How to Install Koha In Out Management System | Attendance Management System (Gate Register) in Koha Software “Koha In Out Management System” is designed in php framework which works along with koha software. This koha plugin is used to track user entry time and exit time in a particular location of library. It generates various types of reports as per requirement. You can install PHP […]

29/01/2020

Koha Data Migration in Koha Software | How to Convert Excel File into MARC Format (Part: #2)

Koha Data Migration Process: How to Convert Excel File into MARC for Data Migration in Koha 20.04/20.11/21.05 In this video, we will convert Excel Data into Marc Format for importing the Bibliographic Records of Books to Koha Software (Open Source Library Software). You can download Excel File Format from Above Download Button for MARC Conversion   Also Read: How to Customize MARC Framework in Koha […]

25/01/2020

Display Book Cover Images in Koha OPAC | Enable Book Cover Images in Koha OPAC

Enabling Amazon Indian Book Cover Images in Koha Koha can display book cover images in search results by fetching the images from Amazon, if you enable the OPACAmazonCoverImages preference in Koha. Furthermore, clicking on the image sends the user to the Amazon site for find more details about the book like author name and ISBN and so on. Follow the below steps to Display Book […]