<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
here is the process I've come up with....<br>
<span style="font-size: 10pt; font-family: Arial;"><br>
<br>
*********************************************<br>
Barcodes
& labels<o:p></o:p></span>
<p class="MsoNormal" style=""><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></p>
<p class="MsoNormal" style=""><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><o:p></o:p></span></p>
<p class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></p>
<p class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: Arial;">On the
server use MySQLAdmin (GUI) > Query Browser > select (double
click) on “items”
(the query should pop-up in the query window) (SELECT * FROM items I;)<o:p></o:p></span></p>
<span style="font-size: 10pt; font-family: Arial;">use a multi-table
MySQL query to pull all of the data from both the biblio and
items tables into a single “outputable” table, then export to CSV.<o:p></o:p></span>
<p class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: Arial;"><a
href="http://www.daniweb.com/forums/thread22066.html"><span style="">http://www.daniweb.com/forums/thread22066.html</span></a><o:p></o:p></span></p>
<p class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: Arial;"><a
href="http://www.informit.com/articles/article.aspx?p=377068&seqNum=7"><span
style="">http://www.informit.com/articles/article.aspx?p=377068&seqNum=7</span></a><o:p></o:p></span></p>
<p class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></p>
<p class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: Arial;">the SQL
query :<o:p></o:p></span></p>
<p class="MsoNormal" style=""><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></p>
<p class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></p>
<p class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: Arial;">Will
produce (in my case) a CSV like<o:p></o:p></span></p>
<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">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">biblionumber<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">title<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">barcode<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">itemcallnumber<o:p></o:p></span></p>
</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">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">1<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">Novell's ZENworks
administrator's handbook /<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">1<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></p>
</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">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">2<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">The New York Public
Library desk reference.<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">30525<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">031 new<o:p></o:p></span></p>
</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">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">3<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">Picture perfect /<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">36003<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">FIC PIC<o:p></o:p></span></p>
</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">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">6<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">Just listen :<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">30431<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">FIC DES<o:p></o:p></span></p>
</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">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">5<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">The lovely bones :<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">30319<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">FIC SEB<o:p></o:p></span></p>
</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">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">8<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">Unexplained /<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">109541<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">001.94 ALL<o:p></o:p></span></p>
</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">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">9<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">Whatever happened to
Janie? /<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">109542<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></p>
</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">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">10<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">The bad beginning /<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">50000<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">F SNI<o:p></o:p></span></p>
</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">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">11<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">The field guide /<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">50003<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">F DIT<o:p></o:p></span></p>
</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">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">12<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 200.5pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="267">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">The clique :<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 81.25pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="108">
<p class="MsoNormal" style="text-align: right;" align="right"><span
style="font-size: 10pt; font-family: Arial;">109528<o:p></o:p></span></p>
</td>
<td style="padding: 0in 5.4pt; width: 93pt; height: 12.75pt;"
nowrap="nowrap" valign="bottom" width="124">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Arial;">F HAR<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: Arial;">(note: As you
get into larger and larger biblionumbers you may want to add a > to
the
query:<o:p></o:p></span></p>
<p class="MsoNormal" style=""><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></p>
<p class="MsoNormal" style=""><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></p>
<p class="MsoNormal" style="">
</p>
<p class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: Arial;"><o:p> </o:p><br>
>From this
point, it’s just a few quick steps to have the CSV ready to print
labels.<o:p></o:p></span></p>
<p class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: Arial;">1. Delete
the biblionumber column.<o:p></o:p></span></p>
<p class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: Arial;">2. Add a
column for our School name<o:p></o:p></span></p>
<p class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: Arial;">3.
Install the free barcode 39 font (unzip and drag the 2 font files to
your
c:\windows\fonts folder)<o:p></o:p></span></p>
<p class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: Arial;">4. Create
your labels with the label making/design software<o:p></o:p></span></p>
<p class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: Arial;">5. Link
your CSV to the label software and……print labels.<o:p></o:p></span></p>
<p class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: Arial;">6.
or……Purchase a Brother QL-500 (comes with it’s own software that works
almost
exactly like the free stuff)<o:p></o:p></span></p>
<p class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: Arial;"><o:p><br>
<br>
</o:p></span></p>
<span style="font-size: 10pt; font-family: Arial;"><o:p></o:p></span>
Rob Weir wrote:
<blockquote cite="mid48C91060.1070209@alum.drexel.edu" type="cite">
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
Hi Mitali,<br>
The barcode support in koha 2.2.9 is not great. It would probably be
better to use a separate application to print your barcode labels, or
purchase pre-printed labels.<br>
<br>
Here are a couple links for free or low-cost barcode solutions for the
windows platform:<br>
<a href="http://barcode4j.sourceforge.net">http://barcode4j.sourceforge.net</a>
(java based)<br>
<a href="http://www.idautomation.com/labelsoftware/free/">http://www.idautomation.com/labelsoftware/free/</a><br>
<a href="http://www.protonbarcode.com/">http://www.protonbarcode.com/</a><br>
<br>
You can also find a variety of free barcode fonts for windows that can
be used for labels. I have collected quite a few of these. Contact me
off-list if you are interested.<br>
<br>
Rob<br>
<br>
<br>
Mitali Phatarpekar wrote:
<blockquote
cite="mid:6d09c0af0809100537v12800cdas26b81f6716494b4d@mail.gmail.com"
type="cite">
<div>Could anyone guide me through generation of barcodes using
Koha
2.2.9-Windows version.</div>
<div> </div>
<div>Mitali</div>
<pre wrap=""><hr size="4" width="90%">
_______________________________________________
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>
</pre>
</blockquote>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
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>
</pre>
</blockquote>
<br>
</body>
</html>