- Koha - lists.katipo.co.nz

slow response time
by Rachel Hollis 25 Aug '10

25 Aug '10

Greetings friends, our Koha 3 has about 5600 items and 1400 biblios; some biblios have 100s of items. We are experiencing very slow response times with transactions involving biblios with many items. We have many circulations for a day or two once a month and some titles take several minutes to check-in or out, while our patrons wait in line. According to my geek, Zebra (version 2.0.32) appears to rebuild the item index for either the entire database or the biblio (my area of fuzziness) after each transaction. Is this the way Zebra is supposed to operate? If so, is there a way to rebuild indexes overnight? If there is another solution, we'd love to hear it. We are running Koha 3.01.00.001 on Debian Etch with Zebra on a P4 beater box running right next to my desk, available only on the intranet. We use Google Chrome as our interface to Koha. Rachel Hollis, librarian Stevens-Henager College, Boise Idaho Campus 2010 Winner of Best Places to Work in Idaho This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.

2 2

Caroline Loh/lib/staff/npnet is out of the office.
by Caroline Loh 25 Aug '10

25 Aug '10

I will be out of the office starting 26/08/2010 and will not return until 03/09/2010. Mrs Lim Ben Wai/Senior Manager (6460 6369) will cover my duties. For matters relating to copyright laws, please refer to Ms Lim Bee Ang/Reference Manager (6460 6551). If you need to reach me, please call my Secretary, Mdm Teo at 6460 6280 . With best regards Caroline Loh (Mrs) | Director | Lien Ying Chow Library Ngee Ann Polytechnic, 535 Clementi Road, Singapore 599489 DID: 6460 6288 | FAX: 6466 8274 | EMAIL: lck4(a)np.edu.sg | http://www.np.edu.sg/library/library.html Our Mission: Advancing People With Information NP Vision: Connecting Minds. Unlocking Talents. Creating Value NOTICE: This message may contain privileged/confidential information. If you are not the intended recipient of this email, please delete it immediately and notify the sender .

1 0

opac displaying incorrect item status
by jason sherman 25 Aug '10

25 Aug '10

Hi all, My library recently migrated to Koha 3.0.6 from a proprietary system. Everything looks good in the staff client, but as we catalog new biblios and items they are showing up as not available in the opac. An example item shows up as available in the staff client and circulates without issue, but its status in the opac is "Not for loan". I tried setting the status to not for loan, which made the opac display its status as "Not for loan (Not for loan)". I toggled the status back, and now I'm back where I started. Any thoughts? -- Jason Sherman

2 1

Problem with OPAC search after upgrade to Koha (staff client results normal)
by Marc Wilson 25 Aug '10

25 Aug '10

