- Koha - lists.katipo.co.nz

zebra issues
by Erik Lewis 03 Aug '09

03 Aug '09

Details Koha 3.03, Ubuntu 9.04 -loaded about 90k worth of marc records into koha -verified that they loaded -ran Zebra rebuild_zebra.pl -b -w -got an error when zebra couldn't create a few lock files, created the directories and kicked it off again -came back prompt had returned no other messages -restarted the zebra server -opened OPAC did a search Got this: No Result found! No results match your search "tree branch:Dalton-Whitifield County Library" Went hoping around to various log files and saw nothing that really caused me any concern. Checked and I have some giant Zebra files, but still no search results. I've started and stopped a few dozen times. Nothing. At this point my suspicion is I really do not know what I'm doing with Zebra and need a few hints on the obvious things I could be missing. I know the details are sketch but any clues as to what I should look for?

3 3

DBD Mysql Error problem solved on Debian Installation
by Sunita Barve 02 Aug '09

02 Aug '09

Dear Marc, After struggling hard for last one month we could find solution for DBD mysql error on Debian 5.0.1 and 5.0.2. We tried installing KOHA on Either Debian 5.0.1 or 5.0.2 and we followed following steps and it worked successfully. Pl. try these steps and check. 1. While Installing Debian we selected only Desktop & Standard Installation. 2. After logging into the system installed apache2 and mysql related all files (such as apache2, apache2.2-common, apache2-util, apache2-mod-perl2, apache2-mod-php5, apache2-mod-python, apache2-reload-perl, apache2-mpm-worker, libdbd-mysql, libdbd-mysql-perl, libdbd-sqlit3-perl, libdbi-perl, libmysqlclient15-dev, libmysqlclient15off, mysql-admin, mysql-client, mysql-common, mysql-server, mysql-server-5.0) through Synaptic instead of installing them through "sudo dselect" command. 3. Edited file koha-3.00.03/install_misc/debian-lenny.packages and deleted the lines apache2-install, apache2-mpm-worker-install, libdbd-mysql-perl install, libdbd-mysql-perl, libdbd-sqlite3-install, libdbi-perl install lines. 4. Now run "sudo dselect" command and it will install all other perl libraries than mysql and apache2 as well as libdbd and libdbi related files. 5. We found that when we run "dselect" command it tries to install latest dbi and dbd related files along with mysql where there is mismatch and we get DBD error. But if we do not install mysql and libdbd-mysql, libdbd-mysql-perl and libdbi-perl files through dselect and install them through synaptic it solves the DBD error problem. 6. While mysql is installed through synaptic it installes libdbd-mysql-perl/libdbi-perl automatically. 7. Installing mysql through synaptic takes care of proper file version requirements of libdbd-mysql, libdbd-mysql-perl & libdbi-perl hence we do not have to install them separately. 8. Then run further steps for KOHA installation as mentioned in INSTALL.debian-lenny file. 9. We have tried these steps and we could run the KOHA sucessfully. If it works for you as well then it is necessary that KOHA installation manual for INSTALL.debian-lenny needs to be updated. reg, Sunita Barve NCRA, Pune On Fri, Jul 31, 2009 at 9:03 PM, <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: DBD driver has not implemented the AutoCommit attribute > (Marc N?rnberger) > 2. Re: MARC record import (Cab Vinton) > 3. Re: MARC record import (Walls, Ian) > 4. Re: MARC record import (Owen Leonard) > 5. Mahalya Havard est absent(e). (Mahalya_Havard(a)ssss.gouv.qc.ca) > 6. Re: MARC record import (Cab Vinton) > 7. marc record matching rules, not working (Scott) > 8. Re: MARC record import (Harris, Gary, DCA) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 31 Jul 2009 16:38:22 +0200 > From: Marc N?rnberger <marc.nuernberger(a)gmx.de> > Subject: Re: [Koha] DBD driver has not implemented the AutoCommit > attribute > To: Joe Atzberger <ohiocore(a)gmail.com> > Cc: Koha List <koha(a)lists.katipo.co.nz> > Message-ID: <4A7301DE.4050302(a)gmx.de> > Content-Type: text/plain; charset=UTF-8; format=flowed > > Dear Joe, > > Thanks for your advice! Unfortunately a Centos (Perl 5.8.8, koha > 3.00.03) install, leads finally to the same error on the intranet page: > > DBD driver has not implemented the Autocommit attribute at > /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/DBI.pm line 705 > > Any idea? > > Best, > Marc > > > > Joe Atzberger schrieb: >> Weird. I think this came up before, without resolution. Maybe try with >> perl 5.8.8? >> >> -- >> Joe Atzberger >> LibLime - Open Source Library Solutions >> >> >> 2009/6/17 Marc N?rnberger <marc.nuernberger(a)gmx.de >> <mailto:marc.nuernberger@gmx.de>> >> >> Dear all, >> >> I am struggling hard with this DBD driver problem, ever since I did >> one reboot on an lenny & perl 5.10 & Koha 3.00.02-final. Make test >> always fails with the below message. >> >> On a test system the same combination is running just fine. So I >> thought it's just a matter of the right Perl modules, DBI and >> DBD::mysql. But no matter if I use the latest packages, or the working >> combination of DBI 1.605 and DBD:mysql 4.007 from the test system, I >> cannot get past this one... >> >> Any suggestions, what could be a next step in troubleshooting? >> Thanks a lot. >> >> Best regards, >> Marc >> >> ***************************************** >> >> t/Circulation_barcodedecode.t .. 1/16 >> # Failed test 'use C4::Circulation;' >> # at t/Circulation_barcodedecode.t line 10. >> # Tried to use 'C4::Circulation'. >> # Error: DBD driver has not implemented the AutoCommit attribute >> at /usr/local/lib/perl/5.10.0/DBI.pm line 690. >> # Compilation failed in require at >> /root/kohaclone/blib/PERL_MODULE_DIR/C4/Circulation.pm line 25. >> # BEGIN failed--compilation aborted at >> /root/kohaclone/blib/PERL_MODULE_DIR/C4/Circulation.pm line 25. >> # Compilation failed in require at (eval 4) line 2. >> # BEGIN failed--compilation aborted at (eval 4) line 2. >> Undefined subroutine &C4::Circulation::barcodedecode called at >> t/Circulation_barcodedecode.t line 31. >> # Looks like you planned 16 tests but ran 1. >> # Looks like you failed 1 test of 1 run. >> # Looks like your test exited with 255 just after 1. >> t/Circulation_barcodedecode.t .. Dubious, test returned 255 (wstat >> 65280, 0xff00) >> Failed 16/16 subtests >> >> >> ****************************************** >> Test Summary Report >> ------------------- >> t/Circulation_barcodedecode.t (Wstat: 65280 Tests: 1 Failed: 1) >> Failed test: 1 >> Non-zero exit status: 255 >> Parse errors: Bad plan. You planned 16 tests but ran 1. >> t/Dates.t (Wstat: 65280 Tests: 135 Failed: 9) >> Failed tests: 127-135 >> Non-zero exit status: 255 >> Parse errors: Bad plan. You planned 126 tests but ran 135. >> Files=21, Tests=183, 3 wallclock secs ( 0.08 usr 0.02 sys + 2.48 >> cusr 0.18 csys = 2.76 CPU) >> Result: FAIL >> Failed 2/21 test programs. 10/183 subtests failed. >> make: *** [test_dynamic] Fehler 255 >> >> > > > ------------------------------ > > Message: 2 > Date: Fri, 31 Jul 2009 10:54:19 -0400 > From: Cab Vinton <bibliwho(a)gmail.com> > Subject: Re: [Koha] MARC record import > To: Kyle Hall <kyle.m.hall(a)gmail.com> > Cc: Koha list <koha(a)lists.katipo.co.nz> > Message-ID: > <835777770907310754w261f9c62jfda5814d46010389(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Not exactly sure what format it's in -- I just copy & pasted into a > text file from a record in the Minuteman Library Network in Mass: > > http://library.minlib.net/search/# > > SirsiDynix catalogs also present options for displaying MARC records > that could be copied. One example: > > http://catalog.dalnet.lib.mi.us/ > http://catalog.dalnet.lib.mi.us/ipac20/ipac.jsp?full=3100001~!431721~!1&ful… > > But in this instance, some processing would be required as the tags & > tag contents end up on separate lines. > > Cab Vinton, Director > Sanbornton Public Library > Sanbornton, NH > > > On Fri, Jul 31, 2009 at 9:57 AM, Kyle Hall<kyle.m.hall(a)gmail.com> wrote: >> Is that a MicroLIF format? I think I might have a script laying around >> that could help you. >> >> Kyle >> >> http://www.kylehall.info >> Information Technology >> Crawford County Federated Library System ( http://www.ccfls.org ) > > > ------------------------------ > > Message: 3 > Date: Fri, 31 Jul 2009 11:10:47 -0400 > From: "Walls, Ian" <Ian.Walls(a)med.nyu.edu> > Subject: Re: [Koha] MARC record import > To: Koha list <koha(a)lists.katipo.co.nz> > Message-ID: > <543F9234BDD8434A8D45C3D6337B7C8E1956EBDF(a)MSGWSDCPMB07.nyumc.org> > Content-Type: text/plain; charset="us-ascii" > > Perhaps some kind of script to parse each line of the text file into MARCXML; it would mostly just be adding XML wrappers around the data, so I doubt it'd be horrible to code up. > > > Ian Walls > Systems Integration Librarian > NYU Health Sciences Libraries > 550 First Ave., New York, NY 10016 > (212) 263-8687 > > > > -----Original Message----- > From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Cab Vinton > Sent: Friday, July 31, 2009 10:54 AM > To: Kyle Hall > Cc: Koha list > Subject: Re: [Koha] MARC record import > > Not exactly sure what format it's in -- I just copy & pasted into a > text file from a record in the Minuteman Library Network in Mass: > > http://library.minlib.net/search/# > > SirsiDynix catalogs also present options for displaying MARC records > that could be copied. One example: > > http://catalog.dalnet.lib.mi.us/ > http://catalog.dalnet.lib.mi.us/ipac20/ipac.jsp?full=3100001~!431721~!1&ful… > > But in this instance, some processing would be required as the tags & > tag contents end up on separate lines. > > Cab Vinton, Director > Sanbornton Public Library > Sanbornton, NH > > > On Fri, Jul 31, 2009 at 9:57 AM, Kyle Hall<kyle.m.hall(a)gmail.com> wrote: >> Is that a MicroLIF format? I think I might have a script laying around >> that could help you. >> >> Kyle >> >> http://www.kylehall.info >> Information Technology >> Crawford County Federated Library System ( http://www.ccfls.org ) > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > ------------------------------------------------------------ > This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain information that is proprietary, confidential, and exempt from disclosure under applicable law. Any unauthorized review, use, disclosure, or distribution is prohibited. If you have received this email in error please notify the sender by return email and delete the original message. Please note, the recipient should check this email and any attachments for the presence of viruses. The organization accepts no liability for any damage caused by any virus transmitted by this email. > ================================= > > > > ------------------------------ > > Message: 4 > Date: Fri, 31 Jul 2009 11:05:03 -0400 > From: Owen Leonard <oleonard(a)myacpl.org> > Subject: Re: [Koha] MARC record import > To: Cab Vinton <bibliwho(a)gmail.com> > Cc: Koha list <koha(a)lists.katipo.co.nz> > Message-ID: > <c0aa2140907310805u70641879i1128bb2db6c25321(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > >> Not exactly sure what format it's in -- I just copy & pasted into a >> text file from a record in the Minuteman Library Network in Mass: > > Not really an answer to your question, but... Why not just search for > the record using z39.50? > > -- Owen > > -- > Web Developer > Athens County Public Libraries > http://www.myacpl.org > > > ------------------------------ > > Message: 5 > Date: Fri, 31 Jul 2009 10:57:49 -0400 > From: Mahalya_Havard(a)ssss.gouv.qc.ca > Subject: [Koha] Mahalya Havard est absent(e). > To: koha(a)lists.katipo.co.nz > Message-ID: > <OF6D9F8E3B.5EA15F07-ON85257604.005232BF-85257604.005232BF(a)ssss.gouv.qc.ca> > > Content-Type: text/plain; charset="iso-8859-1" > > > > Je serai absent(e) du Ven 31-07-2009 au Lun 03-08-2009. > > Je r?pondrai ? votre message d?s mon retour, mardi, le 4 ao?t 2009. Merci. >

