My Blog List


MY All Articles

 

1.Importing Bulk Holidays in Koha's Calendar

Libraries can define library closings and holidays to be used when calculating due dates. You can make use of the Calendar by turning on the proper system preferences


Usually, we do create events/holidays manually in the calendar. As a Keralite, adding each holiday one by one may feel difficult every year. because, In Kerala state, we have several state holidays like Onam, Vishu, Mannan Jayanthi, etc. along with national holidays. So here is a solution that came into my mind with a question raised by Mr. Himanshu Aggarwal (Assistant Librarian at R. D. National College, Bandra) in the Koha Users group of Facebook. He was asking how can we import bulk holidays into koha. 


Yes, It is possible, The export and import option of any MySQL/MariaDB client software solves this problem. Koha already has a special_holidays table in the database that allows us to import custom holidays in bulk. 


Firstly, we need to prepare a CSV file containing branchcode, day, month,  year, title, description, etc. you can download a sample CSV file from below and modify it with your data. 


DOWNLOD SAMPLE FILE



2.How to Adding Autocomplete support to MARC21 Catalogue in koha | Book Data Entry page.

Step - 1

Go to : Koha administration/Global system preferences/Staff interface/IntranetUserJS

Below the Java script  enable of the auto completed in four columns for ISBN, Place of publication, Name of the Publisher, Edition

Copy and paste the bellow JS Coding.

//**Autocomplete support to MARC21 catalogue**//  
$(document).ready(function(){
 $( '[id^="tag_260_subfield_a"]' ).autocomplete({
    source: function(request, response) {
      $.ajax({
        url: "/cgi-bin/koha/cataloguing/ysearch.pl",
        dataType: "json",
        data: {
          term: request.term,
          table: "biblioitems",
          field: "place"
        },
        success: function(data) {
          response( $.map( data, function( item ) {
            return {
              label: item.fieldvalue,
              value: item.fieldvalue
            };
          }));
        }
      });
    },
    minLength: 1,
  });

 $( '[id^="tag_020_subfield_a"]' ).autocomplete({
    source: function(request, response) {
      $.ajax({
        url: "/cgi-bin/koha/cataloguing/ysearch.pl",
        dataType: "json",
        data: {
          term: request.term,
          table: "biblioitems",
          field: "ISBN"
        },
        success: function(data) {
          response( $.map( data, function( item ) {
            return {
              label: item.fieldvalue,
              value: item.fieldvalue
            };
          }));
        }
      });
    },
    minLength: 1,
  });
  
  $( '[id^="tag_260_subfield_b"]' ).autocomplete({
    source: function(request, response) {
      $.ajax({
        url: "/cgi-bin/koha/cataloguing/ysearch.pl",
        dataType: "json",
        data: {
          term: request.term,
          table: "biblioitems",
          field: "publishercode"
        },
        success: function(data) {
          response( $.map( data, function( item ) {
            return {
              label: item.fieldvalue,
              value: item.fieldvalue
            };
          }));
        }
      });
    },
    minLength: 1,
  });

 $( '[id^="tag_250_subfield_a"]' ).autocomplete({
    source: function(request, response) {
      $.ajax({
        url: "/cgi-bin/koha/cataloguing/ysearch.pl",
        dataType: "json",
        data: {
          term: request.term,
          table: "biblioitems",
          field: "Editionstatement"
        },
        success: function(data) {
          response( $.map( data, function( item ) {
            return {
              label: item.fieldvalue,
              value: item.fieldvalue
            };
          }));
        }
      });
    },
    minLength: 1,
  });
});

References:

 https://libpowertech.blogspot.com

3.How to Koha Backup Restoration (Restore)

Open Terminal on your Koha System and applying following command.
sudo apt update

1. Remove the existing database and Create the new database in the new Koha installation

Login to SQL  database user

sudo mysql -uroot -p

[Enter the your MySQL Root password]

Remove your default database for example koha_library

drop database koha_library;

Create the new existing database (Fro example koha_technosolutions)
create database koha_technosolutions;


2. Backup Restoration

  • Copy your database backup from your pen drive to koha home folder.
  • Extract the backup file, the extension will be .sql
  • Then restore the old backup to the new Koha installation.

Database Restoration commands,

sudo mysql -uroot -p koha_technosolutions < koha_library.sql

[Enter the your MySQL Root password]

koha_technosolutions - name of database in new installation
koha_library.sql - name of database in old installation


3. Upgrade Database Schema

Database schema of old Koha should upgrade to match with the new version. 

Apply following commands in a terminal one by one,

sudo service memcached restart
sudo koha-upgrade-schema technosolutions

[Your Database Name]


4. Rebuild the Zebra Index.

Apply following command in a terminal,

sudo koha-rebuild-zebra -v -f technosolutions

[Your Database Name]

References:

 https://libpowertech.blogspot.com

No comments:

Post a Comment