Hi We recently upgraded to Koha 3.01.00.061. Since upgrading, our OPAC searches have returned no results with the message: "No Result found!" The staff client catalogue search returns normal results. >From the "koha-opac-error_log" [Wed Aug 18 21:39:21 2010] [error] [client X.X.X.X] [Wed Aug 18 21:39:21 2010] opac-search.pl: "my" variable $selected masks earlier declaration in same scope at /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 150., refer$ [Wed Aug 18 21:39:22 2010] [error] [client X.X.X.X] HTML::Template::Pro:in TMPL_LOOP at pos 232: , referer: http://X.X.X.X/cgi-bin/koha/opac-search.pl?q=quant [Wed Aug 18 21:39:22 2010] [error] [client X.X.X.X] PARAM:LOOP:next_loop(0): callback returned null scope, referer: http://X.X.X.X/cgi-bin/koha/opac-search.pl?q=quant _________________ Koha is running on the following platform: Debian Linux 2.6.32.7 #3 SMP i686 GNU/Linux Perl version: 5.010001 Perl modules Algorithm::CheckDigits 0.53 Biblio::EndnoteStyle 0.05 CGI 3.49 CGI::Carp 3.45 CGI::Session 4.42 CGI::Session::Serialize::yaml 4.24 Class::Accessor 0.34 Class::Factory::Util 1.7 Compress::Zlib 2.024 DBD::SQLite2 0.33 DBD::mysql 4.017 DBI 1.613 Data::Dumper 2.125 Data::ICal 0.16 Date::Calc 6.3 Date::ICal 1.72 Date::Manip 6.04 Digest::MD5 2.39 Digest::SHA 5.48 Email::Date 1.103 File::Temp 0.22 GD 2.45 GD::Barcode::UPCE 1.1 Getopt::Long 2.38 Getopt::Std 1.06 HTML::Scrubber 0.08 HTML::Template::Pro 0.9502 HTTP::Cookies 5.833 HTTP::OAI 3.23 HTTP::Request::Common 5.824 IPC::Cmd 0.54 JSON 2.21 LWP::Simple 5.835 LWP::UserAgent 5.835 Lingua::Stem 0.84 List::MoreUtils 0.25_02 List::Util 1.21 Locale::Language 2.07 MARC::Charset 1.2 MARC::Crosswalk::DublinCore 0.02 MARC::File::XML 0.92 MARC::Record 2.0.2 MIME::Base64 3.08 MIME::Lite 3.027 MIME::QuotedPrint 3.08 Mail::Sendmail 0.79_16 Net::LDAP 0.4001 Net::LDAP::Filter 0.15 Net::Z3950::ZOOM 1.26 PDF::API2 2.015 PDF::API2::Page 2.001 PDF::API2::Util 2.000 PDF::Reuse 0.35 PDF::Reuse::Barcode 0.05 POE 1.292 POSIX 1.17 SMS::Send 0.05 Schedule::At 1.10 Term::ANSIColor 2.00 Test 1.25_02 Test::Harness 3.17 Test::More 0.92 Text::CSV 1.18 Text::CSV_XS 0.73 Text::Iconv 1.7 Text::Wrap 2009.0305 Time::HiRes 1.9719 Time::localtime 1.02 Unicode::Normalize 1.03 XML::Dumper 0.81 XML::LibXML 1.70 XML::LibXSLT 1.70 XML::RSS 1.48 XML::SAX::ParserFactory 1.01 XML::SAX::Writer 0.53 XML::Simple 2.18 YAML::Syck 1.12 MySQL version: mysql Ver 14.14 Distrib 5.1.48, for debian-linux-gnu (i486) using readline 6.1 Apache server version: Apache/2.2.16 (Debian) Zebra version: Zebra 2.0.44

4 6

952 won't upload
by Darla Grediagin 25 Aug '10

25 Aug '10

Good morning, I have rewritten my 952 lines to match what is in Koha 3.0. I double checked that my MARC links for items are all set. When I upload a new batch of records and look at the MARC that is uploaded, there is no line 952. Any ideas would be gratefully appreciated. TIA Darla -- Darla Grediagin District Librarian Bering Strait School District Unalakleet, Alaska Web Address : http://bssdonline.org/course/view.php?id=51 Blog: http://aklibrarian1.edublogs.org/ OPAC: http://opac.bssd.org:8181/cgi-bin/koha/opac-search.pl

4 5

biblio reloading & zebra reindexing
by Linda Culberson 24 Aug '10

24 Aug '10

Quick newbie question, folks. Do the zebra_daemon and/or zebraqueue_daemon need to be running or not when doing a reloading of the biblios ? How about when reindexing them? Sorry, but I'm brain-dead today, and can use all the help I can get. Thanks! -- Linda Culberson lculber(a)mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives& History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824

6 5

Re: [Koha] Google Chrome
by hfields19＠gmail.com 23 Aug '10

23 Aug '10

