Le symposium Koha 2025 s’est tenu du lundi 17 mars après-midi au mercredi 19 mars à la Maison des sciences de l’Homme et de la Société (MSHS, Université Côte d’Azur/CNRS) à Nice. Programme Lundi 17 mars 14h00-14h30 : Accueil / café 14h30-14h45 : Ouverture 14h45-16h00 : Présentations : retours d’expériences et actualités de la communauté Passage à Koha […]
The post Symposium 2025 first appeared on Association KohaLa.
An App Password permits a non-Google app to access Google's SMTP server. App Passwords can only be used with accounts that have 2-step verification turned on. Google recommends using "Sign in with Google" whenever possible, a more secure way to connect apps. Here, we must create an app password for GMail to work with Koha ILS. Create a dedicated Gmail account or GMail-based email service for Koha. Don't use an existing email for other purposes when SMTP is configured; the inbox will be filled with bounced emails.
1. Visit the Google Account Security settings page and turn on 2-step verification. Here is the link to your Google Account Security Settings, https://myaccount.google.com/u/2/security.
Le symposium Koha s’est tenu du lundi 17 juin après-midi au mercredi 19 juin à la Maison méditerranéenne des sciences de l’homme (MMSH, AMU/CNRS) à Aix-en-Provence. Merci aux équipes de la MMSH et de l’AMU pour leur accueil chaleureux et énergique. Venir à la MMSH Lundi 17 juin 14h00-14h30 : Accueil 14h30-14h45 : Ouverture (Cyril […]
The post Symposium 2024 first appeared on Association KohaLa.
Many libraries started to use SMTP-based email services in Koha. Koha provides SMTP server configuration from Administration > SMTP servers > New SMTP server. Such libraries use Gmail free account as the email service provider. Gmail allow you to send 100 emails per day. Users can't send new messages for up to 24 hours if the number of messages exceeds the limit. Google says, "If a user exceeds their sending limits, their account might be suspended". Another drawback of using an ordinary Gmail account is that libraries can't add their domain to the email ID. Sending emails from an ordinary Gmail account is a non-professional approach.
What's the solution?
Libraries can use a dedicated email service to deliver emails. Hiring an SMTP email service to work with Koha is a good idea. Libraries can choose email services from an array of service providers. Such services enable sending, receiving, and tracking emails. Netcore, MailGun, and Mailchimp are examples of transactional email service providers. Libraries can subscribe to the plan based on the number of transactions per day. Email services give the SMTP server settings details to configure with Koha.
L’association KohaLa organise en 2024 plusieurs sessions de formations gratuites à Koha pour ses adhérents, uniquement en visioconférence via Zoom. Si vous êtes intéressés par une ou plusieurs sessions du programme ci-dessous, mais pas encore adhérent, ou bien si vous n’avez pas encore renouvelé votre adhésion, il est encore temps de le faire ICI ! […]
The post Formations 2024 first appeared on Association KohaLa.
Pour donner suite à l’atelier sur le module Périodiques Koha lors du Symposium 2022 et aux réflexions du Hackfest de Marseille la même année, l’association Kohala a mis en place un groupe de travail « Périodiques ». Module peu ‘glamour’ (du fait même du traitement des périodiques qui apparaît souvent comme complexe), le souhait est de faciliter […]
The post GT Périodiques first appeared on Association KohaLa.
L’après-midi d’étude s’est tenue le mardi 30 janvier 2024 en visio-conférence. Vous avez assisté à cet événement ? Vous avez des suggestions à apporter ? Donner votre avis ! Voici le programme de cette après-midi.Vous 14h00-14h10 – Accueil 14h10-15h10 – Retours Hackathon & GT Groupe Koha / ABES – Vidéo Groupe transition bibliographique – Vidéo Groupe […]
The post Journée Koha 2024 first appeared on Association KohaLa.
Le Hackathon 2024 organisé par l’association KohaLa a eu lieu en visioconférence, les 22 et 23 janvier 2024, de 9h30 à 16h30, et a permis de travailler ensemble sur l’amélioration de Koha et notamment avancer sur les questions traitées par les groupes techniques, à savoir : la traduction la transition bibliographique (https://koha-fr.org/gt-transition-bibliographique/) les échanges entre […]
The post Hackathon 2024 first appeared on Association KohaLa.
Here are the steps on how to install PCloud software in Ubuntu:
1. Go to the pCloud website, and create an account.
2. Download the pCloud AppImage file for Linux.
3. Save the file to your computer.
4. Open a terminal window and navigate to the directory where you saved the file.
5. Run the following command to give the file executable permissions:
sudo chmod +x pcloud
Either double-click on the PCloud icon or run the following command to start the pCloud AppImage:
./pcloud
6. The pCloud login window will appear. Enter your pCloud email address and password, and click Log in.
A folder named pCloudDrive will be created in your home directory. This is your pCloud virtual drive. You can now start storing and accessing your files in pCloud.
To schedule Koha backup to pCloud please visit the following link,
http://kohageek.blogspot.com/2021/08/backup-with-auto-delete-old-files.html
The blog post gives the details of schedule backup in Dropbox cloud storage. The same steps can follow to schedule Koha backup to pCloud.
sudo mousepad /etc/koha/sites/library/koha-conf.xml
Find the location of the lines from the screenshot. Check the line number.
Le symposium Koha s’est tenu du mercredi 28 juin après-midi au vendredi 30 juin à Sciences Po Grenoble – UGA (sur le campus universitaire). Comment venir à Sciences Po Grenoble – UGA ? Mercredi 28 juin 14h00-14h30 : Accueil 14h30-14h45 : Introduction et présentation de l’association KohaLa (Sonia Bouis, […]
The post Symposium 2023 first appeared on Association KohaLa.
BibLibre a organisé du 27 au 31 mars 2023, un Hackfest dans leurs locaux à Marseille, 108 rue Breteuil. Cette semaine s’adressait à tous les utilisateurs de Koha : développeurs, administrateurs, bibliothécaires, informaticiens, qui souhaitaient contribuer à améliorer Koha en : testant de nouvelles fonctionnalités ou de corrections de bugs, qui ont été intégrées récemment […]
The post Hackfest 2023 first appeared on Association KohaLa.
This article shows how to prepare the reports we need on the koha home page, such as koha circulation reports, catalog reports, account reports, library membership reports and etc as instant reports, with an exquisite menu.
Go to: Koha Home/Tools/HTML customizations and Click New Entry, as shown in the image below.
Display Location Select for Librarian Interface and fill in all details.
Click the Source Code.
Copy and paste the below source code and change your library reports link, finally change all report links and save the source code.
Connexion<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 </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&phase=Run%20this%20report">Accession Register</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=12&phase=Run%20this%20report">Total Number of Books</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=33&phase=Run%20this%20report">Department Wise Number of Books</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=34&phase=Run%20this%20report">Collection Wise Number of Books</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=15&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 </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&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&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&phase=Run%20this%20report">Item Type Wise (Check Out Books)</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=24&phase=Run%20this%20report">Circulation Daily Transaction</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=44&phase=Run%20this%20report">Date wise Circulation Activity</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=20&phase=Run%20this%20report">Month Wise Circulation Report</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=9&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 </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&phase=Run%20this%20report">Paid Fine for Students</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=14&phase=Run%20this%20report">Writeoff Fine for Students</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=16&phase=Run%20this%20report">Accounting Type Wise Collection</a></li>
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=17&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>👩‍🎓 Library Membership Report </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&phase=Run%20this%20report">Membership Staff & 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>Go to Koha Home Page and your exquisite instant koha reports menu is ready.
Reference: https://getbootstrap.com/docs/4.0/components/buttons/#sizes
Date Wise Circulation Transaction Counts.
This report is a track the date wise count to total number of circulation books per day issue, renewal, return and payment breakdown etc.
L’association KohaLa organise en 2023 plusieurs sessions de formations gratuites à Koha pour ses adhérents : En présentiel, à l’ENSSIB – Lyon (Villeurbane), En visioconférence via Zoom. Si vous êtes intéressés par une ou plusieurs sessions du programme ci-dessous, mais pas encore adhérent, ou bien si vous n’avez pas encore renouvelé votre adhésion, il est […]
The post Formations 2023 first appeared on Association KohaLa.
Le Hackathon organisé par l’association kohaLa s’est tenu en visioconférence, du 23 au 25 janvier 2023. Une dizaine de participants ont travaillé ensemble sur l’amélioration de Koha et ont fait avancer la traduction. La traduction La version 21.11 de Koha a été traduite à près de 98%. Un effort a été porté au manuel 22.05 […]
The post Hackathon 2023 first appeared on Association KohaLa.
La journée d’étude s’est tenue à la BULAC, le jeudi 26 janvier 2023. Elle a été diffusée en streaming sur la chaîne YouTube BULAC. Voici le programme de cette journée. 10h00-10h30 – Accueil café & échanges [Foyer de l’Auditorium] 10h30-12h00 – Sessions en parallèle : Import automatique des lecteurs dans Koha : Retours d’expériences [Auditorium] […]
L’article Journée Koha 2023 est apparu en premier sur Association KohaLa.
Patron attributes help define custom fields (e.g. blood group, Course name (BSc, BA) etc.) with patron details.
1. Enable Patron Attributes from Global System Preferences
Administration System preferences > Patrons > ExtendedPatronAttributes > Enable
2. Create an Authorized Value for the blood group
Administration > Authorized values > New category
A library Clearance/Discharge certificate certifies that the user has no holds, no active checkouts, and no outstanding debt. Here are the steps to generate a clearance certificate;
1. Enable useDischarge from Koha Administration > Global System Preferences. Search and find the useDischarge settings. Turn it into Allow.
2. Customize the Discharge notice at Tools > Notices and slips. Search and find the Discharge notice. The content of the notice is blank. Visit the Notice Template site and copy the content. Edit and save the notice.
3. Open the Patron account to generate Discharge. Find the Discharge button at the end of the Patron account.
4. Click on the Generate discharge button.
Assume that the old version of Dspace is running. Take a PostgreSQL database backup.
Open a Terminal and apply following commands,
sudo su - postgrespg_dump dspace > dspace.backupThe above command take a backup of Dspace database and store in /var/lib/postgresql/
Copy the database backup file to a safe place.
Here we are going to backup essential things. All uploaded files stored in assetstore folder.
Save the assetstore and log files to External hard disc. (below red color command your external hard disc storage location)
cd /media/your pc name/External hard disc namesudo zip -r assetstore.zip /dspace/assetstoresudo zip -r log.zip /dspace/logsudo service tomcat stopsudo rm -rf /dspace/assetstoresudo rm -rf /dspace/log/sudo mv /home/assetstore /dspacesudo mv /home/log /dspacesudo systemctl stop postgresqlsudo systemctl start postgresqlsudo -u postgres psqlDROP DATABASE dspace;CREATE DATABASE dspace;\quitsudo su postgrespsql -f dspace.backup dspaceexitsudo su postgrespsql --username=postgres dspace -c "CREATE EXTENSION pgcrypto;"exitsudo /dspace/bin/dspace database infosudo /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-mediasudo /dspace/bin/dspace index-discovery(Index update)
sudo /dspace/bin/dspace index-discovery -osudo service tomcat startSELECT CONCAT('<a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=',b.biblionumber,'">Notice</a>') AS 'Notice', b.title AS 'Titre', b.author AS 'Auteur', MIN(i.withdrawn_on) AS 'Pilon depuis', COUNT(i.itemnumber) AS 'Nb exemplaires' FROM items i JOIN biblio b ON(i.biblionumber = b.biblionumber) WHERE b.biblionumber IN ( SELECT biblionumber FROM items GROUP BY biblionumber HAVING COUNT(itemnumber) > 0 AND COUNT(IF(withdrawn = 1,1,NULL)) = COUNT(itemnumber) ) AND i.homebranch LIKE <<Site|branches:all>> AND […]
L’article Liste des notices avec des exemplaires pilonnés est apparu en premier sur Association KohaLa.
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.
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
sudo mousepad /etc/php/7.4/apache2/php.inisession.gc_maxlifetime Press Ctrl + F and paste this variable.session.gc_maxlifetime.In front of that the default value is 1440 second that is 24 Minutes.
INSTALLATION OF PHP 7.4
Open terminal and execute commands.
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.
Now restore the sample database which is present in the ‘inout’ directory by applying
following command in terminal (Open Terminal in ‘inout’ directory).
sudo su
mysql -uroot -p lib < lib.sql
How patrons can intuitively navigate through the Koha OPAC, access their account information, and browse all materials.
This webinar covers the basics of the Koha Staff interface and how staff can intuitively navigate the models.
sudo apt-get updatesudo apt-get upgradeInstall Git.
sudo apt-get install gitCheck git Version.
git --versionAdd git Key.
sudo add-apt-repository ppa:git-core/ppaUpgrade git version.
sudo apt update; apt install gitsudo apt-get install openjdk-8-jdkInstall Maven.
sudo apt-get install mavensudo apt-get install antInstall Postgresql.
Add Postgresql Source file location.
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'Add Postgresql Key
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -sudo apt-get updateInstall Postgresql -9.6 Version
sudo apt-get install postgresql-9.6sudo su postgresCreate Postgres Username and Password.
createuser --username=postgres --no-superuser --pwprompt dspacecreatedb --username=postgres --owner=dspace --encoding=UNICODE -T template0 dspacepsql --username=postgres dspace -c "CREATE EXTENSION pgcrypto;"exitOpen the following postgresql, pg_hba.conf file.
sudo gedit /etc/postgresql/9.6/main/pg_hba.confAdd this below line to the configuration file at the end.
local all dspace md5Restart PostgreSQL
sudo /etc/init.d/postgresql restartsudo useradd -m dspacesudo passwd dspacesudo mkdir /dspacesudo chown dspace /dspacesudo mkdir /buildsudo chmod -R 777 /buildcd /buildDownload the Dspace-6.3 version folder.
wget https://github.com/DSpace/DSpace/releases/download/dspace-6.3/dspace-6.3-src-release.tar.gzUnzip the download Dspace-6.3 version folder.
tar -zxf dspace-6.3-src-release.tar.gz Build the download Dapace-6.3 version folder.
sudo gedit /build/dspace-6.3-src-release/dspace-api/pom.xml[remove 1.4 plugin] line number 103 to 105
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>buildnumber-maven-plugin</artifactId>
<version>1.4</version>
<executions><execution>
<phase>validate</phase>
<goals>
<goal>create</goal >
</goals>
</execution
</executions>
</plugin>Installation of DSpace-6.3 version.
cd /build/dspace-6.3-src-releasesudo mvn -U packagecd dspace/target/dspace-installerInstall Apache tomcat-8.5.82
sudo ant fresh_installcd /optTomcat Download file path Location.
sudo wget https://dlcdn.apache.org/tomcat/tomcat-8/v8.5.83/bin/apache-tomcat-8.5.83.tar.gzUnzip the download Tomcat folder.
sudo tar xvzf apache-tomcat-8.5.83.tar.gzRename folder “apache-tomcat-8.5.82” to “tomcat“
Move tomcat folder.
sudo mv apache-tomcat-8.5.83 tomcatTomcat reading permission.
sudo rm apache-tomcat-8.5.83.tar.gzOpen the following file.
sudo gedit /etc/profileAdd following lines at the bottom of the file.
export JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64
export CATALINA_HOME=/opt/tomcatDspace and Tomcat file configuration Permission.
sudo cp -r /dspace/webapps/* /opt/tomcat/webappsEdit the Tomcat init.d file and Add the Below Scripts.
sudo gedit /etc/init.d/tomcat[add this script]
#!/bin/bash
### BEGIN INIT INFO
# Provides: tomcat8
# Required-Start: $network
# Required-Stop: $network
# Default-Start: 2 3 4 5
# Default-Stop : 0 1 6
# Short-Description: Start/Stop Tomcat server
### END INIT INFO
PATH=/sbin:/bin:/usr/sbin:/usr/bin
start() {
sh /opt/tomcat/bin/startup.sh
}
stop() {
sh /opt/tomcat/bin/shutdown.sh
}
case $1 in
start|stop) $1;;
restart) stop; start;;
*) echo "Run as $0 <start|stop|restart>"; exit 1;;
esacTomcat permission.
sudo chmod +x /etc/init.d/tomcatsudo update-rc.d tomcat defaultsNow you can Restart Tomcat.
sudo service tomcat startCreate the Dspace Administrator
sudo /dspace/bin/dspace create-administratorIt 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
I hope this tutorial will help you to install the DSpace in Ubuntu MATE22.4 LTS.
If you have any error PHP, use the following method
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 apache2sudo mousepad /etc/apache2/conf-enabled/phpmyadmin.confBelow 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/etc/init.d/mysql stopmysqld_safe --skip-grant-tables &mysql -urootUse mysql;update user set password=PASSWORD("mynewpassword") where User='root';update user set plugin="mysql_native_password";quit;/etc/init.d/mysql stopkill -9 $(pgrep mysql)/etc/init.d/mysql startmysql -u root -pPage en cours de construction
L’article GT Traduction est apparu en premier sur Association KohaLa.
Ce groupe de travail a été créé pour contribuer à l’adaptation de Koha aux évolutions liées à la transition bibliographique, en prenant en compte les spécificités françaises. Un premier travail important a été fait depuis 2019 pour adapter Koha aux changements du format Unimarc tel que défini par l’IFLA. Cela implique de mettre à jour […]
L’article GT Transition bibliographique est apparu en premier sur Association KohaLa.
Ce groupe de travail est né de la constatation qu’un quart des établissements du réseau SUDOC utilisaient Koha et qu’il y avait des enjeux spécifiques liés aux échanges d’information entre Koha et les outils de l’ABES. Le GT effectue d’une part une analyse des outils de l’ABES (applications, protocoles d’échange, webservices..) et en relation avec […]
L’article GT Koha-ABES est apparu en premier sur Association KohaLa.
Koha master login username and password is same as MySQL database (e.g. koha_library), where data stored.
First change the password of koha_library database.
Then put new password in /etc/koha/sites/library/koha-conf.xml
Apply following commands in Applications > Accessories > Terminal
sudo mysql -uroot -p [enter the MySQL Root password]
use mysql;SET PASSWORD FOR 'koha_library'@'localhost' = PASSWORD('mamcet@66');flush privileges;quit;Need to change new password in Koha configuration file.
Open the configuration file using any text editor. Use any text editor, mousepad/leafpad. Install mousepad.
sudo apt-get install mousepad sudo mousepad /etc/koha/sites/library/koha-conf.xml 
The file will open. Scroll to bottom part of the file and find the line number 271 for password.
Reference: http://kohageek.blogspot.com/
The Koha Staff Experience July 14, 2022
In this 30 minute, The Koha Staff Experience, we will cover the basics of the Koha Staff interface and how staff can intuitively navigate through the models
Registration Link: https://us02web.zoom.us/webinar/register/WN_BN0k0VrSSm6ykhwHLSgRpQ?timezone_id=Asia%2FKolkata
Discover the Koha OPAC on August 9, 2022
In this 30-minute webinar, Discover the Koha OPAC, we will cover how patrons can intuitively navigate through the Koha OPAC, access their account information, and browse all materials!
Registration Link: https://us02web.zoom.us/webinar/register/WN_VtjLAB1pTGO7kQn0inK9lA?timezone_id=Asia%2FKolkata
Technical Services Overview September 15, 2022
In this 30-minute webinar, Technical Services Overview, we will cover the basics of cataloging, acquisitions, serials, and the tools for technical services workflows in Koha!
Registration Link: https://us02web.zoom.us/webinar/register/WN_9P5y1AWFQQ-4et1v2UqChQ?timezone_id=Asia%2FKolkata
The Koha Staff Experience October 18, 2022
In this 30-minute, The Koha Staff Experience, we will cover the basics of the Koha Staff interface and how staff can intuitively navigate through the models.
Registration Link: https://us02web.zoom.us/webinar/register/WN_MHW5H9DCQbm1jOuF1JV-gw?timezone_id=Asia%2FCalcutta
The Basics of Circulation November 16, 2022
In this 30-minute webinar, The basics of circulation, we will cover how staff can utilize the circulation functionality and integrate it into their daily workflows for a successful customer experience.
Registration Link: https://us02web.zoom.us/webinar/register/WN_qAxK67LATByqxRulY9ZBQQ?timezone_id=Asia%2FCalcutta
An Administrators Overview December 8, 2022
In this 30-minute webinar, An Administrators Overview, we will cover how Koha’s administration functionality can help users easily perform their day-to-day jobs at the library.
Registration Link: https://us02web.zoom.us/webinar/register/WN_cRK3MarjQny_ZuJlKye3qA?timezone_id=Asia%2FKolkata
Last week a client partner raised a rather interesting support ticket: when they are checking in overdue items with fines, the fines seem to be vanishing. No, they were not waiving anything, the fines were simply going away and no record of there being ever a fine or its waiver were showing up in the Accounting tab of the patron.
Turns out this was indeed happening. The instance was Koha 21.05.07 running on Debian 10.11 using MariaDB 10.3 running without plack. The evidence the fines been reset to zero and removed was available in the “Log viewer” under the Tools menu.
Doing a diff on the database backup of the table circulation_rules between the database backup from 2 days before and the one from that day, revealed that the day before, the client had re-jigged their circulation rules during which they had inadvertently changed the Fine interval aka chargeperiod setting from “1” to blank.
As the user manual says :
Enter the ‘Fine charging interval’ in the unit you set (ex. charge fines every 1 day, or every 2 hours). The finesCalendar system preference controls whether the days the library is closed will be taken into account or not.
In this specific instance, not only was the finesMode system preference set to “Calculate and charge” with fines being charged by the daily cron job, it also had CalculateFinesOnReturn system preference set to “Do”. Thus, while the cron job was creating and then updating fines once a day, the CalculateFinesOnReturn triggered at the time of check-in was resetting the fines to “0” as the chargeperiod was not set. This was why the fines were disappearing.
The simple fix was to ensure that for all the circulation rules the chargeperiod was set to “1”. And immediately the problem went away.
KISS, an acronym for “keep it simple, stupid” or “keep it stupid simple”, is a design principle noted by the U.S. Navy in 1960. The KISS principle states that most systems work best if they are kept simple rather than made complicated; therefore, simplicity should be a key goal in design, and unnecessary complexity should be avoided. The phrase has been associated with aircraft engineer Kelly Johnson. Variations on the phrase include: “Keep it simple, silly”, “keep it short and simple”, “keep it simple and straightforward”, “keep it small and simple”, or “keep it stupid simple”. [1]
Earlier today we received a request to add a new SQL report to generate a list of all students with their email ids from the librarian at our client partner Sister Nivedita University. The request prima facie was simple. However, when we looked at the patron categories for students under Administration, the first reaction was “Uh oh!”.
Let me explain. There were 8 patron categories for students (of all types) and all these student patron categories had different mnemonic codes that were as follows:
| DIP | Diploma – 2 years |
| GNM-3 | General Nursing and Midwifery – 3 years |
| RS | Research scholar |
| SPG-2 | Student Postgraduate – 2 years |
| SPG-3 | Student Postgraduate – 3 years |
| SUG-3 | Student Undergraduate – 3 years |
| SUG-4 | Student Undergraduate – 4 years |
| SUG-5 | Student Undergraduate – 5 years |
Still, just to fulfill the service request, all we needed to do was to create an SQL query like
SELECT
cardnumber, firstname, surname, email
FROM borrowers
WHERE categorycode IN
('DIP', 'GNM-3', 'RS', 'SPG-2', 'SPG-3', 'SUG-3', 'SUG-4', 'SUG-5')
There was no way to know from the mnemonic values that all these codes designated a student patron category, as there was no uniform standardization of the values used for student categories. To put the problem in a perspective that library professionals will understand easily – e.g. if we saw a DDC class number that started with 004, we’ll immediately know that it belongs to “computer science“, but what if the computer science documents were marked out with numbers that did not denote computer science under DDC???
Further, if in the future, the library added another student patron category, the SQL report would need to be updated in order to give the correct output that will include members belonging to this newly added category.
Luckily the solution was both simple and straightforward. We had to standardize and re-code the student patron categories and update the affected patrons. To do that we prefixed every student patron category with “STD_“. And thus, the student patron categories became:
| STD_DIP2 | Diploma – 2 years |
| STD_GNM3 | General Nursing and Midwifery – 3 years |
| STD_RS | Research scholar |
| STD_PG2 | Student Postgraduate – 2 years |
| STD_PG3 | Student Postgraduate – 3 years |
| STD_UG3 | Student Undergraduate – 3 years |
| STD_UG4 | Student Undergraduate – 4 years |
| STD_UG5 | Student Undergraduate – 5 years |
This was followed by updating the categorycode in the borrowers table to reflect the new changes. As a result the SQL query became much simplified:
SELECT cardnumber, firstname, surname, email FROM borrowers WHERE categorycode LIKE 'STD_%'
If the library added a new student patron category in the future, all they would need to do is prefix the code with “STD_” and this query would continue to work without any change with this simple and straightforward update.
This solution required us to directly access the production database with MySQL’s foreign key check turned off with SET FOREIGN_KEY_CHECKS=0;. If you get inspired to follow this, please ensure you have a complete database backup before you attempt this. And if by chance, you manage to mess it up or damage your database while attempting to do this, we are NOT responsible in any manner.
References [1] https://en.wikipedia.org/wiki/KISS_principle
We are pleased to welcome our newest client partner ESI-PGIMSR (Joka) Library to our cloud-hosted Koha ILS platform.
ESI-PGIMSR, Kolkata, also known by its full name Employees State Insurance Post Graduate Institute of Medical Sciences and Research & Employees State Insurance Corporation Medical College, Kolkata, is a MCI recognised medical college established in 2013 under the aegis of the ESI Corporation, an autonomous body under the Ministry of Labour and Employment, Government of India.
The library is located at the 2nd Floor of the Academic Building with floor area of more than 3000 sq. ft. Users have facility of for easy browsing, reading and borrowing of Books and Journals. The library caters to the need of M.B.B.S. students, Research Scholars, Post Graduate Students, Senior Residents, Junior Residents, Medical Teaching Faculty and other Doctors and Paramedical Staff of the Institute. The library follows open access system with books arranged using the Decimal Classification (D.D.C.) scheme.
Recently there was a request from IDSK – they wanted the accession register SQL report for their Rabindranath Tagore Grant collection books to be listed in a natural sort. Documents of this collection carry the prefix “RT” which is fine and dandy. The “problem” started after that. In their earlier legacy system (SOUL v1) when these books had been accessioned, they did not use an fixed uniform length accession no for this collection. For example, instead of RT00001, it was entered RT1, RT2 and so on. Further, their problem was compounded by another glitch. In several of these accession nos, there were spaces inserted between “RT” and the actual numerical part. When they migrated to Koha with L2C2 Technologies, these problems were carried over to the new system as data curation and correction was not part of the deliverables. Now, three years later, when reports were being asked for, these issues had come back to haunt them.
The RT collection has over 4000+ books and a manual fix was not feasible at this time. So using the ORDER BY keyword in the report’s SQL like this: ORDER BY LPAD(REPLACE(REPLACE(TRIM(items.barcode)," ",""),"RT",""), 10, ' ') ASC we at least managed to hide the problem and also got natural sorting to work. The first REPLACE() took out any space in the accession no, and the second REPLACE() stripped off the “RT” prefix, leaving us with only the number. Finally using LPAD() we zero prefixed the number so that each one was exactly 10 characters long. And we had our naturally sorted list of accession numbers in the report as we can see below.
The 126-year old heritage library of Bangiya Sahitya Parishat (aka Bangiya Sahitya Parishad) chooses L2C2 Technologies as their Koha hosting service provider, and it is with great joy admixed with a sense of greater responsibility that we welcome our newest client-partner. The OPAC is available at https://library.bangiyasahityaparishat.org/
Originally founded on 23 July, 1893 as the “Bengal Academy of Literature” literary society, the institution renamed itself as “Bangiya Sahitya Parishat” in 1894 with Romesh Chunder Dutt as it’s first president and Rabindranath Tagore and Navinchandra Sen as vice presidents. With the study and development of the Bengali language and literature as its main objective, the society has over the years, has delved into the cultural, historical, archaeological, sociological and other scientific studies and researches with special reference to Bengal. The society moved into its present address in 1908. The land the building stands on was donated by Maharaja Manindra Chandra Nandy of Cossimbazar Raj. In 1997, Kolkata Municipal Corporation notified the building as a Grade-I heritage building.
Established in 1894, the Bangiya Sahitya Parishat Library was the brainchild of Archarya Ramendra Sundar Tribedi. From its early beginning with a handful of donated books and periodicals, the library today in its collection has 1,01,719 books and 17,558 journals. The collection includes very rare and valuable books as well as many rare 19th century periodicals in Bengali and English such as ‘Digdarshan’, ‘Samachar Darpan’, ‘Samachar Chandrika’, ‘Friend of India’ etc. [1] The library has several important collections, the most important highlight being the “Vidyasagar Collection” donated by the erstwhile Maharajah of Lalgola. Given the richness of its collections, the library attracts readers and researchers from both India and abroad.
References: [1] https://bangiyasahityaparishat.org/library/
As the README.md at https://gitlab.com/koha-community/kohadevbox says – “Create a development environment for the Koha ILS project. It uses Vagrant and Ansible to set up a VirtualBox.” Basically it automates the long and somewhat complex process of manually setting up a development system for #kohails.
From the website – PuTTY is an SSH and telnet client, developed originally by Simon Tatham for the Windows platform. PuTTY is open source software that is available with source code and is developed and supported by a group of volunteers. It is our go-to tool on Windows for accessing physical Koha boxes or VMs via SSH.
Vagrant sets up SSH service on the VM to use public-key authentication. Therefore our PuTTY instance needs to know the private key that Vagrant had setup inside the VM, in order to login into it. As many posts in Stackoverflow indicates, this is a point where many people get stuck. Usually they try with %USERPROFILE%\.vagrant.d\insecure_private_key and that typically fails.
Using git-bash go to the directory where you had cloned kohadevbox. Be default it will be %USERPROFILE%/git/kohadevbox if you have simply followed the instructions from kohadevbox README.md file. In our case, it was %USERPROFILE%/gitdev/kohadevbox as we had changed it.
Run the command
vagrant ssh-config
You should see something like this:
The line to note in the output is IdentityFile. That’s the private key you need to grab and feed to PuTTYGen for it to convert it into a PuTTY compatible .ppk format private key.
NOTE: This path to the key is going to be different for different users, so do not attempt to copy-paste what you see here, instead use your own IdentityFile value.
Now we convert the vagrant_private_key from IdentityFile and save it as a .ppk file.
And lastly we import it into PuTTY like this and we are good to go!
Finally we are logged in into the VM
NOTES: The versions of software used – (a) PuTTY.exe – 0.71 (b) Vagrant – 2.2.7 (c) Git Bash – 2.25.0 (d) VirtualBox – 6.1.2
We are happy to announce that Nirmala College, Muvattupuzha has chosen to L2C2 Technologies for migration from a legacy proprietary software to Koha on our hosted Koha on the cloud platform.
Established in 1953, Nirmala College, Muvattupuzha is a first-grade college affiliated to Mahatma Gandhi University, Kottayam. It is a minority Christian institution governed and managed by the Corporate Educational Agency, Syrian Catholic Diocese of Kothamangalam. In strict compliance with the vision of the founding fathers, the college has served the community, irrespective of caste, creed and colour and has contributed to the world quite large a number of value-based Nirmalites. Her performance in academic and non-academic activities has been acknowledged by the NIRF rankings 2017 in the form of its position on the 91st among the list of colleges in the country. In addition, the college has been bestowed with the prestigious ‘Star College’ status by the Department of Bio-Technology (DBT), Government of India, in recognition of the advancements made by the college in the field of science education, with a handsome financial grant. All science departments of the college are supported by the DST- FIST scheme.
The college is located on a hill top at the doorstep of high ranges in the western ghats. The campus is spread over 53 acres of land with state of the art facilities for a constructive learning experience. The college has now grown to become a centre of learning that offers graduation in 16 disciplines, post-graduation in 14 and research facility in six. The college also runs 17 certificate/ diploma programmes. The IGNOU Study Centre, functioning in the college, offers 11 UG and 04 PG Programmes. The Nirmala Civil Service Academy, functioning in the college, caters to the needs of civil service aspirants.
From : http://nirmalacollege.ac.in/welcome-to-nirmala-college/
The Library has a collection of over 80,000 volumes. The Library subscribes to 190 journals and periodicals both national and international. The entire legacy data was migrated over to Koha ILS. The OPAC is available at https://nirmala-opac.l2c2.co.in/
This video shares the idea about how to turbo-charge the sort1 and sort2 fields for patron records in Koha by utilizing Koha’s very own reports web service in tandem with a bit of JQuery.
If you are feeling impatient because you already know the background, feel free to jump to 3 minutes 10 seconds into the playtime, to see the actual action in progress.
Runtime: 14 mins 35 sec.
Earlier this morning, Pranab Roy who manages the Library at the Karnavati University‘s UnitedWorld School of Business‘s Kolkata campus popped up on WhatsApp with a question – “Sir, why is Koha not showing the barcode / accession number of a borrowed document when an user logs in into their own account via the OPAC?”
This is what he meant. And this is actually the expected behaviour, with Koha doing exactly what it was asked to do. I could understand his confusion since the OPAC search’s details view showed the barcode quite nicely, then why not for the users themselves?
Karnavati University Libraries had shifted to L2C2 Technologies‘ cloud platform from a pre-existing Koha instance maintained by a 3rd party. As such the system had quite a few issues. While we had fixed a larger number of these during the initial on-boarding stage, some of these are getting ironed out only now as the librarians hit these “bumps on the road”. Pranab’s problem was one such.
The option to display the barcodes for a logged-in OPAC user’s checkouts (issues) is driven by the SHOW_BARCODE patron attribute. In Koha, patron attributes or more correctly ExtendedPatronAttributes are library-defined custom fields that can be applied to patron records e.g. voter / aadhaar card number, registration number etc.
SHOW_BARCODE is a boolean variable that is defined as either Yes or No. and it is loaded into Koha usually during the web-installer phase of Koha’s installation from the optional SQL dump file: /usr/share/koha/intranet/cgi-bin/installer/data/mysql/en/optional/patron_atributes.sql in Debian package based installations. The tiny file contains a single SQL INSERT statement:
INSERT INTO `borrower_attribute_types` (`code`, `description`, `repeatable`, `unique_id`, `opac_display`, `staff_searchable`, `authorised_value_category`) VALUES (‘SHOW_BCODE’, ‘Show barcode on the summary screen items listings’, 0, 0, 1, 0, ‘YES_NO’);
In the case of Karnavati University this optional patron attribute was not imported during the *original* installation done by the 3rd party support provider at the time. And without “SHOW_BARCODE” being set, Koha had no way of displaying the barcodes of checked out books to patrons logged in via the OPAC.
In the end, the following two lines followed by enabling the ExtendedPatronAttributes system preference cleared off the issue for Karnavati:$ cd /usr/share/koha/intranet/cgi-bin/installer/data/mysql/en/optional$ mysql -uroot -p koha_karnavati .
A memcached restart later (to be safe rather than sorry) the OPAC started showing the barcodes to logged-in patrons.
LEGAL DISCLAIMAR: This tutorial is strictly meant for educational purpose. We are in no way responsible if you attempt to follow these steps and end up messing up your production Koha installation somehow.
Setting up yearly calendars is an important task in Koha. Especially in a country like India where we also use other calendars including lunar calendars. Since the religious festivals / holidays usually use these other calendars, the holidays often fall on different days in different years in the Gregorian calendar that Koha uses.
As support providers, we are often asked to setup the calendar for our client-partners. While Koha provides a rather useful user-interface to setup calendars under the Tools menu, we have often found that not only setting up the long list of Indian holidays a tedious affair, it is also quite prone to operator error. So for the Unique holidays we usually use a LibreOffice (a Free Software Office Suite) Calc spreadsheet to quickly generate the batch of SQL statements that can be directed imported into the special_holidays table of Koha using the SQL backend.
We ask our client-partners to send us a spreadsheet that lists the holidays and the days they fall on according to the Gregorian calendar (see the columns marked in yellow above). And then we use a couple of simple formulae to generate the necessary SQL. This approach has two advantages : (a) it’s very fast and (b) completely free of errors from our end.
In this present case, it took us less than 2 minute to upload all the 25 holidays for 2020 into this particular Koha instance.
Caveat The only risk here is that we are going to access the database directly from the command-line and that, unless you know what you are doing, can end up badly, *if* you mess things up.
Adding auto-complete feature to Koha’s MARC21 biblioitems field (Imprint – place, name of publisher, ISBN,edition, etc) as a cataloging aid.
Go to : Koha administration/Global system preferences/Staff interface/IntranetUserJS
Below the Java script enable of the auto completed in four columns for ISBN, Place of publication, Name of the Publisher, Edition
Copy and paste the bellow JS Coding.
Click Save Button.
Go to : Home/Cataloging/New Record (Enter the all bibliographies details )
[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/
It is an HTML5 & CSS payment receipt template that automatically emails receipts for payments made by koha patrons.
Go to : Tools/Notices & slips/ACCOUNT_PAYMENT ( Edit or create New notes)
Copy and paste the bellow HTML5 & CSS Coding.
First Create the SQL Public Report
Go to: Reports/ Create from SQL and (Copy and paste the following SQL query )
Go to: Koha administration/System preferences/Staff interface/IntranetUserJS
Copy and paste the following JQuery
Replace your IP address and report ID
http://Your koha IP Address/cgi-bin/koha/svc/report?id=36&annotated=1
There are some features of mobile app as listed below:
App Home Page  | OPAC  | OPAC 2  |
DELNET  | NPTEL  | DSpace  |
e- Journals  | OPAC Login  | Lib Staff Interface  |
sudo apt-get updateLogin to SQL database user
sudo mysql -uroot -p[Enter the your MySQL Root password]
Remove your default database for example koha_library
drop database koha_library;create database koha_libpowertech;Database Restoration commands,
sudo mysql -uroot -p koha_libpowertech < koha_library.sql[Enter the your MySQL Root password]
koha_libpowertech - name of database in new installation
koha_library.sql - name of database in old installation
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 restartsudo koha-upgrade-schema libpowertech[Your Database Name]
Apply following command in a terminal,
sudo koha-rebuild-zebra -v -f libpowertech[Your Database Name]
| SL. No | ITEM TYPES | MARC TAG |
| 1 | AUTHOR | 100$a |
| 2 | TITLE | 245$a |
| 3 | BARCODE / ACC NO | 952$p |
| 4 | BARCODE SERIES | 490$a |
| 5 | DDC (Call Number) | 082$a & 952$0 |
| 6 | BILL NO | 300$c |
| 7 | PAGE | 300$a |
| 8 | EDITION | 250$a |
| 9 | YEAR OF PUBLICATION | 260$c |
| 10 | PRICE | 952$g |
| 11 | OPAC PRICE | 300$b |
| 12 | PUBLISHER | 260$b |
| 13 | PLACE OF PUBLICATION | 260$a |
| 14 | SUBJECT | 650$a |
| 15 | COLLECTION CODE (Type of Collection and Relevant Department) | 952$8 |
| 16 | SHELVING LOCATION (Department Full Name ) | 952$c |
| 17 | ELECTRONIC LOCATION (Online book Link) | 856&u |
| 18 | DATA ACQUIRED (Book Data Entry date) | 952$d |
| 19 | ISBN | 020$a |
| 20 | NOTES (Remark / Book Purchase from) | 500$a |
| 21 | LOST STATUS (Missing Lost) | 952$1 |
| 22 | ITEM TYPE CODE (Book, CD, Book Bank) | 942$c |
| 23 | ITEM TYPE CODE (Reference (or) Transfer) | 952$y |
| 24 | BRANCH CODE (Current Location ) | 952$a |
| 25 | BRANCH CODE ( Home Library) | 952$b |
GLabels is a free software tool to generate labels/barcodes for various purposes (e.g. Book Barcode, Students/Staffs ID card barcode labels and etc.. )
sudo apt-get install glabels
sudo apt-get remove glabels
sudo cp /home/koha/header.png /usr/share/koha/opac/htdocs
<header><img src="/header.png" alt="" width="1230" height="190" /></header>
<header><img src="https://i.ibb.co/Yprx9fx/header.png" alt="" width="1230" height="190" /></header>
1.2. Change Koha OPAC Footer:
Go to: Tools › News › New entry
1. Now go to Tools › News Click on New Entry and select opaccredits (en)
2. Enter values as showing in below image.
Copy and Paste the following HTML. (Source Code Section)<footer>
<div class="container">
<center>
<span style="color: #17202a;">
<br/>Designed & Maintained by:<strong>
<a href="#" target="_blank" rel="noopener">Lib Power Tech</a>
</strong><br/>Central Library, <strong>Contact: <span style="color: #2dc26b;">sivamdeveloper</span>
<span style="color: #2dc26b;">@gmail.com</span><strong><br/>
<br/></strong></strong></span></center></div>
</footer>
sudo su
apt-get update
apt-get upgrade
apt-get install mousepad
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
wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key add -
apt-get update
sudo apt install -y koha-common
sudo mousepad /etc/koha/koha-sites.conf
sudo apt install mariadb-client-10.3
sudo apt install mariadb-server
sudo mysqladmin -u root password newpass
sudo a2enmod rewrite
sudo a2enmod cgi
sudo service apache2 restart
sudo koha-create --create-db librarysudo mousepad /etc/apache2/ports.conf
sudo service apache2 restart
sudo a2dissite 000-default
sudo a2enmod deflate
sudo a2ensite library
sudo service apache2 restart
sudo apt install liblocale-codes-perl
sudo koha-plack --enable library && sudo koha-plack --start library
sudo perl -MCPAN -e 'install Bundle::KohaSupport'
sudo service memcached restart
Enter into the Koha staff client using the Database username and password of koha_library. It can find from the file, /etc/koha/sites/library/koha-conf.xml.
sudo mousepad /etc/koha/sites/library/koha-conf.xmlsudo mousepad /etc/apache2/sites-available/library.confKoha on Ubuntu - packages
https://wiki.koha-community.org/wiki/Koha_on_ubuntu_packages
Koha Geek: http://kohageek.blogspot.com/
<p><font face="Josefin Slab"></p> Hello <br> <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>><br> Library Card No: <<borrowers.cardnumber>><br> Department of: <<borrowers.borrowernotes>>,<br> <<borrowers.address>>.<br> <<borrowers.email>>,<br> <<borrowers.phone>><br> Your Library Card Ready Please Collected to <<branches.branchname>>.<br><br> Your New <<branches.branchname>> Membership Account Details are<br> User ID :<b><<borrowers.userid>><br></b> Password: <b><<borrowers.password>></b><br> Please 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><br> <b><u>LIBRARY RULES AND REGULATIONS</b></u> <ul><p style="text-align:justify"> 1. Open Access System is followed in the Library.<br> 2. Strict and absolute silence shall be observed in the library.<br> 3. Mobile phone to be switched off inside the Library.<br> <p><b>This is an Automatically Generated Email.</b> <p> If you have any problems or questions regarding your account, please contact your <<branches.branchname>>.<br><br> Thank you...<br> Librarian,<br> <<branches.branchname>>,<br></font> |
Dear <br> <<borrowers.title>>.<<borrowers.surname>><br> <p>The following items have been<b> Issues:</b></p> <table style="width: auto; height: 45px;" border="2" TABLE BORDERCOLOR="black" cellspacing="2" cellpadding="1"> <tr> <td><strong>Library Card No</td></strong> <td><<borrowers.cardnumber>></td> </tr> <tr> <td><b>Name of the Member</td> <td><<borrowers.surname>></td> </tr> <tr> <td><b>Barcode / Acc No</td> <td><<items.barcode>></td> </tr> <tr> <td><b>Title</td> <td><<biblio.title>></td> </tr> <tr> <td><b>Author</td> <td><<biblio.author>></td> </tr> <tr> <td><b>Book Issue Date</td> <td><<issues.issuedate>></td> </tr> <tr> <td><b>Book Due Date</td> <td><<issues.date_due>></td> </tr> </h2> </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> <br><p><b>This is an Automatically Generated Email.</b></br><br> Thank you for visiting <a href="/cgi-bin/koha/opac-main.pl?logout.x=1" target="_blank"> <<branches.branchname>>.</a> |
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> |
<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> |
<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> |
sudo apt-get updatesudo apt-get install postfixsudo cp /usr/share/postfix/main.cf.debian /etc/postfix/main.cfsudo apt-get install libsasl2-2sudo apt-get install libsasl2-modulessudo apt-get install ca-certificates
sudo leafpad /etc/postfix/main.cfrelayhost = [smtp.gmail.com]:587 smtp_sasl_auth_enable = yes smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd smtp_sasl_security_options = noanonymous smtp_tls_CAfile = /etc/postfix/cacert.pem smtp_use_tls = yes |
sudo leafpad /etc/postfix/sasl_passwd[smtp.gmail.com]:587 urgmailid@gmail.com:yourpasswordsudo chmod 400 /etc/postfix/sasl_passwd
sudo postmap /etc/postfix/sasl_passwd
sudo postalias hash:/etc/aliases
sudo cat /etc/ssl/certs/thawte_Primary_Root_CA.pem >> /etc/postfix/cacert.pem
sudo cat /etc/ssl/certs/Actalis_Authentication_Root_CA.pem >> /etc/postfix/cacert.pem
sudo /etc/init.d/postfix restart
sudo koha-email-enable library
1. Insert DVD and restart PC.
2. Change the boot option to DVD.
3. Live DVD will directly go to Live mode. Ubuntu desktop will load.
4. Open Applications > System Tools > Terminal, and apply following commands,
sudo suPassword:
koha123
ubiquity
The installer window will appear.
Proceed with the installation.
Koha 17.05.09 Live DVD Download
1 2 3 | body { background: linear-gradient(to bottom,#E7FAF9 65%,#6BF3EB 100%); } |
1 2 3 | body { background:url("https://static-cse.canva.com/blob/142529/Image-by-Stanislav-Kondratiev-via-Unsplash.c74e94c2.jpg"); } |
sudo sumysql -u root -pUPDATE mysql.user SET Password=PASSWORD('mynewpassword') WHERE USER='root';quit;sudo service mysql restartmysql -u root -p
1 2 3 4 5 | input:focus, textarea:focus {border-color: #538200;border-radius: 4px;border-style: solid;} |
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;} |
Apply the following commands one by one,
sudo apt install gnupg ca-certificates
sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 3FA7E0328081BFF6A14DA29AA6A19B38D3D831EF
echo "deb https://download.mono-project.com/repo/ubuntu stable-focal main" | sudo tee /etc/apt/sources.list.d/mono-official-stable.list
sudo apt update
No need to install the full Mono package to run MARCEdit.
The following package mono-xsp4 is enough for running ASP.NET applications.
sudo apt install mono-xsp4
Download the MarcEdit package suitable for Linux based OS from here, https://marcedit.reeset.net/downloads
The filename would be marcedit7.run
Give permission to MarcEdit package,
sudo chmod +x marcedit7.run
Apply the following command to install the package,
sudo ./marcedit7.run --target ~/Documents/marcedit
If the installation succeeds, the MarcEdit icon will appear on the desktop. Don't worry if the icon does not appear on the screen. We can run the MarcEdit software from the folder. The MarcEdit folder appeared on the Document folder. Change the permission of the marceditor folder.
cd Documents
sudo chmod -R 777 marcedit
Open the marcedit folder and find the MarcEdit.exe, double click on it.
MarcEdit starts.
Le Symposium Koha 2022 s’est tenu à Orléans, à l’espace Tchumi du Lab’O, du lundi 16 après-midi au mercredi 18 mai, où étaient programmés des présentations, des échanges, des ateliers et l’assemblée générale annuelle de l’association KohaLa. Lundi 16 mai 14h00-14h45 : Accueil 14h45-15h00 : Introduction et présentation de l’association KohaLa (Sonia Bouis, Présidente de Association […]
L’article Symposium 2022 est apparu en premier sur Association KohaLa.
Socket file helps to facilitate communication between different processes of the MySQL and MariaDB server. The file associated with the process is, mysqld.sock and is located at the folder, /var/run/mysqld/. Due to many reasons, MariaDB cannot establish a connection with the socket file. Sometimes socket files are missing from the location. It results in the stopping of the MariaDB service. The problem with the socket file also affects the working of Koha. Often Koha screen shows the following error on the screen.
Possible solutions
We can try to apply three solutions to evoke socket files; restarting the MariaDB service, changing user permissions, and reinstalling MariaDB.
Solution 1: Try to restart the MariaDB service and check whether it's working.
sudo systemctl start mariadb
Refresh the Koha page. If it works, it means the socket file works. If it does not open, we go to the next solution.
Solution 2: Next, we will check whether the mysqld. sock file missing or not. Apply the following command,
ls -a /var/run/mysqld
The file is there, we can see a file with the name, mysqld.sock. If the file is missing from there, the reason may be that MariaDB has no proper permissions to create it. Give the directory permission to MariaDB users to make necessary changes.
sudo chown mysql:mysql /var/run/mysqld/
sudo chmod -R 755 /var/run/mysqld/
Restart the MariaDB service,
sudo systemctl restart mysql
If it is reluctant to start the service and shows the error, find other ways to solve it. The last resort is to reinstall the MariaDB.
Solution 3: Reinstall MariaDB
The first step is the uninstall the MariaDB without removing the Koha databases (e.g. koha_library). The default location of the data directory of MariaDB is at /var/lib/mysql/, where we can see the Koha database directory.
 |
| The location of MariaDB data directory, /var/lib/mysql/ |
sudo apt purge "mariadb*" -y
Apply the following command to reinstall the MariaDB,
sudo apt-get install mariadb-server mariadb-client
I faced the socket problem with MariaDB 10.3 on Ubuntu 20.04. I used the opportunity and installed a higher version of MariaDB (10.04) by adding a repository. The download page in the MariaDB home page gives you instructions to install a higher version of the package. Please check it, https://mariadb.org/download/?t=repo-config
References
How To Troubleshoot Socket Errors in MySQL https://www.digitalocean.com/community/tutorials/how-to-troubleshoot-socket-errors-in-mysql
MariaDB installation - dependency problems and failed to start service https://mariadb.com/kb/en/mariadb-installation-dependancy-problems-and-failed-to-start-service/
L’association KohaLa organise en 2022 plusieurs sessions de formations gratuites à Koha pour ses adhérents : En présentiel, à la BULAC – Paris, En visioconférence via Zoom. Si vous êtes intéressés par une ou plusieurs sessions du programme ci-dessous, mais pas encore adhérent, ou bien si vous n’avez pas encore renouvelé votre adhésion, il est […]
L’article Formations 2022 est apparu en premier sur Association KohaLa.
 |
| DBeaver interface |
Le hackathon s’est tenu en visioconférence du 18 au 20 janvier 2022. Vingt participants (développeurs et bibliothécaires) divisés en 3 groupes ont travaillé sur la traduction, la transition bibliographique et l’amélioration des échanges entre Koha et l’ABES. Voilà un résumé des actions menées dans chaque groupe : Traduction : le groupe de traducteurs s’est […]
L’article Hackathon 2022 est apparu en premier sur Association KohaLa.
La journée d’étude, initialement prévue à la BULAC, le lundi 17 janvier 2022, sera organisée par visio-conférence. La journée sera enregistrée pour une diffusion sur le site de KohaLa. Date limite d’inscription le 14 Janvier 2022 Voici le programme de cette journée. 10h30-12h00 – Sessions en parallèle : Démonstration Koha pour les nouveaux utilisateurs – […]
L’article Journée Koha 2022 est apparu en premier sur Association KohaLa.
Eight regional languages in India were placed in the Koha translation project. Hindi and Telugu translation is almost finished, and other languages work is in progress. Except for Hindi and Telugu, no other Indian languages received community participation in the translation process.
Koha Software community maintains an online platform for translation activities. The Koha translation website is available at https://translate.koha-community.org. The Koha software community uses free software called Pootle to manage translations. Each version of Koha is treated as a project and contains languages and translation files. Translation entries are saved in .po files and multiple .po files for different modules of Koha ILS. You can participate in translation activities by creating an account on the website. No technical knowledge is required to participate in translation activities.
Select the language (e.g. Malayalam) from the top of the website. Translation work on the four Koha editions is underway at the same time.
Select the latest version of Koha for translation. Enter into the translation activities by clicking on the Koha version. When a new version of Koha is released, the current translation entries carry over to the latest one.
The translation entries are stored in different files. For ease of translation, lines related to various modules such as online catalogue, staff interface, messages and installer are stored in separate files. Clicking on the file link will allow you to enter into the file and view the lines to be translated.
Click on the Untranslated link, and it will list out the entries that need a translation. Translate the highlighted entries.
Translate the highlighted English entries. Type the translated entries in the regional language in the box. Use Google Chrome browser, and the Input Tools extension (Google Input Tools) to input translated entries. The translated entry can be submitted by clicking on the Submit / Suggest button. Suggested translations become part of the Malayalam translation once approved by the Administrator.
If there is a variable in the entries, it should be left as it is. Numbers, amounts, dates, etc., appear in the variable position. %s can be found where the variable appears. Even if you change the structure of the lines, add the variable note in the desired position. Do not delete the variable part.
When the translation of each line is complete, the next line is highlighted for translation.
Participation in the Koha translation project does not require technical expertise. Best collaboration space for LIS students and professionals. Participation in the Koha translation project helps the students and professionals acquaint themselves with Free Software’s sharing culture. Become a contributor and help in Koha translation.
L’association kohaLa a organisé un mini hackathon en visioconférence, du 31 mars au 2 avril, pour permettre de travailler ensemble sur l’amélioration de Koha et notamment avancer sur les questions traitées par les groupes techniques, à savoir : la traduction la transition bibliographique l’amélioration des échanges entre Koha et l’ABES (exploitation des webservices de l’ABES […]
L’article Hackathon 2021 est apparu en premier sur Association KohaLa.
 |
Auto deletion of old backup files helps save cloud space. |
Le symposium Koha 2021 s’est déroulé en visio-conférence du mercredi 23 juin au jeudi 24 juin 2021 et a proposé des présentations, des échanges et des ateliers. Il a été également l’occasion pour l’association de faire le point à travers l’assemblée générale annuelle. Mercredi 23 Juin 10h30-12h : Assemblée générale de l’association KohaLa Le rapport […]
L’article Symposium 2021 est apparu en premier sur Association KohaLa.
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, https://hea.koha-community.org. The global usage statistics of Koha available on the website.
A system preference, stafflogininstructions available for this purpose. This feature available since the release of Koha version 18.04.
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="http://127.0.1.1/mgu-logo.jpg" style="width:45%; height:45%;"> </center>
Change the IP (http://127.0.1.1/mgu-logo.jpg) match with yours. Save the settings. Sign out from Koha Staff Client and check the login page.
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.
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.
1. Install Google Chrome browser and install Google Input Tools from the following link,
https://chrome.google.com/webstore/detail/google-input-tools/mclkkofklkfljcocdinagocijmpgbhab?hl=en
2. Enable regional languages
Google Input Tools extension appears on the browser page.
 |
| Image courtesy: techyukti.com |
