<div class="dropdown"><button class=" btn btn-danger  btn-sm btn-block" p="" style="font-size: 16px;" type="button" id="dropdownMenuButton" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"><strong> 📚 Catalog Report&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </strong><b class="caret"></b></button>
<ol class="dropdown-menu" p="" style="font-size: 14px;">
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=1&amp;phase=Run%20this%20report">Accession Register</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=12&amp;phase=Run%20this%20report">Total Number of Books</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=33&amp;phase=Run%20this%20report">Department Wise Number of Books</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=34&amp;phase=Run%20this%20report">Collection Wise Number of Books</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=15&amp;phase=Run%20this%20report">Item Type Wise Number of Books</a></li>
</ol>
</div>
<div class="dropdown"><button class=" btn btn-danger btn-sm btn-block" p="" style="font-size: 16px;" type="button" id="dropdownMenuButton" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"><strong>💻Circulation Report &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </strong><b class="caret"></b></button>
<ol class="dropdown-menu" p="" style="font-size: 14px;">
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=13&amp;phase=Run%20this%20report">Check Out List of Books (Date wise)</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=7&amp;phase=Run%20this%20report">Check in List of Books (Date wise)</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=30&amp;phase=Run%20this%20report">Item Type Wise (Check Out Books)</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=24&amp;phase=Run%20this%20report">Circulation Daily Transaction</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=44&amp;phase=Run%20this%20report">Date wise Circulation Activity</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=20&amp;phase=Run%20this%20report">Month Wise Circulation Report</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=9&amp;phase=Run%20this%20report">Overdues Book List</a></li>
</ol>
</div>
<div class="dropdown"><button class=" btn btn-danger btn-sm btn-block" p="" style="font-size: 16px;" type="button" id="dropdownMenuButton" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"><strong>💰 Accounts Report &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </strong><b class="caret"></b></button>
<ol class="dropdown-menu" p="" style="font-size: 14px;">
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=5&amp;phase=Run%20this%20report">Paid Fine for Students</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=14&amp;phase=Run%20this%20report">Writeoff Fine for Students</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=16&amp;phase=Run%20this%20report">Accounting Type Wise Collection</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=17&amp;phase=Run%20this%20report">Students Fine Arrears Details</a></li>
</ol>
</div>
<div class="dropdown"><button class=" btn btn-danger btn-sm btn-block" p="" style="font-size: 16px;" type="button" id="dropdownMenuButton" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"><strong>👩&zwj;🎓 Library Membership Report &nbsp; &nbsp; </strong><b class="caret"></b></button>
<ol class="dropdown-menu" p="" style="font-size: 14px;">
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=11&amp;phase=Run%20this%20report">Membership Staff &amp; Students</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">More Library Reports</a></li>
</ol>
</div>
<div><br /><br /><br /><br /><br /><br /><br /><br /></div>

sudo zip -r log.zip /dspace/log

• Install latest Dspace. 
• Copy the assetstore, log folders, and database.backup to home folder of the system.
• Extract (unzip) the assetstore and log folders. 
• Follow the below steps to restore old Dspace backup.

sudo service tomcat stop

sudo rm -rf /dspace/assetstore

sudo rm -rf /dspace/log/

sudo mv /home/assetstore /dspace

sudo mv /home/log /dspace

sudo systemctl stop postgresql

sudo systemctl start postgresql

sudo -u postgres psql

DROP DATABASE dspace;

CREATE DATABASE dspace;

\quit

sudo su postgres

psql -f dspace.backup dspace

exit

Install pgcrypto postgres extension

sudo su postgres

psql --username=postgres dspace -c "CREATE EXTENSION pgcrypto;"

exit

sudo /dspace/bin/dspace database info

sudo /dspace/bin/dspace database migrate

(Index Created)

sudo /dspace/bin/dspace index-discovery -b

(All types of files configuration process, for E.g pdf, image, video, audio and etc.. this command long process)

sudo /dspace/bin/dspace filter-media

sudo /dspace/bin/dspace index-discovery

 (Index update)

sudo /dspace/bin/dspace index-discovery -o

sudo service tomcat start

Problem :