1 0

Re: [Koha] Finding a patron name in lookup
by Nora Blake 01 Aug '09

01 Aug '09

Hi Jane and all. It would be really great if you folks could make it more of a priority to list your projects on bugzilla so other projects don't conflict with work PTFS is already engaged in. I think my consortium might be engaging another vendor to do work very similar to this. Some coordination beforehand would have been nice. Thanks, Nora ________________________ Nora Blake MassCat Manager P.O. Box 241 South Deerfield, MA 01373-0241 Toll Free in MA: 866-MASSCAT (627-7228) Local Phone: 413-665-5511 Email: nblake(a)masscat.org Website: http://www.masscat.org AIM: vegancatwoman Skype: veganlibrarian Skype: nora.blake ________________________________ From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Wagner, Jane Sent: Tuesday, July 28, 2009 11:52 AM To: Owen Leonard Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Finding a patron name in lookup Real Soon Now we are planning to do all the bugzilla enhancement entries as was the plan developed at Kohacon. It's just been a question of staff time and rapidly moving code/specs. For the patron searching enhancement, the screen looks like this: The pulldown in the top search box has Standard (covers name and barcode), borrower number, email, and phone. If the staff person is familiar with the SQL, he/she can also do a direct query in the bottom box. You'll note a Borrower Cart in the screenshot - a separate enhancement we're working on has some batch edit/delete capabilities for records that are selected and added to the cart. That code is also still in test. Jane Wagner Library Systems Analyst PTFS Inc. Content Management and Library Solutions 6400 Goldsboro Road, Suite 200 Bethesda, MD 20817 (301) 654-8088 x 151 jwagner(a)ptfs.com -----Original Message----- From: Owen Leonard [mailto:oleonard@myacpl.org] Sent: Tuesday, July 28, 2009 11:10 AM To: Wagner, Jane Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Finding a patron name in lookup > Not an immediate solution, but we do have an enhancement in testing right > now that has some advanced patron searching possibilities including > truncation, searching by partial phone/email, and SQL searching. That sounds great Jane. Can you create an enhancement bug for it so that others can see it's being worked on? Will it be just a change to the way the search works now, or will it include other methods of searching patrons, like an advanced search screen? Thanks, -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

