Language Searching

 Inorder to enable regional language searching the following file need to be modofied.
 

sudo gedit /etc/koha/zebradb/etc/default.idx

comment the line "charmap word-phrase-utf.chr" ( Put # mark at the beginning of the line) 

add the following line after the commented line

"icuchain words-icu.xml "

Rebuild the Zebra index

sudo koha-rebuild-zebra -v -f library 

photo-Bulk import

1. Arrange your photos in a folder. Ensure that photo name must be card number of patrons.

2. Goto the following link and click on Download button.
https://docs.google.com/file/d/0B6E3iEzJp74uWWI4V3BwdUppdk0/edit?usp=sharing

3. Put idlink.py script in photo folder.

4. Open a terminal and enter inside photo folder and apply following commands,

chmod +x idlink.py
./idlink.py

5. After the process, you can see zip file, where all your photos compressed.

Goto Koha > Tools > Upload Patron Images

Upload the zip file.

 

Note:

 

1. In ubuntu 20.04 LTS an error will show

     i.e usr/bin/env pyhton3 

 

      to eliminate the error, use the following command in terminal

        sudo ln -s /usr/bin/python3 /usr/bin/python

 2. There is an error message in idlink.py script will show

an error in line 10 did you mean print (s)

Solution: open the idlink.py using text editor and change the line 10 as print (s) instead of print s

 

 Note : 2

If the folder is unable to upload. extract the created file and the copy all the contents to a new folder and zip this folder and then upload. Then it is possible to upload

 

e-mail facility in koha

Apply following commands one-by-one in the terminal
1. sudo su
2. apt-get update

3. apt-get install postfix

    ( press 'OK' when asks in package configuration and for general type of mail configuration "no configuration" then OK)

  

4.cp /usr/share/postfix/main.cf.debian /etc/postfix/main.cf

5.apt-get install libsasl2-2

6. apt-get install libsasl2-modules

7. apt-get install ca-certificates

8. gedit /etc/postfix/main.cf

pleasse add the following lines at the bottom of the file.

relayhost = [smtp.gmail.com]:587

smtp_sasl_auth_enable = yes

smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd

smtp_sasl_security_options = noanonymous

smtp_tls_CAfile = /etc/postfix/cacert.pem

smtp_use_tls = yes

 

 

 9. gedit /etc/postfix/sasl_passwd

[smtp.gmail.com]:587    urgmailid@gmail.com:yourpassword #replace with your gmail id and password

10.chmod 400 /etc/postfix/sasl_passwd

11. postmap /etc/postfix/sasl_passwd

12. postalias hash:/etc/aliases

13 cat /etc/ssl/certs/thawte_Primary_Root_CA.pem >> /etc/postfix/cacert.pem

14 /etc/init.d/postfix restart

15 koha-email-enable library

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)