Script | Spoken-Tutorial - User contributions [en]

Koha Library Software

2026-03-23T04:11:02Z

VaibhaviS:

=='''Koha Library Management Software'''==

'''Koha''' is a first '''open source Integrated Library System (ILS)''', used world-wide and was created in 1999 by Katipo Communications. It is a library standard compliant like '''MARC21/UNIMARC, Unicode, Z39.50, ILL''', etc. The first installation went live in January 2000.

'''Koha''' allows total customization and complete control of library data at a fraction of the cost of a proprietary system and is serving the needs of a diverse range of libraries from academic to the public and from legal and research to corporate and specialist libraries. Thousands of '''Koha''' users are already benefiting from a vibrant and enthusiastic open source community and an '''ILS''' that will never leave them out of date. It has been partially translated into 62 languages.

'''Koha’s''' main strength is its web accessibility and ease of use. Libraries do not have to install the software on staff and user terminals. '''Koha''' supports all library house keeping activities such as '''Acquisition, Cataloging, Circulation, Serial Control, Patron Management, and OPAC'''. It also supports '''Web 2.0 tools'''. Thus, '''Koha''' can be readily configured to the needs of each library and is updated with new features frequently.

'''Koha''' '''24.05''' was released on May 28, 2024 is the '''open-source Integrated Library System (ILS)''' with key improvements, including enhanced MARC record handling, faster search functionality, and streamlined cataloging workflows. It also features better reporting tools, numerous bug fixes, and a more user-friendly interface. Additionally, it introduces advanced library administration options for managing branches, circulation policies, and user permissions, improving overall system performance and usability.

The '''Spoken Tutorial''' effort for '''Koha Library Software''' '''series''' has been contributed by '''Ms. Vaibhavi Satardekar''', and '''Ms. Maya Hans''' from the '''Spoken Tutorial Project, IIT Bombay'''. The content inputs were given by '''Dr. Manju Naika Central Library, IIT- Bombay''' and domain reviews were done by '''Ms. Samruddhi Hawaldar, Central Library, IIT-Bombay'''. Novice check for the tutorials was done by '''Ms. Ketki Bhamble'''. The entire series of Koha has been edited by '''Arvind Pillai, Spoken Tutorial Project, IIT Bombay'''.

'''Learners''': Library Science students and Library Staff who wish to create a Koha library for their institute.

=='''Basic Level'''==

----

'''1. Create Virtual Machine using WSL'''

*Install WSL

*Install Ubuntu on WSL

*Create and run a virtual Linux environment on WSL

'''2. Koha Library Management System on Ubuntu Linux OS 24.05'''

* Update system packages
* Add Koha 24.05 repository
* Install Koha package
* Modify port configuration
* Setup database (MariaDB)
* Enable Apache module
* Create Koha instance
* Configure database access
* Complete Koha setup

'''3. Koha Web Installation and Onboarding'''

* Koha Web Installer
** Perl modules confirmation
** Database settings
** Database setup
** Basic configuration settings
** MARC21 configuration
** Optional configuration
* Onboarding
** Library code setup
** Library contact details
** Create an admin account (Superlibrarian)
** Create item type
** Create circulation rules

'''4. Add a new library'''

* Add a new library
* Fill in the form
** Fill in the Library code Library Contact Details
* Add a general email id for the created Library to send messages and updates
* Add Reply-To mail to receive reply messages
* Fill in the URL to link the library name to the holdings table on the OPAC
** Enter OPAC details
** Edit Library details

'''5. Modify a library'''

* Introduction to Koha administration
* Access the libraries page
* View the list of libraries
* Select the library to modify
** Find the action options
** Choose the edit option
** Fill in the OPAC details
** Update library details
* Save the changes
* Confirm modification success

'''6. Create a Library Group'''

* Access library groups
* Add a new group
** Enter group title and description
** Configure group options
** Save the group
** Confirmation message
** Edit or manage group options
* Add a sub-group
** Enter sub-group title and description
** Save the sub-group

'''7. Add a new patron category'''

* Add a new patron category
* Access patron categories
* Open new category form
* Fill mandatory fields
** Set enrollment period
** Specify age limits
** Apply enrollment fees
** Configure notification settings
* Define category type and library limitations
* Set OPAC permissions

'''8. Add new patron'''

* Create a new patron
* Select patron type
** Enter patron identity details
** Provide address and contact information
** Configure registration and expiry dates
** Define OPAC/Staff login credentials
** Save patron record
* Set permissions to the patron
* Modify patron details
* Save modified details

'''9. Add an New Item type'''

* Introduction to item types in Koha
* Navigate to item types in Koha
* Create a new item type
** Setup item type details
** Choose an icon for the item type
** Hide in OPAC feature
** Not for loan option
** Set up rental and replacement costs
** Configure check-in message and SIP media type
* Save and manage item types

'''10. Create MARC framework'''

* About MARC frameworks
* Create a MARC framework
* Create a MARC bibliographic framework
* Add new framework
** Framework code and description
* About MARC framework tags
* Edit a tag
* System preferences
* Enable authority preferences
* Save preferences

'''11. Set currency'''

* Acquisition parameters
* Currencies and exchange rates
* Add New currency
** Currency
** Rate
** Symbol
** ISO code
* Active currency
* Edit currency

'''12. Add a Budget'''

* Introduction to budget
* Access the budget module
* Add a new budget
** Set time period
** Allocate budget amount
** Activate budget
* Save budget details

'''13. Allocate Funds'''

* Access Acquisitions module
* Navigate to budgets
* Select budget for allocation
* Create new fund
** Enter fund details
** Set warnings
** Choose library
* Submit the allocation
'''14. Duplicate a Budget'''

* Introduction to duplicate budget
* Access the acquisition parameters
* Select budget for duplication
** Set time period
** Adjust budget amount
** Configure additional options
* Save budget details

'''15. Place Order For a Book'''

* Access system preferences
* Add a new vendor
* Acquisition options
* Create a basket
** Add orders to the basket
** Budget and fund usage alerts
* Close the basket
* Receive shipments
* View receipt summary

'''16. Close a Budget'''

* Access Acquisitions module
* Locate the budget
** Select the close option
** Move unreceived orders
** Unspent funds
* Finalize the process
* Closure report

'''17. Cataloging'''

* Access Cataloging module
* Add a new record
** MARC record initialization
** ISBN entry
** Add cataloging source
** Title and author information
** Physical description and subject tags
** Koha item type
* Save MARC record
* Add item details

'''18. System Preferences'''

* Access system preferences
** Configure enhanced content settings
* Save enhanced content preferences
* Navigate to OPAC preferences
** Update OPAC appearance settings
** Configure OPAC features
** Update OPAC privacy settings
* Save OPAC preferences

'''19. Circulation and fine rules'''

* Access Koha staff interface
* Set Circulation and fine rules
** Customize circulation rules
* Save and clone the rules

'''20. Checkout Checkin'''

* Checkout process
* View checkout details
* Renewing items
* Check in item

'''21. OPAC'''

* Access the OPAC page
* Perform a basic search
* Sort search results
* View item availability
* Refine your search
* Advanced search option
* Use multiple search criteria
** Keyword
** Subject
** Title
** Author
** Publisher
** ISBN
* Set Filters for item type and language
* Use more search options

'''22. Access to Library Account on Web'''

* Access the OPAC page
* Login into the account
* Patron details overview
* Navigating the patron account tabs
* View items in the cart
* Add items to lists
* View checkout history
* Make a purchase suggestion

'''23. Catalog Serials'''

* Introduction to Serials module
* Add MARC record for Serial
* Add item details for Serial
* Verify the cataloging

'''24. Add subscription for serials'''

* Add a new serial subscription
* Select vendor
* Enter subscription details
* Review and save subscription

'''25. Receive serials'''

* Search for serial title
* Receive serial
* Update issue status

'''26. Configure a Claim Notice'''

* Create a New Claim Notice
* Compose the Email
* Save the Notice

'''27. Send Claim Notice'''

* Search serial title
* Claim late serials
* Send claims to vendor

'''28. Check Expiration and Renew Serial'''

* Search Expired Serial
* Check Expiration Date
* Renew Serial

'''29. Add a patron image'''

* Setting patron image preferences
* Search patron
* Add patron image
* Upload the patron image

'''30. Create Spine Label Template'''

* Create a Spine Label Template
* Configure Label Dimensions and Margins
* Save the Template

'''31. Create Spine Label Layout'''

* Create a Spine Label Layout
* Configure Label Dimensions
* Save the Layout

'''32. Create Spine Label Batch'''

* Create a Label Batch
* Add Barcode
* Export Labels
* Download PDF

=='''Intermediate Level'''==
----

'''33. Import Patron Data'''

* Open the Tools module
* Download the CSV file
* Prepare the CSV file
* Upload the CSV file
* Verify the imported patrons

'''34. Set Z39.50 server'''

* Introduction of Z39.50
* Add a new Z39.50 server
* Get server details from IRSpy
* Select a target server
* Save the form

'''35. Copy Cataloging using Z39.50'''

* Open the Z39.50/SRU search
* Select the search criteria
* View and import the search results
* Edit the MARC record
* Save and add item details

'''36. Place hold through staff interface'''

* Login with staff credentials

* Search for the item
* Find the specific item
* Place the hold
* Search the patron
* Choose the pickup location
* Confirm the hold
* Check the hold status

'''37. Place hold on an item through OPAC'''

* Open OPAC
* Search for the Item
* Select the Specific Item
* Place hold on an item
* Login OPAC
* Choose the pickup location
* Confirm the hold
* Check the hold status

'''38. Make purchase suggestion using Koha'''

* Introduction to purchase suggestion
* Search the patron
* Add new purchase suggestion
* Submit the suggestion

'''39. Make purchase suggestion through OPAC'''

* Login OPAC
* Make purchase suggestion
* Save purchase suggestion

'''40. Manage Purchase Suggestion'''

* Overview of the permissions required
* View pending suggestions on staff dashboard
* Approve a purchase suggestion
* View the result

'''41. Configure Patron Discharge Certificate'''

* Introduction to discharge certificate
* Enable the discharge feature
* Customize the discharge notice
* Save the notice

'''42. Issue Patron Discharge Certificate'''

* Access the patron account
* Verify the checkout details
* Generate the discharge certificate

=='''Advance Level'''==

----

'''43. Create Guided Reports'''

* Access the reports module
* Choose create a guided report
* Step by step build a report
* Save the report

'''44. Create SQL Report'''

* Access the reports module
* Choose create SQL report
* Type and save the SQL code
* Run the report
'''45. Run Saved Report'''

* Access the reports module
* Choose create SQL report
* Type and save the SQL code
* Run the report

'''46. Download MarcEditor on Windows'''

* Background – Why MarcEditor is needed
* Steps to Download MarcEdit software

'''47. Install MarcEditor on Windows'''

* Run MarcEdit software
* Install MarcEditor

'''48. Extract Excel to Marc Codefile'''

* Download Excel codefile
* Extract Excel to MARC codefile
* Verify extracted codefile

'''49. Convert excel data to Marc 21 format'''

* Open MarcEdit 7.7
* Convert Excel to .mrk format
* Import file to view Data Snapshot
* Map the Fields to MARC21 tags
* Join the common subfields
* Save template

'''50. Compile .mrk into .mrc file'''

* Open MarcEdit 7.7
* Open the .mrk file
* Compile the .mrk file into a MARC file (.mrc)
* Save the compiled MARC file

'''51. Import MARC file into Koha'''

* Access cataloging module
* Stage MARC records for import
* Testdata file upload
* Manage staged MARC records
* Ensure imported records

Koha Library Software

2026-03-23T04:10:19Z

VaibhaviS: Created page with " =='''Koha Library Management Software'''== '''Koha''' is a first '''open source Integrated Library System (ILS)''', used world-wide and was created in 1999 by Katipo Comm..."

=='''Koha Library Management Software'''==

'''Koha''' is a first '''open source Integrated Library System (ILS)''', used world-wide and was

created in 1999 by Katipo Communications. It is a library standard compliant like '''MARC21/UNIMARC, Unicode, Z39.50, ILL''', etc. The first installation went live in January 2000.

'''Koha''' allows total customization and complete control of library data at a fraction of the cost of a proprietary system and is serving the needs of a diverse range of libraries from academic to the public and from legal and research to corporate and specialist libraries. Thousands of '''Koha''' users are already benefiting from a vibrant and enthusiastic open source community and an '''ILS''' that will never leave them out of date. It has been partially translated into 62 languages.

'''Koha’s''' main strength is its web accessibility and ease of use. Libraries do not have to install the software on staff and user terminals. '''Koha''' supports all library house keeping activities such as '''Acquisition, Cataloging, Circulation, Serial Control, Patron Management, and OPAC'''. It also supports '''Web 2.0 tools'''. Thus, '''Koha''' can be readily configured to the needs of each library and is updated with new features frequently.

'''Koha''' '''24.05''' was released on May 28, 2024 is the '''open-source Integrated Library System (ILS)''' with key improvements, including enhanced MARC record handling, faster search functionality, and streamlined cataloging workflows. It also features better reporting tools, numerous bug fixes, and a more user-friendly interface. Additionally, it introduces advanced library administration options for managing branches, circulation policies, and user permissions, improving overall system performance and usability.

The '''Spoken Tutorial''' effort for '''Koha Library Software''' '''series''' has been contributed by '''Ms. Vaibhavi Satardekar''', and '''Ms. Maya Hans''' from the '''Spoken Tutorial Project, IIT Bombay'''. The content inputs were given by '''Dr. Manju Naika Central Library, IIT- Bombay''' and domain reviews were done by '''Ms. Samruddhi Hawaldar, Central Library, IIT-Bombay'''. Novice check for the tutorials was done by '''Ms. Ketki Bhamble'''. The entire series of Koha has been edited by '''Arvind Pillai, Spoken Tutorial Project, IIT Bombay'''.

'''Learners''': Library Science students and Library Staff who wish to create a Koha library for their institute.

=='''Basic Level'''==

----

'''1. Create Virtual Machine using WSL'''

*Install WSL

*Install Ubuntu on WSL

*Create and run a virtual Linux environment on WSL

'''2. Koha Library Management System on Ubuntu Linux OS 24.05'''

* Update system packages
* Add Koha 24.05 repository
* Install Koha package
* Modify port configuration
* Setup database (MariaDB)
* Enable Apache module
* Create Koha instance
* Configure database access
* Complete Koha setup

'''3. Koha Web Installation and Onboarding'''

* Koha Web Installer
** Perl modules confirmation
** Database settings
** Database setup
** Basic configuration settings
** MARC21 configuration
** Optional configuration
* Onboarding
** Library code setup
** Library contact details
** Create an admin account (Superlibrarian)
** Create item type
** Create circulation rules

'''4. Add a new library'''

* Add a new library
* Fill in the form
** Fill in the Library code Library Contact Details
* Add a general email id for the created Library to send messages and updates
* Add Reply-To mail to receive reply messages
* Fill in the URL to link the library name to the holdings table on the OPAC
** Enter OPAC details
** Edit Library details

'''5. Modify a library'''

* Introduction to Koha administration
* Access the libraries page
* View the list of libraries
* Select the library to modify
** Find the action options
** Choose the edit option
** Fill in the OPAC details
** Update library details
* Save the changes
* Confirm modification success

'''6. Create a Library Group'''

* Access library groups
* Add a new group
** Enter group title and description
** Configure group options
** Save the group
** Confirmation message
** Edit or manage group options
* Add a sub-group
** Enter sub-group title and description
** Save the sub-group

'''7. Add a new patron category'''

* Add a new patron category
* Access patron categories
* Open new category form
* Fill mandatory fields
** Set enrollment period
** Specify age limits
** Apply enrollment fees
** Configure notification settings
* Define category type and library limitations
* Set OPAC permissions

'''8. Add new patron'''

* Create a new patron
* Select patron type
** Enter patron identity details
** Provide address and contact information
** Configure registration and expiry dates
** Define OPAC/Staff login credentials
** Save patron record
* Set permissions to the patron
* Modify patron details
* Save modified details

'''9. Add an New Item type'''

* Introduction to item types in Koha
* Navigate to item types in Koha
* Create a new item type
** Setup item type details
** Choose an icon for the item type
** Hide in OPAC feature
** Not for loan option
** Set up rental and replacement costs
** Configure check-in message and SIP media type
* Save and manage item types

'''10. Create MARC framework'''

* About MARC frameworks
* Create a MARC framework
* Create a MARC bibliographic framework
* Add new framework
** Framework code and description
* About MARC framework tags
* Edit a tag
* System preferences
* Enable authority preferences
* Save preferences

'''11. Set currency'''

* Acquisition parameters
* Currencies and exchange rates
* Add New currency
** Currency
** Rate
** Symbol
** ISO code
* Active currency
* Edit currency

'''12. Add a Budget'''

* Introduction to budget
* Access the budget module
* Add a new budget
** Set time period
** Allocate budget amount
** Activate budget
* Save budget details

'''13. Allocate Funds'''

* Access Acquisitions module
* Navigate to budgets
* Select budget for allocation
* Create new fund
** Enter fund details
** Set warnings
** Choose library
* Submit the allocation
'''14. Duplicate a Budget'''

* Introduction to duplicate budget
* Access the acquisition parameters
* Select budget for duplication
** Set time period
** Adjust budget amount
** Configure additional options
* Save budget details

'''15. Place Order For a Book'''

