- Koha - lists.katipo.co.nz

Expired Patrons with Checkouts
by Hartman, David W. - GBTS Library 27 Aug '12

27 Aug '12

Hello list, I upgraded Koha to 3.09.00.004 but it still won't save the search. Any other thoughts? I logged off and on and created the search again but it won't save. > > -----Original Message----- > From: Nicole Engard [mailto:nengard@gmail.com] > Sent: Monday, August 27, 2012 10:56 AM > To: Hartman, David W. - GBTS Library > Subject: Re: [Koha] Expired Patrons with Checkouts > > This will do what you want (I think): > > > select p.surname, p.firstname, p.cardnumber, p.dateexpiry, > count(c.itemnumber) as 'items out' > from borrowers p > left join issues c using (borrowernumber) > where p.dateexpiry < now() and p.borrowernumber in (select > borrowernumber from issues) > group by p.borrowernumber > > > Thanks > Nicole > > On Mon, Aug 27, 2012 at 10:23 AM, Hartman, David W. - GBTS Library > <David.W.Hartman(a)disney.com> wrote: >> Hello! >> >> Is there a report in Koha to notify the librarian about the expired patrons who still have items checked out? I did not see one but I'd like to see a report of the expired patrons who have not returned their items.] >> >> David >> >> >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Re: [Koha] Expired Patrons with Checkouts
by Nicole Engard 27 Aug '12

27 Aug '12

This was a bug in a previous version of Koha. What version are you on? You might want to upgrade to 3.8.4. Nicole On Mon, Aug 27, 2012 at 11:53 AM, Hartman, David W. - GBTS Library <David.W.Hartman(a)disney.com> wrote: > One problem ... I cannot get it to save in my saved reports? > > I go through the steps for "create from SQL" and then save and it does not show up in my list of saved reports. > > I have tried twice.. could it be a rights issue? > > -----Original Message----- > From: Nicole Engard [mailto:nengard@gmail.com] > Sent: Monday, August 27, 2012 10:56 AM > To: Hartman, David W. - GBTS Library > Subject: Re: [Koha] Expired Patrons with Checkouts > > This will do what you want (I think): > > > select p.surname, p.firstname, p.cardnumber, p.dateexpiry, > count(c.itemnumber) as 'items out' > from borrowers p > left join issues c using (borrowernumber) > where p.dateexpiry < now() and p.borrowernumber in (select > borrowernumber from issues) > group by p.borrowernumber > > > Thanks > Nicole > > On Mon, Aug 27, 2012 at 10:23 AM, Hartman, David W. - GBTS Library > <David.W.Hartman(a)disney.com> wrote: >> Hello! >> >> Is there a report in Koha to notify the librarian about the expired patrons who still have items checked out? I did not see one but I'd like to see a report of the expired patrons who have not returned their items.] >> >> David >> >> >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Koha 3.8.4 released
by Chris Cormack 27 Aug '12

27 Aug '12

