Data migration: bulk check-in

Bulk check-in using .koc (Koha Offline Circulation) file is easy to use the method. It is helpful while Koha trial runs for data migration from the old version of Koha or other software. This method also can apply to other contexts. The following steps discuss how to prepare the .koc file for bulk import of check-in entries.

Data migration: importing of check-out entries from an old version of Koha

Restoration of an old version of a corrupted database to the latest version of Koha is a challenging task. Data migration from a running instance of an old version of Koha is comparatively easy. Porting of bibliographic records to MARC format, patron details and circulation details to CSV is possible. Then it can be imported into a new version of Koha.

This tutorial discusses the various stages in exporting of check-out (issue) details from the old version of Koha into latest version.

Accession Register report

Koha version: 19.05.3
Module: Catalogue
Purpose: Accession register with joined Title and subtitle, Authors and Editors
SELECT items.barcode,items.itemcallnumber,
CONCAT_WS('',,'; ',ExtractValue(metadata,'//datafield[@tag="700"]/subfield[@code="a"]')) AS Author,CONCAT(biblio.title,' ',ExtractValue(metadata,'//datafield[@tag="245"]/subfield[@code="b"]')) AS Title,biblioitems.publishercode
FROM items
LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
LEFT JOIN biblio_metadata on (biblio_metadata.biblionumber=biblio.biblionumber)
WHERE items.homebranch =<<Branch|branches>> AND items.itype=<<Item type|itemtypes>> AND items.dateaccessioned BETWEEN <<Between Date (yyyy-mm-dd)|date>> and <<and (yyyy-mm-dd)|date>> ORDER BY items.barcode DESC

Hardware selection for Koha installation

Library professionals need to acquire background knowledge on hardware selection before the installation/upgrade Koha ILS. Consider budget, the number of records and number of users handles by Koha before the hardware selection. Here are the various occasions and suitable hardware requirements.

Desktop PC: Majority of libraries in India install Koha on desktop PC. Library professionals switch off PC before closing the library and next day they switch on PC to use Koha. Libraries having budget constraints, lack of higher hardware resources and power backup would like to follow this method regardless of the number of records and transactions with Koha. Such libraries can't offer 24x7 OPAC services with Koha on a desktop PC.

Libraries with a small collection (e.g. up to 25000 books) consider a desktop with i5 processor and minimum 8 GB RAM. Buy desktop PC without preloaded Windows. It increases the cost of the PC. Buy PC without Operating System. Use Debian/Ubuntu with a lightweight desktop for the optimum performance of hardware. Ubuntu/Debian with GNOME desktop would eat a sizeable processing power of your PC. Choose Debian Linux with XFCE desktop/Xubuntu/Lubuntu as the operating system for Koha. Opt SSD (Solid State Drives) over traditional HDD as storage for fast performance. Desktop PCs not built for 24x7 performance like a server-class computer. 

Workstation PC: Libraries want heavy-duty performance machines can opt workstation PC. Workstation PC is better than desktop PC in terms of performance and durability. It can handle the library tasks with a large number of records, users, transactions and multiple library branches. Popular computer manufacturers produce workstation PC under separate brand names. For example, Dell Precision, Lenovo Thinkstation, and HP Z belong to the workstation category. 

Server computer: Libraries with excellent IT infrastructure would like to choose a server-class computer for Koha installation. Server computer built for 24x7 hours continuous working and offer static Koha service. I found that libraries with a small collection buy heavy-duty server computer and switch off at the evening when the office time over. This practice affects the performance and reduces the life span of the server computer.

Server class computers available with various specifications. Libraries with small size collections can choose entry-level servers computers for Koha installation. For example, HP Proliant ML series tower server computers cost below Rs. 80000.

Cloud computing: Cloud computing services became more convenient for these days. Libraries free from maintaining hardware for Koha service. Institutions can hire virtual servers from cloud service providers like Amazon, Google, and Microsoft. Libraries can choose virtual servers with a Linux (Debian/Ubuntu) operating system for Koha installation.

Install MariaDB 10.4 on Debian 9 (Stretch)

Image courtesy:
Debian 9 (Stretch) software repository contains MariaDB 10.1. Version 10.1 is a little bit old. It's possible to install the latest version of MariaDB (version 10.3 or 10.4) on Debian 9 to get good database performance. Latest versions of MariaDB free from the auto-increment bug. This version is free from Here is the method to install MariaDB 10.4 on Debian 9 when preparing system for Koha installation. This method can apply for a fresh installation of Koha. Don't try this method to install MariaDB on an existing installation of Koha.

Install dirmngr

sudo apt-get install software-properties-common dirmngr

Importing the MariaDB GPG Public Key and install MariaDB
Apply following commands,

sudo apt-key adv --recv-keys --keyserver hkp:// 0xF1656F24C74CD1D8

sudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] stretch main'

sudo apt update

sudo apt-get install mariadb-server

Assign Root password for MySQL
If password asks during the installation process, enter the password in the window. Apply following command, if the password window did not appear during the installation,

sudo mysqladmin -u root password newpass

[Replace 'newpass' with your own new MySQL Root password]


Display barcode on OPAC Normal view

I tried this feature on Koha version 18.11.x.

Goto Koha > Administration > Additional Parameters > Configure columns > OPAC > Item_barcode

Uncheck it and Save. 

Information courtesy: Richard Vargas

Show nothing when cover images are not found

"No cover image available" plate on OPAC result reduce the beauty of OPAC interface. We can hide it using JQuery.

Goto Administration › System preferences Search OPACUserJS
Copy and paste the following script into the box.



See the result.