Hi Lola, Yes we use Google Chrome because it is so much faster than firefox at issues and returns. We do though have problems with printing that has to be sorted out. Returns: Chrome interface does not 'show' reserves when items are being checked in so it is critical to have the volumne turned on that that the audio alerts can be clearly heard (so that the reserves are caught). Chrome will not print the slips either, aso we put the reserves in a pile and check them in again in Firefox during quiet moments so we can get the slips out. Clunky - yes - but it works and is worth doing for the big speed increases we gain in checking items in using Chrome. Issues: we use Chrome because it is faster but I have a feeling we have done something cutre with the printer to get the slipos printing out ie networking them somehow. I will have to investigate and get back to you. The biggest headache I have wiuth 3.2 is around printing and I would love to help get this issue strealined and problem free. Cheers Jo. On , Lola McKee <lmckee(a)salpublib.org> wrote: > Is anyone out there using google chrome for Koha? If so what printers are > you using and are you having any trouble printing slips in google chrome? > -- > Thanks, > Lola McKee > Tech Systems Specialist > Salina Public Library > 785-825-4624 Ext. 239

11 16

Re: [Koha] Seeking programmer: Patron Cards and Book labels: 3.06-- How are people printing them?
by Scott Owen 23 Aug '10

23 Aug '10

Just installed Koha from git, and the patron card/spine labels seem to work fine. However.... While using Koha 2.2.9 on win32 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. Option 1 ******************************** This requires allowing access to the MySQL database that holds all of your Koha information. *BE CAREFUL AND MAKE SURE YOU UNDERSTAND THE RAMIFICATIONS OF DOING THIS* Barcodes are just a font. 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-… 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. 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. This process is not as easy as just pressing the button in Koha, but, I have found it to work quite in my environment. Option 2:****************************** Create a "remote query" in PHP so that you can automagically generate a barcode ready list. The cut/paste/format into a CSV, and print as above in option 1. example: http://koha.almaschools.net/RQ/booklist.php This requires a bit more work....but is very handy. If you want the messy details, let me know off list...... -Scott Owen Alma Public Schools >>> Chris Nighswonger<cnighswonger(a)foundations.edu> 8/23/2010 7:53 AM >>> Hi David, On Mon, Aug 16, 2010 at 4:02 AM, David M. Bucknell <dbucknell(a)iteachnet.org> wrote: If there is someone who would be willing to jury-rig patron card and spine label printing ... write a script ... I'd be willing to compensate hourly costs. I haven't heard from anyone except Chris, who is a contributing programmer, I take it, so I guess everyone else has either an on-site team or is paying a provider. 3.06 seems pretty cool and there is really no alternative, so if anyone is willing to help for some cash via paypal, it would be worth it to me. I have three installations that need this, none of which have a budget, but all of them hell-bent on Koha because of me. 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. It seems a bit counter productive to pay money for a feature that will die in a couple of weeks anyway. Kind Regards, Chris ----- Message from cnighswonger(a)foundations.edu --------- Date: Fri, 13 Aug 2010 08:27:26 -0400 From: Chris Nighswonger <cnighswonger(a)foundations.edu> Reply-To: Chris Nighswonger <cnighswonger(a)foundations.edu> Subject: Re: [Koha] Patron Cards and Book labels: 3.06 -- How are people printing them? To: david(a)intknowledge.com Cc: koha <koha(a)lists.katipo.co.nz> > Hi David, > > On Thu, Aug 12, 2010 at 11:24 PM, David M. Bucknell <dbucknell(a)iteachnet.org >> wrote: > >> Hello Everyone, >> >> Printing Spine label and patron cards: I started working on this in >> May and 3.06 is >> still the preferred stable version. I've seen two posts that say to >> wait for 3.2. >> >> > 3.2 includes a complete re-write of the label and card creator code. So > waiting is probably the thing to do. > > >> I've installed in various configurations (now have Thai lang with >> marc-21; strange, but >> it seems to work for input and searching).d >> >> I can't get any of the label options to work (English lang mostly) for >> books or patrons >> (at least not more than minimally -- I can get a barcode graphically >> and as text, but >> that's it. (Oh, and a nice red box around the items. Nothing I do to >> customize (choose >> what's on the label) has any effect. >> >> > Label printing is pretty broken when it comes to unicode support. The short > of it is that the pdf standard is not unicode friendly. This is true of 3.2 > as well. > > Having said that, we printed several thousand English (and a few Spanish) > labels with the 3.0.x labels code. So it will work for English and probably > some other Latin based alphabets. > > >> Finally, I can't get the export to csv to work to try it. >> > > I'm not sure what might be going on here. > > >> >> Apologies for not seeing it if it's obvious, but now I would like to >> ask for suggestions. >> Am I wrong or is this just not working? How are people getting >> their labels and patron >> cards done in 3.06? >> > > The patron card code in 3.0.x is basically inflexible as many of the > settings are hard coded. You will have to wait for 3.2 stable or go ahead > and grab 3.2 alpha2 or the latest development master from > http://git.koha-community.org/koha.git > > Kind Regards, > Chris > ----- End message from cnighswonger(a)foundations.edu ----- -- *http://iteachnet.org *http://flossed.org *http://ischoolnet.org *Web Ideas, Tools and Sites for Teachers, Schools, and You. *Cell: +66(0*)84 329 1183; Office: +66(0*)2 980 9464 (*No "0" if calling from overseas.) ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Re: [Koha] Seeking programmer: Patron Cards and Book labels: 3.06-- How are people printing them?
by Scott Owen 23 Aug '10