2 1

Mahalya Havard est absent(e).
by Mahalya_Havard＠ssss.gouv.qc.ca 31 Jul '09

31 Jul '09

Je serai absent(e) du Ven 31-07-2009 au Lun 03-08-2009. Je répondrai à votre message dès mon retour, mardi, le 4 août 2009. Merci.

1 0

KOHA 3.0 at Portuguese Administration
by rafael.antonio＠sapo.pt 31 Jul '09

31 Jul '09

Dear list members, I have the pleasure to announce that we have suceed installing the first 3.0 KOHA version in Portugal at Prospective Planning and Internacional Affaires Department an agency of Environment Ministry. After several years with another system (SIRTEX from Software AG running on ADABAS) last year they participate on a training workshop about Free Software for Libraries and decided to convert near 35.000 biliographic records ad more than 25.000 authority records to KOHA, using UNIMARC flavour. Meanwhile they converted manually all subscriptions issues with the help of some scripts to import items which allowed to do it quickly. This is the second KOHA instalation, after Informatics Institute, which give make us to believe that more departments will join. If you want to acess please go to http://koha.dpp.pt and select english language. Regards, Rafael António

1 0

Stage MARC Records for Import vs. bulkmarcimport
by Sébastien Hinderer 31 Jul '09

31 Jul '09

