Sir, I was not happy with the standard barcode generated by Koha (when I could get them to work) so I used the following software and process to generate my own. ******************************** Free barcode 39 font http://www.squaregear.net/fonts/free3of9.shtml Free (for non-profit and edu) label making/design software http://www.idautomation.com/labelsoftware/free/ MySQLAdmin and GUI tools from http://library.pantek.com/Applications/MySQL/Downloads/MySQLGUITools/mysql-g... Install MySQLGUITools. Use a multi-table MySQL query to pull the data from both the biblio and items tables into a single “output” table, then export to CSV. <http://www.daniweb.com/forums/thread22066.html> <http://www.informit.com/articles/article.aspx?p=377068&seqNum=7> the SQL query : SELECT biblio.biblionumber, biblio.title, items.barcode, items.itemcallnumber FROM biblio, items WHERE biblio.biblionumber = items.biblionumber; Will produce (in my case) a CSV like biblionumber title barcode itemcallnumber 1 Novell's ZENworks administrator's handbook / 1 2 The New York Public Library desk reference. 30525 031 new 3 Picture perfect / 36003 FIC PIC 6 Just listen : 30431 FIC DES 5 The lovely bones : 30319 FIC SEB 8 Unexplained / 109541 001.94 ALL 9 Whatever happened to Janie? / 109542 10 The bad beginning / 50000 F SNI 11 The field guide / 50003 F DIT 12 The clique : 109528 F HAR As you get into larger and larger biblionumbers you may want to add a > to the query: SELECT biblio.biblionumber, biblio.title, items.barcode, items.itemcallnumber FROM biblio, items WHERE biblio.biblionumber>4 = items.biblionumber; The >4 causes the query to only show rows where the biblionumber is (greater than)> 4 ****************************************************** Install the barcode font, and the label making software. You can then design your labels, input data from the CSV, and produce your own custom labels with almost any information you desire. I include the barcode, title, call number, and school name on all of my labels. If you can obtain one, the Brother QL-500 is a wonderful label printer that also includes label design software that will allow you to print barcodes. -Scott Owen Alma Public Schools mohamed megahed wrote:
hi all i install koha 2.2.8 on win32 apache 2.2.4 mysql 5.0.45 when i try to print barcode from barcodesgenerator i have the error :
Premature end of script headers: barcodesGenerator.pl, referer: http://intranet/cgi-bin/koha/barcodes/barcodes.pl [Thu May 29 00:21:06 2008] [error] [client 127.0.0.1] Unable to open /tmp/664947-127.0.0.1-(From 0011 to 0012)-[29.5.2008]-[0:21:5].pdf for writing at C:/usr/site/lib/PDF/API2/Basic/PDF/File.pm line 511., referer: http://intranet/cgi-bin/koha/barcodes/barcodes.pl
please help me to solve this problem
thnks
*
*MOHAMED MEGAHED** * * Librarian & Technical support * *Misr International University Library*
*+02 010 22 97 962*
*+02 44 77 15 60 *
* ------------------------------------------------------------------------ Explore the seven wonders of the world Learn more! <http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE>
------------------------------------------------------------------------
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha