Difference between revisions of "Koha-Library-Software/C3/Import-Patron-Data/English"
| Line 12: | Line 12: | ||
|- | |- | ||
|| '''Slide Number 1''' | || '''Slide Number 1''' | ||
| + | |||
'''Title Slide''' | '''Title Slide''' | ||
|| Welcome to this Spoken Tutorial on '''Import Patron Data''' in '''Koha'''. | || Welcome to this Spoken Tutorial on '''Import Patron Data''' in '''Koha'''. | ||
|- | |- | ||
|| '''Slide Number 2''' | || '''Slide Number 2''' | ||
| + | |||
'''Learning Objectives''' | '''Learning Objectives''' | ||
| + | |||
We will learn how to: | We will learn how to: | ||
* '''Import Patron Data''' | * '''Import Patron Data''' | ||
| Line 24: | Line 27: | ||
|- | |- | ||
|| '''Slide Number 3''' | || '''Slide Number 3''' | ||
| − | '''System | + | |
| − | To record this tutorial, I am using | + | '''System Requirements''' |
| + | |||
| + | To record this tutorial, I am using: | ||
| + | |||
* '''Ubuntu Linux OS v22.04''' | * '''Ubuntu Linux OS v22.04''' | ||
* '''Koha v24.05''' | * '''Koha v24.05''' | ||
| Line 31: | Line 37: | ||
* '''A working internet connection''' | * '''A working internet connection''' | ||
| − | || To record this tutorial, I am using | + | || To record this tutorial, I am using: |
| + | |||
* '''Ubuntu Linux OS version 22 point 04''' | * '''Ubuntu Linux OS version 22 point 04''' | ||
* '''Koha version 24 point 05''' | * '''Koha version 24 point 05''' | ||
| Line 39: | Line 46: | ||
|- | |- | ||
|| '''Slide Number 5''' | || '''Slide Number 5''' | ||
| + | |||
'''Pre-requisites''' | '''Pre-requisites''' | ||
| + | |||
* You should have knowledge of Library Science | * You should have knowledge of Library Science | ||
| Line 66: | Line 75: | ||
|| On the '''Koha''' staff interface click on the '''Tools''' module. | || On the '''Koha''' staff interface click on the '''Tools''' module. | ||
| − | '''Tools '''page opens. | + | '''Tools ''' page opens. |
Under '''Patrons and circulation''' locate''' Import patrons'''. | Under '''Patrons and circulation''' locate''' Import patrons'''. | ||
| Line 76: | Line 85: | ||
|- | |- | ||
|| Cursor on '''Notes''' | || Cursor on '''Notes''' | ||
| + | |||
Got to Downloads folder | Got to Downloads folder | ||
| + | |||
Click on '''patron_import''' file | Click on '''patron_import''' file | ||
| Line 134: | Line 145: | ||
|- | |- | ||
|| Cursor on '''Import into the borrowers table''' | || Cursor on '''Import into the borrowers table''' | ||
| + | |||
Cursor on '''Select the file to import''' | Cursor on '''Select the file to import''' | ||
| Line 159: | Line 171: | ||
Click on the '''Import button''' | Click on the '''Import button''' | ||
| + | |||
|| Now scroll down the '''Import patrons page '''. | || Now scroll down the '''Import patrons page '''. | ||
| Line 177: | Line 190: | ||
|| Cursor on '''Patron Details''' | || Cursor on '''Patron Details''' | ||
|| This will open the '''Patron Details''' page. | || This will open the '''Patron Details''' page. | ||
| + | |||
Here we can see that patron data has been imported successfully. | Here we can see that patron data has been imported successfully. | ||
|- | |- | ||
| Line 183: | Line 197: | ||
|- | |- | ||
|| '''Slide Number 6''' | || '''Slide Number 6''' | ||
| + | |||
'''Summary''' | '''Summary''' | ||
| + | |||
We learned to: | We learned to: | ||
* '''Import Patron Data''' | * '''Import Patron Data''' | ||
| + | |||
|| Let’s quickly recap. | || Let’s quickly recap. | ||
|- | |- | ||
|| '''Slide Number 7''' | || '''Slide Number 7''' | ||
| + | |||
'''Assignment''' | '''Assignment''' | ||
| + | |||
* Randomly add 5 patrons’ details in the CSV file and import data | * Randomly add 5 patrons’ details in the CSV file and import data | ||
| − | || As an assignment | + | || As an assignment, |
| + | |||
* Randomly add 5 patrons' details in the CSV file and import data. | * Randomly add 5 patrons' details in the CSV file and import data. | ||
|- | |- | ||
|| '''Slide Number 8''' | || '''Slide Number 8''' | ||
| + | |||
Thank you | Thank you | ||
|| Thank you for joining. | || Thank you for joining. | ||
|- | |- | ||
|} | |} | ||
Revision as of 15:50, 8 October 2025
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 Requirements 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 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:
|
Let’s quickly recap. |
| Slide Number 7
Assignment
|
As an assignment,
|
| Slide Number 8
Thank you |
Thank you for joining. |
