[Koha] Fwd: Printing Patron Cards with Names

[Marty]

As I understand it, some people are still working on the label tool, for now it leaves something to be desired. On the other hand, I think we do not need absolutely everything in one program, as there are other programs well capable of taking over some functions.

If you are running on Linux (which I think you do, cause you have Koha 3) take a look at kbarcode (kbarcode.net). It is (obviously) designed for kde, but it works great on my gnome desktop.

Once you have installed it, make sure you can connect to your koha database.
Then you can just enter queries, like

SELECT branchcode FROM borrowers WHERE borrowernumber = ##;
SELECT  firstname, surname FROM borrowers WHERE borrowernumber = ##;
SELECT borrowernumber FROM borrowers WHERE borrowernumber = ##;


Where the ## means a number.  If you want to do a range (like existing patrons) you can use something similar to the following we use for printing barcodes for existing items in our library, taking data from an extra table in our dbase called interim which exists of id, barcode, usually filled with a LOAD DATA INFILE  statement from a .cvs file.
[sqlquery: SELECT barcode FROM interim WHERE id = '[index]' + 1;]

Hope this helps,

Marty



--- On Wed, 4/28/10, Chris Cormack <chris at bigballofwax.co.nz> wrote:

From: Chris Cormack
 <chris at bigballofwax.co.nz>
Subject: [Koha] Fwd: Printing Patron Cards with Names
To: "koha-user" <koha at lists.katipo.co.nz>
Received: Wednesday, April 28, 2010, 12:06 AM

Forwarding to the mailing list


---------- Forwarded message ----------
From: John <john.winter at neverseen.ch>
Date: 28 April 2010 06:49
Subject: Printing Patron Cards with Names
To: koha-owner at lists.katipo.co.nz


Hello,



I try to print patron Cards with koha3.00.06 Label creator Tool.



I searched how to print the cards with the name of the patron on it.
But I did not find the function to do it.



I searched the internet and wiki. But couldn’t find any hint
 to do
this. Is there a possibility to do that or where can I configure it?



I am new to Koha. Perhaps I did not see the function?



The Format of the Card should be like this:



|-------------------------------------------------------------------- |

| Libraryname                                                  |

| Firstname + Surname of Patron                    
 |

|                                                                     |

| Barcode                                                      
 |

|                                                                     |

|-------------------------------------------------------------------- |



Thanks a lot for your help.



Greetings

John
_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100428/d3676af3/attachment-0001.htm