First and Largest Academic Social Network of LIS Professionals in India
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 php
sudo apt-get -y install php-{bcmath,bz2,intl,gd,mbstring,mysql,zip}
sudo apt-get -y install libapache2-mod-php
php -v
sudo su
[Enter Password]
cd /usr/share/koha/opac/htdocs
wget https://github.com/omkar2403/inout/archive/refs/tags/v6.zip
unzip v6.zip
mv inout-6 inout
rm v6.zip
sudo chmod 777 -R inout
sudo chown www-data:www-data -R /usr/share/koha/opac/htdocs
sudo su
mysql -uroot -p
[Enter MySQL Root password]
CREATE database user;
CREATE USER 'user'@'localhost' IDENTIFIED BY 'user123';
GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
quit;
sudo su
[Enter Password]
cd /usr/share/koha/opac/htdocs/inout/DB
mysql -uroot -p user < inout.sql
[Enter MySQL Root password]
sudo gedit /usr/share/koha/opac/htdocs/inout/functions/dbconn.php
Change Username,Password, Database Name
sudo systemctl reload apache2 && sudo systemctl restart apache2
Thanks to:
https://github.com/omkar2403/inout
Koha Plugin : In Out Management System - LIBTECHNOPHILE
This guide will help you set up a simple text-to-speech system that can convert written text in English, Hindi, Tamil, and many other languages into audio files. This is useful for creating audiobooks, accessibility services, or audio announcements.
Download Python:
Install Python:
Verify Installation:
Windows Key + Rcmd and press Enterpython --versionPython 3.11.xIn the Command Prompt (same black window), type:
pip install edge-tts
Press Enter and wait. You should see "Successfully installed edge-tts"
Install R:
Install RStudio:
Save the R script above as library_tts.R on your computer
Create your text file:
english_text.txt (or hindi_text.txt, tamil_text.txt, etc.)C:/Library_Audio_FilesRun the script:
library_tts.RFind your audio:
C:/Library_Audio_Files# For Chapter 1input_file <- "chapter1.txt"output_file <- "Chapter_1_Audio.mp3"
For English announcement:
language_code <- "en-US"voice_name <- "en-US-AriaNeural"input_file <- "announcement_english.txt"
output_file <- "Announcement_English.mp3"
For Hindi announcement:
language_code <- "hi-IN"voice_name <- "hi-IN-SwaraNeural"input_file <- "announcement_hindi.txt"
output_file <- "Announcement_Hindi.mp3"
For Tamil announcement:
language_code <- "ta-IN"voice_name <- "ta-IN-PallaviNeural"input_file <- "announcement_tamil.txt"
output_file <- "Announcement_Tamil.mp3"
| Problem | Solution |
|---|---|
| "Python not found" | Install Python and check "Add to PATH" |
| "edge-tts not found" | Run pip install edge-tts in Command Prompt |
| "Input file not found" | Check file is in correct folder with correct name |
| "No sound in audio" | Check text file has content, not empty |
| "Garbled audio" | Save text file with UTF-8 encoding |
Text preparation:
Speed adjustment:
"+0%""+20%""+50%""-20%"File organization:
Book_Title_2025_01_14.mp3This system is completely free, works offline after initial setup, and supports 140+ languages. Perfect for libraries serving diverse communities! 📚🎧
This documentation provides everything you need to install, configure, and operate the Library QR Gate Register System.
Library QR Gate Register (Wordpress Plugin) DocumentationVersion: 1.5
Download: Click here
Core Function: QR-based automated entry/exit tracking with live occupancy and bulk member notification.
1. Installation & SetupCreate Folder: Navigate to /wp-content/plugins/ and create a folder named library-gate-register.
Create File: Create a file inside named library-gate-register.php.
Paste Code: Paste the Version 1.5 code provided in the previous message into this file.
Activate: Go to WordPress Dashboard > Plugins and click Activate on "Library QR Gate Register".
HTTPS: Your website must have an SSL certificate (https://) for the browser to allow camera access.
SMTP: For bulk emails, install the WP Mail SMTP plugin to ensure QR codes are not marked as spam.
2. Configuration (Admin)Go to Library Register > Library Gates in your sidebar. Use the following format:
Use a Colon (:) to separate a floor from its gates.
Use a Comma (,) to separate multiple gates.
Put each floor on a new line.
Example:
Ground Floor: Main Gate, Cafe Gate
First Floor: Study Wing, Lab Entrance
3. Shortcode Reference| Shortcode | Purpose | Visibility |
[library_qr] |
Displays the user's personal Digital ID & QR Code. | Logged-in Members |
[library_scanner] |
Opens the camera to scan member codes. | Admin/Staff Only |
"My Library Pass" Page: Create a page for students and paste [library_qr]. Link this in your member menu.
"Staff Scanner" Page: Create a private page for library staff and paste [library_scanner].
4. Bulk Emailing SystemGo to Library Register > Visit Reports.
Click the button: "
Send QR to All Users".
The system will loop through all registered WordPress members and send a professionally designed HTML email containing their unique QR code.
5. Reports & AnalyticsAccessible via Library Register > Visit Reports.
Live Status: Users currently inside are marked with a green "● Active" dot.
Duration: The system automatically calculates total time spent once the user scans "Out."
CSV Export: Click "
Export CSV" to download all data for use in Microsoft Excel or Google Sheets.
Scan 1: If the user is not in the library, the system logs a Check-In.
Scan 2: If the user is already "Active," the next scan logs a Check-Out and calculates the time.
Live Occupancy: The scanner screen displays a real-time count of people currently on that specific floor.
6. Gate Hardware SetupMount a tablet at each gate.
Open the Staff Scanner Page created in Step 3.
Select the Current Location (e.g., First Floor | Lab Entrance) from the dropdown.
The device is now a dedicated scanner for that specific gate.
7. TroubleshootingCamera won't open: Check that the page is loaded over https://. Ensure you have granted camera permissions to the browser.
User not found: Ensure the member is registered in WordPress with the same email used for the QR code.
Emails not arriving: Check your WP Mail SMTP settings. Many hosting providers block default PHP mail to prevent spam.
© 2026 Created by Dr. Badan Barman.
Powered by

Comment Wall (1 comment)
You need to be a member of LIS Links to add comments!
Join LIS Links
Happy Birthday to u Gopal.