- Koha - lists.katipo.co.nz

Cron Jobs in Koha
by Ephraim Makeke 10 Nov '11

10 Nov '11

Hi All I would like my system to calculate fines and overdue notices. What I really want to find out is this: 1. What is the syntax for the script for calculating fines every 24 hours 2. What is the syntax for calculating over dues every 7 days 3. If I have more than one fine rule for different users what do I do. Thank you Ephraim Ephraim Makeke Senior Assistant Librarian - Library ICT Midlands State University Library P. Bag 9055 Gweru Zimbabwe Tel: 263 54 260445 ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.

2 1

zebra problem
by Jonson philip 10 Nov '11

10 Nov '11

hi i'm using koha V 3.2 from montns i havn't any problems with zebra indexing , i have 15.000 biblio suddenly when i enter a new biblio i can't found it , and i have this massege in zebraqueue DBI connect('dbname=koha;host=localhost;port=3306','kohaadmin',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' any help ?? thank's

4 5

Koha - RFID SIP Module ( to be link with Koha)
by axeubin 10 Nov '11

10 Nov '11

Dear Guys , We just Installed Koha , so to link the RFID SIP module with Koha , am bit confused and don know wat to do Any ideas to link the module with koha . Hopefully waiting for reply -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-RFID-SIP-Module-to-be-link-with-Koha… Sent from the Koha-general mailing list archive at Nabble.com.

2 2

Search failing only on one phrase "economics"
by Raphael Muonga 10 Nov '11

10 Nov '11

Colleagues suddenly I am having this search problem only on this word which was working very well last few days both in Intranet and OPAC. But it is working okay another phrase(s). The error I am getting is as follows in both Intranet and OPAC:- Can't call method "as_usmarc" on an undefined value at /usr/share/koha/lib/C4/Search.pm line 2383. What has caused this and how can I solve it? Thanks in anticipation. Raphael.

4 4

Koha 3.4.6 is now available
by Chris Nighswonger 09 Nov '11

09 Nov '11

