Data migration (Unicode) from Excel to koha

1. Save As the Excel file, 'Unicode' format.

2. Download and install EditPlus software.

3. Open the file using EditPlus

4. Save the file format as utf-8.

5. Use MARCEdit 'Delimited Text translator'to convert to MARC format.
Information courtesy:
Koustubha Kale

Install the latest version of MariaDB with Koha

Image courtesy:
MariaDB is a community fork of MySQL. Latest versions of Koha support MariaDB. Current versions of Ubuntu and Debian repository provide the old version of MariaDB. Users can add the latest version of MariaDB by adding the software repository. The following method can install MariaDB 10.3 with an existing Koha installation on Ubuntu 16.04 LTS. MariaDB installation details can be found at

Installation of MariaDB
The process includes adding the MariaDB repository information to Ubuntu and install the database. Take a backup of the Koha database before the installation process.

Upgrade Ubuntu
Open a terminal and apply the following commands one by one;

sudo apt-get update 
sudo apt-get upgrade

Add MariaDB repository
Login as Root User.

sudo su

apt-get install curl software-properties-common dirmngr

curl -sS | sudo bash

Install MariaDB

apt-get install mariadb-server

Need to enter the Root password when the installation process ask. Give the same old MySQL root password.

After the installation try to Log into MariaDB,

sudo su
mysql -uroot -p

You will get following message,

ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded

Go to the following link and apply the solution mentioned in the forum to fix it,


Create Super Librarian by command line

Koha 18.05 released on June 2018. No more login with the database user with this version. The user not able to log in using the master username (koha_library) and password. Login Koha using master ID and password not advisable for housekeeping operations (e.g. cataloguing, circulation etc.). Many library professionals use the master login for day to day activities with Koha and end in trouble.

I have received a lot of queries regarding not able to login to Koha using master ID and password. They forgot the staff patron login credentials. Koha already has given a provision to create Super User ID and Password by command.

The syntax of the command --userid <userid> --password <password> --branchcode <branchcode> --categorycode <categorycode> --cardnumber <cardnumber>

       -?|--help        brief help message
       --userid         specify the userid to be set
       --password       specify the password to be set
       --branchcode     specify the library code
       --categorycode   specify the patron category code
       --cardnumber     specify the cardnumber to be set

Apply following commands to create the Super User.

Enter inside the Super User script folder
cd /usr/share/koha/bin/devel/

Super Librarian command
Here is an example of Super Librarian command,

./ --userid librarian --password librarian --branchcode MAIN --categorycode LIS --cardnumber 25

Here are the details of examples used in the command:
User ID- librarian
Password- librarian
Branchcode- MAIN
Patron category code- LIS

Image Courtesy: Open Clip Art Library

Enable Memcached with Koha

What is Memcached?
"Free & open source, high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applications by alleviating database load" (

Why we should use Memcached with Koha?
Memcached can boost the performance of Koha.

I have tried to enable Memcached with Koha versions 17.05.x to 18.05.x.

Check Memcached working with Koha

Open Koha > About Koha > Server Information

The red flag indicates that Memcached not working

Configure Firefox browser to view regional language properly

Koha can handle records in Indian regional languages well. We need to install Indic Fonts packages to display Indian languages. Even though Indic Fonts available, Firefox browser does not display the record details properly. Here is the solution to fix the regional language view problem in Koha server and client computers using Ubuntu Linux.

1. Install Indic Fonts package

sudo apt-get update
sudo apt-get install fonts-indic

2. Adjust Firefox Font settings

Firefox > Edit > Preferences

Search for "Content" through search box. Select Advanced option

Select Malayalam Language and set a font.

Search problem after massive upgrade

Many occassions I found following error message after upgrade from very old version of Koha to the latest version. 
Software error:
Can't call method "branchname" on an undefined value at /usr/share/koha/lib/C4/ line 1570.

The solution is that execute a full index of Zebra. Apply following command;

sudo su
koha-rebuild-zebra -f -a -b -v library

How to make available Koha in a network

Koha has web interface and can easily make available Staff Client and OPAC in the institutional / library network. Then library users can access OPAC from their seats. Library staff can use Staff Client from other client PCs. Make sure that the Koha installed computer inside a LAN (Local Area Network). Following things should try from Koha installed PC.

1. Identify IP and Netmask of the PC
Open a Terminal and apply following command.

sudo su

Note down the IP address and Netmask.
e.g. IP address-
       Netmask  -