Category: Koha

13/02/2021

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

https://youtu.be/AvuRPQgApkY 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 20.4 LTS Open Terminal on your Ubuntu machine for Koha installation. Update Ubuntu 20.04 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 […]

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 – Tested with Koha 20.05

Koha Reports: You can easily add customized reports in your Koha Software. Accession Register (Complete List of Books-Sorted by Barcode) SELECT CONCAT(‘<a href=”/cgi-bin/koha/catalogue/detail.pl?biblionumber=’, biblio.biblionumber,'”>’,biblio.biblionumber,'</a>’) 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 Report SELECT oo.dateaccessioned AS ‘Date’, oo.barcode AS ‘Acc. No./Barcode’, […]

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

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

04/12/2019

Install Koha Software on Ubuntu 16.04 & 18.04 LTS

Open Terminal and get ready for installation Update Ubuntu sudo su  apt-get update apt-get upgrade Install Leafpad text editor apt-get install leafpad Add Koha community repository echo deb http://debian.koha-community.org/koha oldstable main | sudo tee /etc/apt/sources.list.d/koha.list wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key add – Update the software repository sudo apt update Install Koha sudo apt install koha-common Server Configuration In this step, need to edit network […]