Patron Attributes in KOHA

If we want to add some  additional fields like Blood Group, Admission Number etc. in patron's details, we can use patron attributes.In order to enable the use of custom fields you need to set the ExtendedPatronAttributes in system preference

Then Go to
Administration > Patrons & Circulation > Patron attribute types

Create a new patron attribute type there.
We can choose an attribute for a particular category of user. For example, the patron attribute namely Admission Number can be restricted to students only.

Bulk upload of patron attributes

When uploading the patron details in bulk, we have to use a specific format.

1. The Column name in CSV file shall be "patron_attributes"

2. A comma separated value for each patron attribute may be created.

 i.e if we are using blood group (code: BGR) and Admission number (code :ADNO) the data in the column should be "BGR: O+ve,ADNO:UG180004"

How to create an attribute file 

The first row of the csv file should be the name of fields to be uploaded. The fields like surname, cardnumber, categorycode and branchcode are mandatory. 

For preparing a file with patron attributes, we can use the "concatenate" option in the excel.

Add the patron attribute code in a column say BGR. column A2 is BGR and B2 is O+ve. select the column C2. type the following syntax in the formula bar

=CONCATENATE(A1,":",B2)

the result will be BGR:O+ve

similiarly we can use the concatenate command to combine different columns in excel and then save it as CSV file.

KOHA INSTALLATION ON UBUNTU 22.04

   $sudo apt-get update
   $sudo apt-get upgrade
   $sudo su
 

 1   sudo sh -c 'wget -qO - https://debian.koha-community.org/koha/gpg.asc | gpg --dearmor -o /usr/share/keyrings/koha-keyring.gpg'  

 

2  sudo sh -c 'echo "deb [signed-by=/usr/share/keyrings/koha-keyring.gpg] https://debian.koha-community.org/koha oldstable main" >> /etc/apt/sources.list.d/koha.list'

 

    3  sudo apt-get update
    4  sudo apt install koha-common
    5  sudo gedit /etc/koha/koha-sites.conf
    6  sudo apt install mariadb-server
 

   

sudo apt update

sudo apt install mariadb-server}

    7  sudo mysqladmin -u root password kohalib
    8  sudo a2enmod rewrite
    9  sudo a2enmod cgi
   10  sudo service apache2 restart
   11  sudo koha-create --create-db library
   12  sudo gedit /etc/apache2/ports.conf
   13  sudo service apache2 restart
   14  sudo a2dissite 000-default
   15  sudo a2enmod deflate
   16  sudo a2ensite library
   17  sudo service apache2 restart


open the web browser and type http://localhost:8000

koha web installer will appears and prompt for username and password

please change the username by editing koha-conf.xml file

sudo gedit /etc/koha/sites/library/koha-conf.xml

ubder config section find out the line password and change it

<config>
 <db_scheme>mysql</db_scheme>
 <database>koha_library</database>
 <hostname>localhost</hostname>
 <port>3306</port>
 <user>koha_library</user>
 <pass>kohalib</pass>

then change mysql privileges

sudo mysql -uroot -p  

[enter the MySQL Root password]

use mysql;
SET PASSWORD FOR 'koha_library'@'localhost' = PASSWORD('kohalib');
flush privileges;
quit;

restart apache2 and mysql 
sudo /etc/init.d/apache2 restart
sudo /etc/init.d/mysql restart 


Note: In case of perl dependencies missing reported use the following commands before installation of koha -common command

 

sudo apt-get install libmarc-record-perl
sudo apt-get install libxml-sax-perl
wget http://ftp.br.debian.org/debian/pool/main/libm/libmarc-charset-perl/libmarc-charset-perl_1.35-2_amd64.deb
wget http://ftp.br.debian.org/debian/pool/main/libm/libmarc-xml-perl/libmarc-xml-perl_1.0.3-1_all.deb
sudo dpkg -i libmarc-charset-perl_1.35-2_amd64.deb libmarc-xml-perl_1.0.3-1_all.deb
sudo apt-get install koha-common