23 Aug '10

Sorry to but in here.....but I have a couple questions.. Is there a known issue with 3.0.6 and labels? ( I already have a nice process for creating labels, but was hoping to use the Koha built in tools) I ask this as I have been in the process of migrating from 2.29 to 3.0.6, but, from what I gather from this conversation, I may be better off going to 3.2? Can I do an upgrade via git to 3.2 from 3.0.6 (any know dependencies that will need to be chased down?) >>> Chris Cormack<chrisc(a)catalyst.net.nz> 8/16/2010 4:25 AM >>> * David M. Bucknell (dbucknell(a)iteachnet.org) wrote: > If there is someone who would be willing to jury-rig patron card and > spine label printing ... write a script ... I'd be willing to > compensate hourly costs. > > I haven't heard from anyone except Chris, who is a contributing > programmer, I take it, so I guess everyone else has either an on-site > team or is paying a provider. 3.06 seems pretty cool and there is > really no alternative, so if anyone is willing to help for some cash > via paypal, it would be worth it to me. I have three installations > that need this, none of which have a budget, but all of them hell-bent > on Koha because of me. > > Let me know if you can help, please. > Hi David If these are new Koha installs, I would strongly suggest installing from either the debian packages, or the git master branch. As Chris Nighswonger (who wrote the labels code) has said, it has been totally rewritten for 3.2.0 (it's 3.0.6 btw) so you are much better off installing that. Quite a few libraries, including Horowhenua Library Trust the original Koha library, are running what is very soon to be 3.2.0 in production. So I would class that as a real alternative, and in fact a better alternative to installing 3.0.6 and having some one off customised and not reusable work done. Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand

3 2

Patron Cards and Book labels: 3.06 -- How are people printing them?
by David M. Bucknell 23 Aug '10

23 Aug '10

Hello Everyone, Printing Spine label and patron cards: I started working on this in May and 3.06 is still the preferred stable version. I've seen two posts that say to wait for 3.2. I've installed in various configurations (now have Thai lang with marc-21; strange, but it seems to work for input and searching).d I can't get any of the label options to work (English lang mostly) for books or patrons (at least not more than minimally -- I can get a barcode graphically and as text, but that's it. (Oh, and a nice red box around the items. Nothing I do to customize (choose what's on the label) has any effect. Finally, I can't get the export to csv to work to try it. Apologies for not seeing it if it's obvious, but now I would like to ask for suggestions. Am I wrong or is this just not working? How are people getting their labels and patron cards done in 3.06? -- *http://iteachnet.org *http://flossed.org *http://ischoolnet.org *Web Ideas, Tools and Sites for Teachers, Schools, and You. *Cell: +66(0*)84 329 1183; Office: +66(0*)2 980 9464 (*No "0" if calling from overseas.) ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.

3 6