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
ifconfig


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

Enable barcode/accession number search in OPAC

Add following query in
Koha> Administration › System preferences › OPACUserJS

$("select[name='idx']").append("<option value='bc'>Accession No.</option>");

Save.
Refresh OPAC page and see the change.

Information courtesy:
L2C2 Technologies
http://blog.l2c2.co.in/index.php/2016/09/10/quick-tip-add-barcode-lookup-to-your-opacs-search-index-selection-downdown/

Import Quotes into Koha

1. Enable and beautify Quotes of the Day in Koha. 
Check following link;
http://kohageek.blogspot.in/2017/12/beautify-quote-of-day-in-opac.html

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.

Beautify Quote of the day in OPAC


1. Add CSS

Koha > Administration > Global System Preferences > OPAC > OPACUserCSS

Add following  CSS query.

#daily-quote {
background-color:#FFFFFF;
border:1px solid #000000;
border-radius:15px 15px 15px 15px;
margin:0 0px 0px;
text-align:center;
width:740px;
}

#daily-quote-text{
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
2. http://bywatersolutions.com/2013/02/28/qotd-in-koha-310/

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 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.

https://cdimage.debian.org/debian-cd/current/amd64/iso-cd/

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.