FRAMEWORK FOR BOOKS

PLEASE USE THIS FRAMEWORK FOR BOOKS

MARCEDIT INSTALLATION ON UBUNTU

To use the marcedit in ubuntu, please follow the steps furnished below.

1. Download the marcedit from the following link
   https://marcedit.reeset.net/software/marcedit.bin.zip
2. Extract the downloaded file. (The extracted "marcedit" folder  may be copied to the home folder for convenience.)
3. Install mono frame work
    $sudo apt-get install mono-devel
    $sudo apt-get install mono-xsp4
 If you found the error "key is not found", please add the key as in the link below
https://www.mono-project.com/download/stable/

4. Open the terminal. change the directory to marcedit
     (eg:  cd marcedit/)
5. type "mono MarcEdit.exe" in terminal and the marcedit screen will appear
     (koha@ubuntu:~/marcedit$ mono MarcEdit.exe)
  

gLabel Barcode

This template can be used to print the barcode for normal use in the library. please change the library name. glabel for kcaet

KCAET LIBRARY-THESIS

Please click here to read the soft copy of theses of the KCAET Library. This site is under construction. please fill up the form to get the copy of the thesis which are not uploaded

phpmyadmin

Installation of phpmyadmin on Ubuntu 16.04LTS

phpMyAdmin is a free, open source web-based database management tool written using PHP programming language. It allows the database administrators to manage single or multiple database servers either from a local or remote system using a web browser. Using phpMyAdmin, we can create, delete, rename, edit databases, tables, fields, and also we can directly execute any SQL commands.

1. Open the terminal and type the following commands one by one

$sudo apt-get update
$sudo apt-get install phpmyadmin
      During the installation a box will appear to choose the web server that should be automatically configured to run phpmyadmin. Choose apache2 and click OK.

Again it will ask for the password for phpmyadmin. Enter the password and re-enter it again to confirm.

2. To get the phpmyadmin in web browser, please edit the following file.

$sudo gedit /etc/apache2/apache2.conf

Add the following line at the end

    Include /etc/phpmyadmin/apache.conf

3. Open the web browser and type

     http://localhost/phpmyadmin

Stock taking using excel

Stock taking in library is a time consuming process. Here is a simple way for carry out stock verification in the libraries where Koha ILMS is using.

1.  Run the Accession Register report in koha

   SQL Query for Accession Register report. Copy the following text and paste in the SQL report box in koha

 SELECT items.barcode,items.dateaccessioned,items.itemcallnumber,biblioitems.isbn,biblio.author,biblio.title,biblioitems.pages,biblioitems.publishercode,biblioitems.place,biblio.copyrightdate,items.price
FROM items
LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
ORDER BY items.barcode ASC

2. Download the report and save the file in excel compatible format. i.e  (.xlsx)

3. Copy the accession numbers taken during the stock verification in a different sheet of the same excel file of koha accession register report.

4. Rename the sheet2 of excel file as "sub" and sheet1 as "Main".

5. Go to sheet1 and insert a blank column just right to the column of  Accession number

6. Apply the following formula in second row of the column and drag the mouse to the end of the column

                         =VLOOKUP(A1,$sub.A:A,1,0) 

7. Now the blank column show appropriate missing numbers

Note: Make sure that the number in stored as 'numeric' in both koha report and value entered during stock verification 

MARKAZ CENTRAL LIBRARY CATALOGUE

PLEASE CLICK ON THE FOLLOWING LINK TO BROWSE MARKAZ CENTRAL LIBRARY KARANTHUR

1. OPAC CENTRAL LIBRARY

KOHA - Auto increment problem

To fix the Auto increment problem in koha use the following steps

