Share Koha usage statistics

Koha users can share the installation details with the Koha community. It helps the developers and other community members to get an idea of Koha installations in all regions. The facility is available at Koha Administration > Additional parameters > Share your usage statistics,

Enter the details of the library. The details sent to the website maintained by the Koha community, The global usage statistics of Koha available on the website.

Why accounts related old reports do not work with the latest version of Koha?

New changes in data structure regarding fines and fees available with the release of Koha version 19.11. Koha used
accounttype table to accommodate payment statuses. The table accounttype no more available with Koha version since 19.11. The reports used values in accounttype do not work with the recent version of Koha upgraded from the old one. 
The new two tables are available to accommodate income and expenses (Fines, fees, Refund etc) for libraries are credit_type_code and the debit_type_code. The codes in the two tables can be check at Administration > Accounting. Koha users need to use the codes in  credit_type_code and the debit_type_code tables to generate reports.

Following is a report which generates the overdue paid by patrons in a date range. I have highlighted where the credit_type_code to display payments made by patrons.

SELECT b.cardnumber AS 'Card Number',b.surname AS 'Name',FORMAT(ABS(a.amount), 2) AS 'Amount'
FROM borrowers b
JOIN accountlines a
WHERE b.borrowernumber = a.borrowernumber AND a.credit_type_code = 'payment' AND BETWEEN <<Between (YYYY-MM-dd)|date>> AND <<and (YYYY-MM-DD |date>> AND b.branchcode=<<Enter patrons library|branches>> AND categorycode LIKE <<Enter Category borrowers|categorycode>>

Make changes in the accounts reports created with Koha versions before 19.11. Otherwise, the reports with the old status codes will fail to work.


Favicon for Staff Client and OPAC

Favicon stands for Favorite Icon. It can display on the website tab. Favicon is a small icon and acts as a website identity. Koha users can display favicon on Staff Client and OPAC. The favicon file extension is .ico.

How it works
Prepare a favicon file with the extension .ico. Many ways we can convert an image to .ico. Either using image processing software like GIMP / Photoshop or using favicon online generators.

Copy to /usr/share/koha/opac/htdocs.
sudo cp fav.ico /usr/share/koha/opac/htdocs
Here is the URL of favicon copied to /usr/share/koha/opac/htdocs.

The favicon can be store in a remote server and give the URL.
Visit the search box at Administration > Global System Preferences 

Search for the term, favicon.
Give the URL of the favicon to each box and save.
Open Staff Client and OPAC. See the favicon on the browser tabs.

Display logo on Koha staff client login page

Displaying institution logo on Koha staff client is part of beautification. Even though library staff who log in the staff client sees the logo, everybody believes that it enhances the branding. 

A system preference, stafflogininstructions available for this purpose. This feature available since the release of Koha version 18.04. 

How it works

Copy the logo to htdocs

Prepare the logo image and put it in an internal folder or in an external server. You can place the image in the folder, /usr/share/koha/opac/htdocs to save in the Koha server. Apply the following command to copy the logo image from the home folder to htdocs.

sudo cp mgu-logo.jpg /usr/share/koha/opac/htdocs

Replace the file name (mgu-logo.jpg) match with the logo name with you.

Add image details in stafflogininstructions

Open Koha Staff Client, visit and find Administration > Global System Preference > Staff Interface > StaffLoginInstructions.

Otherwise, find the specific option by using the search feature in Administration > Global System Preferences. Put the term, StaffLoginInstructions in search box and find.

HTML tag to display logo

<center> <img src="" style="width:45%; height:45%;"> </center>

Change the IP ( match with yours. Save the settings. Sign out from Koha Staff Client and check the login page.

Inventory (Stocktaking)

Inventory feature assists the libraries in stock taking. After the inventory process over, the library gets a picture of missing books. Here are the steps to initiate stocktaking with Koha.

Prepare text file of barcodes
Prepare a text file of barcodes (accession number) either using barcode scanner visiting shelves. Otherwise, prepare the text file with barcodes manually. If you have collected the barcodes in other formats like a spreadsheet, copy it into the text file.

Google Input Tool: an alternative for Google Indic Transliteration in OPAC

Koha made use Google Indic Transliteration (Global System Preferences > OPAC > GoolgeIndicTransliteration) addon in OPAC with the search box. It was useful for search bibliographic details in regional languages. This service not available with Koha now. The reason is that the service seized by Google. But an alternative not added with Koha yet. Anyhow, libraries with bibliographical details in regional languages can make use of Google Input Tools extension with Chrome browser. Koha OPAC needs to load with Chrome browser to make avail this service.

Place a banner on OPAC header with Koha version since 20.05

Configuration of OPAC header has moved to Tools > News section since the release of Koha version 20.05. Earlier the configuration was at Administration > Global System Preferences > OPAC > opacheader. Follow the steps mentioned below to display a banner with Koha version 20.05.