- Koha - lists.katipo.co.nz

Strange Label Template
by Nicole Engard 16 Mar '11

16 Mar '11

Hello all, Has anyone created a template in the label maker that can handle a label sheet with two different sized labels? Go to www.demco.com and search for 14218000 to see a sample of what I'm talking about. I'm thinking that Koha's label maker just can't handle this and this is an enhancement request, but I thought I'd check with you all anyway. Nicole

2 2

Barcodes - various thoughts and questions
by Archives and Collections Society 16 Mar '11

16 Mar '11

Now approaching the end of our Koha (3.02.05.000 on Ubuntu 10.10) implementation of barcodes is the next "problem" to be resolved. There seems to be very little Koha documentation on the subject and what little there is either "not to be used", "deprecated" (e.g hbyymmincr.pm which looked promising but "This format is deprecated and SHOULD NOT BE USED") or has been relegated to "dead files" e.g. <http://wiki.koha-community.org/wiki/Barcode_Prefixes_in_Consortial_Environm…> is now found in the "Abandoned RFC" part of the Wiki. There is a default "generated in the form <branch>yymm0001" in admin -> sys preferences, which is close to what we require (replace "branch" - this would be a constant without practical value to us - with first four letters of "call number") but no obvious means of getting there. [Already we have rewritten callnumber.pl (nonfunctional) as acscallnumber.pl and use it for the callback on new items set as default through the admin interface Marc Subfield structure|edit|more constraints|plugin AND have written a separate perl routine for batch imports.] We can obviously modify barcode.pl and write a batch import routine, as this appears to be similar or parallel to the callnumber routines. However, this requires the 'SHOULD NOT BE USED' module above. So the questions are: - are we missing something? - is there some documentation (barcodes in general, coding|scripting in particular) that someone can kindly point us to? - what are the reasons for the various 'deprecated', 'should not be used', 'abandoned labels'? and what pitfalls are we opening ourselves to? what are the replacements? Our thoughts revolve around our overall respect for all the development that has gone into Koha (thank you all) - it is a remarkable project. But also around the quasi-total lack of technical documentation. We are still attempting to map the logic and data flows in the Koha architecture. We are still struggling with messy implementations of Zebra which has to be reindexed after every rewrite to koha.db during batch jobs (12,000 operations take 10 hours on fast hardware - but cannot find any documentation e.g. why the daemon must be replaced by a cron job, which might be very pertinent) - and we're going to have to do this again for barcodes. Any assistance and advice would be appreciated. We (Pete, who also posts here, and myself) are pretty thick-skinned so please do not hesitate to tell us that we have missed out on simple solutions. Thanks and regards, Paul Tired old sys-admin --- Archives and Collections (ACS) Society 205, Main Street, Picton, Ontario, K0K 2T0, Canada http://www.AandC.org Canadian Charitable Organization 88721 9921 RR0001 Dedicated to maritime conservation and education.

2 1

koha-zebraqueue.err
by John Smith 16 Mar '11

16 Mar '11

