LIB Science Info

 How to subscribe to new arrivals alerts in Koha Koha users can set the new arrival alert using the RSS Feed subscription. Users must have an account with the RSS aggregator and need to add an RSS feed subscription to the RSS feeds. Once the search RSS feed is added to the RSS Feed Readers, patrons will start to get a notification when a new title is added to the catalog and will match your search. Copy the RSS feed of your search results Suppose your specialization is psychology and you would like to be notified when the library catalogs any book related to psychology subject. Open the Koha OPAC and search for the subject keyword of psychology in the catalog Do the Right Click on the orange RSS icon next to the number of results and copy the link address Add the RSS feed subscription link to the RSS Feed Readers You may find many online RSS feed readers/aggregators over the internet. You can use anyone. Here I have taken inoreader that offers a basic version free. The pro version is a

 How to reset the MySql root password The command line of this article is for the MySQL 8 or higher version. I have tested these commands on Ubuntu 20.04 LTS. Commands may work on other Ubuntu versions too. So, First, we need to check the version of your MySQL. Check the MySql version mysql --version Execute the following command to Stop the MySQL server (We need to stop the MySQL in order to change the password) sudo systemctl stop mysql.service You can apply the following command to check whether the MySQL server stopped or not sudo systemctl status mysql.service Enter ctrl+C to return to the command prompt Now start  MySQL server manually without permission networking checks and set “MYSQLD_OPTS” environment variable  sudo systemctl set-environment MYSQLD_OPTS="--skip-networking --skip-grant-tables" Start the MySQL service sudo systemctl start mysql.service You can apply the following command to check whether the MySQL server started or not sudo systemctl status mysql.ser

 Easy Way to Reset MYSQL Root Password for Linux User Stop the MySQL service, Run the following command for Ubuntu and Debian Users  sudo /etc/init.d/mysql stop For CentOS, Fedora, and Red Hat Enterprise Linux Users sudo /etc/init.d/mysqld stop Now Start MySQL without a password Run the following command sudo mysqld_safe --skip-grant-tables & Connect to MySQL mysql -uroot Set a new MySQL root password use mysql; update user set password=PASSWORD(" yournewpassword ") where User='root'; flush privileges; quit Run the following command to Stop and start the MySQL service For Ubuntu and Debian Users  sudo /etc/init.d/mysql stop sudo /etc/init.d/mysql start For CentOS, Fedora, and Red Hat Enterprise Linux Users sudo /etc/init.d/mysqld stop sudo /etc/init.d/mysqld start Refer:  https://www.librarianvijender.com/2022/12/easy-way-to-reset-mysql-root-password.html

 Enable bulk checkouts in Koha Login to your Koha Interface  Koha administration ➤ Global system preference ➤ Circulation ➤ Batch checkout ➤Allow You can select the patron categories under ' BatchCheckoutsValidCategories ' for which you want to enable bulk checkouts to enable Save all circulation preferences Now you will see the option for batch checkouts on the left side tabs of your koha checkout screen . You can scan/enter barcodes one by one into the barcode list area or upload the barcode file of the items that you want to check out to the patrons and click on the Check Out button. Refer:  https://www.librarianvijender.com/2022/10/how-to-enable-bulk-checkouts-in-koha.html

 Import bulk MARC Records Using the Command Line Easy steps to import bulk bibliographic records into the koha server through the terminal commands. 1. Put your .mrc file in the home folder and move it to the ''migration tools'' directory of your koha server where ''bulkmarcimport.pl'' is located  mv book.mrc /usr/share/koha/bin/migration_tools 2. Activate environmental variables  export PERL5LIB="/usr/share/koha/lib" export KOHA_CONF="/etc/koha/sites/library/koha-conf.xml" 3. Now Enter in the  ''migration_tools'' directory  cd /usr/share/koha/bin/migration_tools 4 (a).  Apply the following command to import in the particular MARC framework perl bulkmarcimport.pl -framework BK -file book.mrc 4 (b).  Apply the following command to import in the default MARC framework perl bulkmarcimport.pl -file book.mrc  4 (c). The following command will delete all existing records and import the new bulk MARC records perl bulkma

 Integrating Koha Search Interface Into Your Library Website 1. Select the portion of your library Website from the home page, where to display the Search Interface of  Koha OPAC 2. Copy and paste the following HTML code into a selected portion of your Library Website Home Page and then you will need to modify the Koha OPAC URL,  item codes, and name of the item as per your Koha system and save. <div style="background-color: #87CEEB; border-radius: 7px; border: 3px solid blue;"> <div><form id="searchform" action=" Your Koha OPAC URL/IP Address /cgi-bin/koha/opac-search.pl" method="get" name="searchform"> <table style="height: 50px; width: 600px;"> <tbody> <tr style="height: 50px;"> <td style="width: 90px; height: 50px;"><select id="masthead_search" name="idx"> <option value="kw">Keyword</option> <option value="

 How to convert fixed-length accession numbers in all books of Koha Warning : Before applying the following commands you must take a backup of the koha database for safety purposes.  1. Prefix  Zeros and make the length of the accession numbers six-digit  sudo su sudo mysql -uroot -p (Enter MySQL root password) use koha_library;      (" library " is a koha Instance Name)            UPDATE items SET barcode = lpad(barcode , 6 , '0' ); exit; This is how all accession numbers will be updated to six-digit length with ' '0 '' as leading 2. Remove all leading ''0'' from all accession numbers sudo mysql -uroot -p (Enter MySQL root password) use koha_library;                 UPDATE items SET barcode = trim(LEADING ' 0 ' FROM barcode); exit; This is how all leading '0' will be deleted from the accession numbers  3. Prefix specific characters to all accession numbers (e.g add Character '' GEN " to all accession numbe

   Upload files on Koha server Koha allows you to upload digital files e.g. PDF, text, image, video, etc. on the Koha server. All the uploaded files will be stored in the internal directory of Koha, and files can be retrieved from the staff interface as well as on OPAC.  Configuration First I recommend creating categories to upload the files. If you don't want to create more categories, even you can create only one that will contain all the files.  While uploading the new file you need to select the category otherwise your upload is marked as  temporary  and will be removed when your server restarts.  To start this process, you need to add new authorized values to the  "Upload". Create new Authorized values under the  UPLOAD  category Koha Tools ➤Authorized values 1. Search for  Upload 2. Click on the  Add  button Fill in the detail and Save Upload files Go to  Koha Tools ➤ Upload Browse and Choose the file  Select the file  category  (If you don’t choose a category, the

 Hide the 'No Cover Image Available' from Koha OPAC Sometimes koha could not retrieve the cover image for the displayed title of an item from the  AmazonCoverImages,  GoogleJackets, etc. due to several reasons. Then koha OPAC displays a "No cover image available" placeholder that really decreases the beauty of koha OPAC.  We can remove the  "No Cover Image Available" mark-up easily in two ways, using 'java scripts' and  'CSS codes'. You can apply any one of the following methods. No Cover Image Available in koha Using Java Script  Administration ⇒ System preferences ⇒ Search "OPACUserJS" Paste the following script into the box and save:- $(document).ready(function(){     $('.no-image').remove(); }); Using CSS code Administration ⇒ System preferences ⇒ Search "OPACUserCSS" Paste the following codes into the box and  Save:- .no-image { display: none; } Note :- If you enable multiple sources to show cover images e.g.

 Create a Library Patron Cum Institute ID Card in Koha  Size of Card Generally, we use the most popular Identity card size 86*54mm. This is the same size as an Aadhar card, PAN card, or Voter ID card. We will use the same but will keep the design vertically instead of horizontally 1st we need to design a header for the patron card. You can copy the image of the header from your institute's website. (Preferably remove the background of the image) Header Image for Front Side Remember Header’s width and length should be suitable for your ID card otherwise, it will not look good. If the header image of your institution’s website is not suitable (after resizing) for your identity card then it is recommended that you should design it yourself. Canva is a good website to provide the tools to design header images Now prepare the backside image for the ID card E.x: Instructions .  Patrons' card instructions (prepare Image) like This ID card is not transferable. In case of loss of this I

 Create Barcode Labels in Koha Here we will create the barcode which can be printed on the A4 size ordinary bond paper or A4 size sheet with 65 (5x13) self-adhesive labels. Create a Label Layout First, we need to create a layout for the barcode label. A layout is used to define the fields that you want to print on the label. To create the layout go to:- Koha Home➤ Tools➤Label creater➤New➤ Layout Enter the following details 1. Layout name :- Enter the Name (I have just entered MANC Final) 2. Choose Barcode type :- Code 39 (commonly used) 3. Choose Layout Type :- Bibliographic data proceeds barcode (Library Name on the top and barcode would be below) 4. Bibliographic data :- Here we want to print the library name above the barcode, So I choose order number 1 for the homebranch_description remaining fields left blank. 5. Text Justificatification :- Center 6. Font:-  Times-Roman (You can choose other fonts also) 7. Font Size :- 8 Now save the layout Create a Label Template Koha Home➤ Tool

 How to Add a Chat Feature on the Koha OPAC The chat widgets are a simple tool that allows visitors to interact with website managers via instant messaging services. It is a smart way to add real-time chat functionality to your Koha OPAC.  Patrons can type text into the box and that will appear instantly to the library staff. This feature would also provide a way for librarians to interact with patrons who need reference service through the Internet using a computer or mobile device. To add a chat Widget in Koha OPAC, we need to choose a chat tool. There are many Chat Widget tools available e.g. Olark, Mibew Messenger, Tawk.to , Chatra, Hubspot, ClickDesk, etc. In this tutorial, I am using  Tawk.to .(free without limitations). You can use anyone.  Step:1 Open the Tawk.to the website, Sign up, and create an account. Tawk.to  chat widget Step:2 Enter your Site Name (Library Name), Site  URL (Koha server IP), and Widget Name (e,g, How to Help) Step:3 Create the team members with the emai

 Upload Bulk Patron Images in Koha LMS All the Patron's images are organized in a folder. Keep the size of images below 100kb. And pixels should be the images 200x300 or below. There are many tools available freely to resize bulk images. With the help of the following website, you can resize the images. https://www.iloveimg.com/ Rename all patron's image files as their respective patron's card number (eg. 20101.jpg, 20102. jpg ) Open the notepad or any other text file. ( Only plain text file not RTF ) Enter all patron card numbers followed by a comma and then the name of the patron image file.  Don't forget to put the extension (e.g. jpg, png) with the image name. E.g, 20101,  20101.jpg 20102,  20102.jpg 20103,  20103.jpg 20104,  20104.jpg Now Save the file with the name " IDLINK.TXT " Keep all the patron images and IDLINK.TXT files in the same folder Convert the folder to the zip file Now Upload in Koha Open the Koha staff interface and login Home →Tools→ Upl

   Create Super Librarian by command line in koha LMS Sometimes Librarians forget the login credentials (User ID and Password) in the koha or the koha system has blocked the patrons account because of several unauthorized (wrong password) attempts to log in. In that case, we can create a new user account with the superuser/admin rights by the command lines. Lets us know how to create a new Super Librarian account. 1. Activate environmental variables sudo su export PERL5LIB="/usr/share/koha/lib"  export KOHA_CONF="/etc/koha/sites/library/koha-conf. xml" 2. Change the super librarian script directory  cd /usr/share/koha/bin/devel/ 3. Executive the following command to create a patron with the super librarian rights ./create_superlibrarian.pl --userid  Librarian  --password  Librarian@12 3 --branchcode  MAIN  --categorycode  STA  --cardnumber  2000 In the above command following details have been used. you can change the details accordingly  Patrons User ID-  Libraria

Drupal Installation on Ubuntu Prerequisites 1. Ubuntu 20.04 2. Root access or user with sudo privileges You can check whether you have the proper Ubuntu version installed on your server with the following command: lsb_release -a You should get this output: No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 20.04.3 LTS Release: 20.04 Codename: focal Then, run the following command to make sure that all installed packages on the server are updated to the latest available version sudo apt update && sudo apt upgrade 2. Install and Configure Web server Drupal 9 supports many webservers, like Apache, nginx, LiteSpeed, even Microsoft IIS . In this tutorial, we will show you how to install Drupal 9 using apache or nginx on your Ubuntu 20.04. Drupal will be installed in directory /var/www/html/drupal. For this purpose, we need to create the directory. sudo mkdir /var/www/html/drupal a. Apache If you want to use Apache , run this command to install it from the repos

Joomla installation in Ubuntu Prerequisites : Ubuntu 20.04 Administrative sudo user with root privileges Step 1: Connect to your Server Once logged in, make sure that your server is up-to-date by running the following commands: sudo apt-get update sudo apt-get upgrade Step 2: Install Apache web server and PHP Joomla requires a webserver to function. Apache is a fast and secure web server and one of the most popular and widely used web servers in the world. You can install it from the official Ubuntu repositories running the following command: sudo apt install apache2 After installing Apache, the commands below can be used to stop, start and enable Apache services to always start up every time your server starts up. sudo systemctl stop apache2.service sudo systemctl start apache2.service sudo systemctl enable apache2.service To verify that Apache is running, execute the following command: sudo systemctl status apache2 installation of joomla 4.0 on ubuntu 20.04 Since Joomla is built on P

 Install EPrints on Ubuntu (LTS Version is Recommended) Requisite Software for EPrints: i) A Linux server ii) Apache iii) MariaDB or MySQL iv) Perl V) EPrints Software Step1: Open the terminal by pressing ( Ctrl+Alt+T ) or go to Applications > Terminal and select it for executing the below command. Become a root user sudo su [Give your root password] Create a File nano /etc/apt/sources.list.d/eprints.list #Add the below line and save it [Press ctrl+x, then type y and press Enter key to save] deb http://deb.eprints-hosting.org/3.4/stable/ ./ Download the key repository wget -O - http://deb.eprints-hosting.org/keyFile | apt-key add - Update & Upgrade Ubuntu apt update; apt upgrade -y Not Required to install xpdf Install xpdf wget http://security.ubuntu.com/ubuntu/pool/main/p/poppler/libpoppler73_0.62.0-2ubuntu2.12_amd64.deb wget http://archive.ubuntu.com/ubuntu/pool/universe/x/xpdf/xpdf_3.04-7_amd64.deb dpkg -i libpoppler73_0.62.0-2ubuntu2.12_amd64.deb; apt install --fix-broken -

 Installation of VuFind on Ubuntu Software need to be installed through the command prompt: i) A Linux server ii) Apache iii) MariaDB or MySQL iv) PHP v) Java JDK vi) VuFind vii) Mousepad (Text-Editor) (Note the red mark lines are the command need to be executed on the terminal) Short Installation:  ( Details Installation  👈🏻 Click Here ) Step1: Open the terminal by pressing ( Ctrl+Alt+T ) or go to Applications > Accessories > Terminal and select it for executing the below command. Update Ubuntu This process will update the Linux operating system latest by downloading new packages. sudo apt update Install Mousepad text editor gedit is an open-source text editor, which requires opening configuration files while the installation process of VuFind. sudo apt-get install gedit Download VuFind wget https://github.com/vufind-org/vufind/releases/download/v8.1.1/vufind_8.1.1.deb Install the package sudo dpkg -i vufind_8.1.1.deb If you do not have all of VuFind’s dependencies installed a