It is with pleasure that I announce the release of Koha 3.4.6. The package can be retrieved from: http://download.koha-community.org/koha-3.04.06.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.04.06.tar.gz.MD5 http://download.koha-community.org/koha-3.04.06.tar.gz.MD5.asc http://download.koha-community.org/koha-3.04.06.tar.gz.sig Release notes for 3.4.6 are below. Come and get it! RELEASE NOTES FOR KOHA 3.4.6 - 09 Nov 2011 ======================================================================== Koha is the first free and open source software library automation package (ILS). Development is sponsored by libraries of varying types and sizes, volunteers, and support companies from around the world. The website for the Koha project is http://koha-community.org/ Koha 3.4.6 can be downloaded from: http://download.koha-community.org/koha-3.04.06.tar.gz Installation instructions can be found at: http://wiki.koha-community.org/wiki/Installation_Documentation OR in the INSTALL files that come in the tarball Koha 3.4.6 is a bugfix/maintenance release. Highlights of 3.4.6 ====================== 1139 blocker ISBN search fails with double dashes 5995 blocker Glitch with checkauth 2453 critical (very) large biblio/item handling 6575 critical funds with no restrictions not see by librarians 6576 critical changing framework while cataloging looses data 6687 critical cannot move people in the holds queue 6854 critical import_borrowers.pl : Double password encryption on member update if there is no password in the csv and no default password value. 6879 critical Actual price should show correctly on order line and basket summary 6959 critical Can't import record via Z39.50 from MARC edit page 2599 major Search limits not working for NoZebra 5796 major actual price not taken into account in encumbrance 5945 major can't search patron's email anymore 6014 major Log viewer needs permissions 6414 major actual price not recorded when ordering 6465 major Errors in UNIMARC plugins for fixed length fields (for | and space) (T::T issue) 6490 major Lost and paid not updated when book is checked out. 6660 major limiting search to a patron category shows all patrons in category 6801 major Patron details page slow to load when many checkouts present 6927 major Typo in Overdues.pm 6974 major MARC21 Leader plugin no longer auto-fills the 000 field 6977 major Support for repeated subfields when importing an authority into a biblio record field. 7134 major patron records getting funny birthdays Bugs fixed in 3.4.6 ====================== 3258 normal routing-preview.pl : button text + redirect issue 3704 normal SIP Checkin of not checked out item returns error without additional reason 5369 normal se queries with paranthesis fail 5630 normal CAS improvements 6070 normal On a new order defined from suggestion some fields were missing. 6217 normal Searching for 3 part patron names brings no results 6253 normal Unified Patron Search subroutine 6280 normal Invalid SQL being passed in circulation checkout 6390 normal Basket only visible for librarian who created it 6460 normal No log generated if Action set to All or Modify or Delete 6513 normal Library and Category filters when searching for a borrower to add to a routing list don't work correctly. 6885 normal Superlibrarian users can't delete items from another library when IndependantBranches 6966 normal Update Help Files for Koha 3.6 Release 6972 normal Hardcoded template paths to en in showmarc 6996 normal Encoding problem in opac-showmarc 6997 normal koha-remove leaves system in inconsistent state if there is an error 7202 normal z39.50 search on bib edit not working 959 enhancement We need to be abble to modifie order line after receipt 5528 enhancement Analytical records support 5572 enhancement refinements to function merge sub merge in C4::AuthoritiesMarc 5983 enhancement Change the wording around the CAS login 6012 enhancement Set up a working example of a CAS proxy 6296 enhancement Allow authentication to Koha via PKI / x.509 certificates 6670 enhancement Link patron name on returns screen to circulation page instead of patron detail page 6875 enhancement de-nesting C4 packages 6884 enhancement Improve TinyMCE configuration on Koha News page System requirements ====================== Changes since 3.2: * Template::Toolkit Documentation ====================== As of Koha 3.2, the Koha manual is now maintained in DocBook. The home page for Koha documentation is http://koha-community.org/documentation/ As of the date of these release notes, only the english version of the Koha manual is available: http://koha-community.org/documentation/3-4-manual/ The Git repository for the Koha manual can be found at http://git.koha-community.org/gitweb/?p=kohadocs.git;a=summary Translations ====================== Complete or near-complete translations of the OPAC and staff interface are available in this release for the following languages: * Chinese * Danish * English (New Zealand) * English (USA) * French (France) * French (Canada) * German * Greek * Hindi * Italian * Norwegian * Portuguese * Spanish * Turkish Partial translations are available for various other languages. The Koha team welcomes additional translations; please see http://wiki.koha-community.org/wiki/Translating_Koha for information about translating Koha, and join the koha-translate list to volunteer: http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-translate The most up-to-date translations can be found at: http://translate.koha-community.org/ Release Team ====================== The release team for Koha 3.4 is Release Manager: Chris Cormack <chrisc(a)catalyst.net.nz> Documentation Manager: Nicole C Engard <nengard(a)gmail.com> Translation Manager: Frédéric Demians <frederic(a)tamil.fr> Release Maintainer (3.2.x): Chris Nighswonger <cnighswonger(a)foundations.edu> Release Maintainer (3.4.x): Chris Nighswonger <cnighswonger(a)foundations.edu> QA Manager: Colin Campbell Credits ====================== We thank the following individuals who contributed patches to Koha 3.4.6 (The numeral in the first column represents the number of patches included in this release): 1 Alex Arnaud 1 Larry Baerveldt 1 Greg Barniskis 2 D Ruth Bavousett 1 Jared Camins-Esakov 2 Colin Campbell 2 Frédérick Capovilla 1 Galen Charlton 17 Chris Cormack 8 Frédéric Demians 2 Jonathan Druart 1 Nicole Engard 2 Magnus Enger 3 Katrin Fischer 2 Mason James 6 Srdjan Jankovic 1 Janusz Kaczmarek 12 Owen Leonard 1 Matthias Meusburger 1 Joy Nelson 4 Chris Nighswonger 2 Maxime Pelletier 11 Paul Poulain 1 Meenakshi R 1 MJ Ray 4 Liz Rea 10 Marcel de Rooy 7 Robin Sheat 1 Juan Sieira 18 Ian Walls We regret any omissions. If a contributor has been inadvertantly missed, please send a patch against these release notes to koha-patches(a)lists.koha-community.org. Revision control notes ====================== The Koha project uses Git for version control. The current development version of Koha can be retrieved by checking out the master branch of git://git.koha-community.org/koha.git The branch for Koha 3.4.x (i.e., this version of Koha and future bugfix releases) is 3.4.x. The next major feature release of Koha will be Koha 3.6.0. Bugs and feature requests ====================== Bug reports and feature requests can be filed at the Koha bug tracker at http://bugs.koha-community.org/ Ehara taku toa i te toa takitahi, engari he toa takitini ##### Autogenerated release notes updated last on 09 Nov 2011 at 16:50:37Z ##### RELEASE NOTES FOR KOHA 3.4.6 - 09 Nov 2011 ======================================================================== Koha is the first free and open source software library automation package (ILS). Development is sponsored by libraries of varying types and sizes, volunteers, and support companies from around the world. The website for the Koha project is http://koha-community.org/ Koha 3.4.6 can be downloaded from: http://download.koha-community.org/koha-3.04.06.tar.gz Installation instructions can be found at: http://wiki.koha-community.org/wiki/Installation_Documentation OR in the INSTALL files that come in the tarball Koha 3.4.6 is a bugfix/maintenance release. Highlights of 3.4.6 ====================== 1139 blocker ISBN search fails with double dashes 5995 blocker Glitch with checkauth 2453 critical (very) large biblio/item handling 6575 critical funds with no restrictions not see by librarians 6576 critical changing framework while cataloging looses data 6687 critical cannot move people in the holds queue 6854 critical import_borrowers.pl : Double password encryption on member update if there is no password in the csv and no default password value. 6879 critical Actual price should show correctly on order line and basket summary 6959 critical Can't import record via Z39.50 from MARC edit page 2599 major Search limits not working for NoZebra 5796 major actual price not taken into account in encumbrance 5945 major can't search patron's email anymore 6014 major Log viewer needs permissions 6414 major actual price not recorded when ordering 6465 major Errors in UNIMARC plugins for fixed length fields (for | and space) (T::T issue) 6490 major Lost and paid not updated when book is checked out. 6660 major limiting search to a patron category shows all patrons in category 6801 major Patron details page slow to load when many checkouts present 6927 major Typo in Overdues.pm 6974 major MARC21 Leader plugin no longer auto-fills the 000 field 6977 major Support for repeated subfields when importing an authority into a biblio record field. 7134 major patron records getting funny birthdays Bugs fixed in 3.4.6 ====================== 3258 normal routing-preview.pl : button text + redirect issue 3704 normal SIP Checkin of not checked out item returns error without additional reason 5369 normal se queries with paranthesis fail 5630 normal CAS improvements 6070 normal On a new order defined from suggestion some fields were missing. 6217 normal Searching for 3 part patron names brings no results 6253 normal Unified Patron Search subroutine 6280 normal Invalid SQL being passed in circulation checkout 6390 normal Basket only visible for librarian who created it 6460 normal No log generated if Action set to All or Modify or Delete 6513 normal Library and Category filters when searching for a borrower to add to a routing list don't work correctly. 6885 normal Superlibrarian users can't delete items from another library when IndependantBranches 6966 normal Update Help Files for Koha 3.6 Release 6972 normal Hardcoded template paths to en in showmarc 6996 normal Encoding problem in opac-showmarc 6997 normal koha-remove leaves system in inconsistent state if there is an error 7202 normal z39.50 search on bib edit not working 959 enhancement We need to be abble to modifie order line after receipt 5528 enhancement Analytical records support 5572 enhancement refinements to function merge sub merge in C4::AuthoritiesMarc 5983 enhancement Change the wording around the CAS login 6012 enhancement Set up a working example of a CAS proxy 6296 enhancement Allow authentication to Koha via PKI / x.509 certificates 6670 enhancement Link patron name on returns screen to circulation page instead of patron detail page 6875 enhancement de-nesting C4 packages 6884 enhancement Improve TinyMCE configuration on Koha News page System requirements ====================== Changes since 3.2: * Template::Toolkit Documentation ====================== As of Koha 3.2, the Koha manual is now maintained in DocBook. The home page for Koha documentation is http://koha-community.org/documentation/ As of the date of these release notes, only the english version of the Koha manual is available: http://koha-community.org/documentation/3-4-manual/ The Git repository for the Koha manual can be found at http://git.koha-community.org/gitweb/?p=kohadocs.git;a=summary Translations ====================== Complete or near-complete translations of the OPAC and staff interface are available in this release for the following languages: * Chinese * Danish * English (New Zealand) * English (USA) * French (France) * French (Canada) * German * Greek * Hindi * Italian * Norwegian * Portuguese * Spanish * Turkish Partial translations are available for various other languages. The Koha team welcomes additional translations; please see http://wiki.koha-community.org/wiki/Translating_Koha for information about translating Koha, and join the koha-translate list to volunteer: http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-translate The most up-to-date translations can be found at: http://translate.koha-community.org/ Release Team ====================== The release team for Koha 3.4 is Release Manager: Chris Cormack <chrisc(a)catalyst.net.nz> Documentation Manager: Nicole C Engard <nengard(a)gmail.com> Translation Manager: FrÃ©dÃ©ric Demians <frederic(a)tamil.fr> Release Maintainer (3.2.x): Chris Nighswonger <cnighswonger(a)foundations.edu> Release Maintainer (3.4.x): Chris Nighswonger <cnighswonger(a)foundations.edu> QA Manager: Colin Campbell Credits ====================== We thank the following individuals who contributed patches to Koha 3.4.6 (The numeral in the first column represents the number of patches included in this release): 1 Alex Arnaud 1 Larry Baerveldt 1 Greg Barniskis 2 D Ruth Bavousett 1 Jared Camins-Esakov 2 Colin Campbell 2 FrÃ©dÃ©rick Capovilla 1 Galen Charlton 17 Chris Cormack 8 FrÃ©dÃ©ric Demians 2 Jonathan Druart 1 Nicole Engard 2 Magnus Enger 3 Katrin Fischer 2 Mason James 6 Srdjan Jankovic 1 Janusz Kaczmarek 12 Owen Leonard 1 Matthias Meusburger 1 Joy Nelson 4 Chris Nighswonger 2 Maxime Pelletier 11 Paul Poulain 1 Meenakshi R 1 MJ Ray 4 Liz Rea 10 Marcel de Rooy 7 Robin Sheat 1 Juan Sieira 18 Ian Walls We regret any omissions. If a contributor has been inadvertantly missed, please send a patch against these release notes to koha-patches(a)lists.koha-community.org. Revision control notes ====================== The Koha project uses Git for version control. The current development version of Koha can be retrieved by checking out the master branch of git://git.koha-community.org/koha.git The branch for Koha 3.4.x (i.e., this version of Koha and future bugfix releases) is 3.4.x. The next major feature release of Koha will be Koha 3.6.0. Bugs and feature requests ====================== Bug reports and feature requests can be filed at the Koha bug tracker at http://bugs.koha-community.org/ Ehara taku toa i te toa takitahi, engari he toa takitini ##### Autogenerated release notes updated last on 09 Nov 2011 at 16:50:37Z #####