Hi to all how to fix this error DBI connect('CKI:localhost','kohaadmin',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/koha/intranet/modules/C4/Context.pm line 692 John Smith

2 1

Re: [Koha] How to Display text in Barcode ?
by Vimal Kumar 16 Mar '11

16 Mar '11

Dear Liny Madam, Please provide the exact location of label_pdf file? Can you give me exact description of how to change the script, if you have tried it? Regards, Vimal On Wed, Mar 16, 2011 at 1:09 PM, <liny(a)cusat.ac.in> wrote: > you can change label_pdf perl scripts > > On Tue, March 15, 2011 6:08 pm, Vimal Kumar wrote: > > Dear Friends, > > > > I want to display my library name or CODE in Koha barcode. > > I know that its possible to display Library Code in barcode by including > > marc tag or Koha field. > > But my library code is MAIN. > > I want to display either MGUL or MGU Library in barcode. > > > > Is it possible? > > > > -- > > Vimal Kumar V. > > Mahatma Gandhi University Library > > Kottayam, Kerala- 686 560 > > Web: http://www.vimalkumar.co.nr > > Blog: http://vimalkumar.oksociety.in http://linuxhalwa.blogspot.com > > > --------------------------------------------------------------------------- > > "I forget what I was taught. I only remember what I have learnt" > > -Patrick White > > > > My profiles: [image: Flickr] <http://www.flickr.com/people/vimal0212/> > > [image: > > Delicious] <http://www.delicious.com/vimal0212> [image: > > Facebook]<http://www.facebook.com/people/Vimal-Kumar/512044127> > > [image: > > Twitter] <http://www.twitter.com/vimal0212> [image: > > SlideShare]<http://www.slideshare.net/vimal0212> > > Signature powered by > > < > http://www.wisestamp.com/email-install?utm_source=extension&utm_medium=emai… > > > > WiseStamp< > http://www.wisestamp.com/email-install?utm_source=extension&utm_medium=emai… > > > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > -- > Information Scientist > Cochin University of Science and Technology > Kochi-22 > Ph:91-484-2862127 > http://library.cusat.ac.in > > -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.co.nr Blog: http://vimalkumar.oksociety.in http://linuxhalwa.blogspot.com --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

2 1

Final Call for KUDOS Conference Program Proposals!
by Nora Blake 16 Mar '11

16 Mar '11

Greetings all, KUDOS, an organization consisting of libraries, developers and others who use and/or develop the Koha integrated library system, will be holding a conference May 2-3, 2011 at the University of Wisconsin Madison campus. We are really excited to provide an opportunity to learn and share together, and with that in mind we invite submissions of proposals for programs at KUDOSCon2011. Proposals can be submitted at http://goo.gl/QqLHl. Our deadline has been extended! You have until March 18, 2011 (just a few more days) to submit your proposals. Don't delay, do it today! You can find out more about the conference, and about Madison, at our website: http://kudos.koha.org/kudoscon2011 We can't wait to learn about your brilliant ideas, and get together to share knowledge and love for Koha! The KUDOSCon Planning Committee: Vicki Teal-Lovely David Schuster Nora Blake Lisa Priebe Shannon O'Grady Liz Rea ________________________ Nora Blake MassCat Manager Massachusetts Library System P.O. Box 609 South Deerfield, MA 01373-0241 413-665-9898 x123 800-282-7755 Email: nblake(a)masslibsystem.org AIM: noraatmls

2 1

Re: [Koha] Koha Digest, Vol 65, Issue 61
by Nikunj Tyagi 16 Mar '11

16 Mar '11

Hi, I am using following sql for serial received during the particular period (month), you can create same for missing serials after changing the sql code in subscriptionhistory SELECT serial.subscriptionid,serial.biblionumber,serial.serialid,biblio.title,serial.serialseq,serial.planneddate,serial.publisheddate, IF( LOCATE('<datafield tag="310"', biblioitems.marcxml) = 0 OR LOCATE('<subfield code="a">', biblioitems.marcxml, LOCATE('<datafield tag="310"', biblioitems.marcxml)) = 0 OR LOCATE('<subfield code="a">', biblioitems.marcxml, LOCATE('<datafield tag="310"', biblioitems.marcxml)) > LOCATE('</datafield>', biblioitems.marcxml, LOCATE('<datafield tag="310"', biblioitems.marcxml)), '', SUBSTRING( biblioitems.marcxml, LOCATE('<subfield code="a">', biblioitems.marcxml, LOCATE('<datafield tag="310"', biblioitems.marcxml)) + 19, LOCATE('</subfield>', biblioitems.marcxml, LOCATE('<subfield code="a">', biblioitems.marcxml, LOCATE('<datafield tag="310"', biblioitems.marcxml)) + 19) -(LOCATE('<subfield code="a">', biblioitems.marcxml, LOCATE('<datafield tag="310"', biblioitems.marcxml)) + 19))) AS FREQUENCY FROM serial, biblio,biblioitems WHERE serial.biblionumber = biblio.biblionumber AND serial.biblionumber=biblioitems.biblionumber AND MONTH(planneddate) = 03 AND YEAR(planneddate)= 2011 ORDER BY serial.subscriptionid ASC Nikunj Tyagi Delhi Public Library On Wed, Mar 16, 2011 at 1:05 AM, <koha-request(a)lists.katipo.co.nz> wrote: > Send Koha mailing list submissions to > koha(a)lists.katipo.co.nz > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.katipo.co.nz/mailman/listinfo/koha > or, via email, send a message with subject or body 'help' to > koha-request(a)lists.katipo.co.nz > > You can reach the person managing the list at > koha-owner(a)lists.katipo.co.nz > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Koha digest..." > > > Today's Topics: > > 1. Re: Creating a report for serials (Peel Lisa) > 2. Re: Creating a report for serials (Nicole Engard) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 15 Mar 2011 19:21:48 +0000 > From: Peel Lisa <lisa.peel(a)ritz.edu> > Subject: Re: [Koha] Creating a report for serials > To: 'Nicole Engard' <nengard(a)gmail.com> > Cc: "'koha(a)lists.katipo.co.nz'" <koha(a)lists.katipo.co.nz> > Message-ID: > > <4501112D012181428D5AB62DDE501768022BDD(a)IHCRSV025.admin.ihcr.ritz.local> > > Content-Type: text/plain; charset="utf-8" > > Hi Nicole > > Still on 3.00 I am afraid ! > > Lisa > > From: Nicole Engard [mailto:nengard@gmail.com] > Sent: 15 March 2011 20:11 > To: Peel Lisa > Cc: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Creating a report for serials > > Lisa, > > My list of claims is showing me the branch code. What version of Koha are > you using? > > Nicole > 2011/3/15 Peel Lisa <lisa.peel(a)ritz.edu<mailto:lisa.peel@ritz.edu>> > Hello all > > We have had our serials module live for about 6 months now so I thought it > was about time I looked at the Claims ? however, it does not tell me which > library each subscription is for so it is difficult for me to know which > missed/late serials to direct to which library. > > Could someone perhaps provide me with the SQL to run a report which will > give me the information which Claims gives me but also with the added > information of Library (Claims currently gives me Supplier, Title, Issue > Number, Status, and Since). I normally try and tweak one of the reports in > the SQL Reports Library but I cannot find any for the Serials module. > > Thanks in advance. > > Regards > > Lisa > > [Description: Description: Description: CR_logo_POS_COULEUR b] > > > LISA PEEL, PGDip, MA. > Librarian > C?sar Ritz Colleges Switzerland > 1897 Le Bouveret - Switzerland > Tel: +41 24 482 82 82<tel:%2B41%2024%20482%2082%2082> Fax: +41 24 482 82 > 80<tel:%2B41%2024%20482%2082%2080> > E-mail: lisa.peel(a)ritz.edu<mailto:hortense.hofer@ritz.edu> > http://www.ritz.edu<http://www.ritz.edu/> - http://www.culinaryarts.ch< > http://www.culinaryarts.ch/> > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> > http://lists.katipo.co.nz/mailman/listinfo/koha > >

2 1

rebuild_zebra issue
by Bernard Desnoues 16 Mar '11

16 Mar '11

Hi All, We run Koha 3.02.00.004 and we have a problem with rebuild_zebra. In some circumstances, when we load and update records, double index entries corresponding to the same record (same biblionumber) appear when we search the catalog. The first entry is the old index entry and the second for the new state or the record. It's a big catalog : more than 900 000 bib records. If we run ./rebuild_zebra.pl -b -r -x -v, double entries disappear. I don't see anything strange in our settings. Does anybody have any idea on what happens and if there is a mistake in our settings or a misunderstanding ? Every suggestion is appreciated. Thanks -- Bernard Desnoues Bibliothécaire Bibliothèque universitaire des langues et civilisations Pôle informatique 60, rue de Wattignies - 75012 Paris Tél. (+33) 01 53 46 15 57 Fax. (+33) 01 53 46 15 90 http://www.bulac.fr bernard.desnoues(a)bulac.fr

4 7

Regular performance problems
by Chris Hobbs 16 Mar '11

16 Mar '11

Our koha server regularly grinds to a halt, preventing use of the web gui and even making it near impossible to log into via ssh. One minute load average on the server has spiked into at least the 80s, where it normally hovers around 1. If I'm patient, after about 15 minutes the system becomes usable again. Where should I begin looking for the trouble? The system is running on a VMWare ESX host. It's been given two vCPUs and 6GB of RAM. The host is not starved for resources, so I think I can exclude it from the equation. Other VMs running on the same host are not affected. Koha is version 3.01.00.140 (last beta before 3.2). The server is Ubuntu 9.10. We have ~200,000 items and ~100,000 biblios. I was able to capture a process list during the last event (this AM), and saw that I had 95 instances of apache started. At the moment, with things working smoothly, I have only 14. I've also run mysqltuner.pl in order to locate potential bottlenecks with the db, and the only glaring issues I have are: 1) Lots of joins without indexes (811 since db restart this morning) 2) Temporary tables created on disk: 45% (6K on disk / 15K total) I've set innodb_buffer_pool_size = 1G in my.cnf, but still the system keeps creating these tables on disk, which certainly can't be helping anything. OK, any ideas? Other troubleshooting info I can provide? It's gotten to the point that we're losing a decent amount of time every day to this issue. Thanks so much in advance! -- Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean.

2 3

Problem Importing Patrons
by Darla Grediagin 15 Mar '11

15 Mar '11

# # Good morning, # I am having problems getting my patron data imported into Koha. I am using Koha version 3.00.06.010 # I used the starter CSV file that is on the 'Import Patron' page to set the data in a table. I have checked the categorycode and branchcode to make sure they are correct. I received the same message for the 2750 patrons I uploaded. # Line 2 could not be parsed! |2737 561000 "Ablowaluk" "Arin" "" "" "AA" "PO BOX 513" "" "" "" "Teller" 99778 "" "642-6885" "" "" "" "" "C" "0000-00-00" 0 0 0 "" "" "TLA" "C" "3/15/11" "12/31/17" "" "" "" "" "" "" "" "" "" "" "" "M" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" | # Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; surname: UNDEF). |2737 561000 "Ablowaluk" "Arin" "" "" "AA" "PO BOX 513" "" "" "" "Teller" 99778 "" "642-6885" "" "" "" "" "C" "0000-00-00" 0 0 0 "" "" "TLA" "C" "3/15/11" "12/31/17" "" "" "" "" "" "" "" "" "" "" "" "M" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" | # Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; surname: UNDEF). |2737 561000 "Ablowaluk" "Arin" "" "" "AA" "PO BOX 513" "" "" "" "Teller" 99778 "" "642-6885" "" "" "" "" "C" "0000-00-00" 0 0 0 "" "" "TLA" "C" "3/15/11" "12/31/17" "" "" "" "" "" "" "" "" "" "" "" "M" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" | # Any ideas would be appreciated, Thanks, 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

2 1

Re: [Koha] help
by Jonson philip 15 Mar '11

15 Mar '11

> hi i need help in this message > i founded this in messages in log and syslog > zebraqueue : 56 operations waiting to be *run * > * any explanation for that , this repeated every seconds * > *thank's * > >

1 0