LIB Science Info

  Dspace 7.6 Installation We use Debian 11 (Bull Eye) Ubuntu 20.04 LTS and 22.04 LTS to install DSpace 7. Update the operating system. Apply the following commands one by one to receive new updates. It makes the system new. sudo apt update && sudo apt upgrade -y Create a DSpace user from the terminal after the installation. Here are the commands to create the  DSpace user; sudo useradd -m dspace sudo passwd dspace [enter a password for the new user dspace] Add dspace user to sudoers group sudo usermod -aG sudo dspace  Create the directory for the DSpace installation. sudo mkdir /dspace Change the dspace folder permission to the dspace user. sudo chown dspace /dspace Build the Installation Package Install packages to support the Dspace installation. sudo apt install wget curl git build-essential mousepad zip unzip -y Install Open JDK The JDK is a development environment for building applications, applets, and components using the Java programming language. JDK prepares an enviro

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 sections

   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 from (  952$C   Shelving location ) in the drop-down list that mat

 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 Barco

   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 choose any format except the default on

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 TRUNCATE borrowers;  TRUNCATE deletedbor

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