After installation using any method, When user run this URL (http://localhost/inout/login.php) users are getting blank page in Mozilla Firefox Browser, and Http 500 error in Google Chrome.

Solution:

The problem is with php. It works on php 5.6 so you have to switch php 7 to php 5.6

Execute the following command in terminal.

sudo su

[Enter Password]

sudo a2dismod php8.0

*In above command php8.0 is your active php version. it can be 8.1, 8.2 or 8.3 please make sure this version by entering command php -v.

sudo a2enmod php7.4

sudo service apache2 restart

Download In Out management: https://github.com/omkar2403/inout/releases

Old Inout Management Step by step Installation Notes Click here

Latest In Out management Installation Process.

INSTALLATION OF PHP 7.4

Open terminal and execute commands.

sudo apt-get update
sudo apt -y install software-properties-common
sudo add-apt-repository ppa:ondrej/php
sudo apt-get update

sudo apt -y install php7.4

php -v

Setup the OPAC folder: 

First download the package of the software which contains two mainly files and copy it into Home directory.

Now we have to copy the inout directory into OPAC htdocs directory. 

Open the terminal into Home directory and apply the following commands.

Setup the database:
Open the terminal and apply the following commands.

Information courtesy: Mr. Omkar Kakeru https://omkar2403.github.io/its_me/

sudo apt-get upgrade

Install Git.

sudo apt-get install git

Check git Version. 

git --version

Add git Key. 

sudo add-apt-repository ppa:git-core/ppa

Upgrade git version. 

sudo apt update; apt install git

sudo apt-get install openjdk-8-jdk

Install Maven. 

sudo apt-get install maven

sudo /dspace/bin/dspace create-administrator

It will ask to enter the email address for user login.

Enter Your email Id : dspace@localhost

first & last name : dspace

password & confirm password : dspace

Continue: Yes

Go to any browser copy and paste the link.

http://localhost:8080/jspui

sudo php - v PHP file location (Version Check) usr/share 

sudo a2dismod php7.4

In above command php7.4 is dis-active in php version. 

sudo a2enmod php8.1

In above command php8.1 is active in php version. 

Restart apache web server.

sudo systemctl restart apache2

Configure Apache web Server file php8.1 version

sudo mousepad /etc/apache2/conf-enabled/phpmyadmin.conf

Below contents to the file: verified your php version.

Alias /phpmyadmin /usr/share/phpmyadmin

<Directory /usr/share/phpmyadmin>
    Options SymLinksIfOwnerMatch
    DirectoryIndex index.php

    <IfModule mod_php8.c>
        <IfModule mod_mime.c>
            AddType application/x-httpd-php .php
        </IfModule>
        <FilesMatch ".+\.php$">
            SetHandler application/x-httpd-php
        </FilesMatch>

        php_value include_path .
        php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp
        php_admin_value open_basedir /usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext/:/usr/share/php/php-php-gettext/:/usr/share/javascript/:/usr/share/php/tcpdf/:/usr/share/doc/phpmyadmin/:/usr/share/php/phpseclib/
        php_admin_value mbstring.func_overload 0
    </IfModule>
    <IfModule mod_php.c>
        <IfModule mod_mime.c>
            AddType application/x-httpd-php .php
        </IfModule>
        <FilesMatch ".+\.php$">
            SetHandler application/x-httpd-php
        </FilesMatch>

        php_value include_path .
        php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp
        php_admin_value open_basedir /usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext/:/usr/share/php/php-php-gettext/:/usr/share/javascript/:/usr/share/php/tcpdf/:/usr/share/doc/phpmyadmin/:/usr/share/php/phpseclib/
        php_admin_value mbstring.func_overload 0
    </IfModule>

</Directory>

# Authorize for setup
<Directory /usr/share/phpmyadmin/setup>
    <IfModule mod_authz_core.c>
        <IfModule mod_authn_file.c>
            AuthType Basic
            AuthName "phpMyAdmin Setup"
            AuthUserFile /etc/phpmyadmin/htpasswd.setup
        </IfModule>
        Require valid-user
    </IfModule>
</Directory>

# Disallow web access to directories that don't need it
<Directory /usr/share/phpmyadmin/templates>
    Require all denied
</Directory>
<Directory /usr/share/phpmyadmin/libraries>
    Require all denied
</Directory>
<Directory /usr/share/phpmyadmin/setup/lib>
    Require all denied
</Directory>

Restart apache web server.

sudo systemctl restart apache2

sudo su

Use mysql;

update user set password=PASSWORD("mynewpassword") where User='root';

update user set plugin="mysql_native_password";

quit;

/etc/init.d/mysql stop

kill -9 $(pgrep mysql)

/etc/init.d/mysql start

mysql -u root -p

sudo mysql -uroot -p  

use mysql;

SET PASSWORD FOR 'koha_library'@'localhost' = PASSWORD('mamcet@66');

flush privileges;

quit;

sudo apt-get install mousepad 

sudo mousepad /etc/koha/sites/library/koha-conf.xml 

References:

[2] https://developer.mozilla.org/en-US/docs/AJAX/Getting_Started

[3] https://gist.github.com/l2c2technologies/7d0449dcb80c90880381ef4571003d1d

[4] http://catb.org/jargon/html/H/hack.html

[5] http://blog.l2c2.co.in/index.php/2017/01/15/adding-autocomplete-support-to-marc21-260-264-imprint-fields-in-koha/

MASTeR Library

•   Fast and easy to installation 1.16MB Android apk file.

•   Rotate your phone to view websites in landscape mode.

•   Single web page design and multiple links pages.

•   Links to mobile-friendly websites and resources.

sudo apt-get update

sudo mysql -uroot -p

create database koha_libpowertech;

quit;

2. Backup Restoration

• Copy your database backup from your pen drive to koha home folder.
• Extract the backup file, the extension will be .sql
• Then restore the old backup to the new Koha installation.

Database Restoration commands,

sudo mysql -uroot -p koha_libpowertech < koha_library.sql

3. Upgrade Database Schema

Database schema of old Koha should upgrade to match with the new version. 

Apply following commands in a terminal one by one,

sudo service memcached restart

sudo koha-upgrade-schema libpowertech

sudo koha-rebuild-zebra -v -f libpowertech

Book Data Convert to MARC Process

Go to: Tools > Stage MARC records for import

• You can enter a name for this import. It may be useful, when creating a record, to remember where the suggested MARC data comes from!

Go to : Reports > Create from SQL

How to Uninstall gLabels:

1.1. Change Banner of Koha OPAC Header:

sudo cp /home/koha/header.png /usr/share/koha/opac/htdocs

• Crete the New SQL Report
• Copy and Paste  following lines in the SQL report. Save and close.

SELECT items.Barcode,biblioitems.biblionumber,items.itemcallnumber AS 'Call Number',biblio.Author,biblio.Title AS Titles,biblioitems.size As 'Bill No', biblioitems.Pages, biblioitems.Editionstatement AS Edition,biblio.Copyrightdate AS Year,items.Price,biblioitems.illus AS 'OPAC Price',biblioitems.publishercode AS Publisher,biblioitems.Place AS 'Place of Publication',biblio.unititle AS Subject,items.ccode AS Collection,items.location AS 'Department Wise', items.itype AS 'Book Status / Item type',biblioitems.itemtype AS Department,biblioitems.url AS OnlineURL,items.Dateaccessioned,biblioitems.ISBN,biblio.notes As ' General Notes/Remarks',biblio.Serial,items.Issues,items.Renewals

FROM items 

LEFT JOIN biblioitems ON (items.biblioitemumber=biblioitems.biblioitemnumber)

LEFT JOIN biblio ON (biblioitems.biblionumber=biblnio.biblionumber)

ORDER BY LPAD(items.barcode,40,' ') ASC

Run Report

sudo su

apt-get update

apt-get upgrade

Install mousepad Text Editor

apt-get install mousepad

Add Koha repository

sudo apt install -y software-properties-common dirmngr file-roller 

echo 'deb http://debian.koha-community.org/koha oldstable main' | sudo tee /etc/apt/sources.list.d/koha.list

Update Software Repository

apt-get update

Install Koha Software

Port Configuration

Open following file to change port number.

sudo mousepad /etc/koha/koha-sites.conf

Install MariaDB Server.

Assign Root password for MariaDB

Koha instance creation

sudo a2enmod cgi

Create a Koha instance with the name library. (Your Library Short Name)

Run the following command to install “Locale::Language” perl module.

Restart Memcached service to open Koha web installer.

sudo service memcached restart

2.Check-out

.

3.Check-In

Go to: Tools > Notics & Slips / CHECKIN ( Click Edit)

Copy and Paste the following HTML Lines.

.

Dear <br>         <<borrowers.title>>. <<borrowers.surname>><br> The following items have been<b><font color="green"> Return:</b><br></font color> <table style="width: auto; height: 45px;" border="2" TABLE BORDERCOLOR="green"   cellspacing="2" cellpadding="1">   <tr>     <td><b>Lib No</td></b>     <td><<borrowers.cardnumber>></td>   </tr>   <tr>     <td><b>Name of the Member</td></b>     <td><<borrowers.surname>></td>   </tr>   <tr>     <td><b>Barcode / Acc No</td></b>     <td><<items.barcode>></td>      </tr>   <tr>     <td><b>Book Title</td></b>     <td><<biblio.title>></td>   </tr>  <tr>     <td><b>Author</td></b>     <td><<biblio.author>></td>   </tr>  <tr>     <td><b>Date of Return</td></b>     <td><<old_issues.returndate>></td>   </tr> </table> <b><p>Visit your account details. <a href="/cgi-bin/koha/opac-main.pl?logout.x=1" target="_blank">Click here<img src="https://4.bp.blogspot.com/-IwJHtzYqSKo/V6XBL0tZESI/AAAAAAAAAbg/rVqNyWSn2cY21ZezUGiKrrByUxAqjuXzQCPcB/w1200-h630-p-nu/look-here.gif" alt="Smiley face" width="50" height="42"></img></a></p></b> <p><b>User Name:</b> <<borrowers.userid>></p></b> <p><b>Password:</b> mamcet</p></b> <p><b>This is an Automatically Generated Email.</b>  Thank you for visiting <a href="/cgi-bin/koha/opac-main.pl?logout.x=1" target="_blank"> <<branches.branchname>>.</a></br>

4.Renewal

Go to: Tools > Notics & Slips / RENEWAL ( Click Edit)

Copy and Paste the following HTML Lines.

<br> Dear <br>      <<borrowers.title>>.   <<borrowers.surname>><br> The following items have been<b><font color="orange"> Renewal:</b><br></font color> <table style="width: auto; height: 45px;" border="2" TABLE BORDERCOLOR="#FF9900"   cellspacing="2" cellpadding="1">   <tr>     <td><b>Lib No</td></b>     <td><<borrowers.cardnumber>></td>   </tr>   <tr>     <td><b>Name of the Member</td></b>     <td><<borrowers.surname>></td>   </tr>   <tr>     <td><b>Barcode</td></b>     <td><<items.barcode>></td>      </tr>   <tr>     <td><b>Book Title</td></b>     <td><<biblio.title>></td>   </tr>  <tr>     <td><b>Author</td></b>     <td><<biblio.author>></td>   </tr>  <tr>     <td><b>Book Issue Date</td></b>     <td><<issues.issuedate>></td>   </tr>  <tr>   <td><b>Last Renewal Date</td></b>     <td><<issues.lastreneweddate>></td>   </tr>  <tr>     <td><b>Book Due Date</td></b>     <td><<issues.date_due>></td>   </tr>  <tr>    <td><b>No. of.  Renewals</td></b>     <td><<issues.renewals>></td> </table> <b><p>Your account  details <a href="/cgi-bin/koha/opac-main.pl?logout.x=1" target="_blank">Click here<img src="https://4.bp.blogspot.com/-IwJHtzYqSKo/V6XBL0tZESI/AAAAAAAAAbg/rVqNyWSn2cY21ZezUGiKrrByUxAqjuXzQCPcB/w1200-h630-p-nu/look-here.gif" alt="Click" width="50" height="42"></img></a></p></b> <p><b>User Name:</b> <<borrowers.userid>></p></b> <p><b>Password:</b> <<borrowers.password>></p></b><br> <p><b>This is an Automatically Generated Email.</b> <p>Thank you for visiting<p> <a href="/cgi-bin/koha/opac-main.pl?logout.x=1" target="_blank"> <font size="3"> <<branches.branchname>> </font></a></br>

4.Reminder Overdue, and Fine.

Go to: Tools > Notics & Slips / ODUE ( Click Edit)

Copy and Paste the following HTML Lines.

<p><font face="verdana"style="text-align:justify"font size="3"> Dear        <br>          <<borrowers.title>>. <<borrowers.firstname>> <<borrowers.surname>>, <p>       According to our current records, you have items that are overdue. Your library does not charge late fines, but please return or renew them at the branch below as soon as possible.</p> <p>      If you have registered a password with the library, and you have a renewal available, you may renew accessible to the PCs in the campus through LAN. <a href="/cgi-bin/koha/opac-main.pl?logout.x=1" target="_blank">OPAC</a> If an item becomes more than 15 & 30* days overdue, you will be unable to use your library card until the item is returned.</p> <p>The following item(s) is are currently overdue:<p> <item><br> <strong>Title:</strong> <<biblio.title>><br> <strong>Author:</strong> <<biblio.author>> <br> <strong>Barcode:</strong> <<items.barcode>> <br> <strong>Book Due Date:</strong> <<issues.date_due>><br> <strong>Fine amount: Rs:</strong><font color="red"> <<items.fine>><<accountlines.Amount>></font color></item><br> <b><p><font color="green">Visit your account details. <a href="/cgi-bin/koha/opac-main.pl?logout.x=1" target="_blank">Click here<img src="https://4.bp.blogspot.com/-IwJHtzYqSKo/V6XBL0tZESI/AAAAAAAAAbg/rVqNyWSn2cY21ZezUGiKrrByUxAqjuXzQCPcB/w1200-h630-p-nu/look-here.gif" alt="Smiley face" width="50" height="42"></img></a></p> <p>User Name: <<borrowers.userid>></p> <p>Password: mamcet</p></font color></b> <font face="verdana"style="text-align:justify"font size="3"> <p><b>This is an Automatically Generated Email.</b> <p> <p>Thank-you for your prompt attention to this matter.<p></p> <<branches.branchname>>  </font></p>

Open a terminal and apply the following commands one by one,

sudo apt-get update

sudo apt-get install postfix

2. Copy the configuration file.

sudo cp /usr/share/postfix/main.cf.debian /etc/postfix/main.cf

sudo apt-get install libsasl2-2
sudo apt-get install libsasl2-modules
sudo apt-get install ca-certificates

4. Open the following file and add few lines.

sudo leafpad /etc/postfix/main.cf

[smtp.gmail.com]:587    urgmailid@gmail.com:yourpassword

sudo cat /etc/ssl/certs/thawte_Primary_Root_CA.pem >> /etc/postfix/cacert.pem

For Ubuntu 20.04 LTS Users

sudo /etc/init.d/postfix restart

sudo koha-email-enable library

10. Check the following settings in Koha to send email notices,
Koha > Administration > Patron categories > Overdue notice required > Yes

sudo su

koha123

ubiquity

• Crete the New SQL Report
• Copy and Paste  following lines in the SQL report. Save and close.

Text box border style change from koha , for example the barcode field on the checkout, check-in , and etc..

1. Open a Terminal and apply following command. (Ctrl + Alt = T)

sudo su( Enter your Password)

1 2 3 4 5

input:focus, textarea:focus { border-color: #538200; border-radius: 4px; border-style: solid; }

Remove the default border style CSS code.

3. Copy and paste the following customized textbox style CSS code:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

input:focus { border-top: 5px solid #86B300; border-bottom: 5px solid #CCFF33; background-image: -webkit-gradient(linear, 0 0, 0 100%, from(#86B300), to(#CCFF33)); background-image: -webkit-linear-gradient(#86B300, #CCFF33); background-image: -moz-linear-gradient(#86B300, #CCFF33), -moz-linear-gradient(#86B300, #CCFF33); background-image: -o-linear-gradient(#86B300, #CCFF33), -o-linear-gradient(#86B300, #CCFF33); background-image: linear-gradient(#86B300, #CCFF33), linear-gradient(#86B300, #CCFF33); -moz-background-size:5px 100%; background-size:5px 100%; background-position:0 0, 100% 0; background-repeat:no-repeat; border-width: 5px 0; padding: 5px; }

4. Finally your koha text box has been changed successfully.

Information courtesy:

Athens County Public Libraries https://www.myacpl.org/

Koha :https://wiki.koha-community.org/wiki/Mana_central_database

Go : Home › Reports › Use saved › Accession Register

•  Note the Biblio Item Number from Accession register report.

•  Open CSV Document and Enter your Delete Books Biblio item numbers details.

Go : Home › Tools › Batch record deletion

•  Upload Your Delete books CSV file.