How to Create Book Barcode and Student's/Saff's ID Card Label Barcode using Glabels Software (Data Download from Koha Software)

GLabels is a free software tool to generate labels/barcodes for various purposes (e.g. Book Barcode, Students/Staffs ID card barcode labels and etc.. )

Install glabels

   1. Open the Terminal (Shortcut: Ctrl + Alt + T)
   2. Type the following command:  sudo apt-get update
   3. Press Enter or Return and type in your password
   4. Type the following command:  sudo apt-get install glabels
   5. Type Y and press Enter or Return

Open Terminal on your Koha System and applying following command.

sudo apt-get install glabels

You can find Glabels in Application > Office > Glabels

Prepare Labels for Barcode/Label creation

Download the Book Barcode template files from here,

Extract them. It contains a Glabels template. Open the Glabels template (Book Barcode 5x13.glabels and User ID Barcode 3x7.glabels) by clicking on the file. 

1.1 Create an book Barcode.

Prepare a list for barcode/label creation

Prepare a Report in Koha to get the list of the barcode (College Name, Call number and Accession number)

Go to : Reports > Create from SQL

Copy and Paste the following SQL

SQL:

SELECT items.homebranch,items.itemcallnumber,items.barcode

FROM items

LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber)

LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)

WHERE cast(items.barcode AS UNSIGNED) BETWEEN <<Accession Number>> AND <<To Accession Number>>

ORDER BY items.barcode ASC

Download the Book barcode report in csv format.

1.2 Create an Students/Staffs ID Barcode.

Prepare a Report in Koha to get the list of the barcode (ID Number, Name, Department and designation)

Go to : Reports > Create from SQL

Copy and Paste the following SQL

SQL:

SELECT borrowers.cardnumber,borrowers.surname,borrowers.borrowernotes,borrowers.categorycode FROM borrowers WHERE branchcode=<<Enter patrons library|branches>> AND categorycode LIKE <<Select User category|categorycode>>

ORDER BY LPAD(borrowers.cardnumber,100,' ') ASC

Download the User Barcode report in csv format.

How to Uninstall gLabels:

   1. Open the Terminal (Shortcut: Ctrl + Alt + T)
   2. Type the following command:   sudo apt-get remove glabel

sudo apt-get remove glabels