Patron import

We can import details of users from a list saved in spreadsheet (MS Excel/LibreOffice Calc). Every academic year colleges and schools prepare details of students got new admission in excel sheet. Librarian can collect list from office for the purpose of import into Koha.

Prepare patron list

Often details of students in save in spread sheet file (e.g. MS Excel). We have to arrange details in a spreadsheet. Here is an example. Filed names in header should same as in patron table. You can download sample file from here.

I have added here minimum patron fields. You can check other field names and add from here. 

This spread sheet represent student details from a school. cardnumber represent unique ID number of students. Student class can add in sort1 field. 

branchcode and categorycode are mandatory fields. 

Library code in Koha should be in branchcode field. 

You can check your library code from  

Koha > Administration > Libraries and Groups

Check Patron category code from 

Koha > Administration > Patron types and categories

Arrange patron details in spreadsheet. Save/Save As spread sheet to .csv format.

 

 Import Patrons

Goto Koha > Tools > Import Patrons

Upload csv file.

Press Import button. Import button located in bottom of the page.

See the result page. Your records imported successfully.