Resize patron images to upload

Resize  patron images before upload into Koha. Big size patron images can make Koha database size big. You can resize images using imagemagick commands with Ubuntu or Debian.

Install Image Magick

sudo apt-get install imagemagick

Copy all patron images into a folder. Enter inside the folder from command Terminal, Example:

cd /home/koha/Pictures 

mogrify -resize 50% -format jpg *


Change percentage based on the original file size.

Resize image by specifies width and height,

mogrify -resize 800x600 -format jpg *

Specify width only, it automatically calculate height,

mogrify -resize 800x -format jpg *

Information courtesy: Shaiful Azam's Weblog

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.