Create a script for daily automatic DSpace backup of Database & Repository using Dspace Backup Commands in Terminal. Here is how you take the backup of your Dspace Server. In this process we will create dspace backup file for below 3 things: 1. PostgreSQL Database. 2. Dspace File System (dspace/assetstore directory). 3. Dspace Log Files. (dspace/log directory). To setup Automatic Daily Dspace […]
You can easily install Koha on Ubuntu Operating system using below process. In this process we will install latest stable version of Koha on Ubuntu. Open Terminal in your Ubuntu machine for Koha Installation. Update Ubuntu OS using below commands: sudo su apt-get update apt-get upgrade Install Leafpad Text Editor apt-get install leafpad Add Koha Community Repository & Trusted Repository Key sudo echo deb http://debian.koha-community.org/koha […]
Install Anydesk on Ubuntu Run the following commands as root user: sudo su Enter login password when prompt. sudo apt-get update && sudo apt-get upgrade wget -qO – https://keys.anydesk.com/repos/DEB-GPG-KEY | apt-key add – echo “deb http://deb.anydesk.com/ all main” > /etc/apt/sources.list.d/anydesk-stable.list sudo apt update sudo apt install anydesk That’s it, Anydesk is ready to use. Uninstall Anydesk on Ubuntu sudo apt-get purge anydesk Install TeamViewer 0n Ubuntu Run […]
Koha Reports: You can easily add customized SQL reports in Koha Report Module. Accession Register – Sorted by Barcode SELECT CONCAT(”,biblio.biblionumber,”) AS biblionumbers, items.barcode, 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 LPAD (items.barcode,40,’ ‘) ASC Detailed Accession Register SELECT oo.dateaccessioned AS ‘Date’, oo.barcode AS ‘Acc. No./Barcode’, ooo.title AS ‘Title’, ooo.author […]
Before you deploy any Web Application on your Ubuntu Server, You have to install Java , Tomcat Server, MySql Database, phpMyAdmin etc. First of all open Terminal on GCP Ubuntu Instance OR connect your AWS Ubuntu Instance in Putty Software through SSH. Login as root and update > sudo su > apt-get update Install JAVA (OpenJDK) Run below command to install OpenJDK 11 > sudo […]
Follow these steps to apply the solution for the “library” instance for Koha Auto Increment Fix: sudo gedit /etc/mysql/my.cnf Locate the [mysqld] section and add: init-file=/var/lib/mysql/init-file_koha_fix.sql sudo gedit /var/lib/mysql/init-file_koha_fix.sql Copy following code and paste into “init-file_koha_fix.sql” file. USE koha_library; SET @new_AI_borrowers = ( SELECT GREATEST( IFNULL( ( SELECT MAX(borrowernumber) FROM borrowers ), 0 ), IFNULL( ( SELECT MAX(borrowernumber) FROM deletedborrowers ), 0 ) ) + […]
Koha Data Migration Process: How to Convert Excel File into MARC for Data Migration in Koha 20.04/20.11/21.05 In this video, we will convert Excel Data into Marc Format for importing the Bibliographic Records of Books to Koha Software (Open Source Library Software). You can download Excel File Format from Above Download Button for MARC Conversion  Also Read: How to Customize MARC Framework in Koha […]
Open Terminal and get ready for installation Update Ubuntu sudo su apt-get update apt-get upgrade Install Leafpad text editor apt-get install leafpad Add Koha community repository echo deb http://debian.koha-community.org/koha oldstable main | sudo tee /etc/apt/sources.list.d/koha.list wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key add – Update the software repository sudo apt update Install Koha sudo apt install koha-common Server Configuration In this step, need to edit network […]
Create Shell Script for Daily Koha Backup To setup Automatic Daily Koha Backup, Follow the below Commands. First of all, Login to root user and create directory for backup. sudo su Enter Login password when prompted. Next, Create Koha Backup directory mkdir koha_backup Allow write permission to this folder sudo chmod 777 koha_backup (Now, Exit from root directory) Create a backup file. sudo gedit koha_backup/backup.sh Copy below text into […]
Koha Data Migration is very time consuming process, So you can import you Bibliographic Data into Koha Software by using Terminal Commands In the process of Koha Data Migration, You can import .mrc file into koha directly using Terminal commands. Follow the steps below and run commands one by one carefully: sudo su export PERL5LIB=”/usr/share/koha/lib” export KOHA_CONF=”/etc/koha/sites/library/koha-conf.xml” Next, Move your .mrc file into folder where […]