The Koha release team are proud to announce the release of 3.8.4. This is a maintenance release, and contains a lot of useful bug fixes. You can download the release from http://download.koha-community.org packages will be available shortly at http://debian.koha-community.org Please read below for the release notes. RELEASE NOTES FOR KOHA 3.8.4 22 Aug 2012 ======================================================================== 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.8.4 can be downloaded from: http://download.koha-community.org/koha-3.08.04.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.8.4 is a bugfix/maintenance release. Highlights of 3.8.4 ====================== 7943 blocker Untranslatable strings in OPAC's authority search 8486 blocker Critical error in Koha::Calendar::days_between calculation 8162 critical packaging scripts create user incorrectly 8251 critical Patrons are systematically debarred at checkin 8439 critical Printing basketgroup does not work on plack 8520 critical Authorities display incorrectly in staff results 8576 critical Software error on authority edition when using merge 8172 major Missing dereference marker for buildQuery parameter in addbooks.pl 8329 major GetLostItems in C4::Items.pm has a SELECT * 8414 major Intranet header toplinks display white rather than blue in < IE8 8448 major Holds Awaiting Pickup : Cancelling a hold on a waiting item with multiple holds displays a blank screen instead of a warning prompt 8503 major Software error n edit items with EasyAnalyticalRecords 8513 major OPAC detail page broken with XSLT 8547 major Enabling star ratings causes javascript errors that cause IE to have a boo boo 8572 major Attempting to view an invalid authority in the OPAC gives an error instead of 404 Bugs fixed in 3.8.4 ====================== 3383 normal Item due reminder digests - cannot display title information 6617 normal table of contents not printing right if entered right 7628 normal Required format is not enforced for Patron Categories 8391 normal Cannot view reading record through staff client 8419 normal Suspended holds appear on the daily holds queue 8434 normal Notice generation fails for Advanced Notices, Item Due, and Overdues when run in shell (due to error in Letters.pm) 8455 normal Check ins processed through "Check Out" tab of the Patron Record ignore Circulation System Preferences 8458 normal $stemmed_operand in C4::Search _build_stemmed_operand is not initialized. 8514 normal Display of patron results changed display order 8522 normal Markup errors cause problems with customized CSS 8532 normal Old/iffy data causes error checking out 8550 normal Z39.50 searches for ISBN/ISSN problematic 8573 normal Translation difficult in picture-upload.tt due to nested sentence in if/foreach/if/elsif - construction 8575 normal Number of items expected is wrong 8586 normal Small bug in die if no mapping in framework for biblioitems.biblioitemnumber 8590 normal checked out from missing on patron detail 3701 minor If the ReturnToShelvingCart syspref is on, and something needs to go in transit, the shelving cart setting is overriding the transit. 8062 minor Cart email broken for non english templates 8322 minor Removing space between end of marc data and fullstops 8351 minor fix wording when undoing an import 8357 minor UNIMARCslim2OPACDetail.xsl, title without class and too links to views 8392 minor Memberentry is not enforcing birthdate restrictions 8421 minor patron images fail when barcode for patron has a + 8422 minor Fix impossible warning in circulation.pl when OverduesBlockCirc set to Block 8440 minor Dates does not appear in suggestions management 8470 minor remove depreciated H:T:P test file 8476 minor Little bug in OPAC XSLT on OPACURLOpenInNewWindow 8518 minor Self checkout does not display debt amount if syspref AllowFineOverride is set to allow 8556 minor "Mark seen and continue" not translatable in inventory.tt 6655 trivial Sorting order of serial issues in OPAC 7143 trivial Bug for tracking changes to the about page 7367 trivial General OPAC typo omnibus 7368 trivial General staff client typo omnibus 8453 trivial need spaces after radio buttons on inventory 8544 trivial Make RSS icon styleable 7153 enhancement Show Open Library as Search Target in "More Searches" in OPAC detail page 8204 enhancement Authority viewer in OPAC ugly, unfriendly, and mostly useless New sysprefs in 3.8.4 ====================== * OPACSearchForTitleIn System requirements ====================== Important notes: * Perl 5.10 is required * Zebra is required 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://manual.koha-community.org/3.8/en/ 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: * Arabic (100%) * Armenian (100%) * Chinese (Taiwan) (100%) * Danish (75%) * English (New Zealand) (96%) * English (USA) * French (100%) * French (Canada) (69%) * German (100%) * German (Switzerland) (100%) * Greek (69%) * Italian (100%) * Norwegian Bokmål (68%) * Portuguese (Brazil) (91%) * Spanish (91%) 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.8 is Release Manager: Paul Poulain <paul.poulain(a)biblibre.com> Documentation Manager: Nicole C Engard <nengard(a)gmail.com> Translation Manager: Frédéric Demians <frederic(a)tamil.fr> QA Manager: Ian Walls <koha.sekjal(a)gmail.com> QA team: Marcel de Rooy <M.de.Rooy(a)rijksmuseum.nl>, Jonathan Druart <jonathan.druart(a)biblibre.com> Mason James <mason(a)kohaaloha.com> Bug Wranglers: Katrin Fischer, Magnus Enger Release Maintainer (3.4.x): Chris Nighswonger <cnighswonger(a)foundations.edu> Release Maintainer (3.6.x): Jared Camins-Esakov <jcamins(a)cpbibliography.com> Release Maintainer (3.8.x): Chris Cormack <chrisc(a)catalyst.net.nz> Credits ====================== We thank the following individuals who contributed patches to Koha 3.8.4. 1 Tomas Cohen Arazi 1 D Ruth Bavousett 10 Jared Camins-Esakov 2 Colin Campbell 5 David Cook 4 Chris Cormack 1 Elliott Davis 1 Frédéric Demians 2 Jonathan Druart 2 Nicole Engard 1 Magnus Enger 1 Chris Hall 4 Kyle M Hall 1 Mason James 2 Owen Leonard 1 Julian Maurice 1 Dobrica Pavlinusic 1 Meenakshi R 2 Marcel de Rooy 8 Fridolyn SOMERS 5 Robin Sheat 3 Mark Tompsett 4 Marc Veron 1 Savitra sirohi We also especially thank the following individuals who tested patches for Koha 3.8.4. 1 Joseph Alway 1 Tomas Cohen Arazi 7 Jared Camins-Esakov 1 David Cook 68 Chris Cormack 1 Elliott Davis 2 Frédéric Demians 7 Jonathan Druart 2 Nicole C. Engard 5 Katrin Fischer 5 Kyle M Hall 9 Owen Leonard 1 Julian Maurice 1 Dobrica Pavlinusic 28 Paul Poulain 1 Marcel de Rooy 1 Zeno Tajoli 3 Mirko Tietgen 3 Marc Veron 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 this version of Koha and future bugfixes in this release line is 3.8.x. The last Koha release was 3.8.3, which was released on July 22, 2012. 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