Dear all, I'm trying to understand the differences between bulkmarcimport (BMI) and stage MARC records for import (SMRI). As I understand it: 1. BMI is done through command-line whereas SMRI uses the web interface. 2. With BMI the records get catalogued directly so the reservoir step is skipped, contrary to what happens with SMRI. So my questions are: 1. Is this understanding correct ? 2. What's the intended use of the two functionality ? Being new to the library science field, I suspect that there is perhaps something more to the storry than what I know. Actually, I think I understand the idea behind BMI (catalogue a bunch of records at once), but I don't understand what there is behind SMRI. 3. Once I understand things better, I'm willing to write something in the manual or in the wiki to explain what I have understood and which could then be improved by others. old that be relevant, and, where would that fit best ? Thanks much in advance for your help, Sébastien.

10 13

marc record matching rules, not working
by Scott 31 Jul '09

31 Jul '09

Hi, I am trying to import 1 marc only record, and then import a list of items for that marc record. I have the default matching rules that come with koha and so I am trying to match the isbn 020a tag. here is a the marc record only. =LDR 00000nam 2200000Ia 45e0 =008 090731s9999\\\\xx\\\\\\\\\\\\000\0\und\d =020 \\$a9780439533263 =100 1\$a"Blevins, Wiley" =245 04$aA Hat =650 0\$aGeneral =952 \\$oA$p80006$yL and here is the sample of one of the item records. =LDR 00000nam 2200000Ia 45e0 =008 090731s9999\\\\xx\\\\\\\\\\\\000\0\und\d =020 \\$a9780439533263 =100 1\$a"Blevins, Wiley" =245 04$aA Hat =952 \\$oA$p80006$yL$v5 there probably shouldnt be a barcode in the record only, since i see that now that im writing this, but how i do this is I first stage the marc record and just have it replace any matching and to not add any items. I then import it, and rebuild_zebra just to be sure its in there correctly. I then stage the item record and tell it to ignore adding records but add all items. I then upload it and it ignores all the items. Even though the 020$a is the same as the marc record. Shouldnt the items be adding to the record? Is what I am doing even possible? I basically just want to add a marc record, then add a bunch of items to it. Instead of having a bunch of the same items with different records. Thanks for all the help. -Scott