1. Install phpmyadmin and remove the affected tables
(If there is an issue in loading of phpmyadmin after successful installation, use the following steps to change in Apache configuration)
    1. gedit /etc/apache2/apache2.conf
   2. Add the following to the bottom of the file:
    
    # phpMyAdmin Configuration
    Include /etc/phpmyadmin/apache.conf
  check using localhost/phpmyadmin  or yourip/phpmyadmin

2. Edit the my.cnf file
    sudo gedit /etc/mysql/my.cnf
find out the [mysqld] section or create new one and add the following line

           init-file=/var/lib/mysql/init-file_library.sql 

3. Create a file /var/lib/mysql/init-file_library.sql  ( Assuming that the "library" is the instance name or otherwise replace with library with your instance name)

$sudo gedit /var/lib/mysql/init-file_library.sql

4. Add the following text in the file

USE koha_library;
 
SET @new_AI_borrowers = ( SELECT GREATEST( IFNULL( ( SELECT MAX(borrowernumber) FROM borrowers ), 0 ), IFNULL( ( SELECT MAX(borrowernumber) FROM deletedborrowers ), 0 ) ) + 1 );
SET @sql = CONCAT( 'ALTER TABLE borrowers AUTO_INCREMENT = ', @new_AI_borrowers );
PREPARE st FROM @sql;
EXECUTE st;
 
SET @new_AI_biblio = ( SELECT GREATEST( IFNULL( ( SELECT MAX(biblionumber) FROM biblio ), 0 ), IFNULL( ( SELECT MAX(biblionumber) FROM deletedbiblio ), 0 ) ) + 1 );
SET @sql = CONCAT( 'ALTER TABLE biblio AUTO_INCREMENT = ', @new_AI_biblio );
PREPARE st FROM @sql;
EXECUTE st;
 
SET @new_AI_biblioitems = ( SELECT GREATEST( IFNULL( ( SELECT MAX(biblioitemnumber) FROM biblioitems ), 0 ), IFNULL( ( SELECT MAX(biblioitemnumber) FROM deletedbiblioitems ), 0 ) ) + 1 );
SET @sql = CONCAT( 'ALTER TABLE biblioitems AUTO_INCREMENT = ', @new_AI_biblioitems );
PREPARE st FROM @sql;
EXECUTE st;
 
SET @new_AI_items = ( SELECT GREATEST( IFNULL( ( SELECT MAX(itemnumber) FROM items ), 0 ), IFNULL( ( SELECT MAX(itemnumber) FROM deleteditems ), 0 ) ) + 1 );
SET @sql = CONCAT( 'ALTER TABLE items AUTO_INCREMENT = ', @new_AI_items );
PREPARE st FROM @sql;
EXECUTE st;
 
SET @new_AI_issues = ( SELECT GREATEST( IFNULL( ( SELECT MAX(issue_id) FROM issues ), 0 ), IFNULL( ( SELECT MAX(issue_id) FROM old_issues ), 0 ) ) + 1 );
SET @sql = CONCAT( 'ALTER TABLE issues AUTO_INCREMENT = ', @new_AI_issues );
PREPARE st FROM @sql;
EXECUTE st;
 
SET @new_AI_reserves = ( SELECT GREATEST( IFNULL( ( SELECT MAX(reserve_id) FROM reserves ), 0 ), IFNULL( ( SELECT MAX(reserve_id) FROM old_reserves ), 0 ) ) + 1 );
SET @sql = CONCAT( 'ALTER TABLE reserves AUTO_INCREMENT = ', @new_AI_reserves );
PREPARE st FROM @sql;
EXECUTE st;

5. Restart Mysql

$sudo service mysql restart 

SAMPLE HEADER FOR OPAC

The header for the OPAC. click to view

Style repository for referencing in word

Download the folder here. Open the folder and copy all the styles from the Directory.
Goto ---> mycomputer -----> Program Files/Microsoft Office/Office12/Bibliography/Style
copy all the .xsl files to style folder. now you can see newly added 24 styles in the Word styles.

Library OPAC KCAET Library

How to Create a simple OPAC using Awesome table