1 0

Re: [Koha] List of Koha libraries and/or their OPACs
by Adalid Ortiz 09 Nov '11

09 Nov '11

OK, my selection: http://nyack.waldo.kohalibrary.com/ http://kohaxercode.homelinux.net/ http://www.library.britishcouncil.org.in/cgi-bin/koha/opac-main.pl http://mykoha.co.nz/ http://library.hauraki-dc.govt.nz/ http://demo-kobli.bage.es/ And my Koha/OPAC http://clavius.tij.uia.mx Felipe Adalid Ortiz Anzaldo Bibliotecario de sistemas Universidad Iberoamericana Tijuana Biblioteca Loyola http://clavius.tij.uia.mx Ave. Centro Universitario 2501 Playas de Tijuana 22200, Tijuana, B.C. 0 664 630-1577 Ext. 623 adalid(a)tij.uia.mx

2 1

Import items not importing items
by WTC 09 Nov '11

09 Nov '11

Hello I've just tried to import a couple of batches of items but they haven't imported. I've created MARC records with MarcEdit. I staged them for import. I looked for existing records based on ISBN (020$a) and Ignore incoming record if matching biblio found). I chose Yes to check for embedded items. I selected Always add items. Clicked on stage for import. The message was: 29 records in file 0 records not staged ... 29 records staged 29 records with at least one match ... 29 item records found and staged Clicked on Manage Staged Records All 29 items were auto_matched I clicked on Import this batch into the catalog The message was Completed import of records Number of records added 0 Number of records updated 0 Number of records ignored 29 Number of items added 29 Number of items ignored 0 Now normally when I do this there is a delay of a few minutes before the items are visibile in the catalogue, but these 29 items aren't showing at all. When I look at the record for an item it doesn't show the items that I just imported. I've done this procedure many times, and it has always worked. Any ideas on what may have gone wrong? My version is: Koha version: 3.04.02.000 OS version ('uname -a'): Linux Koha 2.6.32-5-amd64 #1 SMP Tue Jun 14 09:42:28 UTC 2011 x86_64 GNU/Linux Perl interpreter: /usr/bin/perl Perl version: 5.010001 Perl @INC: /usr/share/koha/lib /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . MySQL version: mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (x86_64) using readline 6.1 Apache version: Server version: Apache/2.2.16 (Debian) Zebra version: Zebra 2.0.44 (C) 1994-2010, Index Data ApS Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: 419ad759807269fdfa379799a051ed3a551c6541 Using ICU -- View this message in context: http://koha.1045719.n5.nabble.com/Import-items-not-importing-items-tp497156… Sent from the Koha-general mailing list archive at Nabble.com.

