Koha-Library-Software/C3/Import-Patron-Data/English
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.
| 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:
|
In this tutorial, we will learn how to:
|
| Slide Number 3
System Requirement To record this tutorial, I am using
|
To record this tutorial, I am using
I also have a working internet connection. |
| Slide Number 5
Pre-requisites
|
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:
|
Let’s quickly recap. |
| Slide Number 7
Assignment
|
As an assignment
|
| Slide Number 8
Thank you |
Thank you for joining. |
