<!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>