1 1

Mahalya Havard est absent(e).
by Mahalya_Havard＠ssss.gouv.qc.ca 31 Jul '09

31 Jul '09

Je serai absent(e) du Ven 31-07-2009 au Lun 03-08-2009. Je répondrai à votre message dès mon retour, mardi, le 4 août 2009. Merci.

1 0

Bad MARC bib records
by Basu Talikoti 31 Jul '09

31 Jul '09

hi we are encountering some problem in MARC Biblio records, may be because of too many items with some of biblio records . Therefore I executed the perl script. ./sync_items_in_marc_bib.pl --run update the summary report is 3 bad Marc records. I would like to know. how to correct this corrupt records. and what precautions we should take records should not be corrupted because there are may deletion additions in biblio every day basu [root@dplcat maintenance]# ./sync_items_in_marc_bib.pl --run update ... processed 100 records ... processed 200 records processed 22100 records Could not retrieve bib 22480 from the database - record is corrupt. Could not processed 26800 records Could not retrieve bib 27209 from the database - record is corrupt.retrieve bib 22481 from the database - record is corrupt. processed 27900 records ... processed 28000 records ... processed 28100 records ... processed 28200 records ... processed 28300 records Embedded item synchronization report ------------------------------------ Number of bibs checked: 28354 Number of bibs modified: 28200 Number of item fields removed from bibs: 95800 Number of item fields added to bibs: 95801 Number of bibs with errors: 3 [root@dplcat maintenance]#

2 1

DBD driver has not implemented the AutoCommit attribute
by Marc Nürnberger 31 Jul '09

31 Jul '09

Dear all, I am struggling hard with this DBD driver problem, ever since I did one reboot on an lenny & perl 5.10 & Koha 3.00.02-final. Make test always fails with the below message. On a test system the same combination is running just fine. So I thought it's just a matter of the right Perl modules, DBI and DBD::mysql. But no matter if I use the latest packages, or the working combination of DBI 1.605 and DBD:mysql 4.007 from the test system, I cannot get past this one... Any suggestions, what could be a next step in troubleshooting? Thanks a lot. Best regards, Marc ***************************************** t/Circulation_barcodedecode.t .. 1/16 # Failed test 'use C4::Circulation;' # at t/Circulation_barcodedecode.t line 10. # Tried to use 'C4::Circulation'. # Error: DBD driver has not implemented the AutoCommit attribute at /usr/local/lib/perl/5.10.0/DBI.pm line 690. # Compilation failed in require at /root/kohaclone/blib/PERL_MODULE_DIR/C4/Circulation.pm line 25. # BEGIN failed--compilation aborted at /root/kohaclone/blib/PERL_MODULE_DIR/C4/Circulation.pm line 25. # Compilation failed in require at (eval 4) line 2. # BEGIN failed--compilation aborted at (eval 4) line 2. Undefined subroutine &C4::Circulation::barcodedecode called at t/Circulation_barcodedecode.t line 31. # Looks like you planned 16 tests but ran 1. # Looks like you failed 1 test of 1 run. # Looks like your test exited with 255 just after 1. t/Circulation_barcodedecode.t .. Dubious, test returned 255 (wstat 65280, 0xff00) Failed 16/16 subtests ****************************************** Test Summary Report ------------------- t/Circulation_barcodedecode.t (Wstat: 65280 Tests: 1 Failed: 1) Failed test: 1 Non-zero exit status: 255 Parse errors: Bad plan. You planned 16 tests but ran 1. t/Dates.t (Wstat: 65280 Tests: 135 Failed: 9) Failed tests: 127-135 Non-zero exit status: 255 Parse errors: Bad plan. You planned 126 tests but ran 135. Files=21, Tests=183, 3 wallclock secs ( 0.08 usr 0.02 sys + 2.48 cusr 0.18 csys = 2.76 CPU) Result: FAIL Failed 2/21 test programs. 10/183 subtests failed. make: *** [test_dynamic] Fehler 255

2 2