Import Quotes into Koha

1. Enable and beautify Quotes of the Day in Koha. 
Check following link;

2. Prepare quotes
Open a spread sheet (Applications > Office > Libre Office Writer). Put quotes in spreadsheet. Arrange author or source name in first column and the quote in second column.  Save as .csv format.
Quotes arranged in a .csv file.
3. Upload the quotes file
Koha > Tools > Edit quotes for QOTD feature > Import quotes

Upload the csv file.

Uploaded quotes.
4. Open Koha OPAC interface and check the quote.

Information courtesy
Subeesh Gopinathan

Beautify Quote of the day in OPAC

1. Add CSS

Koha > Administration > Global System Preferences > OPAC > OPACUserCSS

Add following  CSS query.

#daily-quote {
border:1px solid #000000;
border-radius:15px 15px 15px 15px;
margin:0 0px 0px;

color: black;

#daily-quote-source {
color: black;

Save it.

2. Enable Quote of the Day feature

Koha > Administration > Global System Preferences > OPAC > QuoteOfTheDay > Enable

3. Add some quotes

Koha > Tools > Edit quotes for QOTD feature

4. Open Koha OPAC interface and check the quote.

Information courtesy
1. Subeesh Gopinathan

Delete records in Koha

In certain occasions need to empty bibliographic, patron and transaction details from Koha database and clean the installation to start the process again. The user has to go to Koha database and empty the concerned tables.

Log into MySQL
Apply following commands to login to the MySQL database;

sudo su
mysql -uroot -p
use koha_library;

Delete all bibliographic details
Apply following commands one by one.


TRUNCATE items; 
TRUNCATE deleted_items;

TRUNCATE biblioitems; 
TRUNCATE biblio; 
TRUNCATE deletedbiblioitems; 
TRUNCATE deletedbiblio; 

Delete transactions (Issue, return)

TRUNCATE old_issues; 
TRUNCATE issues; 

Delete borrowers details

TRUNCATE borrowers; 
TRUNCATE deletedborrowers;


Delete circulation entries from databse tables

Certain records reluctant to Checkin due to DBMS auto increment problem. In such cases the transaction remain in the tables. Developers still working for the solution. Here is a temporary solution.
Record reluctant to checkin.

Install Koha on Debian 9 (Stretch)

Install Debian Linux

This Debian image comes with XFCE Desktop. Download Debian 64 bit from the following link and burn in a CD/DVD/Pen Drive. Insert the medium, change the boot option of the computer and start the installation process of Debian 9.

Download the debian-9.2.1-amd64-xfce-CD-1.iso file.

See the below video and familiar with the installation process of Debian 9.

Write down root password and user names in a diary or a piece of paper.

Enable Plack with Koha and improve the performance

Plack is a performance booster for Perl web applications. Plack can enhance the speed of Koha while various operations. Plack requires Apache 2.4.10+ and can enable with Koha installed in Debian 8 (Jessie) / Ubuntu 16.04 LTS. 

Apply following commands after the installation of Koha:

sudo su
sudo koha-plack --enable library
sudo koha-plack --start  library
sudo service apache2 restart

Note: Plack creates cache for speed. Make sure the PC has good amount of RAM, if you are going to enable Plack.


Send messages in queue immediately

Koha user can send messages in queue due to various reasons. Certain messages in Koha set to send in midnight. Often libraries running Koha on desktop machine shut down PC after working hours. In this situation, messages can't send. If you are also hurry to send messages generated at once, apply following commands:

1. Load environmental variables

sudo su
export PERL5LIB="/usr/share/koha/lib" 
export KOHA_CONF="/etc/koha/sites/library/koha-conf.xml"

2. Push messages in queue

cd /usr/share/koha/bin/cronjobs

Warning: When executing the, the library personnel should ensure that no one is trying to check in / out items.