<HTML><HEAD>
<META content="text/html; charset=UTF-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18928"></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Just installed Koha from git, and the patron card/spine labels seem to work fine.</DIV>
<DIV> </DIV>
<DIV>However....</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>While using Koha 2.2.9 on win32 I was not happy with the standard barcode generated by Koha (when I <BR>could get them to work) so I used the following software and process to <BR>generate my own.<BR></DIV>
<DIV> </DIV>
<DIV><BR>Option 1 ********************************</DIV>
<DIV> </DIV>
<DIV>This requires allowing access to the MySQL database that holds all of your Koha information.</DIV>
<DIV>*BE CAREFUL AND MAKE SURE YOU UNDERSTAND THE RAMIFICATIONS OF DOING THIS*</DIV>
<DIV> </DIV>
<DIV>Barcodes are just a font. <BR>Free barcode 39 font <A href="http://www.squaregear.net/fonts/free3of9.shtml">http://www.squaregear.net/fonts/free3of9.shtml</A><BR></DIV>
<DIV>Free (for non-profit and edu) label making/design software <BR><A href="http://www.idautomation.com/labelsoftware/free/">http://www.idautomation.com/labelsoftware/free/</A><BR></DIV>
<DIV>MySQLAdmin and GUI tools from <BR><A href="http://library.pantek.com/Applications/MySQL/Downloads/MySQLGUITools/mysql-gui-tools-5.0-r12-win32.msi">http://library.pantek.com/Applications/MySQL/Downloads/MySQLGUITools/mysql-gui-tools-5.0-r12-win32.msi</A> <BR><BR><BR>Install MySQLGUITools.<BR>Use a multi-table MySQL query to pull the data from both the biblio and <BR>items tables into a single “output” table, then export to CSV.<BR><BR>the SQL query :<BR>SELECT biblio.biblionumber, biblio.title, items.barcode, <BR>items.itemcallnumber FROM biblio, items WHERE biblio.biblionumber = <BR>items.biblionumber;<BR><BR>Will produce (in my case) a CSV like<BR>biblionumber title barcode itemcallnumber<BR>1 Novell's ZENworks administrator's handbook / 1 <BR>2 The New York Public Library desk reference. 30525 031 new<BR>3 Picture perfect / 36003 FIC PIC<BR>6 Just listen : 30431 FIC DES<BR>5 The lovely bones : 30319 FIC SEB<BR>8 Unexplained / 109541 001.94 ALL<BR>9 Whatever happened to Janie? / 109542 <BR>10 The bad beginning / 50000 F SNI<BR>11 The field guide / 50003 F DIT<BR>12 The clique : 109528 F HAR<BR><BR><BR>As you get into larger and larger biblionumbers you may want to add a > <BR>to the query:<BR><BR>SELECT biblio.biblionumber, biblio.title, items.barcode, <BR>items.itemcallnumber FROM biblio, items WHERE biblio.biblionumber>4 = <BR>items.biblionumber;<BR>The >4 causes the query to only show rows where the biblionumber is <BR>(greater than)> 4<BR><BR>Install the barcode font, and the label making software. You can then <BR>design your labels, input data from the CSV, and produce your own custom <BR>labels with almost any information you desire.<BR>I include the barcode, title, call number, and school name on all of my <BR>labels.<BR><BR>If you can obtain one, the Brother QL-500 is a wonderful label printer <BR>that also includes label design software that will allow you to print <BR>barcodes.<BR><BR>This process is not as easy as just pressing the button in Koha, but, I <BR>have found it to work quite in my environment.<BR><BR></DIV>
<DIV>Option 2:******************************</DIV>
<DIV> </DIV>
<DIV>Create a "remote query" in PHP so that you can automagically generate a barcode ready list.</DIV>
<DIV>The cut/paste/format into a CSV, and print as above in option 1. </DIV>
<DIV> </DIV>
<DIV>example:</DIV>
<DIV><A href="http://koha.almaschools.net/RQ/booklist.php">http://koha.almaschools.net/RQ/booklist.php</A></DIV>
<DIV> </DIV>
<DIV>This requires a bit more work....but is very handy.</DIV>
<DIV> </DIV>
<DIV>If you want the messy details, let me know off list......</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>-Scott Owen</DIV>
<DIV>Alma Public Schools</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><BR><BR>>>> Chris Nighswonger<cnighswonger@foundations.edu> 8/23/2010 7:53 AM >>><BR>Hi David,<BR><BR></DIV>
<DIV class=gmail_quote>On Mon, Aug 16, 2010 at 4:02 AM, David M. Bucknell <SPAN dir=ltr><<A href="mailto:dbucknell@iteachnet.org">dbucknell@iteachnet.org</A>></SPAN> wrote:<BR>
<BLOCKQUOTE style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex" class=gmail_quote>If there is someone who would be willing to jury-rig patron card and<BR>spine label printing ... write a script ... I'd be willing to<BR>compensate hourly costs.<BR><BR>I haven't heard from anyone except Chris, who is a contributing<BR>programmer, I take it, so I guess everyone else has either an on-site<BR>team or is paying a provider. 3.06 seems pretty cool and there is<BR>really no alternative, so if anyone is willing to help for some cash<BR>via paypal, it would be worth it to me. I have three installations<BR>that need this, none of which have a budget, but all of them hell-bent<BR>on Koha because of me.<BR><BR></BLOCKQUOTE>
<DIV><BR>Why don't you just upgrade to the current beta of Koha 3.2? There are several libraries, including ours, that have been running over this code for months now.<BR><BR>It seems a bit counter productive to pay money for a feature that will die in a couple of weeks anyway.<BR><BR>Kind Regards,<BR>Chris<BR><BR></DIV>
<BLOCKQUOTE style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex" class=gmail_quote>----- Message from <A href="mailto:cnighswonger@foundations.edu">cnighswonger@foundations.edu</A> ---------<BR>Date: Fri, 13 Aug 2010 08:27:26 -0400<BR>From: Chris Nighswonger <<A href="mailto:cnighswonger@foundations.edu">cnighswonger@foundations.edu</A>><BR>Reply-To: Chris Nighswonger <<A href="mailto:cnighswonger@foundations.edu">cnighswonger@foundations.edu</A>><BR>Subject: Re: [Koha] Patron Cards and Book labels: 3.06 -- How are<BR>people printing them?<BR>To: <A href="mailto:david@intknowledge.com">david@intknowledge.com</A><BR>Cc: koha <<A href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</A>><BR><BR><BR>> Hi David,<BR>><BR>> On Thu, Aug 12, 2010 at 11:24 PM, David M. Bucknell <<A href="mailto:dbucknell@iteachnet.org">dbucknell@iteachnet.org</A><BR>>> wrote:<BR>><BR>>> Hello Everyone,<BR>>><BR>>> Printing Spine label and patron cards: I started working on this in<BR>>> May and 3.06 is<BR>>> still the preferred stable version. I've seen two posts that say to<BR>>> wait for 3.2.<BR>>><BR>>><BR>> 3.2 includes a complete re-write of the label and card creator code. So<BR>> waiting is probably the thing to do.<BR>><BR>><BR>>> I've installed in various configurations (now have Thai lang with<BR>>> marc-21; strange, but<BR>>> it seems to work for input and searching).d<BR>>><BR>>> I can't get any of the label options to work (English lang mostly) for<BR>>> books or patrons<BR>>> (at least not more than minimally -- I can get a barcode graphically<BR>>> and as text, but<BR>>> that's it. (Oh, and a nice red box around the items. Nothing I do to<BR>>> customize (choose<BR>>> what's on the label) has any effect.<BR>>><BR>>><BR>> Label printing is pretty broken when it comes to unicode support. The short<BR>> of it is that the pdf standard is not unicode friendly. This is true of 3.2<BR>> as well.<BR>><BR>> Having said that, we printed several thousand English (and a few Spanish)<BR>> labels with the 3.0.x labels code. So it will work for English and probably<BR>> some other Latin based alphabets.<BR>><BR>><BR>>> Finally, I can't get the export to csv to work to try it.<BR>>><BR>><BR>> I'm not sure what might be going on here.<BR>><BR>><BR>>><BR>>> Apologies for not seeing it if it's obvious, but now I would like to<BR>>> ask for suggestions.<BR>>> Am I wrong or is this just not working? How are people getting<BR>>> their labels and patron<BR>>> cards done in 3.06?<BR>>><BR>><BR>> The patron card code in 3.0.x is basically inflexible as many of the<BR>> settings are hard coded. You will have to wait for 3.2 stable or go ahead<BR>> and grab 3.2 alpha2 or the latest development master from<BR>> <A href="http://git.koha-community.org/koha.git" target=_blank>http://git.koha-community.org/koha.git</A><BR>><BR>> Kind Regards,<BR>> Chris<BR>><BR><BR><BR>----- End message from <A href="mailto:cnighswonger@foundations.edu">cnighswonger@foundations.edu</A> -----<BR><BR><BR><BR>--<BR>*<A href="http://iteachnet.org" target=_blank>http://iteachnet.org</A><BR>*<A href="http://flossed.org" target=_blank>http://flossed.org</A><BR>*<A href="http://ischoolnet.org" target=_blank>http://ischoolnet.org</A><BR>*Web Ideas, Tools and Sites for Teachers, Schools, and You.<BR>*Cell: +66(0*)84 329 1183; Office: +66(0*)2 980 9464 (*No "0" if calling from<BR>overseas.)<BR><BR>----------------------------------------------------------------<BR>This message was sent using IMP, the Internet Messaging Program.<BR><BR>_______________________________________________<BR>Koha mailing list<BR><A href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</A><BR><A href="http://lists.katipo.co.nz/mailman/listinfo/koha" target=_blank>http://lists.katipo.co.nz/mailman/listinfo/koha</A><BR></BLOCKQUOTE></DIV><BR></BODY></HTML>