Create barcode/label using glabels software

GLabels is a free software tool to generate labels/barcodes for various purposes. GLabel can be make use for label creation and print on label printing papers (e.g. Avery-6121, 65 per sheet).


Install glabels
Either you can search and install glabels from Ubuntu Software center.

apt-get install glabels

You can find glabel in Application > Office > Glabels

Prepare list for barcode/label creation

Prepare a Report in Koha to get the list of barcode (accession number) and call number.


You can make use following SQL query to generate above displayed report.

Reports > Use saved > Create from SQL

Here is two useful reports to generate list for barcode label creation

Book list between range of accession numbers.
SELECT items.barcode,items.itemcallnumber
FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) 
WHERE items.homebranch =<<Branch|branches>> AND items.barcode BETWEEN <<From Acc>> AND <<To Acc)>>
ORDER BY LPAD(items.barcode,30,' ') ASC

Call number list

SELECT items.barcode,items.itemcallnumber
FROM items
LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
WHERE homebranch = <<Pick your branch|branches>> AND items.itemcallnumber LIKE <<Call number LIKE (USE % FOR wildcard)>> 
ORDER BY items.itemcallnumber ASC

Download download the report.

Another method is prepare list in spreadsheet and save in .csv format.
Copy and paste the list in a spreadsheet (e.g. Libreoffice, OpenOffice).
Save the sheet as .csv file.

Prepare Glabels for Barcode/Label creation
Download a glabel template from here, accession number and call number will display in the barcode.
Open the glabel template (koha-barcode.glabels) by clicking on the file.


See the template open in glabel. Click on the merge button. You can change the library code (MGUL) by clicking on it.



Find the csv file which contain list of accession number and call number.



You can see accession number and call number. Click OK and return to Glabels main screen.


Click on print button to print barcodes in PDF. Otherwise you can print direct to your laser printer. You can print on ordinary bond paper or paper with 65 adhesive labels.


Change settings in Label tab to get two copies of the same label,

See the final result in PDF format.


4 comments:

  1. You can use IDautomations also it will give more flexibility and beauty to yr barcode http://www.idautomation.com/free-barcode-products/label-software/

    ReplyDelete
  2. how to add new barcode ''Code 39 full ASCII'' type on koha 22 or koha 18

    ReplyDelete
  3. how to add new barcode Code 39 full ASCII type on koha 22 or koha 18

    ReplyDelete