3 4

Unblock User
by anjoze 09 Nov '11

09 Nov '11

Hi list, Is there a way to "unblock" a Patron? My Library works with suspensions in days. The problem is that some times for some reasons we need to forgive that suspension. If its not possible, can I do it directly on the database? What is the flag/tablename? Thank you very much, JA Koha Version: 3.02.10 -- View this message in context: http://koha.1045719.n5.nabble.com/Unblock-User-tp4949411p4949411.html Sent from the Koha-general mailing list archive at Nabble.com.

5 5

Re: [Koha] Branches and circulation rules
by Fischer, Katrin 09 Nov '11

09 Nov '11

Ann, I am forwarding your questions to the mailing list. I am not sure you can do what you want to do with Koha – perhaps someone else has some ideas and can help you. Regards, Katrin From: library [mailto:library@katikaticollege.school.nz] Sent: Wednesday, November 09, 2011 12:30 AM To: Fischer, Katrin Subject: Re: [Koha] Branches and circulation rules Thankyou for your help. Basically I want to be able to block patrons from issuing more books but allow them to get equipment. There are not separate permissions for different item types as far as I can see. I also need to isolate the book issuing/renewing/returning from the students and teachers who will be issuing the laptops. Regards Ann Murphy On Wed, Nov 9, 2011 at 10:52 AM, Fischer, Katrin <Katrin.Fischer(a)bsz-bw.de> wrote: Hi, some of my libraries use a separate itemtpye 'multimedia equipment' for lending laptops and cameras. With a separate itemtype you can set up rules for patron category/itemtype combinations, which works quite well. I am not sure if using a separate branch gives you a real advantage. You can do separate things for overdues in Koha, so I am not sure where your problem is located. You can block the patron from different actions (renewal, checkout, placing holds) using system preferences (OPACFineNoRenewals, noissuescharge, maxoutstanding) and a fine amount. You can also debar patrons with sending out overdue notices (tools > overdue notice/status triggers). The number of overdue books does not influence the checkout, onle the fine amounts and time span since the books got overdue can. Those blocks will take effect system wide, so a separate branch will not make a difference. You can also check the manual for more information about fines and setting up circulation rules: http://koha-community.org/documentation/ Hope that helps a bit. -- Katrin -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz on behalf of library Sent: Tue 08.11.2011 21:57 To: koha(a)lists.katipo.co.nz Subject: [Koha] Branches and circulation rules Tena koutou We are struggling to understand the way individual branches work. We would like to create an independent branch to issue laptops to students (and departmental resources later) which will not be affected by how many library books students have overdue. I have tried setting circulation rules in the laptop issues branch to be completely different to those in our library but this has not worked. Are we able to define differing borrow rules for the same patron at different libraries. Could someone direct me to more complete instructions on how the overdues systems work or how circulation rules work. We are still using 3.2 but will be migrating to 3.6 in the New Year. Thanks Ann Murphy Librarian Katikati College amurphy(a)katikaticollege.school.nz

