Tag: koha 20.05

13/02/2021

How to Install Koha on Ubuntu 20.04 LTS | Install Koha on Ubuntu (with easy steps)

https://youtu.be/AvuRPQgApkY 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 20.4 LTS Open Terminal on your Ubuntu machine for Koha installation. Update Ubuntu 20.04 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 […]

27/08/2020

Koha Reports – Tested with Koha 20.05

Koha Reports: You can easily add customized reports in your Koha Software. Accession Register (Complete List of Books-Sorted by Barcode) SELECT CONCAT(‘<a href=”/cgi-bin/koha/catalogue/detail.pl?biblionumber=’, biblio.biblionumber,'”>’,biblio.biblionumber,'</a>’) 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 Report SELECT oo.dateaccessioned AS ‘Date’, oo.barcode AS ‘Acc. No./Barcode’, […]