2 1

Expired Patrons with Checkouts
by Hartman, David W. - GBTS Library 27 Aug '12

27 Aug '12

Hello! Is there a report in Koha to notify the librarian about the expired patrons who still have items checked out? I did not see one but I'd like to see a report of the expired patrons who have not returned their items.] David

2 1

Re: [Koha] Upgrade koha 3.0 to 3.8 installation guide
by Vimal Kumar V. 27 Aug '12

27 Aug '12

Please see the following link, http://kohageek.pbworks.com/w/page/31795398/upgrade Regards, -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.org Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

3 3

I need your help
by Dagne Woldie, MS/HS Library Assistant 27 Aug '12

27 Aug '12

we are using koha 3.8, the OPAC is not displaying the call no. is there a way how to fix this. thanks Dagne

3 2

Koha upgrade version
by pandu rangaswamy 27 Aug '12

27 Aug '12

Dear all, I am running Koha 3.00.05.003 on Linux, Perl interpreter: /usr/local/bin/perl Pear Version 5.010001, Pearl @ INC /usr/share/koha/lib /usr/local/lib/perl5/5.10.1/i686-linux /usr/local/lib/perl5/5.10.1 /usr/local/lib/perl5/site_perl/5.10.1/i686-linux /usr/local/lib/perl5/site_perl/5.10.1 My SQL Version: mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i686) using readline 5.0 Apache Version: Server version: Apache/2.2.3 Server built: Jan 21 2009 22:01:41 and would like to upgrade to the latest version 3.8. Can someone provide me a guide to complete this task? Thank you Pandu.

1 0

importing batch
by izzeldin mojawir 27 Aug '12

27 Aug '12

Is it important to rebuild zebra when you import a batch of records ? and if you do not do what will hapen ? Izzeldin Mojawir O.I.University SUDAN

2 1

Koha 3.06.02
by Remark 27 Aug '12