1 0

Koha and Third-Party commercial services
by Ian Walls 09 Nov '11

09 Nov '11

Dear Community, In the last few months, I've seen more and more interest in developing Koha support for integration with third-party commercial services. These services usually require some kind of special coding to achieve that integration, instead of using a global standard for data transmission. To be fair, I think this is often because there IS NO global standard for the kind of data they want to transmit. But I'm still wary of this. All the external services we have now (Amazon, Babelthèque, Baker and Taylor, Google, Library Thing, Novelist Select, OCLC, Open Library, and Syndetics) are very self-contained; they have system preferences which just control whether or not a block of HTML/Javascript API code gets put into the template. This is pretty benign; it's template code and some database data (nothing structural), and can be completely disabled if the preferences are turned off. This seems like good integration to me. But other services require something a bit more heavy-weight. Things that would involve writing a fair block of Perl code, or altering Koha's data structure to store a new kind of information (new table columns or tables, instead of just entries in existing tables). Changes like this concern me, particularly if the service requires a subscription, is geographically-limited or has closed licensure. Perhaps I'm just being paranoid, but it seems that if we start letting these external services influence the development of Koha, we could eventually wind up with an ILS that is no longer in the interest of the global community. Am I being crazy? Is this a valid issue? Are the advantages of being able to talk to more external products greater than the risks of a few specific company's products getting hardcoded into our ILS? Thanks for any feedback you can provide, -Ian

7 8