* Access system preferences
* Add a new vendor
* Acquisition options
* Create a basket
** Add orders to the basket
** Budget and fund usage alerts
* Close the basket
* Receive shipments
* View receipt summary

'''16. Close a Budget'''

* Access Acquisitions module
* Locate the budget
** Select the close option
** Move unreceived orders
** Unspent funds
* Finalize the process
* Closure report

'''17. Cataloging'''

* Access Cataloging module
* Add a new record
** MARC record initialization
** ISBN entry
** Add cataloging source
** Title and author information
** Physical description and subject tags
** Koha item type
* Save MARC record
* Add item details

'''18. System Preferences'''

* Access system preferences
** Configure enhanced content settings
* Save enhanced content preferences
* Navigate to OPAC preferences
** Update OPAC appearance settings
** Configure OPAC features
** Update OPAC privacy settings
* Save OPAC preferences

'''19. Circulation and fine rules'''

* Access Koha staff interface
* Set Circulation and fine rules
** Customize circulation rules
* Save and clone the rules

'''20. Checkout Checkin'''

* Checkout process
* View checkout details
* Renewing items
* Check in item

'''21. OPAC'''

* Access the OPAC page
* Perform a basic search
* Sort search results
* View item availability
* Refine your search
* Advanced search option
* Use multiple search criteria
** Keyword
** Subject
** Title
** Author
** Publisher
** ISBN
* Set Filters for item type and language
* Use more search options

'''22. Access to Library Account on Web'''

* Access the OPAC page
* Login into the account
* Patron details overview
* Navigating the patron account tabs
* View items in the cart
* Add items to lists
* View checkout history
* Make a purchase suggestion

'''23. Catalog Serials'''

* Introduction to Serials module
* Add MARC record for Serial
* Add item details for Serial
* Verify the cataloging

'''24. Add subscription for serials'''

* Add a new serial subscription
* Select vendor
* Enter subscription details
* Review and save subscription

'''25. Receive serials'''

* Search for serial title
* Receive serial
* Update issue status

'''26. Configure a Claim Notice'''

* Create a New Claim Notice
* Compose the Email
* Save the Notice

'''27. Send Claim Notice'''

* Search serial title
* Claim late serials
* Send claims to vendor

'''28. Check Expiration and Renew Serial'''

* Search Expired Serial
* Check Expiration Date
* Renew Serial

'''29. Add a patron image'''

* Setting patron image preferences
* Search patron
* Add patron image
* Upload the patron image

'''30. Create Spine Label Template'''

* Create a Spine Label Template
* Configure Label Dimensions and Margins
* Save the Template

'''31. Create Spine Label Layout'''

* Create a Spine Label Layout
* Configure Label Dimensions
* Save the Layout

'''32. Create Spine Label Batch'''

* Create a Label Batch
* Add Barcode
* Export Labels
* Download PDF

=='''Intermediate Level'''==
----

'''33. Import Patron Data'''

* Open the Tools module
* Download the CSV file
* Prepare the CSV file
* Upload the CSV file
* Verify the imported patrons

'''34. Set Z39.50 server'''

* Introduction of Z39.50
* Add a new Z39.50 server
* Get server details from IRSpy
* Select a target server
* Save the form

'''35. Copy Cataloging using Z39.50'''

* Open the Z39.50/SRU search
* Select the search criteria
* View and import the search results
* Edit the MARC record
* Save and add item details

'''36. Place hold through staff interface'''

* Login with staff credentials

* Search for the item
* Find the specific item
* Place the hold
* Search the patron
* Choose the pickup location
* Confirm the hold
* Check the hold status

'''37. Place hold on an item through OPAC'''

* Open OPAC
* Search for the Item
* Select the Specific Item
* Place hold on an item
* Login OPAC
* Choose the pickup location
* Confirm the hold
* Check the hold status

'''38. Make purchase suggestion using Koha'''

* Introduction to purchase suggestion
* Search the patron
* Add new purchase suggestion
* Submit the suggestion

'''39. Make purchase suggestion through OPAC'''

* Login OPAC
* Make purchase suggestion
* Save purchase suggestion

'''40. Manage Purchase Suggestion'''

* Overview of the permissions required
* View pending suggestions on staff dashboard
* Approve a purchase suggestion
* View the result

'''41. Configure Patron Discharge Certificate'''

* Introduction to discharge certificate
* Enable the discharge feature
* Customize the discharge notice
* Save the notice

'''42. Issue Patron Discharge Certificate'''

* Access the patron account
* Verify the checkout details
* Generate the discharge certificate

=='''Advance Level'''==

----

'''43. Create Guided Reports'''

* Access the reports module
* Choose create a guided report
* Step by step build a report
* Save the report

'''44. Create SQL Report'''

* Access the reports module
* Choose create SQL report
* Type and save the SQL code
* Run the report
'''45. Run Saved Report'''

* Access the reports module
* Choose create SQL report
* Type and save the SQL code
* Run the report

'''46. Download MarcEditor on Windows'''

* Background – Why MarcEditor is needed
* Steps to Download MarcEdit software

'''47. Install MarcEditor on Windows'''

* Run MarcEdit software
* Install MarcEditor

'''48. Extract Excel to Marc Codefile'''

* Download Excel codefile
* Extract Excel to MARC codefile
* Verify extracted codefile

'''49. Convert excel data to Marc 21 format'''

* Open MarcEdit 7.7
* Convert Excel to .mrk format
* Import file to view Data Snapshot
* Map the Fields to MARC21 tags
* Join the common subfields
* Save template

'''50. Compile .mrk into .mrc file'''

* Open MarcEdit 7.7
* Open the .mrk file
* Compile the .mrk file into a MARC file (.mrc)
* Save the compiled MARC file

'''51. Import MARC file into Koha'''

* Access cataloging module
* Stage MARC records for import
* Testdata file upload
* Manage staged MARC records
* Ensure imported records

Koha-Library-Software/C2/Create-Virtual-Machine-using-WSL/English

2026-03-12T11:39:45Z

VaibhaviS:

'''Title of the Script:''' Create Virtual Machine using WSL

'''Author: '''Maya Hans and Vaibhavi Satardekar

'''Keywords:''' Windows Subsystem for Linux (WSL), Virtual Machine in WSL, Linux on Windows, Ubuntu on WSL, Linux Environment on Windows, Install WSL on Windows 11, Video Tutorial.

{|border=1
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide Number 1'''

'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Create a Virtual Machine using WSL'''.
|-
|| '''Slide Number 2'''
'''Learning Objectives'''

In this tutorial, we will learn about '''WSL'''
We will also learn how to:
* Install '''WSL'''
* Install Ubuntu on '''WSL'''
* Create and run a virtual Linux environment on '''WSL'''

|| In this tutorial, we will learn about '''WSL'''
We will also learn how to:
* Install '''WSL'''
* Install Ubuntu on '''WSL'''
* Create and run a virtual Linux environment on '''WSL'''
|-
|| '''Slide Number 3'''

'''System Requirements'''

To record this tutorial, I am using:
*'''Windows 11 Pro Operating System'''
* A working internet connection

|| To record this tutorial, I am using:
* A '''Windows 11 pro Operating System ''' and,
* A working internet connection.

|-
|| '''Slide Number 4'''

'''Pre-requisites'''

To follow this tutorial,
* Learners should have basic knowledge of using '''Command Prompt'''

|| To follow this tutorial,
* Learners should have basic knowledge of using '''Command Prompt'''.

|-
|| '''Slide Number 5'''

'''What is WSL?'''

'''WSL''' stands for '''Windows Subsystem for Linux'''
* It allows users to run a '''Linux''' environment directly on '''Windows'''
* It works without using traditional virtual machines like '''VirtualBox''' or '''VMware'''
* '''WSL''' is lightweight, fast, and easy to use environment

|| Let’s understand what '''WSL''' is.

'''WSL''' stands for '''Windows Subsystem for Linux'''.
* It allows users to run a '''Linux''' environment directly on '''Windows'''.
* It works without using traditional virtual machines like '''VirtualBox''' or '''VMware'''.
* '''WSL''' is lightweight, fast, and easy to use environment.

|-
|| Narration only

Click on '''Start menu>>'''Right-click >>'''Run as Administrator'''

|| Now, let’s begin the installation.

Click on the '''Start menu'''.

In the search box, let’s type '''Command Prompt'''.

Right-click on it and select '''Run as administrator'''.
|-
|| Highlight '''User Account Control''' window.

'''Do you want to allow this app to make changes to your device?'''

Click on '''Yes'''.

Highlight '''Administrator Command Prompt''' window

Type: '''wsl --install ''' and press '''Enter'''

Narration only

Highlight '''Operation completed successfully'''
||The''' User Account Control''' window opens.

A message, '''Do you want to allow this app to make changes to your device?''' appears.

Click on the '''Yes''' button to continue.

The '''Administrator Command Prompt''' window opens.

Type the following command and press '''Enter'''.

This command will:
* Enable '''WSL''' and,
* Install the default '''Linux''' distribution, '''Ubuntu'''.

Please wait for the installation to complete.

The message '''Operation completed successfully''' appears.
|-
|| Narration only

Type: '''wsl --install ubuntu-22.04''' and press '''Enter'''.

Highlight '''Ubuntu 22.04 LTS'''

Narration only
|| Now, let us install '''Ubuntu 22 point 04'''.

Type the following command and press '''Enter'''.

'''Ubuntu 22 point 04 LTS''' will start launching.

The installation may take few minutes.
|-
|| Narration only

Highlight the '''new UNIX username'''
|| Once the installation is complete, '''Ubuntu''' will launch automatically.

You will then be prompted to create a '''new UNIX username'''.
|-
|| '''Username''': '''ubuntu'''

'''Password''': '''ubuntu123'''

Retype the password '''ubuntu123''' and press '''Enter'''
|| Let us type the username as '''ubuntu''' and press '''Enter'''.

Let’s set '''password''' as '''ubuntu123''' and press '''Enter'''.

I will retype the same password and press '''Enter'''.
|-
|| Highlight '''Installation successful'''

Highlight root path: '''ubuntu@DESKTOP-G4R5B47:~$'''

Highlight Changed root path: '''C:\Windows\System32>'''
|| After this, you will see the message '''Installation successful'''.

Notice that the root path has changed.

This confirms that the '''Ubuntu''' instance has been created successfully.

Now, type '''exit''' on the command prompt to log out from the running '''Ubuntu 22 point 04'''.

We can see that the command prompt path has changed.
|-
|| Narration only

Type: '''wsl -l -v''' and press '''Enter'''.

Highlight the output

|| Now, let us verify the installed version of '''WSL'''.

Type the following command and press '''Enter'''.

The output shows that the status is '''Stopped''' and the version is '''2'''.
|-
|| Type: '''wsl -d ubuntu-22.04'''

Highlight the changed root path: '''ubuntu@DESKTOP-G4R5B47:/mnt/c/Windows/System32$'''

Narration only
|| Now, type the following command to start '''Ubuntu 22 point 04'''.

Once it starts, notice that the root path has changed.

With this we come to the end of this tutorial.

In the next tutorial we will learn to install '''Koha'''.
|-
|| '''Slide Number 6'''

'''Summary'''

In this tutorial, we learnt about '''WSL'''
We also learnt how to:
* Install '''WSL'''
* Install Ubuntu on '''WSL'''
* Create and run a virtual Linux environment on '''WSL'''

|| Let’s quickly recap.
|-
|| '''Slide Number 7'''

'''Thank you'''
|| Thank you for joining.
|-
|}

Koha-Library-Software/C2/Create-Virtual-Machine-using-WSL/English

2026-03-05T04:27:55Z

VaibhaviS:

'''Title of the Script:''' Create Virtual Machine using WSL

'''Author: '''Maya Hans and Vaibhavi Satardekar

'''Keywords:''' Windows Subsystem for Linux (WSL), Virtual Machine in WSL, Linux on Windows, Ubuntu on WSL, Linux Environment on Windows, Install WSL on Windows 11, Video Tutorial.

{|border=1
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide Number 1'''

'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Create a Virtual Machine using WSL'''.
|-
|| '''Slide Number 2'''
'''Learning Objectives'''

In this tutorial, we will learn to:
*Define '''WSL'''
*Install '''WSL'''
*Install '''Ubuntu''' on '''WSL'''
*Create and run a virtual '''Linux''' environment using '''WSL'''

|| In this tutorial, we will learn to:
*Define '''WSL'''
*Install '''WSL'''
*Install '''Ubuntu''' on '''WSL''' and
*Create and run a virtual '''Linux''' environment using '''WSL'''.

|-
|| '''Slide Number 3'''

'''System Requirements'''

To record this tutorial, I am using:
*'''Windows 11 Pro Operating System'''
*A working internet connection

|| To record this tutorial, I am using:
*A '''Windows 11 pro Operating System ''' and,
*A working internet connection.

|-
|| '''Slide Number 4'''

'''Pre-requisites'''

To follow this tutorial,
*Learners should have basic knowledge of using '''Command Prompt'''

|| To follow this tutorial,
*Learners should have basic knowledge of using '''Command Prompt'''.

|-
|| '''Slide Number 5'''

'''What is WSL?'''

'''WSL''' stands for '''Windows Subsystem for Linux'''
*It allows users to run a '''Linux''' environment directly on '''Windows'''
*It works without using traditional virtual machines like '''VirtualBox''' or '''VMware'''
*'''WSL''' is lightweight, fast, and easy to use environment

|| Let’s understand what '''WSL''' is.

'''WSL''' stands for '''Windows Subsystem for Linux'''.
*It allows users to run a '''Linux''' environment directly on '''Windows'''.
*It works without using traditional virtual machines like '''VirtualBox''' or '''VMware'''.
*'''WSL''' is lightweight, fast, and easy to use environment.

|-
|| Narration only

Click on '''Start menu>>'''Right-click >>'''Run as Administrator'''

|| Now, let’s begin the installation.

Click on the '''Start menu'''.

In the search box, let’s type '''Command Prompt'''.

Right-click on it and select '''Run as Administrator'''.
|-
|| Highlight '''User Account Control''' window.

'''Do you want to allow this app to make changes to your device?'''

Click on '''Yes'''.

Highlight '''Administrator Command Prompt''' window

Type: '''wsl --install ''' and press '''Enter'''

Narration only

Highlight '''Operation completed successfully'''
||The''' User Account Control''' window opens.

A message, '''Do you want to allow this app to make changes to your device?''' appears.

Click on the '''Yes''' button to continue.

The '''Administrator Command Prompt''' window opens.

Type the following command and press '''Enter'''.

This command will:
*Enable '''WSL''' and,
*Install the default '''Linux''' distribution, '''Ubuntu'''.

Please wait for the installation to complete.

The message '''Operation completed successfully '''appears.
|-
|| Narration only

Type: '''wsl --install ubuntu-22.04''' and press '''Enter'''.

Highlight '''Ubuntu 22.04 LTS'''

Narration only
|| Now, let us install '''Ubuntu 22 point 04'''.

Type the following command and press '''Enter'''.

'''Ubuntu 22 point 04 LTS''' will start launching.

The installation may take a few minutes.
|-
|| Narration only

Highlight the '''new UNIX username'''
|| Once the installation is complete, '''Ubuntu''' will launch automatically.

You will then be prompted to create a '''new UNIX username'''.
|-
|| '''Username''': '''ubuntu'''

'''Password''': '''ubuntu123'''

Retype the password '''ubuntu123''' and press '''Enter'''
|| Let us type the username as '''ubuntu''' and press '''Enter'''.
Let’s set '''password''' as '''ubuntu123''' and press '''Enter'''.

I will retype the same password and press '''Enter'''.
|-
|| Highlight '''Installation successful'''

Highlight root path: '''ubuntu@DESKTOP-G4R5B47:~$'''

Highlight Changed root path: '''C:\Windows\System32>'''
|| After this, you will see the message '''Installation successful'''.
Notice that the root path has changed.

This confirms that the '''Ubuntu''' instance has been created successfully.

Now, type '''exit''' on the command prompt to log out from the running '''Ubuntu 22 point 04'''.

We can see that the command prompt path has changed.
|-
|| Narration only

Type: '''wsl -l -v''' and press '''Enter'''.

Highlight the output

|| Now, let us verify the installed version of '''WSL'''.
Type the following command and press '''Enter'''.

The output shows that the status is '''Stopped''' and the version is '''2'''.
|-
|| Type: '''wsl -d ubuntu-22.04'''

Highlight the changed root path: '''ubuntu@DESKTOP-G4R5B47:/mnt/c/Windows/System32$'''

Narration only
|| Now, type the following command to start '''Ubuntu 22 point 04'''.

Once it starts, notice that the root path has changed.

With this we come to the end of this tutorial.

In the next tutorial we will learn to install '''Koha'''.
|-
|| '''Slide Number 6'''

'''Summary'''

In this tutorial we learned how to:
*Define '''WSL'''
*Install '''WSL'''
*Install '''Ubuntu''' on '''WSL'''
*Create and run a virtual '''Linux''' environment using '''WSL'''

||
Let’s quickly recap.
|-
|| '''Slide Number 7'''

'''Thank you'''
|| Thank you for joining.
|-
|}

Koha-Library-Software/C2/Create-Virtual-Machine-using-WSL/English

2026-03-05T04:23:25Z

VaibhaviS: Created page with "'''Title of the Script: Create Virtual Machine using WSL''' '''Author: '''Maya Hans and Vaibhavi Satardekar '''Keywords:''' Windows Subsystem for Linux (WSL), Virtual Machi..."

