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.

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.

Configure Exim with Gmail to send notices from Koha

Exim is a Mail Transfer Agent suitable (MTA) with Linux operating systems. Koha user can install Exim to send email notices to library users. Exim can be used instead of Postfix.

An email from Koha.

Backup with time stamp and automatic deletion of old files

Scheduling Koha backup can save the time of the library staff. Know the backup date and time from the filename (e.g. koha_library-25-04-2017-20.08.sql.gz) is very convenient. Entry to delete old files remove backup files older than stated days (e.g. 5 days) and avoid the heap of files in the computer/cloud storage.

Cron is a utility available in Linux Operating system, which helpful to schedule various tasks (e.g. Backup Koha database in a particular time). User has to record the desired tasks in Crontab file with time to execute.

Data entry in regional languages using Google Chrome Input Tools extension

Google Input Tool is helpful to type various languages without any hassle. Google Input Tool now has Chrome browser extension. User can type regional languages without leaving Chrome browser. 

The Google Input Tools extension provides virtual keyboards for over 90 languages, full IMEs or direct transliteration for over 30 different scripts, and handwriting input for over 40 languages.