- Koha - lists.katipo.co.nz

Culling old session data
by Rick Welykochy 09 Jan '10

09 Jan '10

HI all, We have a Koha instance that has way too many entries in the sessions table for reason I won't go since the "why" is unimportant. Is there a periodic job that can be run to cull old sessions from the table? We don't want to backup all the useless session data every night. cheers rick -- _________________________________ Rick Welykochy || Praxis Services If you have any trouble sounding condescending, find a Unix user to show you how it's done. -- Scott Adams

2 1

Cataloging workflow
by Owen Leonard 08 Jan '10

08 Jan '10

I'd like to take an informal survey to get some ideas from the Koha-using community. My library has never done the bulk of its cataloging within Koha. We switched to Koha from a system which didn't have a good cataloging module, so our catalogers have always been most comfortable with their separate cataloging tools. However, we're always looking for ideas for improving our workflow. Koha users, are you doing all your cataloging within Koha? If not, what are you using? -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

13 13

How do I bulk delete bibliographic records (of one given item type)?
by Ricardo Dias Marques 08 Jan '10

08 Jan '10

Hi everyone... and Happy New Year! :) I thought this would be easy, but I'm not finding it: in Koha 3.0.x (3.0.5, in my case), is there a way to bulk delete biblio records (of one given item type), either using the web interface or some command line tool / script? In case it is relevant, I'm running Koha in SUSE (SLES 11 - SUSE Linux Enterprise Server), and it's an UNIMARC and NoZebra installation. I know that I could run the Perl script "bulkmarcimport.pl" with the "-d" (delete) switch, in the command line, but that would delete EVERY bibliographic record, and that's not what I want. Thanks in advance. Cheers, Ricardo Dias Marques lists AT ricmarques DOT net Installation Guide for Installing Koha 3 on openSUSE 11 http://wiki.koha.org/doku.php?id=opensuse_11.0

3 6

Problem with Holds
by nitesh rijal 08 Jan '10

08 Jan '10

hello all. I tried to place hold in an item from the opac interface...it took me to another page with item listing and radio buttons to choose from. the problem is that the radio buttons are frozen, I cannot choose a value of them. what might be the problem??? please help. -- Nitesh Rijal BE IT email: rijal.it(a)gmail.com url: http://niteshrijal.com.np facebook: http://facebook.com/openrijal twitter: http://twitter.com/openrijal +9779841458173

1 0

Koha subfields in 100 tag not shown
by AnkitBabbar 08 Jan '10

08 Jan '10

I have edited hidden value and tried my best but when I go to Create catalouge it doesnot display any subfield under 100 tag please suggest me something I ma newbie Koha 3.00.00.107 Ubuntu -9.04 -- View this message in context: http://old.nabble.com/Koha-subfields-in-100-tag-not-shown-tp27070178p270701… Sent from the Koha - Discuss mailing list archive at Nabble.com.

1 0

Re: [Koha] Active borrowers
by Kathy Rippel 08 Jan '10

08 Jan '10

1 0

Active borrowers
by Ian Trim 08 Jan '10

08 Jan '10

Hi all What SQL queries are people using to get 'borrowers who have used their card in the last 2 years'? I have looked in the SQL library... Thanks Ian Trim Circulation Services Librarian Te Kaitiaki Pukapuka Wāhi Tuku Paraparaumu Library 9 Iver Trask Place Paraparaumu 04 2964 797 Skype ian.trim Kapiti Coast District Council does not guarantee the accuracy or completeness of any information contained in this e-mail or attached files. Internet communications are not secure; therefore the Council does not accept legal responsibility for the contents of this message or attached files. The content of this email may express the view of the author and not the official position of the Council. Kapiti Coast District Council may monitor and store all outgoing and incoming email traffic. This e-mail is subject to copyright. Except in reply to the author, no part of it should be reproduced, adapted or communicated without the written consent of the copyright owner. If you have received this e-mail in error, please advise the sender immediately by return e-mail, or telephone the author and delete all copies. ##################################################################################### This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal ##################################################################################### ______________________________________________________________________________ This email has been scrubbed for your protection by SMX. For more information visit http://smx.co.nz ______________________________________________________________________________

1 0

Problem installing XML::LibXSLT
by Marty 07 Jan '10

07 Jan '10