'''Title of the Script: Create Virtual Machine using WSL'''

'''Author: '''Maya Hans and Vaibhavi Satardekar

'''Keywords:''' Windows Subsystem for Linux (WSL), Virtual Machine in WSL, Linux on Windows, Ubuntu on WSL, Linux Environment on Windows, Install WSL on Windows 11, Video Tutorial.

{|border=1
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide Number 1'''

'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Create a Virtual Machine using WSL'''.
|-
|| '''Slide Number 2'''
'''Learning Objectives'''

In this tutorial, we will learn to:
*Define '''WSL'''
*Install '''WSL'''
*Install '''Ubuntu''' on '''WSL'''
*Create and run a virtual '''Linux''' environment using '''WSL'''

|| In this tutorial, we will learn to:
*Define '''WSL'''
*Install '''WSL'''
*Install '''Ubuntu''' on '''WSL''' and
*Create and run a virtual '''Linux''' environment using '''WSL'''.

|-
|| '''Slide Number 3'''

'''System Requirements'''

To record this tutorial, I am using:
*'''Windows 11 Pro Operating System'''
*A working internet connection

|| To record this tutorial, I am using:
*A '''Windows 11 pro Operating System ''' and,
*A working internet connection.

|-
|| '''Slide Number 4'''

'''Pre-requisites'''

To follow this tutorial,
*Learners should have basic knowledge of using '''Command Prompt'''

|| To follow this tutorial,
*Learners should have basic knowledge of using '''Command Prompt'''.

|-
|| '''Slide Number 5'''

'''What is WSL?'''

'''WSL''' stands for '''Windows Subsystem for Linux'''
*It allows users to run a '''Linux''' environment directly on '''Windows'''
*It works without using traditional virtual machines like '''VirtualBox''' or '''VMware'''
*'''WSL''' is lightweight, fast, and easy to use environment

|| Let’s understand what '''WSL''' is.

'''WSL''' stands for '''Windows Subsystem for Linux'''.
*It allows users to run a '''Linux''' environment directly on '''Windows'''.
*It works without using traditional virtual machines like '''VirtualBox''' or '''VMware'''.
*'''WSL''' is lightweight, fast, and easy to use environment.

|-
|| Narration only

Click on '''Start menu>>'''Right-click >>'''Run as Administrator'''

|| Now, let’s begin the installation.

Click on the '''Start menu'''.

In the search box, let’s type '''Command Prompt'''.

Right-click on it and select '''Run as Administrator'''.
|-
|| Highlight '''User Account Control''' window.

'''Do you want to allow this app to make changes to your device?'''

Click on '''Yes'''.

Highlight '''Administrator Command Prompt''' window

Type: '''wsl --install ''' and press '''Enter'''

Narration only

Highlight '''Operation completed successfully'''
||The''' User Account Control''' window opens.

A message, '''Do you want to allow this app to make changes to your device?''' appears.

Click on the '''Yes''' button to continue.

The '''Administrator Command Prompt''' window opens.

Type the following command and press '''Enter'''.

This command will:
*Enable '''WSL''' and,
*Install the default '''Linux''' distribution, '''Ubuntu'''.

Please wait for the installation to complete.

The message '''Operation completed successfully '''appears.
|-
|| Narration only

Type: '''wsl --install ubuntu-22.04''' and press '''Enter'''.

Highlight '''Ubuntu 22.04 LTS'''

Narration only
|| Now, let us install '''Ubuntu 22 point 04'''.

Type the following command and press '''Enter'''.

'''Ubuntu 22 point 04 LTS''' will start launching.

The installation may take a few minutes.
|-
|| Narration only

Highlight the '''new UNIX username'''
|| Once the installation is complete, '''Ubuntu''' will launch automatically.

You will then be prompted to create a '''new UNIX username'''.
|-
|| '''Username''': '''ubuntu'''

'''Password''': '''ubuntu123'''

Retype the password '''ubuntu123''' and press '''Enter'''
|| Let us type the username as '''ubuntu''' and press '''Enter'''.
Let’s set '''password''' as '''ubuntu123''' and press '''Enter'''.

I will retype the same password and press '''Enter'''.
|-
|| Highlight '''Installation successful'''

Highlight root path: '''ubuntu@DESKTOP-G4R5B47:~$'''

Highlight Changed root path: '''C:\Windows\System32>'''
|| After this, you will see the message '''Installation successful'''.
Notice that the root path has changed.

This confirms that the '''Ubuntu''' instance has been created successfully.

Now, type '''exit''' on the command prompt to log out from the running '''Ubuntu 22 point 04'''.

We can see that the command prompt path has changed.
|-
|| Narration only

Type: '''wsl -l -v''' and press '''Enter'''.

Highlight the output

|| Now, let us verify the installed version of '''WSL'''.
Type the following command and press '''Enter'''.

The output shows that the status is '''Stopped''' and the version is '''2'''.
|-
|| Type: '''wsl -d ubuntu-22.04'''

Highlight the changed root path: '''ubuntu@DESKTOP-G4R5B47:/mnt/c/Windows/System32$'''

Narration only
|| Now, type the following command to start '''Ubuntu 22 point 04'''.

Once it starts, notice that the root path has changed.

With this we come to the end of this tutorial.

In the next tutorial we will learn to install '''Koha'''.
|-
|| '''Slide Number 6'''

'''Summary'''

In this tutorial we learned how to:
*Define '''WSL'''
*Install '''WSL'''
*Install '''Ubuntu''' on '''WSL'''
*Create and run a virtual '''Linux''' environment using '''WSL'''

||
Let’s quickly recap.
|-
|| '''Slide Number 7'''

'''Thank you'''
|| Thank you for joining.
|-
|}

Developing-Empathy/C2/Empathy/English

2026-01-19T07:32:42Z

VaibhaviS: Created page with "'''Spoken Tutorial Script – Empathy''' Keywords: empathy, beliefs, perception, story, understanding, teamwork, EduPyramids, Emotional Intelligence, video tutorial {|borde..."

'''Spoken Tutorial Script – Empathy'''

Keywords: empathy, beliefs, perception, story, understanding, teamwork, EduPyramids, Emotional Intelligence, video tutorial

{|border=1
|-
|| Visual Cue
|| Narration
|-
|| Slide 1: Title slide with logos
|| Welcome to this Spoken Tutorial on '''Empathy'''.
|-
|| Slide 2: Learning Objectives
|| In this tutorial, we will learn:
* How beliefs help us form an opinion
* What is empathy
* How to use empathy in our daily life through examples
* Why do people see the same event differently
* How empathy helps us understand others

|-
|| Scene: Three students — Rahul, Priya, and Rani — working on a group project
|| Let’s meet''' Rahul, Priya''', and''' Rani'''.

They are working together on a group project.
|-
|| Visual: Calendar shows submission date approaching
|| The time to submit the project is near.

'''Rani''' hasn’t submitted her part of the work yet.
|-
|| Rahul frowning, looking frustrated
|| '''Rahul''' gets upset and says, “'''Rani''' is irresponsible.

We can’t rely on her.”
|-
|| Priya looking concerned
|| '''Priya''' says softly, “Maybe she’s having a hard time.

Let’s ask her if she needs any help.”
|-
|| Text on screen: “Same event. Different interpretations.”
|| Did you notice?

The event is the same, but the interpretation is different.
|-
|| Visual: Notebook shows two lines: “Reality” and “Interpretation.”
|| Let’s pause and understand this.

The reality is simple.

'''Rani''' submitted her work late.
|-
|| Text highlight: “Interpretation 1 – She’s careless.” “Interpretation 2 – She might be struggling.”
|| '''Rahul''' thinks, “She is careless.”

'''Priya''' thinks, “She might be struggling with something else.”
|-
|| Visual: Brain icons over each — showing “Beliefs” shaping thoughts.
|| Why do '''Rahul''' and '''Priya''' see the same event so differently?

Because their beliefs are different.
|-
|| Flashback 1: Rahul as a child being praised for punctuality
|| Maybe '''Rahul '''grew up in a family that values discipline.

For him, being on time means respect and responsibility.
|-
|| Flashback 2: Priya comforting a friend, learning empathy
|| '''Priya''' grew up watching her mother care for others, even when they made mistakes.

For her, being kind mattered more than following rules perfectly.
|-
|| Visual: Two colored lenses over eyes — blue for Rahul, green for Priya
|| Beliefs act like lenses through which people see the world.
|-
|| Text animation: “Beliefs → Interpretation → Emotion.”
|| Our beliefs decide how we interpret events and how we feel about them.
|-
|| Visual: Rahul angry, Priya calm
|| The outcome of '''Rahul'''’s belief is anger.

The outcome of '''Priya'''’s belief is concern.
|-
|| Visual montage: parents, teachers, movies, childhood scenes
|| Each experience we live adds a new layer to the lens through which we see others

Our beliefs keep evolving as we live, learn, and meet new people.
|-
|| Scene: Later that day, Rani explains she was caring for her sick mother
|| Later that evening,''' Rani '''says, “I’m sorry.

My mother has been unwell, so I couldn’t focus on the project.”
|-
|| Visual: Rahul looks surprised, then thoughtful
|| On hearing this, '''Rahul's''' anger vanished.

He understood that '''Rani''' was going through a tough time.
|-
|| Text: “Understanding replaces judgment.”
|| When we understand someone instead of judging them, it is empathy.
|-
|| Visual: Rahul, Priya, and Rani smiling, working together again
|| Empathy doesn’t mean we agree with someone.

It means that we understand their position and what they are going through.
|-
|| Title: Empathy connects people
|| '''Rahul''' decides to support '''Rani'''.

He asks her if he can help her complete her part of the project.

When we show empathy, we turn conflict into cooperation.

We turn blame into support.

We build stronger relationships.
|-
|| '''Summary Slide'''
|| Let’s summarize what we learnt today.
* Beliefs help us form an opinion.
* Everyone has a story.
* Understanding others’ stories helps us build empathy.
* Empathy turns tension into trust.

|-
|| '''Assignment slide:'''

Title: Activity – Everyone Has a Story
|| Let’s do a reflection exercise.
|-
|| Visual: Journal template appears with 3 columns
|| For the next 1 week, every day, think of one person who upset you.

Write what happened, what you thought, and what might be their story.
|-
|| Text example on screen
|| For example:

“My friend didn’t call me back.

I thought she didn’t care.

Maybe she was tired.”
|-
|| '''End slide'''
|| This brings us to the end of this tutorial.

This tutorial is brought to you by '''EduPyramids Educational Services Private Limited , SINE IIT Bombay'''.

Thanks for watching.
|-
|}

Koha-Library-Software/C4/Import-MARC-file-into-Koha/English

2025-12-15T06:05:35Z

VaibhaviS: Created page with "'''Title of the Script: Import MARC file into Koha''' '''Author: '''Maya Hans and Vaibhavi Satardekar '''Keywords:''' Koha, Koha 24.05, Koha Library System, Staging records,..."

'''Title of the Script: Import MARC file into Koha'''

'''Author: '''Maya Hans and Vaibhavi Satardekar

'''Keywords:''' Koha, Koha 24.05, Koha Library System, Staging records, Import records, Manage staged records, TestData.mrc, UTF-8 encoding, Record management, Video Tutorial.

'''Prerequisite: '''Compile .mrk into .mrc file

{|border=1
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide Number 1'''

'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Import MARC file''' into '''Koha'''.
|-
|| '''Slide Number 2'''

'''Learning Objectives'''
*Import '''.mrc '''file into ''' Koha'''

|| In this tutorial, we will learn how to:
*Import '''.mrc''' file into ''' Koha'''.

|-
|| '''Slide Number 3'''

'''System Requirements'''
*Ubuntu Linux OS v22.04
*Koha v24.05
*Firefox v131.0.3
*A working internet connection

|| To record this tutorial, I am using the following setup.
|-
|| '''Slide Number 4'''

'''Pre-requisites'''

You should have knowledge of Library Science
|| To follow this tutorial, you should have knowledge of Library Science.
|-
|| '''Slide Number 5'''

'''Please note'''

Importing records into '''Koha''' is done in two steps-

1. '''Stage MARC records for import'''

2. '''Manage staged records'''

|| Please note, importing records into '''Koha''' is done in two steps-

1. '''Stage MARC records for import ''' and

2. '''Manage staged records'''.

|-
|| Show '''Koha''' interface

'''Username - Bella '''

'''Password - Library@1'''

'''Library: Spoken Tutorial Library'''

Click on '''Login'''
|| To import the '''MARC''' file into '''Koha''', I have logged in as a '''Superlibrarian'''.
|-
|| Narration only
|| Please note that if you have not compiled the '''.mrc''' file in an earlier tutorial.

You may use the sample file provided in the '''Code files''' link to practice this tutorial.
|-
|| Click on '''Cataloging module'''
|| On the '''Koha''' staff interface click on the '''Cataloging''' module.
|-
|| Point to '''Cataloging''' click on '''Stage records for import'''
||'''Cataloging''' page opens.

Click on '''Stage records for import'''.
|-
|| Point to '''Stage MARC records for import'''
|| '''Stage MARC records for import''' page opens.
|-
|| Point to '''Upload a file to stage''' click on '''Browse'''
|| Under the '''Upload a file to stage''' section, click on '''Browse''' adjacent to the '''File'''.
|-
|| Point to '''File Upload'''

From the left side panel click on '''Downloads'''
|| '''File Upload''' window opens.

From the left panel click on '''Downloads'''.
|-
|| Point to '''TestData.mrc''' in '''Downloads''' folder
|| Locate the '''TestData.mrc''' file.

Recall, we had created this file in one of the earlier tutorials.
|-
|| Point to '''TestData.mrc'''

Click on '''Select''' button
|| Select the '''TestData.mrc''' file.

At the top right side of the window, click on the '''Select''' button.
|-
|| Point to '''Browse'''

Point to '''TestData.mrc'''
|| We can see the '''TestData.mrc''' is selected.
|-
|| Click on '''Upload file''' button
|| Click on the '''Upload file''' button.
|-
|| Point to '''Upload progress''' bar in brown color
|| We can see the '''Upload progress''' bar.
|-
|| Cursor on '''Upload''' is complete '''100%'''
|| Once the '''Upload''' is '''100%''' complete we are prompted to fill in some details.
|-
|| Point to '''Comments about this file''' type '''Book Data'''
|| Now go to the '''Settings '''section.

In the field '''Comments about this file''', type '''Book Data'''.
|-
|| Point to
*'''Record type'''
*'''Bibliographic'''
*'''Character encoding'''
*'''Format'''

|| Note that the remaining fields of this section are auto-filled by '''Koha'''.

|-
|| Point to '''Look for existing records in catalog?'''
*'''Record matching rule'''
*'''Action if matching record found'''
*'''Action if no match is found'''

|| Scroll down to the '''Look for existing records in catalog''' section.

In this section '''Koha''' auto-filled the following fields.

So we will leave it as it is.
|-
|| Point to '''Check for embedded item record data'''

Cursor on

'''1. Yes'''

'''2. No'''
|| Under the '''Check for embedded item record data '''section we can see two radio buttons.
1.'''Yes '''and

2.'''No'''

'''Koha''' by default, selected '''Yes'''.

So, we will keep it as it is, and leave the remaining fields as such.
|-
|| Click on '''Stage for import''' at the bottom of the page

'''MARC staging''' page

Cursor on '''Job progress''' bar
|| At the bottom of the page, click on the '''Stage for import''' button.

'''MARC staging''' page opens.

The text highlighted in blue box says '''The job has been enqueued'''.

You can see a '''Job progress''' bar.

Once the progress is '''100%'''complete the bar color changes to green.
|-
|| Point to '''Job progress'''

Click on '''View batch link'''
|| After the progress is '''100% finished''' click on '''View batch link'''.
|-
|| Point to

'''Manage staged MARC records › Batch 4'''
|| '''Manage staged MARC records''' page opens.

You may see different '''Batch''' numbers on your machine.
|-
||
*'''File name: TestData.mrc'''
*'''Profile:(none)'''
*'''Comments: Book Data'''
*'''Type: Bibliographic records'''
*'''Staged: 2018-09-14 11:36:51'''
*'''Status: Staged'''

|| On this page, '''Koha''' fills the following fields with the values shown here.
|-
|| Cursor on:
*'''Matching rule applied: Do not look for matching records'''
*'''Action if matching record found: Add incoming record'''
*'''Action if no match found: Add incoming record '''
*'''Item processing: Always add items'''

Cursor on '''Apply different matching rules'''
|| Note that the following fields are also auto-filled by '''Koha'''.

You may change as per your requirement from their respective drop-downs.

I am keeping them as such.

At the bottom of this section we can see the '''Apply different matching rules''' button.

You may click on this button to avoid the duplication of the records.

I will skip this button and move ahead.
|-
|| Cursor on '''Add new record framework:'''

Select '''Book'''
|| Now locate the '''New record framework''' and select '''Books''' from the drop down.
|-
|| Narration only
|| Scroll down, we can see the list of books that we are going to import.
|-
|| Click on '''Import this batch into the catalog'''
|| Click on '''Import this batch into the catalog''' button.
|-
|| Cursor on '''Job progress'''

Cursor on page '''Details of job'''

Click on the '''Refresh''' button

Cursor on '''Status'''
|| The text highlighted in blue box says '''The job has been enqueued'''.

Once the progress is '''100%''' complete, a new page '''Details of job''' opens.

In case the '''Status''' is showing '''Started''', click on the '''Refresh''' button.

Here we can see the '''Status''' of imported data has '''Finished'''.
|-
|| Cursor on '''Report'''

Cursor on '''Completed import of records'''
|| The text highlighted in bluebox says '''Completed import of records'''.
|-
|| Cursor on
*'''Number of records added-5'''
*'''Number of records updated-0'''
*'''Number of records ignored-0'''
*'''Number of item added-0'''
*'''Number of item replaced-0'''
*'''Number of item ignored-0'''

|| Also under the '''Report''' section we can see a table with following details.
|-
|| Narration only
|| With this we have successfully imported records into '''Koha'''.
|-
|| '''Slide Number 6'''

'''Summary'''

We learned to-
*Import a '''.mrc''' file into '''Koha'''

|| Let’s quickly recap.
|-
|| '''Slide Number 7'''

'''Assignment'''
*In the previous tutorial assignment, you compiled a '''.mrk file''' into a '''.mrc file'''
*Import that '''.mrc file''' into '''Koha'''

|| As an assignment,
*In the previous tutorial assignment, you compiled a '''.mrk file''' into a '''.mrc file'''.
*Import that '''.mrc file''' into '''Koha'''.

|-
|| '''Slide Number 8'''

'''Thank you'''
|| Thank you for joining.
|-
|}

