LIB Science Info

Install Ubuntu Cleaner on Ubuntu Ubuntu Cleaner is a useful graphical user interface tool for the Ubuntu Operating system that makes it easy to clean your system. Ubuntu Cleaner does free up hard disk space and enhances the performance of your system. Ubuntu cleaner helps you to remove the:- Clear browser cache Clear APT cache Clear thumbnail cache Remove unneeded packages Remove old kernels Remove old installers In this article, we know about the installation process of Ubuntu cleaner on the Ubuntu operating system. Installation Ubuntu cleaner  Open the terminal ( ctrl+shift+T ) and apply the following command  sudo apt update && sudo apt upgrade -y Install Software Properties sudo apt install software-properties-common Add PPA for Ubuntu cleaner package sudo add-apt-repository ppa:gerardpuig/ppa Refresh/Update the System sudo apt-get update Install Ubuntu Cleaner sudo apt install ubuntu-cleaner Launch Ubuntu Cleaner from the Application Menu. You can see the various ...

   Manage Collection wise and Department wise Items using Authorized values in koha Koha allows you to manage the Items/Books through authorized value. Following are the steps to manage the library collection via authorized values. 1. Add Authorized Values for collection  Go to  Koha Administration ➤ Authorized Values  and click on   CCODE ccode Click the New authorized value and add the codes of the new collection one by one  e.g. Reference, Gifted books, Textbooks, fiction, Non-fiction, Audio Visual, etc. 2. Add Authorized Values for Department Go to  Koha  Administration ➤ Authorized Values  and click on   LOC Location in koha Click the New authorized value and add the new Department codes one by one  e.g. Civil Engineering, Mechanical Engineering, Information Technology, Computer Science Engineering, etc. 3. Add collection and Department to record Add or edit the records and select the collection code and Department fr...

 Library Stock Verification (Inventory) Koha has a dedicated inventory tool to verify stock and keep your catalog up to date. Follow the below steps to take inventory in Koha.  Step-1 Prepare a List of Accession numbers (Barcodes) To prepare a list of barcodes, you need a portable scanner or laptop with the scanner. Take your barcode scanner to the shelving location and scan the barcodes into a text document e.g. Notepad, or Wordpad. You can prepare the list of barcodes manually also. Remember you have to prepare the barcode list in the text document only, if you have a list of barcodes in other formats then copy and paste it into the text document. You should have a list that looks like the below:- Step-2 Login to Koha staff client and navigate the Inventory Tool Koha Tools ➤ Inventory  Upload your file by using the ' Choose file ' button under the ‘ Use a barcode file ’ tab. Alternatively, you can directly scan the barcodes one by one using the portable scanner into the...

   Generate Auto Receipt Number in Koha Sometimes we need to add a unique receipt number (credit number) to each payment for audit purposes or any other reason. Koha allows you to generate credit numbers automatically. let's know How to enable automatically generate credit numbers to patrons' payment receipts Change some settings in Account credit types Go to  Koha Administration ➤ Accounting ➤ Credit types Click on the edit button of " Payment " 1. Tick check the box to enable credit ( Receipt ) number options  2.  Save  the credit type. Go to  Koha Administration ➤ Global system preferences ➤ AutoCreditNumber There are the following values in the drop-down list 1. Do not automatically generate  credit numbers 2. Automatically generate credit numbers in the form  <year>-0001 3. Automatically generate credit numbers in the form  <branchcode>yyyymm0001 4. Automatically generate credit numbers in forms  1, 2, 3 You can cho...

How to Attach files to bibliographic records To Attach the files in the MARK framework, you need to add the 'upload.pl' plugin to a MARC framework in which you want to upload the files. You can add this plugin to the specific framework or all of your frameworks. Koha Administration ➤ MARC Bibliographic Framework ➤ Books (Select your desired framework) ➤ Actions ➤MARC Structure ➤ Search for Tag 856$u In Other Option section select the " Upload.pl " option from the dropdown list in the Plugin and click on save changes. (In Cataloging) Now you will see the Upload icon right side of the 856$u subfield of the bibliographic record while cataloging or editing the record from the cataloging module. Click on the upload icon on the 856$u field to upload the file. Browse the file and upload and Click on the Choose button  to connect the file to your MARC record and save the record Now you see the link for online access on the Koha OPAC as well as on the Koha staff interface. ...

 How to delete library data in koha using the command line Sometimes you need to empty the all data (e.g. bibliographic, borrowers, and transaction details)  from your Koha LMS without losing the configuration settings and authorized values, e.g. libraries, item types, patron categories, locations, etc. Let us know how to delete data from the Koha instance/library. Delete Koha's bibliographic data NB: I would recommend taking a backup of the database before applying the following commands. Login as a root user sudo su Log into MySQL database mysql -uroot -p Enter MySQL root password use koha_library; Disable foreign key constraints when you truncate the tables SET FOREIGN_KEY_CHECKS=0; Delete all bibliographic details TRUNCATE items;  TRUNCATE biblioitems;  TRUNCATE biblio;  TRUNCATE deletedbiblioitems; TRUNCATE deletedbiblio;  TRUNCATE biblio_metadata; Delete all transactions  TRUNCATE old_issues;  TRUNCATE issues;  Delete borrowers details ...

Koha SQL Reports 1. Fine-wise Patron list & Item Information SELECT b.surname, b.firstname, b.email, bib.title, i.barcode, a.amountoutstanding, ni.issuedate, ni.date_due, IF ( ni.returndate IS NULL , " ", ni.returndate ) AS returndate FROM accountlines a LEFT JOIN borrowers b ON ( b.borrowernumber = a.borrowernumber ) LEFT JOIN items i ON ( a.itemnumber = i.itemnumber ) LEFT JOIN biblio bib ON ( i.biblionumber = bib.biblionumber ) LEFT JOIN ( SELECT * FROM issues UNION SELECT * FROM old_issues ) ni ON ( ni.itemnumber = i.itemnumber AND ni.borrowernumber = a.borrowernumber ) WHERE a.amountoutstanding > 0 GROUP BY a.description ORDER BY b.surname, b.firstname, ni.timestamp DESC SELECT b.surname, b.firstname, b.email, bib.title, i.barcode, a.amountoutstanding, ni.issuedate, ni.date_due, IF ( ni.returndate IS NULL , " ", ni.returndate ) AS returndate FROM accountlines a LEFT JOIN borrowers b ON ( b.borrowernumber = a.borrowernumber ) LEFT JOIN items i ON ( a.item...

 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 ...

 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...

 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 Charac...

   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  Sele...

 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 ...

 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 H...

 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 t...