27 Aug '12

The problem is as common as items catalog is not seen on opac nor lbrarian admin, i rebuilt zebra but problm still the same, pls advice Esmael

2 1

Merging authorities is not working, ZOOM error 25
by Doug Kingston 27 Aug '12

27 Aug '12

We are trying to fix up some duplicate and wrong authority records (note that Mr Calvertt below has an extra comma after his middle name in the MAIN ENTRY--PERSONAL NAME, but not in SUBJECT ADDED ENTRY-PERSONAL NAME which is correct. We want to dump auth 2705 and just keep auth 2706. The merge_authorities command looks like just the ticket, but exits ungracefully with a ZOOM error 25. Any thoughts? -Doug- Labeled MARC biblio : 15279 ( Rain and ruin : ) *With framework : Default Models Books, Booklets, Workbooks CD-ROMs, DVD-ROMs, General Online Resources Fast Add Framework Binders Kits Serials Audio Cassettes, CDs DVDs, VHS * CONTROL NUMBER 201204161534.nwCONTROL NUMBER IDENTIFIER UkLoVWDATE AND TIME OF LATEST TRANSACTION 20120417120703.0FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION 850212s1983 enka 001 0aeng LIBRARY OF CONGRESS CONTROL NUMBER85117086 INTERNATIONAL STANDARD BOOK NUMBER0862991137 : £8.95 0862991145 (pbk.) CATALOGING SOURCEDLC DLC DLC GEOGRAPHIC AREA CODE e-uk-en LIBRARY OF CONGRESS CALL NUMBERS417.C25 A37 1983 DEWEY DECIMAL CLASSIFICATION NUMBER630/.92/4 B 19 LOCAL CALL NUMBERGN 20 (31) MAIN ENTRY--PERSONAL NAMECalvertt, John Simpson, 2705 TITLE STATEMENTRain and ruin : the diary of an Oxfordshire farmer, John Simpson Calvertt, 1875-1900 / edited by Celia Miller. PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)Gloucester : Alan Sutton, 1983.PHYSICAL DESCRIPTION 285 p. : ill. ; 23 cm. GENERAL NOTEIncludes index. SUBJECT ADDED ENTRY--PERSONAL NAMECalvertt, John Simpson 2706 SUBJECT ADDED ENTRY--TOPICAL TERMRural conditions 446 Nineteenth century 353 Social history 485 Diaries 136 ADDED ENTRY--PERSONAL NAMEMiller, Celia 2707 ADDED ENTRY ELEMENTS (KOHA)VWML BK GN 20 (31) 0 GN_00020_31 SYSTEM CONTROL NUMBERS (KOHA)15279 15279 ~/koha-test/bin/migration_tools$ ./merge_authority.pl -f 2705 -t 2706 ************ You will merge authority : 2705 (PERSO_NAME) LDR 00378nz a2200133o 4500 001 2705 003 UkLoVW 005 20120416153840.0 008 120416|||a|||||| | ||| d 040 _aUkLoVW _cUkLoVW 100 _aCalvertt, John Simpson, 667 _aMachine generated authority record. 670 _aWork cat.: (UkLoVW)0: Calvertt, John Simpson,, Rain and ruin :, 1983. 942 _aPERSO_NAME ************* Into authority : 2706 (PERSO_NAME) LDR 00382nz a2200133o 4500 001 2706 003 UkLoVW 005 20120416153840.0 008 120416|||a|||||| | ||| d 040 _aUkLoVW _cUkLoVW 100 _aCalvertt, John Simpson 667 _aMachine generated authority record. 670 _aWork cat.: (UkLoVW)0: Calvertt, John Simpson, 2705, Rain and ruin :, 1983. 942 _aPERSO_NAME Do you confirm (enter YES)?YES Merging ZOOM error 25 "Specified element set name not valid for specified database" (addinfo: "F") from diag-set 'Bib-1'

1 0