Trying to install KOHA 3.0 on Debian Etch After running Makefile.PL I get a warning; Makefile.PL: Warning: prerequisite XML::LibXSLT 1.59 not found. Trying to install with CPAN gives me the following; /usr/bin/ld: cannot find -ldb collect2: ld returned 1 exit status make: *** [blib/arch/auto/XML/LibXSLT/LibXSLT.so] Error 1 PAJAS/XML-LibXSLT-1.66.tar.gz /usr/bin/make -- NOT OK Running make test Can't test without successful make Running make install Make had returned bad status, install seems impossible I have searched here and there, but am not sure what to do here. Any hint or link is welcome, Thanks, Marty

5 5

OPAC display problems
by Inock Siziba 07 Jan '10

07 Jan '10

Compliments of the new year, and trust the message finds you all very well. On carrying out a search from our OPAC, the availability details of some materials are not showing on the search results list. This is especially so, for some few new books recently added to the catalogue, although most of the new books also recently added will display the availability details informationn. May someone kindly advise why we are experiencing this inconsistance whenever the index is updated? Just to prove it for yourselves, you may make a search for the following search term (Jewish and Christian) from our catalogue at http://tcz.co.zw:8383 You will realize that 9 search results will display, but the ninth record (This strange story by Davis Stacy) has a blank on the availability area. However, if you also search by author (Davis Stacy) nothing is displayed on the status space. There are many such inconsistancies being encountered in our OPAC display. Please help, so we can arrest the problem before it develops any further. Inock Siziba Theological College of Zimbabwe

2 1

environment variables
by Amy Schuler 07 Jan '10

07 Jan '10

Good morning, A few days ago it was suggested to me that my environmental variables Koha_conf and PERL5LIB were not set up, which may lead to the problems I had running the migration tools (bulkmarcimport, authority import) also the zebra indexing. It seems to me that my environmental variables are set up correctly. Here we have run the echo command and also tried bulk authority import again. If this printout below suggests anything new, I am grateful to hear your thoughts. Thanks again! koha@Koha3:~/kohaclone/misc/migration_tools$ echo $KOHA_CONF && echo $PERL5LIB /home/koha/koha-dev/etc/koha-conf.xml /etc/perl/C4 koha@Koha3:~/kohaclone/misc/migration_tools$ ./bulkauthimport.pl -file bulkauthimport.xml Use of uninitialized value $conf_fname in concatenation (.) or string at /etc/perl/C4/Context.pm line 321. read_config_file() returned undef at /etc/perl/C4/Context.pm line 321. Use of uninitialized value $conf_fname in concatenation (.) or string at /etc/perl/C4/Context.pm line 321. read_config_file() returned undef at /etc/perl/C4/Context.pm line 321. Use of uninitialized value $conf_fname in concatenation (.) or string at /etc/perl/C4/Context.pm line 321. read_config_file() returned undef at /etc/perl/C4/Context.pm line 321. Use of uninitialized value $conf_fname in concatenation (.) or string at /etc/perl/C4/Context.pm line 321. read_config_file() returned undef at /etc/perl/C4/Context.pm line 321. Use of uninitialized value $conf_fname in concatenation (.) or string at /etc/perl/C4/Context.pm line 321. read_config_file() returned undef at /etc/perl/C4/Context.pm line 321. Can't call method "config" on unblessed reference at /etc/perl/C4/Context.pm line 655. Compilation failed in require at /etc/perl/C4/Items.pm line 30. Compilation failed in require at /etc/perl/C4/XSLT.pm line 22. BEGIN failed--compilation aborted at /etc/perl/C4/XSLT.pm line 22. Compilation failed in require at /etc/perl/C4/Search.pm line 27. BEGIN failed--compilation aborted at /etc/perl/C4/Search.pm line 27. Compilation failed in require at /etc/perl/C4/AuthoritiesMarc.pm line 24. BEGIN failed--compilation aborted at /etc/perl/C4/AuthoritiesMarc.pm line 24. Compilation failed in require at ./bulkauthimport.pl line 20. BEGIN failed--compilation aborted at ./bulkauthimport.pl line 20. I am also interested in the response to Luis Diaz recent question, about how to make sure that zebra indexing is actually working when you have chosen to use the zebra indexing after the initial web installer setup (turning nozebra sys pref OFF, then running rebuild_zebra.pl - is this all it takes?) Thanks again, Amy Amy C. Schuler Manager of Information Services Cary Institute of Ecosystem Studies PO Box AB Millbrook, NY 12545 (845) 677-7600 x164 schulera(a)caryinstitute.org<mailto:schulera@ecostudies.org>

2 1