<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=windows-1256"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<font face="Arial">Sir,<br>
<br>
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. <br>
<br>
********************************<br>
<span style="font-size: 10pt; font-family: Arial;">Free
barcode 39 font<span style=""> </span><a
href="http://www.squaregear.net/fonts/free3of9.shtml"><span style="">http://www.squaregear.net/fonts/free3of9.shtml</span></a><o:p></o:p></span>
<br>
<span style="font-size: 10pt; font-family: Arial;">Free (for
non-profit and edu) label making/design software <a
href="http://www.idautomation.com/labelsoftware/free/"><span style="">http://www.idautomation.com/labelsoftware/free/</span></a></span><br>
<span style="font-size: 10pt; font-family: Arial;">MySQLAdmin and GUI
tools from
<a class="moz-txt-link-freetext" href="http://library.pantek.com/Applications/MySQL/Downloads/MySQLGUITools/">http://library.pantek.com/Applications/MySQL/Downloads/MySQLGUITools/</a></span><span
style="font-size: 10pt; font-family: Arial;">mysql-gui-tools-5.0-r12-win32.msi
</span><br>
<span style="font-size: 10pt; font-family: Arial;"><o:p></o:p></span><br>
<span style="font-size: 10pt; font-family: Arial;"><o:p></o:p></span><span
style="font-size: 10pt; font-family: Arial;"><o:p></o:p></span>Install
<span style="font-size: 10pt; font-family: Arial;">MySQLGUITools.</span><br>
<span style="font-size: 10pt; font-family: Arial;">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.<o:p></o:p></span>
<br>
<span style="font-size: 10pt; font-family: Arial;"><a
href="http://www.daniweb.com/forums/thread22066.html"><span style=""></span></a></span><span
style="font-size: 10pt; font-family: Arial;"><a
href="http://www.informit.com/articles/article.aspx?p=377068&seqNum=7"><span
style=""></span></a></span><br>
<span style="font-size: 10pt; font-family: Arial;">the SQL
query :<o:p></o:p></span>
<br>
<span style="font-size: 10pt; font-family: Arial;">SELECT
biblio.biblionumber, biblio.title, items.barcode, items.itemcallnumber
FROM
biblio, items WHERE biblio.biblionumber = items.biblionumber;<o:p></o:p></span>
<br>
<span style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span>
<br>
<span style="font-size: 10pt; font-family: Arial;">Will
produce (in my case) a CSV like<o:p></o:p></span></font>
<table class="MsoNormalTable"
style="width: 433.5pt; margin-left: 4.65pt; border-collapse: collapse;"
border="0" cellpadding="0" cellspacing="0" width="578">
<tbody>
<tr style="height: 12.75pt;">
<td style="padding: 0in 5.4pt; width: 58.75pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="78"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">biblionumber<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">title<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">barcode<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">itemcallnumber<o:p></o:p></span></font>
</td>
</tr>
<tr style="height: 12.75pt;">
<td style="padding: 0in 5.4pt; width: 58.75pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="78"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">1<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">Novell's ZENworks
administrator's handbook /<o:p></o:p></span></font> </td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">1<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></font>
</td>
</tr>
<tr style="height: 12.75pt;">
<td style="padding: 0in 5.4pt; width: 58.75pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="78"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">2<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">The New York Public
Library desk reference.<o:p></o:p></span></font> </td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">30525<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">031 new<o:p></o:p></span></font>
</td>
</tr>
<tr style="height: 12.75pt;">
<td style="padding: 0in 5.4pt; width: 58.75pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="78"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">3<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">Picture perfect /<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">36003<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">FIC PIC<o:p></o:p></span></font>
</td>
</tr>
<tr style="height: 12.75pt;">
<td style="padding: 0in 5.4pt; width: 58.75pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="78"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">6<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">Just listen :<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">30431<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">FIC DES<o:p></o:p></span></font>
</td>
</tr>
<tr style="height: 12.75pt;">
<td style="padding: 0in 5.4pt; width: 58.75pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="78"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">5<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">The lovely bones :<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">30319<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">FIC SEB<o:p></o:p></span></font>
</td>
</tr>
<tr style="height: 12.75pt;">
<td style="padding: 0in 5.4pt; width: 58.75pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="78"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">8<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">Unexplained /<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">109541<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">001.94 ALL<o:p></o:p></span></font>
</td>
</tr>
<tr style="height: 12.75pt;">
<td style="padding: 0in 5.4pt; width: 58.75pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="78"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">9<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">Whatever happened to
Janie? /<o:p></o:p></span></font> </td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">109542<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></font>
</td>
</tr>
<tr style="height: 12.75pt;">
<td style="padding: 0in 5.4pt; width: 58.75pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="78"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">10<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">The bad beginning /<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">50000<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">F SNI<o:p></o:p></span></font>
</td>
</tr>
<tr style="height: 12.75pt;">
<td style="padding: 0in 5.4pt; width: 58.75pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="78"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">11<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">The field guide /<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">50003<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">F DIT<o:p></o:p></span></font>
</td>
</tr>
<tr style="height: 12.75pt;">
<td style="padding: 0in 5.4pt; width: 58.75pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="78"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">12<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">The clique :<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">109528<o:p></o:p></span></font>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124"> <font face="Arial"><span
style="font-size: 10pt; font-family: Arial;">F HAR<o:p></o:p></span></font>
</td>
</tr>
</tbody>
</table>
<font face="Arial"><span style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span>
<br>
<span style="font-size: 10pt; font-family: Arial;">As you
get into larger and larger biblionumbers you may want to add a > to
the
query:<o:p></o:p></span><br>
<span style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span>
<br>
<span style="font-size: 10pt; font-family: Arial;">SELECT
biblio.biblionumber, biblio.title, items.barcode, items.itemcallnumber
FROM
biblio, items WHERE biblio.biblionumber>4 = items.biblionumber;<o:p> </o:p></span>
<br>
<span style="font-size: 10pt; font-family: Arial;">The >4
causes the query to only show rows where the biblionumber is (greater
than)>
4<o:p></o:p></span><br>
******************************************************<br>
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.
<br>
I include the barcode, title, call number, and school name on all of my
labels.<br>
<br>
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.<br>
<br>
-Scott Owen<br>
Alma Public Schools<br>
<br>
</font>
<br>
<br>
<br>
mohamed megahed wrote:
<blockquote cite="midBAY111-W45B3F6770FEE5E380E835AE8BF0@phx.gbl"
type="cite">
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>hi all<br>
i install koha 2.2.8 on win32<br>
apache 2.2.4<br>
mysql 5.0.45<br>
when i try to print barcode from barcodesgenerator i have the error :<br>
<br>
Premature end of script headers: barcodesGenerator.pl, referer: <a
href="http://intranet/cgi-bin/koha/barcodes/barcodes.pl">http://intranet/cgi-bin/koha/barcodes/barcodes.pl</a><br>
[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: <a href="http://intranet/cgi-bin/koha/barcodes/barcodes.pl">http://intranet/cgi-bin/koha/barcodes/barcodes.pl</a><br>
<br>
please help me to solve this problem<br>
<br>
thnks<br>
<br>
<br>
<br>
<p dir="ltr" style="margin-right: 0px;" align="center"> </p>
<span style="font-size: 10pt; color: black;" itc??="" blackadder=""></span><font
size="6"><strong><span style="font-size: 10pt; color: red;" itc??=""
blackadder=""><font size="5"></font>
<p
style="background: white none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; text-align: center;"
align="center"><span style="font-size: 10pt; color: black;"
verdana?,?sans-serif??=""></span><font size="5"><strong><span
style="font-size: 10pt; color: red;" handwriting??="" lucida=""><img
moz-do-not-send="true"
src="http://gfx1.hotmail.com/mail/w2/emoticons/rose.gif">MOHAMED
MEGAHED</span></strong><b><span style="font-size: 10pt; color: red;"
handwriting??="" lucida=""> <img moz-do-not-send="true"
src="http://gfx1.hotmail.com/mail/w2/emoticons/rose.gif"></span></b><span
style="font-size: 10pt; color: black;" verdana?,?sans-serif??=""><br>
</span><strong><span style="font-size: 10pt; color: red;"
handwriting??="" lucida=""> Librarian & Technical support </span></strong><span
style="font-size: 10pt; color: black;" verdana?,?sans-serif??=""><br>
</span><strong><span style="font-size: 10pt; color: red;"
handwriting??="" lucida="">Misr International University Library</span></strong><span
style="font-size: 10pt;" verdana?,?sans-serif??=""></span></font></p>
<p
style="background: white none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; text-align: center;"
align="center"><font size="5"><strong><span
style="font-size: 10pt; color: red;" handwriting??="" lucida="">+02
010 22 97 962</span></strong><span
style="font-size: 10pt; color: black;" verdana?,?sans-serif??=""></span></font></p>
<p
style="background: white none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; margin-bottom: 12pt; text-align: center;"
align="center"><font size="5"><strong><span
style="font-size: 10pt; color: red;" handwriting??="" lucida="">+02 44
77 15 60 </span></strong><span style="font-size: 10pt; color: black;"
verdana?,?sans-serif??=""></span></font></p>
</span></strong></font><font size="6"><br>
</font>
<hr><font size="6">Explore the seven wonders of the world <a
href="http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE"
target="_new">Learn more!</a></font>
<pre wrap=""><font size="6">
</font><hr size="4" width="90%"><font size="6">
_______________________________________________
Koha mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a>
<a class="moz-txt-link-freetext" href="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</a>
</font></pre>
</blockquote>
<br>
</body>
</html>