Koha-Library-Software/C4/Run-Saved-Report/English

2025-12-15T04:27:09Z

VaibhaviS: Created page with "'''Title of the Script: Run saved report'''. '''Author: '''Maya Hans and Vaibhavi Satardekar '''Keywords:''' koha, koha 24.05, koha library system, reports module, guided r..."

'''Title of the Script: Run saved report'''.

'''Author: '''Maya Hans and Vaibhavi Satardekar

'''Keywords:''' koha, koha 24.05, koha library system, reports module, guided reports wizard, create report, tabular report, report criteria, cache expiry, sql reports, saved reports, library automation, video tutorial.

'''Prerequisite: '''Create Guided Reports

{|border=1
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide Number 1'''

'''Title Slide'''
|| Welcome to this Spoken Tutorial on''' Run '''the''' saved report''' in '''Koha'''.
|-
|| '''Slide Number 2'''

'''Learning Objectives'''
* '''Run the saved report'''

|| In this tutorial, we will learn how to:
* '''Run '''the''' saved report''' in '''Koha'''.

|-
|| '''Slide Number 3'''

'''System Requirement'''
* '''Ubuntu Linux OS v22.04'''
* '''Koha v24.05'''
* '''Firefox v131.0.3'''
* '''A working internet connection'''

|| To record this tutorial, I am using the following setup.

|-
|| '''Slide Number 4'''

'''Prerequisites'''
* '''You should have knowledge of Library Science'''

|| To follow this tutorial you should have knowledge of Library Science.

|-
|| Show '''Koha''' interface

'''Username - Bella '''

'''Password - Library@1'''

'''Library: Spoken Tutorial Library'''

Click on '''Login'''
|| To run the saved reports in '''Koha '''I have logged in as a '''Superlibrarian'''.

|-
|| Click on '''Reports '''module
|| On the '''Koha''' staff interface click on the '''Reports '''module.
|-
|| Point to '''Reports''' page

Point to '''Guided reports''' Click on '''Use saved'''
|| '''Reports''' page opens.

Here under the '''Guided reports '''click on '''Use saved'''.
|-
|| Point to '''Saved reports'''

Narration only

Scroll right and go to the '''Actions '''column

Click on the '''Run''' dropdown

Point to
* '''View'''
* '''Preview SQL'''
* '''Edit'''
* '''Duplicate'''
* '''Schedule'''
* '''Delete'''

|| '''Saved reports '''page opens with a list of reports.

Remember in an earlier '''Create guided reports''' tutorial we created one '''Sample report'''.

Now we will learn to '''Run''' the report.

Scroll right and go to the '''Actions '''column.

Click on the '''Run''' dropdown button.

Here we can see options like-
* '''View'''- to view the output of the saved report.
* '''Preview SQL'''- to check the '''SQL''' query used in the report.
* '''Edit'''- to make changes in the report or query
* '''Duplicate'''- To make copy of the report which you can modify.
* '''Schedule'''- To set the report to run automatically at a chosen time.
* '''Delete'''- To remove the report permanently from '''Koha'''.

|-
|| Click on '''Run '''button.

Point to '''Sample report''' results
|| Now click on the''' Run '''button.

'''Sample report''' page opens with the total number of results.
|-
|| Narration only
|| With this we come to the end of this tutorial.
|-
|| '''Slide Number 5'''

'''Summary'''

In this tutorial we learned to-
* '''Run the saved report'''
|| Let’s quickly recap.
|-
|| '''Slide Number 6'''

'''Assignment'''
* Run the sample report created in the '''Create guided report''' assignment

|| As an assignment,

Run the sample report created in the '''Create guided report''' assignment.
|-
|| '''Slide Number 7'''

'''Thank you'''
|| Thank you for joining.
|-
|}

Koha-Library-Software/C4/Create-SQL-Report/English

2025-12-12T06:53:49Z

VaibhaviS: Created page with "'''Title of the Script: Create SQL report'''. '''Author: '''Maya Hans and Vaibhavi Satardekar '''Keywords:''' koha, koha 24.05, koha library system, reports module, guided r..."

'''Title of the Script: Create SQL report'''.

'''Author: '''Maya Hans and Vaibhavi Satardekar

'''Keywords:''' koha, koha 24.05, koha library system, reports module, guided reports wizard, create report, tabular report, report criteria, cache expiry, sql reports, saved reports, library automation, video tutorial.

'''Prerequisite: '''Create Guided Reports

{|border=1
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide Number 1'''

'''Title Slide'''
|| Welcome to this Spoken Tutorial on''' Create SQL Report''' in '''Koha'''.
|-
|| '''Slide Number 2'''

'''Learning Objectives'''
* '''Create SQL report'''

|| In this tutorial, we will learn how to:
* '''Create SQL report''' in '''Koha'''.

|-
|| '''Slide Number 3'''

'''System Requirement'''
* '''Ubuntu Linux OS v22.04'''
* '''Koha v24.05'''
* '''Firefox v131.0.3'''
* '''A working internet connection'''

|| To record this tutorial, I am using the following setup.
|-
|| '''Slide Number 4'''

'''Prerequisites'''
* '''You should have knowledge of Library Science'''

|| To follow this tutorial you should have knowledge of Library Science.
|-
|| Show '''Koha''' interface

'''Username - Bella '''

'''Password - Library@1'''

'''Library: Spoken Tutorial Library'''

Click on '''Login'''
|| To create a '''SQL''' report in '''Koha '''I have logged in as a '''Superlibrarian'''.

|-
|| '''Slide Number 5'''

'''What is SQL?'''

'''SQL '''is a '''Structured Query Language''' used to '''communicate with databases'''
* It allows to '''retrieve, add, update, or delete data''' from a database
* In '''Koha''', '''SQL''' is used in the '''Reports module''' to create '''custom reports'''

|| '''SQL '''is a '''Structured Query Language''' used to '''communicate '''with''' databases'''.
* It allows to retrieve, add, update, or delete data from a database.
* In '''Koha''', '''SQL''' is used in the''' Reports module''' to create '''custom reports'''.

|-
|| Click on '''Reports '''module
|| On the '''Koha''' staff interface click on the '''Reports '''module.
|-
|| Point to '''Reports''' page

Point to '''Guided reports'''>>Click on '''Create from SQL'''
|| '''Reports''' page opens.

Here under the '''Guided reports '''click on '''Create from SQL.'''
|-
|| Point to '''Create from SQL'''

Type '''Purchase suggestions''' in the '''Report Name '''field

'''SQL''' '''Code'''

SELECT suggestions.title AS Title, suggestions.author AS Author, suggestions. copyrightdate AS Year,

suggestions.isbn AS ISBN, suggestions.publishercode AS Publisher, suggestions.place AS 'Publication Place',

suggestions.itemtype AS 'Type of Book', suggestions.note AS Notes, borrowers.surname AS 'Recommended By',

suggestions.suggesteddate AS 'Suggestion Date', suggestions.STATUS FROM suggestions LEFT JOIN borrowers ON

(suggestions.suggestedby=borrowers.borrowernumber) Click on the '''Save report'''

Point to '''Your report “Purchase Suggestions” has been saved'''.
|| '''Create from SQL '''page opens.

In the''' Create report from SQL''' section, in the '''Report Name '''field type '''Purchase suggestions'''.

Leave the other fields as such.

Now pause the video and type the code in the '''SQL''' section as shown here.

Scroll down, and click on the '''Save report''' button at the bottom of the page.

The text highlighted in the blue box says '''Your report Purchase Suggestions has been saved'''.
|-
|| Point to '''Edit SQL report '''

Click on '''Run report'''

Point to '''Purchase Suggestions'''
|| On the''' Edit SQL report '''page, at the top click on the '''Run report''' button.

The '''Purchase Suggestions''' page opens with the total number of results.
|-
|| Narration only
|| With this we have successfully created a '''SQL''' report.
|-
|| Narration only
|| This brings us to the end of this tutorial.
|-
|| '''Slide Number 6'''

'''Summary'''

In this tutorial we learned to:
* '''Create SQL report'''

|| Let’s quickly recap.
|-
|| '''Slide Number 7'''

'''Assignment'''

Refer to the link:[https://wiki.koha-community.org/wiki/SQL Reports Circulation ][https://wiki.koha-community.org/wiki/SQL_Reports_Circulation https://wiki.koha-community.org/wiki/SQL_Reports_Circulation]
* Select any''' SQL '''code of your choice
* Copy paste the''' SQL '''code into the''' Create SQL Report '''section
* Save and run the report

|| As an assignment,

Refer to the link and do the following.
|-
|| '''Slide Number 8'''

'''Thank you'''
|| Thank you for joining.
|-
|}

Koha-Library-Software/C4/Create-Guided-Reports/English

2025-12-12T06:04:32Z

VaibhaviS: Created page with "'''Title of the Script: Create guided reports'''. '''Author: '''Maya Hans and Vaibhavi Satardekar '''Keywords:''' koha, koha 24.05, koha library system, reports module, guid..."

'''Title of the Script: Create guided reports'''.

'''Author: '''Maya Hans and Vaibhavi Satardekar

'''Keywords:''' koha, koha 24.05, koha library system, reports module, guided reports wizard, create report, tabular report, report criteria, cache expiry, sql reports, saved reports, library automation, video tutorial.

'''Prerequisite: '''Cataloging

{|border=1
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide Number 1'''

'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Create guided reports '''in '''Koha'''.
|-
|| '''Slide Number 2'''

'''Learning Objectives'''
* Create guided report

|| In this tutorial, we will learn to:
* Create a guided report in '''Koha'''.

|-
|| '''Slide Number 3'''

'''System Requirement'''
* '''Ubuntu Linux OS v22.04'''
* '''Koha v24.05'''
* '''Firefox v131.0.3'''
* '''A working internet connection'''

|| To record this tutorial, I am using the following setup.
|-
|| '''Slide Number 4'''

'''Prerequisites'''
* '''You should have knowledge of Library Science'''

|| To follow this tutorial you should have knowledge of Library Science.
|-
|| Show '''Koha''' interface

'''Username - Bella '''

'''Password - Library@1'''

'''Library: Spoken Tutorial Library'''

Click on '''Login'''
|| To create a simple guided report in '''Koha''', I have logged in as a '''Superlibrarian'''.
|-
|| Click on '''Reports '''module
|| On the '''Koha''' staff interface click on the '''Reports '''module.

The '''Reports''' module allows librarians to create, manage, and run reports for library operations.
|-
|| Point to '''Reports''' page

Point to '''Guided reports'''
* '''Create guided report''' for simple step-by-step reports,
* '''Create from SQL '''for advanced users, and
* '''Use saved '''to reuse existing reports

|| The''' Reports''' page opens.

Here under the '''Guided reports '''we see three types of reports:
* '''Create guided report''' for simple step-by-step reports,
* '''Create from SQL''' for advanced users, and
* '''Use saved''' to reuse existing reports.

|-
|| '''Slide Number 5'''

'''What is Create guided report?'''
* The create guided report is useful for beginners
* It allows you to generate basic reports by selecting modules and fields
* No '''SQL''' is needed

|| Now let’s create a guided report.
* The create guided report is useful for beginners.
* It allows you to generate basic reports by selecting modules and fields.
* No '''SQL''' is needed.

|-
|| Click on''' Create guided report'''

Point to''' Build a report''' page

'''Step 1 of 6 Choose a module to report on, Set cache expiry, and choose report visibility'''

'''Choose>>Catalog>>'''Click on '''Next'''
|| Click on '''Create guided report'''.

'''Build a report''' page opens, with the heading '''Step 1 of 6 Choose a module to report on, Set cache expiry, and choose report visibility'''.

From the '''Choose''' dropdown, select the '''Catalog''' module.

Next is the '''Report is public''' field, it controls the visibility of reports.

We will leave it as it is.

Next is the''' Cache expiry '''field.

It is the time in seconds for which '''Koha''' stores the report results.

We will keep it as default and click on the '''Next''' button.
|-
|| Point to '''Step 2 of 6 Pick a report type'''

'''Choose>>Tabular>>'''Click on '''Next'''
|| The heading changes to '''Step 2 of 6 Pick a report type'''.

From the '''Choose''' dropdown, select '''Tabular''' and click on the '''Next''' button.

|-
|| Point to '''Step 3 of 6 Select columns for display'''

Scroll down to '''Items '''heading

Title / biblio.title

Author / biblio.author

Date acquired / items.dateaccessioned

Price / items.price

Call number / items.itemcallnumber

Koha itemtype / items.itype

ISBN / biblioitems.isbn

Edition statement / biblioitems.editionstatement

Number of pages / biblioitems.pages

Click on '''Next '''button
| The heading '''Step 3 of 6 Select columns for display''' opens.

It allows us to choose which fields or columns we want to see in the report output.

On the left side, you can see the fields with their codes.

When you select a field, it appears in the right-side box for display in the report.

Pause the video, and select and '''Add''' the fields as shown and click on the '''Next '''button.
|-
| Point to '''Step 4 of 6 Select criteria to limit on'''

Narration only

Click on '''Next '''button

|| The heading '''Step 4 of 6 Select criteria to limit on''' opens.

Here you can choose a criteria to show only the records you want in the report.

I don’t want to apply any specific criteria.

So, I will leave it as it is and click the '''Next''' button.
|-
|| Point to '''Step 5 of 6 Pick which columns to total''' opens

Narration only

Click on '''Next '''button
|| The heading '''Step 5 of 6 Pick which columns to total''' opens.

Here you can choose columns to calculate totals.

I don’t want to total any columns, so I will leave it as it is and click the '''Next''' button.
|-
|| Point to '''Step 6 of 6 Choose how you want the report ordered'''

Narration only

Click on '''Finish '''button
|| The last '''Step 6 of 6 Choose how you want the report ordered''' appears.

Here you can decide the order of the report, for example by title, author, or item type.

I will leave the default order and click the '''Finish''' button.

Please note, clicking this will only create the report.
|-
|| Point to '''Confirm customer report'''

Point to '''Your report will be generated with the following SQL statement'''

Point to '''You will need to save the report before you can execute it'''

Click on '''Next''' button
|| '''Confirm customer report '''page opens.

Saying '''Your report will be generated with the following SQL statement'''.

'''You will need to save the report before you can execute it'''.

Click on the '''Next''' button.

|-
|| Point to '''Edit SQL report '''

Point to '''Your report has been saved'''

In the '''Report name''' field type '''sample report'''

Click on '''Update SQL''' button

|| '''Edit SQL report '''page opens.

The text highlighted in the blue box says '''Your report has been saved'''.

In the required '''Report name''' field type '''sample report'''.

Leave the other fields as such.

Scroll down to the bottom of the page, click on the '''Update SQL '''button.

With this we have successfully created a guided report.
|-
|| Narration only
|| This brings us to the end of this tutorial.
|-
|| '''Slide Number 6'''

'''Summary'''

In this tutorial we learned to-
* '''Create guided report'''

|| Let’s quickly recap.
|-
|| '''Slide Number 7'''

'''Assignment '''
* Create a guided report using the '''Circulation''' module
* Select '''card number''', '''first name''', and '''due date''' fields
* Save the report with the name '''Borrower Due Report'''

|| As an assignment,
* Create a guided report using the '''Circulation''' module.
* Select the '''card number''', '''first name''', and '''due date''' fields.
* Save the report with the name '''Borrower Due Report'''.

|-
|| '''Slide Number 8'''

'''Thank you'''
|| Thank you for joining.
|-
|}

Koha-Library-Software/C3/Issue-Patron-Discharge-Certificate/English

2025-10-03T06:43:25Z

VaibhaviS:

'''Title of the Script: Issue Patron Discharge Certificate'''

'''Author: '''Vaibhavi Satardekar and Maya Hans

'''Keywords: '''koha, koha 24.05, discharge certificate, no dues certificate, library clearance, generate discharge, issue discharge certificate, restrict patron, video tutorial.

'''Pre-requisites: '''Configure Patron Discharge Certificate

{|border=1
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide Number 1'''

'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Issue Patron Discharge Certificate '''in '''Koha'''.
|-
|| '''Slide Number 2'''

'''Learning Objectives'''

We will learn how to-
* '''Issue''' '''Patron''' '''Discharge Certificate'''

|| In this tutorial, we will learn how to-
* '''Issue '''a '''Patron''' '''Discharge Certificate'''.

|-
|| '''Slide Number 3'''

'''System Requirement'''
* '''Ubuntu Linux OS v22.04'''
* '''Koha v24.05'''
* '''Firefox v131.0.3'''
* '''A working internet connection'''

|| To record this tutorial, I am using
* '''Ubuntu Linux OS version 22 point 04'''.
* '''Koha version 24 point 05'''.
* '''Firefox version 131 point 0 point 3'''.

I also have a working internet connection.
|-
|| '''Slide Number 4'''

'''Pre-requisites'''
* You should have knowledge of Library Science

|| To follow this tutorial, you should have knowledge of Library Science.
|-
|| Narration only
|| Please remember in an earlier tutorial we had '''Configured '''a''' Patron Discharge Certificate'''.

Now, we will learn to issue a''' Patron Discharge Certificate '''to the patron.
|-
|| Login with '''Superlibrarian''' account

'''Username - Bella '''

'''Password - Library@1'''

'''Library: Spoken Tutorial Library'''

Click on '''Login'''
|| I have already logged in as a '''Superlibrarian.'''

|-
| In the '''Check out '''bar >>''' '''type '''Krishna '''press '''Enter'''
|| On the '''Koha''' staff interface locate the '''Check out '''search bar.

Enter the patron card number or a partial name.

I will enter the patron’s name as''' Krishna '''and press '''Enter'''.
|-
| Cursor on '''Checkout'''

|| A '''Checkouts''' page with the details of Mister''' Krishna Gautam''' opens.
|-
| '''Slide Number 5'''

'''Please note'''
* Patrons must clear all dues and return books before the discharge is issued
* The '''discharge certificate''' can only be issued after all items have been '''checked in'''

|| Please note.

Patrons must clear all dues and return books before the discharge is issued.

The '''discharge certificate''' can only be issued after all items have been '''checked in'''.
|-
|| Narration only

Cursor on '''More>>Discharges'''

Under the patron details click on '''Discharges'''
|| To give discharge from the top menu bar click on '''More'''.

And from the dropdown select '''Discharge'''.
|-
|| Cursor on '''Discharge'''

Click on '''Generate discharge'''

Click on the download icon
|| The '''Discharge '''page opens with the option to '''Generate discharge'''.

Click on the''' Generate discharge '''button.

The certificate will be downloaded in pdf format.

To view the discharge certificate click on the download icon and select the file.

The '''Print notices''' '''certificate''' will open in a new tab.

We have now successfully issued the discharge certificate.
|-
|| Narration only

Library No Dues/Clearance Certificate

Put highlight boxes while editing.
|| Please note, once you generate a discharge certificate.

It means that the patron has returned all the items.

Patron now is no longer an active borrower as his/her account is closed.
|-
|| From the left side panel under the patron details>> click on '''Details'''

Cursor on '''Attention>>''' text highlighted in red says-
* Restricted since 07/30/2025: Patron's account is restricted.

Click on the '''view restrictions''' button

Cursor on table details
|| Now close this '''Print notices''' '''certificate '''tab.

This will bring us back to the '''Discharge '''page.

Go to the left side menu.

Under the patron details click on '''Details'''.

A page with details of Mister''' Krishna Gautam '''opens.

Here under the '''Attention '''the text highlighted in red says-
* Restricted since 07/30/2025: Patron's account is restricted.

To view the restrictions click on the '''view restrictions '''button.

This will display a table at the bottom of the page with Restrictions details.

To remove''' '''restrictions''' '''you may''' '''click on the''' Remove '''button.

For now we will leave it as it is.
|-
|| Narration only
|| With this we come to the end of the tutorial.
|-
|| '''Slide Number 6'''

'''Summary'''

In this tutorial we learned to:
* '''Issue Patron Discharge Certificate'''

|| Let’s quickly recap.
|-
|| '''Slide Number 7'''

'''Assignment'''
* Issue '''Discharge Certificate''' to another patron

|| As an assignment
* Issue a '''Discharge Certificate''' to another patron.

|-
|| '''Slide Number 8'''

'''Thank you'''
||

Thank you for joining.
|-
|}

Koha-Library-Software/C3/Manage-Purchase-Suggestions/English

2025-10-03T06:17:50Z

VaibhaviS:

'''Title of the Script: Manage Purchase Suggestions'''

'''Author: '''Vaibhavi Satardekar and Maya Hans

'''Keywords:''' Koha, koha 24.05, koha library system, koha library interface, purchase suggestion, manage suggestions, pending suggestions, accepted suggestions, video tutorial.

'''Prerequisite: '''Make purchase suggestions using Koha.

{|border=1
|-
| '''Visual Cue'''
| '''Narration'''
|-
|| '''Slide Number 1'''

'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Manage Purchase Suggestions ''' in '''Koha'''.
|-
|| '''Slide Number 2'''

'''Learning Objectives'''
* '''Manage Purchase Suggestions'''

|| In this tutorial, we will learn how to:
* '''Manage Purchase Suggestions '''in '''Koha'''.

|-
|| '''Slide Number 3'''

'''System Requirement'''

To record this tutorial, I am using
* '''Ubuntu Linux OS v22.04'''
* '''Koha v24.05'''
* '''Firefox v131.0.3'''
* '''A working internet connection'''

|| To record this tutorial, I am using
* '''Ubuntu Linux OS version 22 point 04'''
* '''Koha version 24 point 05'''
* '''Firefox version 131 point 0 point 3'''

I also have a working internet connection.
|-
|| '''Slide Number 4'''

'''Pre-requisites'''
* You should have knowledge of Library Science

|| To practice this tutorial, you should have knowledge of Library Science.
|-
|| '''Slide Number 5'''

'''Please note'''
* To manage suggestions staff needs special permission
* This permission is called ''' suggestions manage '''
* Alternatively, they must have ''' Superlibrarian '''rights
* This allows them to view and manage purchase suggestions

|| Please note, to manage suggestions staff needs special permission.

This permission is called '''suggestions manage'''.

Alternatively, they must have '''Superlibrarian''' rights.

This allows them to view and manage purchase suggestions.
|-
|| Show '''Koha''' interface

'''Username - Vaibhavi'''

'''Password - Vaibhavi02'''

'''Library: Spoken Tutorial Library'''

Click on '''Login'''
|| To manage purchase suggestions I have already logged in as a '''Library Staff Vaibhavi'''.
|-
|| Cursor on '''Suggestions pending approval'''
|| The pending suggestion appears on the staff dashboard under the module labels.
|-
|| Click on '''Suggestions pending approval'''

Cursor on '''Suggestions management'''

Click on checkbox adjacent to '''Introduction to Library Science, by Khan, Riyazuddin'''

Cursor on '''Change selected suggestions'''

Click on '''Mark selected as Pending''', '''Accepted''', '''Checked''', '''Rejected, Ordered''', and

From dropdown select '''Accepted'''
|| Click on the '''Suggestions pending approval: Spoken Tutorial Library''' clickable link.

This will open the '''Suggestions management '''page, with the pending suggestions.

Each suggestion will show the name of the staff member who managed it.

It will also show the date it was managed on.

Click on the checkbox adjacent to '''Introduction to Library Science by Khan Riyazuddin'''.

Go to the '''Change selected suggestions '''section.

Locate the '''Mark selected as '''field, in the dropdown we can see the following options.

For now we will select '''Accepted'''.
|-
|| Cursor on '''with this reason '''from the dropdown select '''Others'''

In a text box type '''Useful for research'''

Click on '''Submit'''
|| Next for '''with this reason''' field, from the dropdown select '''Others'''.

Here you will be prompted to enter your reason in a text box.

So, we will type '''Useful for research'''.

Click on the '''Submit''' button at the bottom of the page.
|-
|| Cursor on '''Accepted''' tab

Cursor on '''Pending''', '''Accepted''', '''Checked''', '''Ordered''', '''Rejected '''tab

Click on '''Accepted''' tab

Cursor on result
|| The '''Suggestions management '''page opens.

Please note suggestions will be sorted into tabs based on their current status.

Under the '''Suggestions management '''we can see the '''Accepted''' tab and '''Pending''' tab.

Now click on the '''Accepted''' tab.

We can see, the accepted purchase suggestion is added successfully.
|-
|| Narration only
|| With this we come to the end of this tutorial.
|-
|| '''Slide Number 7'''

'''Summary'''

We learned to:
* '''Manage Purchase Suggestion'''

|| Let’s quickly recap.
|-
|| '''Slide Number 8'''

'''Assignment'''

Manage the purchase suggestion for the following book:
* '''Title''': '''Fundamentals of Library and Information Science'''
* '''Change status as accepted'''

|| As an assignment
* Manage purchase suggestion for the following book and
* Change the status as accepted.

|-
| '''Slide Number 9'''

'''Thank you'''
|| Thank you for joining.
|-
|}

Koha-Library-Software/C3/Import-Patron-Data/English

2025-10-03T05:57:28Z

VaibhaviS:

'''Title of the Script: Import Patron Data'''

'''Author: '''Vaibhavi Satardekar and Maya Hans

'''Keywords:''' koha, koha 24.05, koha library system, tools module, import patrons records, import patron data, patron import, CSV file upload, patron_import.csv, koha data import, video tutorial.

{|border=1
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide Number 1'''
'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Import Patron Data''' in '''Koha'''.
|-
|| '''Slide Number 2'''
'''Learning Objectives'''
We will learn how to:
* '''Import Patron Data'''
|| In this tutorial, we will learn how to:
* '''Import Patron Data '''in '''Koha'''.
|-
|| '''Slide Number 3'''
'''System Requirement'''
To record this tutorial, I am using
* '''Ubuntu Linux OS v22.04'''
* '''Koha v24.05'''
* '''Firefox v131.0.3'''
* '''A working internet connection'''
|| To record this tutorial, I am using
* '''Ubuntu Linux OS version 22 point 04'''
* '''Koha version 24 point 05'''
* '''Firefox version 131 point 0 point 3'''
I also have a working internet connection.
|-
|| '''Slide Number 5'''
'''Pre-requisites'''
* You should have knowledge of Library Science
|| To follow this tutorial, you should have knowledge of Library Science.
|-
|| Show '''Koha''' interface

'''Username - Bella '''

'''Password - Library@1'''

'''Library: Spoken Tutorial Library'''

Click on '''Login'''

|| To '''import patron data''',''' '''I have already logged in as a '''Superlibrarian'''.
|-
|| Click on the '''Tools''' module

Cursor on '''Tools'''

Cursor on '''Patrons and circulation'''

Click on''' Import patrons'''
|| On the '''Koha''' staff interface click on the '''Tools''' module.

'''Tools '''page opens.

Under '''Patrons and circulation''' locate''' Import patrons'''.

Click on''' Import patrons'''.
|-
|| Cursor on '''Import patrons'''
|| A new page '''Import patrons '''opens.
|-
|| Cursor on '''Notes'''
Got to Downloads folder
Click on '''patron_import''' file

'''Cardnumber: 10'''

'''Surname: Raghav'''

'''Firstname: Soniya'''

'''Middlename: '''Blank

'''Title: Ms.'''

'''City: Mumbai'''

'''email''': Blank

'''Branchcode: ST'''

'''Categorycode: RS'''

'''Dateenrolled: 2025-06-19'''

'''Expirydate: 2026-06-18'''

'''Password: Soniya@1234'''

To save the file go to the '''File''' menu and from the drop down click on '''Save'''

Save the file in '''Use Text CSV Format'''

|| On the right side under the '''Notes''' section, click on '''Download a Starter CSV file with all the columns'''.
It will download a sample file with all the needed column headings.

From the dialogue box, click on the '''patron_import.csv''' file.

A popup window '''Text import - [patron_import.csv]''' opens.

Click the '''OK '''button at the bottom of the window.

This will open '''patron_import.csv -LibreOffice Calc'''.

Pause the video, and fill the patrons details in the required fields as shown.

These patrons details are also provided in the '''Code files''' link.

Download and extract the file.

Copy and paste the details in the required fields.

To save the file go to the '''File''' menu and from the drop down click on '''Save'''.

A popup '''Confirm File Format '''window opens.

Click on '''Use Text CSV Format''' and close the file.
|-
|| Cursor on '''Import into the borrowers table'''
Cursor on '''Select the file to import'''

Click on '''Browse'''

Cursor on''' File Upload'''

Choose '''patron_import.csv''' file

Click on '''Select '''button

|| Go back to the '''Koha Import patrons''' page.
Go to the '''Import into the borrowers table '''section.

For the field '''Select the file to import '''click on the '''Browse '''button.

A pop up '''File Upload''' window opens.

Here choose the '''patron_import.csv''' file.

Click on the '''Select''' button at the top right of the window.
|-
|| Scroll down the page.

Click on the '''Import button'''
|| Now scroll down the '''Import patrons page. '''
Click on the '''Import''' button at the bottom of the page.
|-
|| Cursor on '''Import results '''
|| The '''Import results''' page opens, showing the number of imported records.
|-
|| Click on '''Import Patron Data'''
In the '''Search patron''' bar type '''10''' and press '''Enter'''
|| At the top of the page locate the '''Search patron''' bar.

Here we will enter a card number of a patron imported through csv file.

In the '''Search patron''' bar we will type '''10''' and press '''Enter'''.
|-
|| Cursor on '''Patron Details'''
|| This will open the '''Patron Details''' page.
Here we can see that patron data has been imported successfully.
|-
|| Narration only
|| With this we come to the end of this tutorial.
|-
|| '''Slide Number 6'''
'''Summary'''
We learned to:
* '''Import Patron Data'''
|| Let’s quickly recap.
|-
|| '''Slide Number 7'''
'''Assignment'''
* Randomly add 5 patrons’ details in the CSV file and import data
|| As an assignment
* Randomly add 5 patrons' details in the CSV file and import data.
|-
|| '''Slide Number 8'''
Thank you
|| Thank you for joining.
|-
|}

Koha-Library-Software/C3/Copy-Cataloging-using-Z39.50-server/English

2025-09-09T09:25:12Z

VaibhaviS: Created page with "'''Title of the Script: Copy Cataloging using Z39.50 server''' '''Author: '''Vaibhavi Satardekar and Maya Hans '''Keywords:''' koha, koha 24.05, koha library system, z39.50,..."

'''Title of the Script: Copy Cataloging using Z39.50 server'''

'''Author: '''Vaibhavi Satardekar and Maya Hans

'''Keywords:''' koha, koha 24.05, koha library system, z39.50, z39.50 server, client-server, copy cataloging, title search, isbn search, issn search, marc21, marc record, add item, video tutorial.

'''Prerequisite:''' Set Z39.50 server

{|border=1
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide Number 1'''

'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Copy Cataloging '''using''' Z39 point 5 0 server '''in'''Koha'''.
|-
|| '''Slide Number 2'''

'''Learning Objectives'''

We will learn how to:
*Add record in catalog by using '''Z39.50 server'''

|| In this tutorial, we will learn how to:
* Add record in catalog by using '''Z39 point 5 0 server'''.

|-
|| '''Slide Number 3'''

'''System Requirement'''

To record this tutorial, I am using
*'''Ubuntu Linux OS version 22 point 04'''
*'''Koha v24.05'''
*'''Firefox v131.0.3'''
*'''A working internet connection'''

|| To record this tutorial, I am using
*'''Ubuntu Linux OS version 22 point 04'''
*'''Koha version 24 point 05'''
*'''Firefox version 131 point 0 point 3'''

I also have a working internet connection.
|-
|| '''Slide Number 4'''

'''Pre-requisites'''
*You should have knowledge of Library Science

|| To practice this tutorial, you should have knowledge of Library Science.
|-
|| Show '''Koha''' interface

'''Username - Bella '''

'''Password - Library@1'''

'''Library: Spoken Tutorial Library'''

Click on '''Login'''
|| To '''Copy Cataloging using Z39 point 5 0''', I have logged in as a '''Superlibrarian'''.
|-
|| Click on '''Cataloging module'''
|| On the '''Koha''' staff interface click on the '''Cataloging module'''.
|-
|| Cursor on '''Cataloging '''
|| The '''Cataloging '''page opens.
|-
|| Click on''' Z39.50/SRU '''dropdown >> '''Books'''
|| Now click on the '''New from''' '''Z39 point 5 0 slash SRU '''dropdown and select''' Books'''.
|-
|| Cursor on '''Z39.50/SRU search results > Koha'''
|| A pop-up window '''Z39 point 5 0 slash SRU search results '''opens.
|-
|| Locate the section '''Search targets '''on the right side of the window

Cursor on
*'''LIBRARY OF CONGRESS SRU'''
*'''LIBRARY OF CONGRESS '''
*'''LIBRARY OF CONGRESS '''
*'''NATIONAL LIBRARY OF FRANCE'''

Click on X '''Clear all '''tab
|| Locate the section '''Search targets''' at the right side of the window.

Here, we can see the '''Z39 point 5 0 targets '''as follows.

Click on the '''Clear all '''tab.
|-
|| Click on the third checkbox adjacent to '''LIBRARY OF CONGRESS'''.
|| Click the third checkbox adjacent to '''LIBRARY OF CONGRESS'''.
|-
|| Cursor on '''Z39.50/SRU search '''
|| Under the '''Z39 point 5 0 slash SRU search '''section we can see''' '''various fields.
|-
|| Cursor on '''Title'''

Type '''Applied Medical Microbiology'''

|| In the '''Title '''field,''' '''type''' '''the title''' '''as shown here.

You may fill in the rest of the fields, if you wish to.

I will leave them as default.
|-
|| Click on '''Search '''button
|| Now click the '''Search '''button at the bottom right side of the window.

Please ensure that you are connected to the '''internet'''.

This step may take some time.
|-
|| Cursor on

'''Server: LIBRARY OF CONGRESS '''

'''Title: Applied Medical Microbiology'''

'''Author: College, J. G.'''

'''Year: 1981'''

'''Edition: 2nd ed.'''

'''ISBN:

'''LCCN: 81007165 '''and

'''Actions'''
|| The '''Results''' page opens up showing the following details.

|-
|| Go to right side

Cursor on '''Actions '''locate''' Import '''column
|| Go to the right side of the title '''Applied Medical Microbiology'''.

Locate the '''Actions '''column.

From the dropdown click on '''Import'''.
|-
|| Cursor on '''Add MARC record'''
|| When '''Import '''is clicked, a new page '''Add MARC record '''opens.
|-
|| Point to the '''Required''' fields

'''Imported '''from the '''Library of Congress '''database
|| Note the fields shown as '''Required'''.

These fields''' '''have been '''Imported '''from''' Library of Congress '''database.
|-
|| Click on '''Tab 9'''

Scroll down and go to''' 942 ADDED ENTRY ELEMENTS(KOHA)'''

From the '''Koha item type '''drop down select '''Books'''
|| Now click on the '''Tab 9'''.

Locate the field''' 942 ADDED ENTRY ELEMENTS(KOHA)'''.

For the subfield-''' c Koha item type''',''' '''select '''Books''' from''' '''the''' '''drop down.
|-
|| Click on''' Save''' at the top of the page
|| After filling the details, click the '''Save '''button at the top of the page.
|-
|| Cursor on

'''Items for Applied medical microbiology / by Collee, J. G. (Record #7)'''
|| A new page''' Items for Applied medical microbiology by Collee, J. G. '''opens.
|-
|| Cursor on '''Barcode''' field type '''00004'''
|| Now scroll down to the '''Barcode''' field and add a barcode for this item.

I will assign the following '''Barcode'''.

You may assign a different barcode, if you had assigned this to another item.
|-
|| Cursor on '''Add item '''at the bottom of the page
|| Now click on the '''Add item '''button at the bottom of the page.
|-
|| Cursor on '''Items for Applied medical microbiology / by Collee, J. G. (Record #7)'''
|| A new page '''Items for Applied medical microbiology by Collee, J. G. '''opens.
|-
|| Cursor on '''Normal'''
|| Now from the left menu click on '''Normal''' option.
|-
|| Cursor on '''Applied medical microbiology / J. G. Collee.'''
|| A page with details of the book '''Applied medical microbiology '''opens.
|-
|| Point to the page
|| We have successfully added a record for the book '''Applied medical microbiology '''using '''Z39 point 5 0'''.
|-
|| Narration only
|| With this, we come to the end of this tutorial.
|-
|| '''Slide Number 5'''

'''Summary'''

We learned to:
*Add record in the catalog by using '''Z39.50'''

|| Let’s quickly recap.
|-
|| '''Slide Number 6'''

'''Assignment'''

Add a new record of the following books in catalog by using '''Z39.50'''
*'''Title: Applied symbolic logic '''by''' Lynch Edward P. (1980)'''
*'''Title: Polymers: chemistry and physics of modern materials '''by''' Cowie, J.M.G. (2008)'''

|| As an assignment,

Add a new record for the following books''' '''in the catalog by using '''Z39 point 5 0'''.
|-
|| '''Slide Number 7'''

'''Assignment'''
*'''Title: Introduction to modern colloid science '''by '''Hunter, Robert J. (1993)'''
*'''Title: Educated: a memoir '''by '''Westover Tara (2018)'''

||
|-
|| '''Slide Number 8'''

'''Thank you'''
|| Thank you for joining.
|-
|}

Koha-Library-Software/C3/Place-hold-on-an-item-through-OPAC/English

2025-09-09T09:17:43Z

VaibhaviS: Created page with " '''Title of the Script''': '''Place hold on an item through OPAC''' '''Author''': '''Vaibhavi Satardekar and Maya Hans '''Keywords: '''Koha, Koha 24.05, Search item,Place..."

'''Title of the Script''': '''Place hold on an item through OPAC'''

'''Author''': '''Vaibhavi Satardekar and Maya Hans

'''Keywords: '''Koha, Koha 24.05, Search item,Place hold for an item, Library item hold, Reserve a book, Check hold status, Koha holds management, Specific item hold, Cancel book hold, Video tutorial.

'''Pre-requisites''': Cataloguing

{|border=1
|-
|| '''Visual cue'''
|| '''Narration'''
|-
|| '''Slide Number 1'''

'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Place hold on an item through OPAC'''.
|-
|| '''Slide Number 2'''

'''Learning Objectives'''

We will learn how to:
* Place hold on an item through''' OPAC'''

|| In this tutorial, we will learn how to:

* Place a hold on an item through''' OPAC'''.

|-
|| '''Slide Number 3'''

'''System Requirement'''

To record this tutorial, I am using
* '''Ubuntu Linux OS v22.04'''
* '''Koha v24.05'''
* '''Firefox v131.0.3'''
* '''A working internet connection'''

|| To record this tutorial, I am using
* '''Ubuntu Linux OS version 22 point 04'''
* '''Koha version 24 point 05'''
* '''Firefox version 131 point 0 point 3'''

I also have a working internet connection.
|-
|| '''Slide Number 4'''

'''Pre-requisites'''
* You should have knowledge of Library Science

|| To follow this tutorial,''' '''you should have knowledge of Library Science.
|-
|| Open this '''OPAC''' URL browser:127.0.1.1:8000 or 127.0.0.0
|| To view the '''OPAC''', open a '''web browser''' and type this '''url'''.
|-
|| Narration only
|| This URL is based on a port number and the domain name.

This port number we had given at the time of installation.
|-
|| Press''' Enter'''
|| Please type as per what you had mentioned and press''' Enter.'''
|-
|| Cursor on''' Spoken Tutorial Library OPAC'''

|| This will open the '''Spoken Tutorial Library OPAC''' page.
|-
|| Opened '''OPAC''' interface

|| To place hold on an item, I have opened the '''OPAC''' interface.
|-
|| Click on''' Library catalog'''

Select''' Title'''

Search by: '''Author''',''' Subject''',''' ISBN''',''' ISSN''',''' Series '''or''' Call number'''
|| At the top of the page locate the Library''' catalog '''tab.

From the drop down select the '''Title '''option.

You can also search for an item by '''Author, Subject''', '''ISBN''', '''ISSN''',''' Series or Call number'''.
|-
|| Type '''Industrial Microbiology''' and press '''Enter'''.
|| In the search''' '''bar I will type '''Industrial Microbiology''' and press '''Enter'''.
|-
|| Narration only

'''Item type: Book'''

'''Current library''':''' Spoken Tutorial Library'''

'''Call number''':

'''Copy number''':

'''Status: Checked out'''

'''Date due''':
|| A page '''Industrial Microbiology Patel''',''' Arvind H'''. opens with the details of this item.

Below the item details we can see a table with the following details.

Under the '''Status''' column we can see the availability of the item.

Please note we can only place hold on checkedout items.
|-
|| Cursor on '''Browse results '''

Click on the '''Place hold'''.

|| To place hold on this item''' '''go to the right side of the page.

Click on '''Place hold'''.
|-
|| Narration only
|| Before logging into '''OPAC''', please note:

In '''Add a new patron''' tutorial,

we had learned how to modify or edit patron details.
|-
|| Change the password of patron '''Soniya Raghav''' in '''Koha.'''

|| So, first we need to change the password of patron '''Soniya Raghav''' in '''Koha'''.
|-
|| logged koha as a '''Superlibrarian'''.

In the '''Checkout''' search bar type '''Soniya''' and press enter.

|| I have already logged into koha as a '''Superlibrarian'''.

In the '''Checkout''' search bar type '''Soniya''' and press Enter.
|-
|| Click on '''Change Password'''

Cursor on''' Change username and/or password for''' '''Soniya. Raghav'''
|| Above the patron name click on '''Change password'''.

A Page''' Change username and/or password for''' '''Soniya. Raghav''' opens.
|-
|| '''Username''':''' soniya. raghav'''

'''Passward''':''' Soniya@1234'''

Click on''' Save'''

Cursor on''' OPAC'''
|| Let us change the password as shown here.

Click on the '''Save''' button.

Let’s go back to the '''OPAC''' tab.
|-
|| '''Login''': '''Soniya, Raghav'''

'''Password''': '''Soniya@1234'''

Click on '''Login'''
|| Now login using '''Soniya. Raghav’s''' credentials.

|-
|| Cursor on '''Placing a hold''' '''Confirm holds for Miss Soniya, Raghav'''.

Cursor on checkbox for '''Industrial microbiology'''
|| '''Placing a hold''' '''Confirm holds for Miss.Soniya, Raghav''' page opens.

'''Koha''' auto-clicked the checkbox for '''Industrial microbiology'''.
|-
|| Cursor on '''Pick up location'''
|| For the '''Pick up location''' '''Koha''' auto selected '''Spoken Tutorial Library'''.

So we will keep it as it is.
|-
|| Click on '''Confirm hold'''
|| Now click on the '''Confirm hold '''button at the bottom of the page.
|-
|| Cursor on '''Your summary''' page
|| '''Your summary '''page opens with the '''Hold''' details.

Under the patron name we can see the holds on this particular item.
|-
|| Cursor on '''X Modify'''
|| If you wish to remove the hold, go to '''Modify''' column and click the '''Cancel''' button.
|-
|| Narration only
|| With this we come to the end of this tutorial.
|-
|| '''Slide Number 5'''

'''Summary'''

In this tutorial we learned to:
* '''Place hold on an item through OPAC'''

|| Let’s quickly recap.

|-
|| '''Slide Number 6'''

'''Assignment'''
* '''Place hold on any other checked out book to Ms.Soniya, Raghav'''

|| As an assignment
* Place hold on any other checked out book to Miss '''Soniya Raghav'''.

|-
|| '''Slide Number 7'''

'''Thank you'''
|| Thank you for joining.
|-
|}

Koha-Library-Software/C3/Issue-Patron-Discharge-Certificate/English

2025-09-09T09:09:06Z

VaibhaviS: Created page with "'''Title of the Script: Issue Patron Discharge Certificate''' '''Author: '''Vaibhavi Satardekar and Maya Hans '''Keywords: '''koha, koha 24.05, discharge certificate, no due..."

'''Title of the Script: Issue Patron Discharge Certificate'''

'''Author: '''Vaibhavi Satardekar and Maya Hans

'''Keywords: '''koha, koha 24.05, discharge certificate, no dues certificate, library clearance, generate discharge, issue discharge certificate, restrict patron, video tutorial.

'''Pre-requisites: '''Configure Patron Discharge Certificate

{|border=1
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide Number 1'''

'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Issue Patron Discharge Certificate '''in '''Koha'''.
|-
|| '''Slide Number 2'''

'''Learning Objectives'''

We will learn how to-
* '''Issue''' '''Patron''' '''Discharge Certificate'''

|| In this tutorial, we will learn how to-
* '''Issue '''a '''Patron''' '''Discharge Certificate'''.

|-
|| '''Slide Number 3'''

'''System Requirement'''
* '''Ubuntu Linux OS v22.04'''
* '''Koha v24.05'''
* '''Firefox v131.0.3'''
* '''A working internet connection'''

|| To record this tutorial, I am using
* '''Ubuntu Linux OS version 22 point 04'''.
* '''Koha version 24 point 05'''.
* '''Firefox version 131 point 0 point 3'''.

I also have a working internet connection.
|-
|| '''Slide Number 4'''

'''Pre-requisites'''
* You should have knowledge of Library Science

|| To follow this tutorial, you should have knowledge of Library Science.
|-
|| Narration only
|| Please remember in an earlier tutorial we had '''Configured '''a''' Patron Discharge Certificate'''.

Now, we will learn to issue a''' Patron Discharge Certificate '''to the patron.
|-
|| Login with '''Superlibrarian''' account

'''Username - Bella '''

'''Password - Library@1'''

'''Library: Spoken Tutorial Library'''

Click on '''Login'''
|| I have already logged in as a '''Superlibrarian.'''

|-
| In the '''Check out '''bar >>''' '''type '''Krishna '''press '''Enter'''
|| On the '''Koha''' staff interface locate the '''Check out '''search bar.

Enter the patron card number or a partial name.

I will enter the patron’s name as''' Krishna '''and press '''Enter'''.
|-
| Cursor on '''Checkout'''

|| A '''Checkouts''' page with the details of Mister''' Krishna Gautam''' opens.
|-
| '''Slide Number 5'''

'''Please note'''
* Patrons must clear all dues and return books before the discharge is issued
* The '''discharge certificate''' can only be issued after all items have been '''checked in'''

|| Please note.

Patrons must clear all dues and return books before the discharge is issued.

The '''discharge certificate''' can only be issued after all items have been '''checked in'''.
|-
|| Narration only

Cursor on '''More>>Discharges'''

Under the patron details click on '''Discharges'''
|| To give discharge from the top menu bar click on '''More'''.

And from the dropdown select '''Discharge'''.
|-
|| Cursor on '''Discharge'''

Click on '''Generate discharge'''

Click on the download icon
|| The '''Discharge '''page opens with the option to '''Generate discharge'''.

Click on the''' Generate discharge '''button.

The certificate will be downloaded in pdf format.

To view the discharge certificate click on the download icon and select the file.

The '''Print notices''' '''certificate''' will open in a new tab.

We have now successfully issued the discharge certificate.
|-
|| Narration only

Library No Dues/Clearance Certificate

Put highlight boxes while editing.
|| Please note, once you generate a discharge certificate.

It means that the patron has returned all the items.

Patron now is no longer an active borrower as his/her account is closed.
|-
|| From the left side panel under the patron details>> click on '''Details'''

Cursor on '''Attention>>''' text highlighted in red says-
* Restricted since 07/30/2025: Patron's account is restricted.

Click on the '''view restrictions'''

Cursor on table details
|| Now close this '''Print notices''' '''certificate '''tab.

This will bring us back to the '''Discharge '''page.

Go to the left side menu.

Under the patron details click on '''Details'''.

A page with details of Mister''' Krishna Gautam '''opens.

Here under the '''Attention '''the text highlighted in red says-
* Restricted since 07/30/2025: Patron's account is restricted.

To view the restrictions click on the '''view restrictions '''tab.

This will display a table at the bottom of the page with Restrictions details.

To remove''' '''restrictions''' '''you may''' '''click on the''' Remove '''tab.

For now we will leave it as it is.
|-
|| Narration only
|| With this we come to the end of the tutorial.
|-
|| '''Slide Number 6'''

'''Summary'''

In this tutorial we learned to:
* '''Issue Patron Discharge Certificate'''

|| Let’s quickly recap.
|-
|| '''Slide Number 7'''

'''Assignment'''
* Issue '''Discharge Certificate''' to another patron

|| As an assignment
* Issue a '''Discharge Certificate''' to another patron.

|-
|| '''Slide Number 8'''

'''Thank you'''
||

Thank you for joining.
|-
|}

Koha-Library-Software/C3/Manage-Purchase-Suggestions/English

2025-09-09T09:01:40Z

VaibhaviS:

'''Title of the Script: Manage Purchase Suggestions'''

'''Author: '''Vaibhavi Satardekar and Maya Hans

'''Keywords:''' Koha, koha 24.05, koha library system, koha library interface, purchase suggestion, manage suggestions, pending suggestions, accepted suggestions, video tutorial.

'''Prerequisite: '''Make purchase suggestions using Koha.

{|border=1
|-
| '''Visual Cue'''
| '''Narration'''
|-
|| '''Slide Number 1'''

'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Manage Purchase Suggestions ''' in '''Koha'''.
|-
|| '''Slide Number 2'''

'''Learning Objectives'''
* '''Manage Purchase Suggestions'''

|| In this tutorial, we will learn how to:
* '''Manage Purchase Suggestions '''in '''Koha'''.

|-
|| '''Slide Number 3'''

'''System Requirement'''

To record this tutorial, I am using
* '''Ubuntu Linux OS v22.04'''
* '''Koha v24.05'''
* '''Firefox v131.0.3'''
* '''A working internet connection'''

|| To record this tutorial, I am using
* '''Ubuntu Linux OS version 22 point 04'''
* '''Koha version 24 point 05'''
* '''Firefox version 131 point 0 point 3'''

I also have a working internet connection.
|-
|| '''Slide Number 4'''

'''Pre-requisites'''
* You should have knowledge of Library Science

|| To practice this tutorial, you should have knowledge of Library Science.
|-
|| '''Slide Number 5'''

'''Please note'''
* To manage suggestions Staff need special permission
* Alternatively,''' Superlibrarian '''rights are needed to manage suggestions

|| Please note, to manage suggestions staff needs special permission.

This permission is called '''suggestions manage'''.

Alternatively, they must have '''Superlibrarian''' rights.

This allows them to view and manage purchase suggestions.
|-
|| Show '''Koha''' interface

'''Username - Vaibhavi'''

'''Password - Vaibhavi02'''

'''Library: Spoken Tutorial Library'''

Click on '''Login'''
|| To manage purchase suggestions I have already logged in as a '''Library Staff Vaibhavi'''.
|-
|| Cursor on '''Suggestions pending approval'''
|| The pending suggestion appears on the staff dashboard under the module labels.
|-
|| Click on '''Suggestions pending approval'''

Cursor on '''Suggestions management'''

Click on checkbox adjacent to '''Introduction to Library Science, by Khan, Riyazuddin'''

Cursor on '''Change selected suggestions'''

Click on '''Mark selected as Pending''', '''Accepted''', '''Checked''', '''Rejected, Ordered''', and

From dropdown select '''Accepted'''
|| Click on the '''Suggestions pending approval: Spoken Tutorial Library''' clickable link.

This will open the '''Suggestions management '''page, with the pending suggestions.

Each suggestion will show the name of the staff member who managed it.

It will also show the date it was managed on.

Click on the checkbox adjacent to '''Introduction to Library Science by Khan Riyazuddin'''.

Go to the '''Change selected suggestions '''section.

Locate the '''Mark selected as '''field, in the dropdown we can see the following options.

For now we will select '''Accepted'''.
|-
|| Cursor on '''with this reason '''from the dropdown select '''Others'''

In a text box type '''Useful for research'''

Click on '''Submit'''
|| Next for '''with this reason''' field, from the dropdown select '''Others'''.

Here you will be prompted to enter your reason in a text box.

So, we will type '''Useful for research'''.

Click on the '''Submit''' button at the bottom of the page.
|-
|| Cursor on '''Accepted''' tab

Cursor on '''Pending''', '''Accepted''', '''Checked''', '''Ordered''', '''Rejected '''tab

Click on '''Accepted''' tab

Cursor on result
|| The '''Suggestions management '''page opens.

Please note suggestions will be sorted into tabs based on their current status.

Under the '''Suggestions management '''we can see the '''Accepted''' tab and '''Pending''' tab.

Now click on the '''Accepted''' tab.

We can see, the accepted purchase suggestion is added successfully.
|-
|| Narration only
|| With this we come to the end of this tutorial.
|-
|| '''Slide Number 7'''

'''Summary'''

We learned to:
* '''Manage Purchase Suggestion'''

|| Let’s quickly recap.
|-
|| '''Slide Number 8'''

'''Assignment'''

Manage the purchase suggestion for the following book:
* '''Title''': '''Fundamentals of Library and Information Science'''
* '''Change status as accepted'''

|| As an assignment
* Manage purchase suggestion for the following book and
* Change the status as accepted.

|-
| '''Slide Number 9'''

'''Thank you'''
|| Thank you for joining.
|-
|}

Koha-Library-Software/C3/Manage-Purchase-Suggestions/English

2025-09-09T08:58:21Z

VaibhaviS: Created page with "'''Title of the Script: Manage Purchase Suggestions''' '''Author: '''Vaibhavi Satardekar and Maya Hans '''Keywords:''' Koha, koha 24.05, koha library system, koha library in..."

'''Title of the Script: Manage Purchase Suggestions'''

'''Author: '''Vaibhavi Satardekar and Maya Hans

'''Keywords:''' Koha, koha 24.05, koha library system, koha library interface, purchase suggestion, manage suggestions, pending suggestions, accepted suggestions, video tutorial.

'''Prerequisite: '''Make purchase suggestions using Koha.

{|border=1
|-
| '''Visual Cue'''
| '''Narration'''
|-
|| '''Slide Number 1'''

'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Manage Purchase Suggestions ''' '''Koha'''.
|-
|| '''Slide Number 2'''

'''Learning Objectives'''
* '''Manage Purchase Suggestions'''

|| In this tutorial, we will learn how to:
* '''Manage Purchase Suggestions '''in '''Koha'''.

|-
|| '''Slide Number 3'''

'''System Requirement'''

To record this tutorial, I am using
* '''Ubuntu Linux OS v22.04'''
* '''Koha v24.05'''
* '''Firefox v131.0.3'''
* '''A working internet connection'''

|| To record this tutorial, I am using
* '''Ubuntu Linux OS version 22 point 04'''
* '''Koha version 24 point 05'''
* '''Firefox version 131 point 0 point 3'''

I also have a working internet connection.
|-
|| '''Slide Number 4'''

'''Pre-requisites'''
* You should have knowledge of Library Science

|| To practice this tutorial, you should have knowledge of Library Science.
|-
|| '''Slide Number 5'''

'''Please note'''
* To manage suggestions Staff need special permission
* Alternatively,''' Superlibrarian '''rights are needed to manage suggestions

|| Please note, to manage suggestions staff needs special permission.

This permission is called '''suggestions manage'''.

Alternatively, they must have '''Superlibrarian''' rights.

This allows them to view and manage purchase suggestions.
|-
|| Show '''Koha''' interface

'''Username - Vaibhavi'''

'''Password - Vaibhavi02'''

'''Library: Spoken Tutorial Library'''

Click on '''Login'''
|| To manage purchase suggestions I have already logged in as a '''Library Staff Vaibhavi'''.
|-
|| Cursor on '''Suggestions pending approval'''
|| The pending suggestion appears on the staff dashboard under the module labels.
|-
|| Click on '''Suggestions pending approval'''

Cursor on '''Suggestions management'''

Click on checkbox adjacent to '''Introduction to Library Science, by Khan, Riyazuddin'''

Cursor on '''Change selected suggestions'''

Click on '''Mark selected as Pending''', '''Accepted''', '''Checked''', '''Rejected, Ordered''', and

From dropdown select '''Accepted'''
|| Click on the '''Suggestions pending approval: Spoken Tutorial Library''' clickable link.

This will open the '''Suggestions management '''page, with the pending suggestions.

Each suggestion will show the name of the staff member who managed it.

It will also show the date it was managed on.

Click on the checkbox adjacent to '''Introduction to Library Science by Khan Riyazuddin'''.

Go to the '''Change selected suggestions '''section.

Locate the '''Mark selected as '''field, in the dropdown we can see the following options.

For now we will select '''Accepted'''.
|-
|| Cursor on '''with this reason '''from the dropdown select '''Others'''

In a text box type '''Useful for research'''

Click on '''Submit'''
|| Next for '''with this reason''' field, from the dropdown select '''Others'''.

Here you will be prompted to enter your reason in a text box.

So, we will type '''Useful for research'''.

Click on the '''Submit''' button at the bottom of the page.
|-
|| Cursor on '''Accepted''' tab

Cursor on '''Pending''', '''Accepted''', '''Checked''', '''Ordered''', '''Rejected '''tab

Click on '''Accepted''' tab

Cursor on result
|| The '''Suggestions management '''page opens.

Please note suggestions will be sorted into tabs based on their current status.

Under the '''Suggestions management '''we can see the '''Accepted''' tab and '''Pending''' tab.

Now click on the '''Accepted''' tab.

We can see, the accepted purchase suggestion is added successfully.
|-
|| Narration only
|| With this we come to the end of this tutorial.
|-
|| '''Slide Number 7'''

'''Summary'''

We learned to:
* '''Manage Purchase Suggestion'''

|| Let’s quickly recap.
|-
|| '''Slide Number 8'''

'''Assignment'''

Manage the purchase suggestion for the following book:
* '''Title''': '''Fundamentals of Library and Information Science'''
* '''Change status as accepted'''

|| As an assignment
* Manage purchase suggestion for the following book and
* Change the status as accepted.

|-
| '''Slide Number 9'''

'''Thank you'''
|| Thank you for joining.
|-
|}

Koha-Library-Software/C3/Import-Patron-Data/English

2025-08-22T06:03:57Z

VaibhaviS: Created page with "'''Title of the Script: Import Patron Data''' '''Author: '''Vaibhavi Satardekar and Maya Hans '''Keywords:''' koha, koha 24.05, koha library system, tools module, import patro..."

'''Title of the Script: Import Patron Data'''
'''Author: '''Vaibhavi Satardekar and Maya Hans
'''Keywords:''' koha, koha 24.05, koha library system, tools module, import patrons records, import patron data, patron import, CSV file upload, patron_import.csv, koha data import, video tutorial.

{|border=1
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide Number 1'''
'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Import Patron Data''' in '''Koha'''.
|-
|| '''Slide Number 2'''
'''Learning Objectives'''
We will learn how to:
* '''Import Patron Data'''
|| In this tutorial, we will learn how to:
* '''Import Patron Data '''in '''Koha'''.
|-
|| '''Slide Number 3'''
'''System Requirement'''
To record this tutorial, I am using
* '''Ubuntu Linux OS v22.04'''
* '''Koha v24.05'''
* '''Firefox v131.0.3'''
* '''A working internet connection'''
|| To record this tutorial, I am using
* '''Ubuntu Linux OS version 22 point 04'''
* '''Koha version 24 point 05'''
* '''Firefox version 131 point 0 point 3'''
I also have a working internet connection.
|-
|| '''Slide Number 5'''
'''Pre-requisites'''
* You should have knowledge of Library Science
|| To follow this tutorial, you should have knowledge of Library Science.
|-
|| Show '''Koha''' interface

'''Username - Bella '''

'''Password - Library@1'''

'''Library: Spoken Tutorial Library'''

Click on '''Login'''

|| To '''import patron data''',''' '''I have already logged in as a '''Superlibrarian'''.
|-
|| Click on the '''Tools''' module

Cursor on '''Tools'''

Cursor on '''Patrons and circulation'''

Click on''' Import patrons'''
|| On the '''Koha''' staff interface click on the '''Tools''' module.

'''Tools '''page opens.

Under '''Patrons and circulation''' locate''' Import patrons'''.

Click on''' Import patrons'''.
|-
|| Cursor on '''Import patrons'''
|| A new page '''Import patrons '''opens.
|-
|| Cursor on '''Notes'''
Got to Downloads folder
Click on '''patron_import''' file

'''Cardnumber: 10'''

'''Surname: Raghav'''

'''Firstname: Soniya'''

'''Middlename: '''Blank

'''Title: Ms.'''

'''City: Mumbai'''

'''email''': Blank

'''Branchcode: ST'''

'''Categorycode: RS'''

'''Dateenrolled: 2025-06-19'''

'''Expirydate: 2026-06-18'''

'''Password: Soniya@1234'''

To save the file go to the '''File''' tab and from the drop down click on '''Save'''

Save the file in '''Use Text CSV Format'''

|| On the right side under the '''Notes''' section, click on '''Download a Starter CSV file with all the columns'''.
It will download a sample file with all the needed column headings.

From the dialogue box, click on the '''patron_import.csv''' file.

A popup window '''Text import - [patron_import.csv]''' opens.

Click the '''OK '''button at the bottom of the window.

This will open '''patron_import.csv -LibreOffice Calc'''.

Pause the video, and fill the patrons details in the required fields as shown.

These patrons details are also provided in the '''Code files''' link.

Download and extract the file.

Copy and paste the details in the required fields.

To save the file go to the '''File''' tab and from the drop down click on '''Save'''.

A popup '''Confirm File Format '''window opens.

Click on '''Use Text CSV Format''' and close the file.
|-
|| Cursor on '''Import into the borrowers table'''
Cursor on '''Select the file to import'''

Click on '''Browse'''

Cursor on''' File Upload'''

Choose '''patron_import.csv''' file

Click on '''Select '''button

|| Go back to the '''Koha Import patrons''' page.
Go to the '''Import into the borrowers table '''section.

For the field '''Select the file to import '''click on the '''Browse '''button.

A pop up '''File Upload''' window opens.

Here choose the '''patron_import.csv''' file.

Click on the '''Select''' button at the top right of the window.
|-
|| Scroll down the page.

Click on the '''Import button'''
|| Now scroll down the '''Import patrons page. '''
Click on the '''Import''' button at the bottom of the page.
|-
|| Cursor on '''Import results '''
|| The '''Import results''' page opens, showing the number of imported records.
|-
|| Click on '''Import Patron Data'''
In the '''Search patron''' bar type '''10''' and press '''Enter'''
|| At the top of the page locate the '''Search patron''' bar.

Here we will enter a card number of a patron imported through csv file.

In the '''Search patron''' bar we will type '''10''' and press '''Enter'''.
|-
|| Cursor on '''Patron Details'''
|| This will open the '''Patron Details''' page.
Here we can see that patron data has been imported successfully.
|-
|| Narration only
|| With this we come to the end of this tutorial.
|-
|| '''Slide Number 6'''
'''Summary'''
We learned to:
* '''Import Patron Data'''
|| Let’s quickly recap.
|-
|| '''Slide Number 7'''
'''Assignment'''
* Randomly add 5 patrons’ details in the CSV file and import data
|| As an assignment
* Randomly add 5 patrons' details in the CSV file and import data.
|-
|| '''Slide Number 8'''
Thank you
|| Thank you for joining.
|-
|}

Koha-Library-Software/C2/Create-a-Spine-Label-Batch/English

2025-06-12T10:31:59Z

VaibhaviS: Created page with "'''Title of the Script: Create a Spine Label Batch''' '''Author: '''Vaibhavi Satardekar and Maya Hans '''Keywords: '''Koha, Koha 24.05, Label Creator, Spine Label, Label Bat..."

'''Title of the Script: Create a Spine Label Batch'''

'''Author: '''Vaibhavi Satardekar and Maya Hans

'''Keywords: '''Koha, Koha 24.05, Label Creator, Spine Label, Label Batch, Export Batch, Print Labels, Download pdf labels, Video tutorial.

'''Prerequisite: '''Create a Spine Label Layout

{|border=1
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide Number 1'''

'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Create''' a''' Spine Label Batch''' in '''Koha'''.
|-
|| '''Slide Number 2'''

'''Learning Objectives'''

We will learn how to:
* '''Create a Spine Label Batch '''

|| In this tutorial, we will learn how to:

* '''Create a Spine Label Batch '''in''' Koha'''.

|-
|| '''Slide Number 3'''

'''System Requirement'''

To record this tutorial, I am using
* '''Ubuntu Linux OS version 22 point 04'''
* '''Koha version 24 point 05'''
* '''Firefox version 131 point 0 point 3'''
* '''A working internet connection'''

|| To record this tutorial, I am using
* '''Ubuntu Linux OS version 22 point 04'''
* '''Koha version 24 point 05'''
* '''Firefox version 131 point 0 point 3'''

I also have a working internet connection.
|-
|| '''Slide Number 4'''

'''Pre-requisites'''
* You should have knowledge of Library Science

|| To follow this tutorial, you should have knowledge of Library Science.
|-
|| Login with '''Superlibrarian''' account

'''Username - Bella '''

'''Password - Library@1'''

Choose '''Library''' as '''Spoken Tutorial Library.'''

Click on '''Login'''
|| To''' create a spine label''' '''batch '''in '''Koha''' I have already logged in as a '''Superlibrarian'''.

|-
|| Click on '''Cataloging module '''
|| On the '''Koha''' homepage click on the''' Cataloging module'''.
|-
|| Highlight '''Cataloging '''page
|| The''' Cataloging '''page opens.
|-
|| Cursor on '''Tools''' >> Choose '''<nowiki>#Label Creator</nowiki>'''
|| Now go to the '''Tools''' section and click on '''Label Creator'''.
|-
|| Highlight '''Label creator '''
|| The '''Label creator '''page opens.
|-
|| Click on '''New''' dropdown>> '''Label batch'''
|| Click on the '''New''' dropdown and select '''Label batch'''.
|-
|| Highlight '''New''' '''label batch '''page
|| The '''New''' '''label batch '''page opens.
|-
|| Cursor on
* '''Enter by barcode '''
* '''Enter by itemnumber'''

Highlight '''Enter by barcode'''

Highlight '''Add by barcode(s) or itemnumbers(s) '''textbox
* '''One number per line'''
* '''Leave empty to add via item search (itemnumber) '''

'''00001'''

'''00002'''

click on the '''Add Item(s)'''
|| Here we can see two options like:
* '''Enter by barcode '''and
* '''Enter by itemnumber'''

For now we will choose the first option.

So check the checkbox adjacent to '''Enter by barcode'''if not selected by default.

Now in the '''Add by barcode(s) or itemnumbers(s) '''textbox, enter the following barcodes as shown here.

Click on the '''Add Item(s)''' button at the bottom.
|-
|| Cursor on''' Edit label batch 1 '''

Cursor on''' Items in batch number 1 '''

Cursor on
* '''+Add item(s)'''
* '''Save description'''
* '''Remove selected items'''
* '''- batch'''
* '''Remove duplicates'''
* '''Export selected items'''
* '''Export full batch'''

Click on the '''Export full batch '''

Cursor on popup window '''Export labels'''

'''Select a template to be applied>>Spine Sample'''

'''Select a layout to be applied>>Spine Layout'''

'''Enter starting label position (for PDF)''' : '''1'''

Click on the '''Export'''
|| This will change the page name to '''Edit label batch 1'''.

Scrolling down, we can see''' Items in batch number 1 '''section with the results of the barcodes we entered earlier.

Just above the '''Items in batch number 1 '''section we can see the following options.

For now, we will choose the '''Export full batch '''option.

A popup window '''Export labels''' opens with the heading '''Label printing or exporting'''.

For the field '''Select a template to be applied'''.

From the drop down select '''Spine Template '''if not selected by default.

For the field '''Select a layout to be applied'''.

From the drop down select '''Spine Layout'''.

For '''Enter starting label position (for PDF)''' type '''1''' or as per your requirement.

Now click on the '''Export '''button at the bottom of the window.
|-
||

Cursor on '''Label printing/exporting '''

Cursor on
* '''Download as PDF'''
* '''Download as CSV'''
* '''Download as XML'''

Click on '''Download as PDF'''
|| A popup window opens with the heading '''Label printing or exporting'''.

'''Click on the following links to download the exported batch(es)'''.

Under the '''Label batch number 1 '''we can see the following file formats to print the barcodes.

For now we will click on '''Download as PDF'''.

With this the printable barcodes are ready.

Now close this newly opened tab.

And click on the '''Done''' button to close this popup window.
|-
|| Narration only
|| With this we come to the end of this tutorial.
|-
|| '''Slide Number 5'''

'''Summary'''

We learned to:
* '''Create''' a''' Spine Label Batch '''

|| Let’s quickly recap.

Today we learned how to:
* '''Create '''a''' Spine Label Batch '''in '''Koha'''.

|-
|| '''Slide Number 6'''

'''Assignment'''
* Create another '''Spine Label Batch'''

|| As an assignment
* Create another '''Spine Label Batch'''.

|-
|| '''Slide Number 7'''

'''Thank you'''
|| Thank you for joining.
|-
|}

Koha-Library-Software/C2/Create-a-Spine-Label-Layout/English

2025-06-12T10:28:19Z

VaibhaviS: Created page with "'''Title of the Script: Create a Spine Label Layout''' '''Author: '''Vaibhavi Satardekar and Maya Hans '''Keywords: '''Koha, Koha 24.05, Label Creator, Label Layout, Spine L..."

'''Title of the Script: Create a Spine Label Layout'''

'''Author: '''Vaibhavi Satardekar and Maya Hans

'''Keywords: '''Koha, Koha 24.05, Label Creator, Label Layout, Spine Label, Video tutorial.

'''Prerequisite: '''Create a Spine Label Template

{|border=1
|-
|| '''Visual cue'''
|| '''Narration'''
|-
|| '''Slide Number 1'''

'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Create '''a '''Spine Label Layout''' in '''Koha'''.
|-
|| '''Slide Number 2'''

'''Learning Objectives'''

We will learn how to:
* '''Create '''a''' Spine Label Layout '''

|| In this tutorial, we will learn how to:

* '''Create '''a''' Spine Label Layout '''in''' Koha'''.

|-
|| '''Slide Number 3'''

'''System Requirement'''

To record this tutorial, I am using
* '''Ubuntu Linux OS version 22 point 04'''
* '''Koha version 24 point 05'''
* '''Firefox version 131 point 0 point 3'''
* '''A working internet connection'''

|| To record this tutorial, I am using
* '''Ubuntu Linux OS version 22 point 04'''
* '''Koha version 24 point 05'''
* '''Firefox version 131 point 0 point 3'''

I also have a working internet connection.
|-
|| '''Slide Number 4'''

'''Pre-requisites'''
* You should have knowledge of Library Science

|| To follow this tutorial, you should have knowledge of Library Science.
|-
|| Login with '''Superlibrarian''' account

'''Username - Bella '''

'''Password - Library@1'''

Choose '''Library''' as '''Spoken Tutorial Library.'''

Click on '''Login'''
|| To''' create a spine label''' '''layout''' in '''Koha''' I have already logged in as a '''Superlibrarian'''.

|-
|| Click on '''Cataloging module '''
|| On the Koha homepage click on the''' Cataloging module'''.
|-
|| Highlight '''Cataloging '''page
|| The '''Cataloging '''page opens.
|-
|| Cursor on '''Tools''' >> Choose '''<nowiki>#Label Creator</nowiki>'''
|| Now go to the '''Tools''' section and click on '''Label Creator'''.
|-
|| Highlight '''Label creator '''
|| The '''Label creator '''page opens.
|-
|| Click on '''New''' dropdown>> '''Layout'''
|| Click on the '''New''' dropdown and select '''Layout'''.
|-
|| Highlight '''New''' '''label layout '''page
|| The '''New''' '''label layout '''page opens.
|-
|| Cursor on '''Layout name'''

'''Enter Layout name: Spine Layout'''
|| For the '''Layout''' '''name '''we will type '''Spine Layout'''.
|-
|| Cursor on '''Choose barcode type(encoding)'''

From the dropdown select '''Code''' '''39'''
|| Next is the '''Choose barcode type(encoding)''' field.

Here you can select the encoding for the barcode.

The most common is '''Code 39'''.

So from the dropdown select '''Code''' '''39,''' if not selected by default.
|-
|| Cursor on '''Choose layout type '''

From the dropdown select>> '''Only the bibliographic data is printed'''
|| Next is the '''Choose layout type''' field.

Here we are creating a spine label, so from the dropdown select '''Only the bibliographic data is printed'''.
|-
|| Highlight '''Bibliographic data to print '''

Cursor on '''Choose order of text fields to print: '''title, author, isbn, issn, itemtype and barcode

Cursor on '''List fields Data fields'''
|| Next is the '''Bibliographic data to print '''section.

Here '''Koha''' auto selected '''Choose order of text fields to print '''option''' '''with the predetermined fields.

Below that we can also see the '''List fields '''option.

From the given options choose as per your requirement.

|-
|| Select '''Choose order of text fields to print.'''

'''itemcallnumber '''dropdown select''' 1'''

'''barcode '''dropdown select''' 2.'''

Leave the remaining dropdowns empty
|| For now we will go with the first option '''Choose order of text fields to print'''.

So for''' itemcallnumber '''from the''' '''dropdown select''' 1'''.

For''' barcode, '''from the''' '''dropdown select''' 2'''.

Leave the remaining dropdowns empty.
|-
|| Highlight '''Text justification>>Center'''
|| For the '''Text justification '''field, from the dropdown select '''Center'''.
|-
|| Highlight '''Font'''

From the drop down select '''Times-Roman'''
|| Next is the '''Font '''field.

From the drop down select '''Times-Roman'''.

You can choose as per your requirement.
|-
|| Highlight '''Font size '''

Type '''10'''
|| For the '''Font size''' field.

Type '''10'''.

You can set it as per your requirement.
|-
|| Highlight '''Barcode width '''

Set it to '''2.5 in'''

Highlight '''Barcode height '''

Set it to '''1.5 in'''
|| For the '''Barcode width '''enter '''2 point 5 '''and for''' Barcode height''' enter''' 1 point 5'''
|-
|| Narration only
|| Rest of the fields we will leave it as it is.
|-
|| Click on '''Save'''
|| Now click on the '''Save '''button at the bottom of the page.
|-
|| Cursor on
* '''Layout ID'''
* '''Layout'''
* '''Barcode type'''
* '''Print type'''
* '''Fields to print'''
* '''Actions'''

|| This will bring us to the '''Label layouts '''page.

Here we can see the '''Spine Layout '''is added successfully.

|-
|| Narration only
|| With this we come to the end of this tutorial.
|-
|| '''Slide Number 5'''

'''Summary'''

We learned to:
* '''Create '''a''' Spine Label Layout '''

|| Let’s quickly recap.

Today we learned how to:
* '''Create '''a''' Spine Label Layout '''in''' Koha'''.

|-
|| '''Slide Number 6'''

'''Assignment'''

Create''' '''another '''Spine Label Layout '''with the following dimensions:
* '''Barcode width: 1.5 in'''
* '''Barcode height: 1 in'''

|| As an assignment
* '''Create '''another '''Spine Label Layout'''.

|-
|| '''Slide Number 7'''

'''Thank you'''
|| Thank you for joining.
|-
|}

Koha-Library-Software/C2/Create-a-Spine-Label-Template/English

2025-06-12T10:25:04Z

VaibhaviS: Created page with "'''Title of the Script: Create a Spine Label Template''' '''Author: '''Vaibhavi Satardekar and Maya Hans '''Keywords: '''Koha, Koha 24.05, Cataloging Module, Label Creator,..."

'''Title of the Script: Create a Spine Label Template'''

'''Author: '''Vaibhavi Satardekar and Maya Hans

'''Keywords: '''Koha, Koha 24.05, Cataloging Module, Label Creator, Label Template, Spine Label, Video Tutorial.

'''Prerequisite: '''Cataloging

{|border=1
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide Number 1'''

'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Create''' a '''Spine Label Template''' in '''Koha'''.
|-
|| '''Slide Number 2'''

'''Learning Objectives'''

We will learn how to:
* '''Create '''a''' Spine Label Template'''

|| In this tutorial, we will learn how to:

* '''Create '''a''' Spine Label Template '''in''' Koha'''.

|-
|| '''Slide Number 3'''

'''System Requirement'''

To record this tutorial, I am using
* '''Ubuntu Linux OS version 22 point 04'''
* '''Koha version 24 point 05'''
* '''Firefox version 131 point 0 point 3'''
* '''A working internet connection'''

|| To record this tutorial, I am using
* '''Ubuntu Linux OS version 22 point 04'''
* '''Koha version 24 point 05'''
* '''Firefox version 131 point 0 point 3'''

I also have a working internet connection.
|-
|| '''Slide Number 4'''

'''Pre-requisites'''
* You should have knowledge of Library Science

|| To follow this tutorial, you should have knowledge of Library Science.
|-
|| Login with '''Superlibrarian''' account

'''Username - Bella '''

'''Password - Library@1'''

Choose '''Library''' as '''Spoken Tutorial Library.'''

Click on '''Login'''
|| To''' create '''a''' spine label template''' I have already logged in as a '''Superlibrarian'''.

|-
|| Click on '''Cataloging module '''
|| On the Koha homepage click on the''' Cataloging module'''.
|-
|| Highlight '''Cataloging '''page
|| The '''Cataloging '''page opens.
|-
|| Cursor on '''Tools''' >> Choose '''<nowiki>#Label Creator</nowiki>'''
|| Now go to the '''Tools''' section and click on '''Label Creator'''.
|-
|| Highlight '''Label creator '''
|| The '''Label creator '''page opens.
|-
|| Click on '''New''' dropdown >> '''Label template'''
|| Now click on the '''New''' dropdown and select '''Label template'''.
|-
|| Highlight '''New label template'''
|| The '''New label template '''page opens.
|-
|| Cursor on '''Template code''' and '''Template description'''

Enter '''Template code: Spine Template'''

Leave''' '''the '''Template description: 5 columns and 10 rows.'''
|| You can create '''Template code''' and '''Template description''' for this '''Label'''.

For now we will enter the '''Template code '''as a '''Spine Template'''.

In the '''Template description '''textbox''' '''we will type '''5 columns and 10 rows'''.
|-
|| Cursor on '''Units'''

Click on''' '''dropdown >> '''US Inches'''
|| Next for the '''Units '''field click on the dropdown and select '''US Inches.'''
|-
|| Cursor on '''Page height''' and '''Page width'''

Enter''' Page height: 11 in'''

Enter''' Page width 8.5 in'''

Enter''' Label width: 2.5 in'''

Enter''' Label height 1.5 in'''
|| Now we will set the margin for the spine template as shown here.

|-
|| Cursor on '''Top page margin''' field

Enter '''Top page margin: .5 in'''

Enter '''Left page margin: .4 in'''

Enter '''Top''' '''text margin: .125 in'''

Enter '''Left text margin: .1'''

Enter '''Number of columns''': '''5 '''

Enter '''Number of rows''': '''10'''

Enter '''Gap between columns: .12 in '''

Enter '''Gap between rows: .5 in'''

|| Moving to the right side, we will also set the margin for the following fields as shown here.
|-
|| Click on '''Save''' button

Highlight '''Label template''' page

Cursor on the results
|| After filling all the details click on the '''Save''' button at the bottom of the page.

This will bring us back to the '''Label templates''' page.

Here we can see the '''Spine Template '''is''' '''created successfully.

With this we come to the end of this tutorial.
|-
|| '''Slide Number 5'''

'''Summary'''

We learned to:
* '''Create '''a''' Spine Label Template '''

|| Let’s quickly recap.

Today we learned how to:
* '''Create '''a''' Spine Label Template''' in '''Koha'''.

|-
|| '''Slide Number 6'''

'''Assignment'''

Create''' '''another''' Spine Label Template'''

with the following dimensions:
* '''Page width: 5.83 in'''
* '''Barcode height: 8.27 in'''
* '''Label width: 0.8 in'''
* '''Label height: 2.0 in'''

|| As an assignment
* '''Create '''another''' Spine Label Template'''.

|-
|| '''Slide Number 7'''

'''Thank you'''
|| Thank you for joining.
|-
|}

Koha-Library-Software/C2/Add-a-Patron-Image/English

2025-06-11T11:46:55Z

VaibhaviS: Created page with "'''Title of the Script: Add a Patron Image ''' '''Author: '''Vaibhavi Satardekar and Maya Hans '''Keywords: '''Koha, Koha 24.05, System preferences, Patrons module, Patrons..."

'''Title of the Script: Add a Patron Image '''

'''Author: '''Vaibhavi Satardekar and Maya Hans

'''Keywords: '''Koha, Koha 24.05, System preferences, Patrons module, Patrons preferences, Patronimage, Patron photo, Video tutorial.

'''Pre-requisites: '''Add a New Patron

{|border=1
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide Number 1'''

'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Add '''a''' patron image '''in '''Koha'''.
|-
|| '''Slide Number 2'''

'''Learning Objectives'''

We will learn how to:
* '''Add '''a''' patron image'''

|| In this tutorial, we will learn how to:

* '''Add '''a''' patron image'''

|-
|| '''Slide Number 3'''

'''System Requirement'''

To record this tutorial, I am using
* '''Ubuntu Linux OS version 22 point 04'''
* '''Koha version 24 point 05'''
* '''Firefox version 131 point 0 point 3'''
* '''A working internet connection'''

|| To record this tutorial, I am using
* '''Ubuntu Linux OS version 22 point 04.'''
* '''Koha version 24 point 05.'''
* '''Firefox version 131 point 0 point 3.'''

I also have a working internet connection.
|-
|| '''Slide Number 4'''

'''Pre-requisites'''
* You should have knowledge of Library Science

|| To follow this tutorial, you should have knowledge of Library Science.
|-
|| Show login interface screenshot

'''Username''': '''Bella'''

'''Password:''' '''Library@1'''

'''Library: Spoken Tutorial Library'''

Click on '''Login'''
|| To add a patron image I have already logged in as '''Superlibrarian'''.

|-
|| Show '''Koha '''staff Interface

Click on '''Koha administration module '''
|| Now click on the''' Koha administration module'''.
|-
|| '''Koha administration '''page

Click on '''System preferences'''
|| The '''Koha administration '''page opens.

Click on '''System preferences'''.
|-
|| '''System preferences Accounting preferences '''page
|| '''System preferences Accounting preferences '''page opens.
|-
|| Click on '''Patrons'''
|| Now scroll down and from the left side panel click on '''Patrons'''.
|-
|| '''System preferences Patrons preferences '''page
|| '''System preferences Patrons preferences '''page opens.
|-
|| Cursor on''' General>>Preference '''and '''Value'''

Change the '''Value '''of '''Patronimage''' '''Preferences '''as '''Allow'''

Click on''' Save all Patrons preferences'''
|| Under the section''' General''' we can see two columns.

One is '''Preference '''and another one is '''Value'''.

Now scroll down and change the '''Value '''of '''Patronimages''' preferences''' '''as '''Allow'''.

Now click on the '''Save all Patrons preferences '''button at the top.
|-
|| Pop message in a black box confirms:

'''Saved preference patronimages'''
|| A message in the black box confirms the '''Saved preferences'''.
|-
|| Click on '''Home''' icon
|| Now scroll up and go to the top left corner of the page, and click on the '''Home''' icon.

This will bring us back to the '''Koha''' homepage.
|-
|| Click on the '''Patrons module'''

'''Patron''' page

In the '''Search patrons '''bar >>''' Maya'''
|| Now click on the '''Patrons module'''.

'''Patrons''' page opens.

In the '''Search patrons '''bar enter the patron card number or a partial name.

I will enter the patron’s name as''' Maya '''and press '''Enter'''.
|-
|| Patron details '''Ms''' '''Maya '''

Cursor on placeholder image box

Go to the left side>>upload patron image click on '''+Add'''
|| A page opens with patron details of '''Miss Maya Hans'''.

On the left side we can see a placeholder image.

Under the patron’s name and a box to upload a patron image.

Now in the upload patron image''' '''box click on the '''+Add '''button.
|-
|| A pop-up window '''Patron photo'''

Click on '''Browse'''

Pop-up window '''File upload'''

Choose the image and click on '''Select'''

'''Patron photo '''pop-up window

Click on '''Upload photo'''
|| A pop-up window '''Patron photo '''opens.

To upload an existing image, click '''Browse''' to find the image on your computer.

'''The image used in this video is provided in the code file link. '''

'''You can download, extract and use it for practicing. '''

Again a pop-up window '''File upload''' opens.

Here, choose the image and click on '''Select'''.

This will bring us back to the same '''Patron photo '''pop-up window.

Now click on the '''Upload photo '''to load the image in the patron’s file.
|-
|| Cursor on patron image
|| This will bring us back to the patron page.

Here we can see the patron image is uploaded successfully.
|-
|| Narration only
|| With this, we come to the end of this tutorial.
|-
|| '''Slide Number 5'''

'''Summary'''

In this tutorial we learned to:
* '''Add''' a '''patron image'''

|| Let’s quickly recap!

Today, we learned to
* '''Add''' a '''patron image'''.

|-
|| '''Slide Number 6'''

'''Assignment'''
* Add another patron’s image

|| As an assignment:
* Add another patron’s image.

|-
|| '''Slide Number 7'''

'''Thank you'''
|| Thank you for joining.
|-
|}