January 2012 - Koha-devel - lists.koha-community.org

How to get CAS based Single Sign On working?
by Koustubha Kale 25 May '15

25 May '15

Hi All, I have a situation where we have a main website based on Joomla. This Joomla site uses CAS to authenticate users. We would like users ( who have already logged in to the Joomla site via CAS) to be able to follow a link to Koha site and be logged in automatically ( e.g. Single Sign On ). I have got simple CAS ( not proxy CAS ) working with Koha ( version 3.2.6 ) using the same CAS server as used by Joomla site. Still when I login to Joomla site with CAS, and then go to Koha and click on login and follow the CAS login link, I am asked to fill up CAS login information again. How can this be avoided by using CAS SSO? I have read through http://wiki.koha-community.org/wiki/SSO_CAS_improvements and am confused by the statement "Note: simple sso cas support (no proxy) has been done already by biblibre, is in testing and should be released in Koha 3.2" in there. Does this statement mean that SSO is possible with simple CAS? If yes how to set it up? If not, I have also read through bugs 6012, 5630 and the CAS Proxy examples. Frankly I haven't been able to figure out how I can achieve the above required functionality based on all the reading. Any help is much appreciated.. Another related query is, Is it possible to automatically create users in Koha once they have authenticated with CAS? Regards, Koustubha Kale Anant Corporation Contact Details : Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), Maharashtra, India, Pin : 400601. TeleFax : +91-22-21720108, +91-22-21720109 Mobile : +919820715876 Website : http://www.anantcorp.com Blog : http://www.anantcorp.com/blog/?author=2

3 3

koha-3.00.00 make fails
by Rick Welykochy 28 Dec '13

28 Dec '13

Hi all, I have downloaded http://download.koha.org/koha-3.00.00.tar.gz and began installing it on Debian/etch (in a Linux vserver environment). 0. FINE: cd koha-3.00.00 1. FINE: perl Makefile.PL 2. FAIL: make : : : Manifying blib/man3/C4::UploadedFile.3pm Manifying blib/man3/C4::BackgroundJob.3pm Manifying blib/man3/opac::opac-dictionary.3pm Manifying blib/man3/serials::member-search.3pm /usr/bin/perl "-Iblib/arch" "-Iblib/lib" fix-perl-path.PL blib /usr/bin/perl "-Iblib/arch" "-Iblib/lib" rewrite-config.PL blib/KOHA_CONF_DIR/koha-conf.xml Bad arg length for Socket::inet_ntoa, length is 0, should be 4 at rewrite-config.PL line 67. make: *** [blib/KOHA_CONF_DIR/koha-conf.xml] Error 255 Any ideas what went wrong and how to fix? Aside: there were a couple of other problems with this "out of the box" debian based install of Koha 3.0 which had to be fixed along the way, e.g. seven missing perl modules and libgd not found. I'll report on the entire process from unpacking to a running Koha/3.00.00 once I get to the end. cheers rickw -- ________________________________________________________________ Rick Welykochy || Praxis Services || Internet Driving Instructor The manual said Windows XP/SP2 or better so I installed Linux.

4 5

Re: [Koha-devel] Improving permissions on lists (virtual shelves)
by Marcel de Rooy 02 Apr '12

02 Apr '12

Thanks all for responding to this inquiry. This was very helpful. I am merging here the results and will be posting them back to report 7310 or a wiki page. Feel free to correct me where I made the wrong conclusion. 1 Public lists in OPAC: Currently, a user should be logged in to create a list. I would strongly recommend to keep that restriction. A new preference is added that allows opac users to create public lists or does not allow that. Additionally, I would add the restriction that another opac user cannot change the list type of a public list to private list or change the list permissions when he did not create it (currently possible); the owner can do that or a staff member with permissions in the staff client. 2 Three new permissions per list: Add items, Delete own items, Delete other items. This makes the Open list type obsolete. 3 Share private lists with another patron (as described before). Can be turned on/off with a preference. 4 Staff client features: add an option under Tools to moderate inappropriate list names for public lists and shared private lists. (A library is free to use it or not.) Add staff list permission: allow to manage lists (virtual shelves). With that permission a staff member can moderate the list names as mentioned and access the staff Lists module. (He can change list type and permissions. He can take ownership of a public list if the owner has been deleted.) 5 [NEW] Deleting a patron should also delete his (unshared) private lists, his shares with private lists of someone else and clear owner on his public lists. [Currently, the virtualshelves table will contain lists (of any type) of deleted borrowers.] A new problem is what to do with shared private lists (still used by other patrons). Just deleting them would not be nice for those patrons. Just promoting them to public lists could not be ideal too; same for leaving this to be sorted out by the librarian. The best [pragmatic] solution is probably setting ownership to the first user that received a share on that list. (He already had access to those lists, but is now able to change settings on that list too.) ADDITIONAL COMMENT If a library does not allow public list creation in OPAC and does not share lists, how should a staff member change list type of a private list? This is not possible. You could say by design. It is the result of combining those two prefs. As a workaround, a staff member could enable public list creation, let the user change list type in opac and reset the pref. Or enable sharing lists, let the user share that list with staff member, accept it and reset the pref.

1 1

Re: [Koha-devel] link_bibs_to_authorities.pl can corrupt records
by Paul 16 Feb '12

16 Feb '12

Chris, Many thanks - picking up on you points below: At 09:57 AM 1/7/2012 +1300, Chris Cormack wrote: >I have successfully use that script to link authorities to biblio records >after doing a migration. But the way it works is to remove all links and >recreate. Not sure about the "recreate" bit... >Course I didn't do this on a server people were using, which it sounds >like you are, to have lost 100 biblios. "People" are using it. After nearly a year of using Koha 3.2, 3.6.1 is up and running (kudos to the development team, average LAN response time is down from 4.7 secs to well < 1 sec.) I asked for assistance with zebra for authorities, and the assistance from the community allowed me to resolve the difficulties. Then I asked our volunteers to start cataloguing on 3.6.1 to sort out any remaining "update" glitches -- hence the ~100 biblios in the last 24 hours (if you want the nitty-gritty on why we've got to do so many per day, I'll oblige off-list) >Its included for that use case. Jared is working on a much better linking >script and he gave you the information how to change it. Respectfully, it's included in the "current stable release" with no warnings (3.6.1 was "current" when I installed it -- I haven't verified 3.6.2.) and Jared's information came after "horses and barn doors." >Its not a total screwup script, and it didn't demolish the whole db, I >think you would find people more willing to help you, in their own free >time, in their weekends if you didn't come across so aggressive and >accusatory in your tone. I humbly apologize to anyone who finds me "aggressive and accusatory" -- it's probably the way I was taught to write (concisely, briefly, etc) rather than my feelings. Most people who know me well find me to be a cuddly rather than a grizzly bear. Again my apologies. Best - Paul >Chris >On 7 Jan 2012 09:48, "Archives and Collections Society" ><<mailto:info@aandc.org>info(a)aandc.org> wrote: >At 03:02 PM 1/6/2012 -0500, Ian Walls wrote: >>Paul, >>The <http://link_bibs_to_authorities.pl>link_bibs_to_authorities.pl >>script is hardcoded to ALWAYS erase manual links.ÃÂ I'm not sure what >>the reasoning is behind that.ÃÂ But, every time you run it, any link >>you've done manually that the script can't automatically figure out will >>be removed.ÃÂ Nature of the beast (for now, at least). > >What is "any link you've done manually"?, please.Â More than 90% of our >input is Z39.50 and "default" item cataloguing. > >OK - a total screw-up that is included without any warning whatsoever in >the standard distribution of 3.6.1 ???Â From the bug report ><<http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5683>http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5683> > >Chris Cormack 2011-06-01 21:13:23 UTC >Pushed to master > >Jared Camins-Esakov 2011-07-08 14:37:02 UTC >Seems to be working now. Closing. > >If it's "nature of the beast" why isn't the "beast" mentioned >somewhere?Â What on earth is the reason for this .pl to be included in >any distribution? > >More... >>2012/1/6 Chris Cormack >><<mailto:chris@bigballofwax.co.nz>chris(a)bigballofwax.co.nz> >>Im assuming you did this on your testing/staging server right? >>Id restore that from backup, then try applying the patch and see if you >>get better behaviour. >>If so, then do it on your production machine. > >what "patch"??? > >And yes -- I can restore from a previous sqldump, and only lose +/- 100 >biblios.Â Â We're in pre-production and when we got the zebra indexing >working properly, I told our volunteers to start inputting to 3.6.1 *only* >(not duplicate on 3.2) so that I could look into any difficulties they >experienced as cataloguers. > >I had no way at all of knowing that a pl script included in the "latest >stable distribution" could possibly demolish the whole db. > >Again, what "patch" and where do I find it? > >Might I suggest that someone re-opens the bug (I have attempted to >annotate it) and removes this dangerous script from public distribution >(or at least includes a very visible warning.) > >Best - Paul > >>Chris >>On 7 Jan 2012 08:47, "Paul" <<mailto:paul.a@aandc.org>paul.a(a)aandc.org> >>wrote: >>Bug 5683 (<http://link_bibs_to_authorities.pl>link_bibs_to_authorities.pl >>can corrupt records) was signed off some months ago, but is perhaps a >>little too cryptic for me to follow in detail. Ã Can someone help? As >>far as I can see, without remedial action, this is catastrophic. >>Following difficulties we have had migrating 3.2 to 3.6.1, someone on the >>users mailing list suggested we should run >><http://link_bibs_to_authorities.pl>link_bibs_to_authorities.pl -- (db >>has ~10k authorities and ~15k biblios) -- so I did just that, and have >>APPARENTLY DEMOLISHED *EVERY* LINK IN THE DB. Ã From my notes: >>paul@nelson:/usr/share/koha$ >>./bin/<http://link_bibs_to_authorities.pl>link_bibs_to_authorities.pl >>Bib authority heading linking report >>------------------------------------ >>Number of bibs checked: ÃÂ ÃÂ ÃÂ 14911 >>Number of bibs modified: ÃÂ ÃÂ Ã 14886 >>Number of bibs with errors: ÃÂ 0 >>but - the staff interface no longer correctly finds authorities !!! >>[1] Manually link (staff client) auth "Lubbock" to bib "Arctic Whalers" >>-- now linked, 35 other Lubbock bibs not linked. Ã Is this a question of >>zebra re-indexing? >>So: Ã KOHA_CONF=/etc/koha/koha-conf.xml PERL5LIB=/usr/share/koha/lib >>./bin/migration_tools/<http://rebuild_zebra.pl>rebuild_zebra.pl -a -r -v >>and Ã KOHA_CONF=/etc/koha/koha-conf.xml PERL5LIB=/usr/share/koha/lib >>./bin/migration_tools/<http://rebuild_zebra.pl>rebuild_zebra.pl -b -r -v -x >>koha@nelson:/usr/share/koha$ >>./bin/<http://link_bibs_to_authorities.pl>link_bibs_to_authorities.pl >>... processed 100 records >>/ ... / >>... processed 14900 records >>Bib authority heading linking report >>------------------------------------ >>Number of bibs checked: ÃÂ ÃÂ ÃÂ 14911 >>Number of bibs modified: ÃÂ ÃÂ Ã 1 >>Number of bibs with errors: ÃÂ 0 >>koha@nelson:/usr/share/koha$ >>All this did was to *un-link" the bib/auth link that I had manually >>entered at [1] above. Could someone involved with signing off bug 5683 >>please explain why link==unlink? >>Help - please. >>Paul >>_______________________________________________ >>Koha-devel mailing list >><mailto:Koha-devel@lists.koha-community.org>Koha-devel(a)lists.koha-community.org >> >>http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >>website : <http://www.koha-community.org/>http://www.koha-community.org/ >>git : <http://git.koha-community.org/>http://git.koha-community.org/ >>bugs : <http://bugs.koha-community.org/>http://bugs.koha-community.org/ >> >> >>_______________________________________________ >>Koha-devel mailing list >><mailto:Koha-devel@lists.koha-community.org>Koha-devel(a)lists.koha-community.org >>http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >>website : <http://www.koha-community.org/>http://www.koha-community.org/ >>git : <http://git.koha-community.org/>http://git.koha-community.org/ >>bugs : <http://bugs.koha-community.org/>http://bugs.koha-community.org/ >> >> >> >> >>-- >>Ian Walls >>Lead Development Specialist >>ByWater Solutions >>ALA Midwinter Booth #2048 >>Phone # (888) 900-8944 >><http://bywatersolutions.com>http://bywatersolutions.com >><mailto:ian.walls@bywatersolutions.com>ian.walls(a)bywatersolutions.com >>Twitter: @sekjal >>_______________________________________________ >>Koha-devel mailing list >><mailto:Koha-devel@lists.koha-community.org>Koha-devel(a)lists.koha-community.org >>http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >>website : <http://www.koha-community.org/>http://www.koha-community.org/ >>git : <http://git.koha-community.org/>http://git.koha-community.org/ >>bugs : <http://bugs.koha-community.org/>http://bugs.koha-community.org/ > >--- >Archives and Collections (ACS) Society >205, Main Street, Picton, Ontario, K0K 2T0, Canada ><http://www.aandc.org/>http://www.AandC.org >Canadian Charitable Organization 88721 9921 RR0001 >Dedicated to maritime conservation and education. > >_______________________________________________ >Koha-devel mailing list >Koha-devel(a)lists.koha-community.org >http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >website : http://www.koha-community.org/ >git : http://git.koha-community.org/ >bugs : http://bugs.koha-community.org/ --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://UltraMarine.ca>, <http://AandC.org> and <http://MarDoc.ca>

4 7

Speed improvement & T::T
by Paul Poulain 10 Feb '12

10 Feb '12

Hello Koha-devel, As I said during last IRC chat, I'm focusing on performance improvement those weeks. I've digged into Template::Toolkit, and here http://search.cpan.org/~abw/Template-Toolkit-2.22/lib/Template/Manual/Confi… I've found 2 options that look promizing : COMPILE_EXT and COMPILE_DIR The loading of the template seems to cost 150ms, and I feel that those 2 options could be usefull to speed up the process. Did anyone already saw this option before ? Is it something worth investigating more ? Here is the documentation of the 1st option: COMPILE_EXT >From version 2 onwards, the Template Toolkit has the ability to compile templates to Perl code and save them to disk for subsequent use (i.e. cache persistence). The COMPILE_EXT option may be provided to specify a filename extension for compiled template files. It is undefined by default and no attempt will be made to read or write any compiled template files. my $template = Template->new({ COMPILE_EXT => '.ttc', }); If COMPILE_EXT is defined (and COMPILE_DIR isn't, see below) then compiled template files with the COMPILE_EXT extension will be written to the same directory from which the source template files were loaded. Compiling and subsequent reuse of templates happens automatically whenever the COMPILE_EXT or COMPILE_DIR options are set. The Template Toolkit will automatically reload and reuse compiled files when it finds them on disk. If the corresponding source file has been modified since the compiled version as written, then it will load and re-compile the source and write a new compiled version to disk. This form of cache persistence offers significant benefits in terms of time and resources required to reload templates. Compiled templates can be reloaded by a simple call to Perl's require(), leaving Perl to handle all the parsing and compilation. This is a Good Thing. -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

4 6

deafult for biblio.frameworkcode
by Zeno Tajoli 27 Jan '12

27 Jan '12

Hi to all, I want to add, in "Koha to MARC mapping" a link beetween the mysql field biblio.frameworkcode to a marc21 subfield. I think it is useful to have this data in the marc record. I propose to use 997 $a. The tag 997 is an empty tag. What do you thing ? Bye Zeno Tajoli -- Dott. Zeno Tajoli tajoliAT_SPAM_no_prendiATcilea.it fax +39 02 2135520 CILEA - Consorzio Interuniversitario http://www.cilea.it/disclaimer

8 16

RM monthly newsletter #2 (2012 january)
by Paul Poulain 27 Jan '12

27 Jan '12

Welcome to my 3rd RM monthly newsletter. There has been a *LOT* of *important* things pushed this month. Everybody should read this newsletter in detail. If you're planning to submit patches, you *must*. If you're just a user of Koha, there are some interesting announcements too, you can read it as well ! ==== Bugzilla news ==== There are 87 bugs waiting to be signed-off. That's too much ! and a problem is that is seems that hard-to-test patches can be lost in the wilderness for a long time. Small/easy patches are usually quickly signed-off. The patches to QA pile show a correct 30 patches. Unfortunatly, that's the hardest ones too, as I QAed a lot of 'trivial' patches this month... ==== Bugzilla ==== Earlier this month Ian, our QA manager made important changes to our bugzilla setup. The "patch status" field has been removed in favor of the "status" field. The previous "patch status" have all be moved to "status". 2 new status have been added: - in discussion = will be used when a patch need a deeper discussion to see if it can/should be added into Koha. The discussion can be functional (is the feature desirable in Koha ?) or technical (is the way it's made OK ?) The "in discussion" bugs will be discussed on the monthly meeting. - 'pushed to stable': pushed has been splitted in "pushed to master" and "pushed to stable". The RMaint (Chris N. for now) will use "Pushed to stable" when he pushed a patch to stable (3.6). The "pushed to master" is used by me when pushing to master (for the future 3.8) The only side effect of this bulkchange is that date of last change of each bug has been reseted to the date of the bulkchange. That's annoying if you want to see which patch to signoff is the oldest. ==== Coding guidelines ==== I've updated the code guideline page on the wiki (http://wiki.koha-community.org/wiki/Coding_Guidelines) I've removed all deprecated guidelines, and added some that we already use, and that were not written. I've added a general rule for QA: General rule: if you submit code that fixes an existing code that violates those guidelines, the QA can still be passed. You don't have to fix everything. If you want to fix more than just your fix, to respect current guidelines, you're welcomed of course. But in this case, please to it in a 2nd patch, to have reviewers being able to distinguish easily what's related to your bugfix and what is related to your guidelines-violation fixing. ==== Important technical patches pushed ==== Some important internal changes have been pushed. Those change won't be visible for users, but are important for developers === Date formatting & displaying === Chris has written a nice Template::Toolkit plugin that will take care of date formatting for you. Before the patch, you had to format dates before sending them to the template, something like: my $entrydate = C4::Dates->new( $data->{'entrydate'}, 'iso' ); $data->{'entrydate'} = $entrydate->output("syspref"); # entrydate is now available Now, you still can do it that way, but that would be a really bad idea: just send the date as it's provided by mySQL (iso format), and, in the template, write [% MyDate | $KohaDates %] don't forget to put [% USE KohaDates %] at the beginning of your page to tell Template::Toolkit you'll use this plugin. What must/can be done now is ... update all code & templates displaying dates to use this plugin ! Bug 7444 has been created to reflect all the patches that will be made to switch to KohaDates template. *Coding Guideline rule* * all new code displaying date *MUST* use this plugin * existing code can still use previous option, but cleaning is highly welcomed === Datatable jquery plugin === We've decided some months ago to get rid of the various jquery plugins we use to display large tables, in favor of Datatable. Datatable has been pushed into master, with a first page using it (patron reading record), and some documentation on the wiki (http://wiki.koha-community.org/wiki/DataTables_HowTo) *Coding guideline rule* * all new code displaying potentially large tables *MUST* use this plugin (preferably the "server side processing" option) * existing code can still use old plugins, but cleaning is highly welcomed ! ==== Important functionnal patches pushed ==== Some patches that contains important new features have been pushed. Don't hesitate to test them again and again if you've a sandbox. They'll be available in Koha 3.8 === UnwantedFields in member entry (bug 6190) === A new syspref now let you choose fields that you don't want to have in patron forms. A very interesting feature as there are *many* fields available. Note that this is a syspref, so you can't remove some fields for a given category and keep it for another. But that's a nice first step anyway ! === Acquisition changes === Some changes, coming from the stuff made by BibLibre for StEtienne university have been pushed: * show cancelled order in basket page (bug 5358): after the list of orders, you now also have the list of cancelled lines, on every basket * late order management (bug 5347): Koha now keep track of how many claims you've made on a given order line, and the date of the last claim. The default claim notification has been updated and your claim will have to be updated when upgrading to 3.8 The breakdown of budget spending has also been reintroduced (Bug 929) : on acqui-home.pl page, on each budget you can now see how the budget has been spent. === Local cover images (bug 1633) === You can now upload images to your biblios, that will be displayed as cover image. You can also zoom on the image, and, if you've uploaded more than just one, see all of them. This feature can be activated on staff and OPAC independantly. === j2a.pl script === The j2a.pl script, that is in misc/cronjobs was previously very basic, upgrading Childs to Adult (hardcoded category) when they reached 18. The script now has many new option to make it much more usefull ==== Hackfest in Europe ==== Again, in case you missed the news BibLibre (my company, in case you don't know) organize a hackfest in Marseille in March. More information at http://drupal.biblibre.com/en/blog/entry/2012-hackfest-in-europe, feel free to join, all attendees will get a special thanks on this newsletter after the hackfest. We already have Owen coming from USA, Marc, coming from Switzerland, Katrin coming from Germany, Dobrika and Marijana coming from Croatia, and -probably- Zeno coming from Italy. It's still time to join, don't hesitate anymore !!! See you next month for the #4 and in the meantime, happy hacking !!! -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 0

Koha 3.4.8 is now available
by Chris Nighswonger 27 Jan '12

27 Jan '12

It is with pleasure that I announce the release of Koha 3.4.8. The package can be retrieved from: http://download.koha-community.org/koha-3.04.08.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.04.08.tar.gz.MD5 http://download.koha-community.org/koha-3.04.08.tar.gz.MD5.asc http://download.koha-community.org/koha-3.04.08.tar.gz.sig Release notes for 3.4.8 are below. Come and get it! RELEASE NOTES FOR KOHA 3.4.8 27 Jan 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.4.8 can be downloaded from: http://download.koha-community.org/koha-3.04.08.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.8 is a bugfix/maintenance release. Highlights of 3.4.8 ====================== 6627 blocker [security] insecure file creation 2830 critical Hold not removed when "trapped" item on hold shelf is checked out to a different patron in the holds queue 3651 critical Require patron login to send shelves and baskets 5533 critical marking item lost diff in two places 6292 critical Overdue notices have a bug when multiple overdues exist 7093 critical Placeholders for suggestion table in suggestion related mails broken 7160 critical paying fines throws error 7193 critical can't remove end date from subscriptions 7316 critical Missing escaping in search results 7360 critical Importing a SQL file for frameworks based on Default Framework deletes the default framework 7370 critical Longoverdue cronjob claims Undefined subroutine &main::LostItem 7407 critical HidePatronName not working anymore 2012 major Add bilio crashes under no zebra 6302 major Failing to send email notices - to_address not set 6923 major can't load help files 7202 major z39.50 search on bib edit not working 7226 major Can't add tags on list 7275 major Pagination lost when click in the option "Show more" of facets column Bugs fixed in 3.4.8 ====================== 2307 normal Calendar widget cannot be translated 2534 normal Viewing items table on item edit screen requires horizontal scrolling 3431 normal Catalog by itemtype report pulling from holdingbranch 5226 normal MARC21 field 545 missing 5369 normal se queries with paranthesis fail 6098 normal zebra conf NSB NSE indexed as space 6142 normal CanBookBeReserved function is redefined in C4/ILSDI/Utility.pm 6374 normal Use "size" as names/hash keys leads to an unexpected results when using Template::Toolkit (name of a virtual method there) 6466 normal hung socket read causes SIP tests to fail 6700 normal Better handling of version numbers in updatedatabase 6717 normal Sub total doubled up on borrower pay fines page 6885 normal Superlibrarian users can't delete items from another library when IndependantBranches 6917 normal Acquisitions reports: Dates filters doesn't work when they are not selected on row or column 7097 normal HidePatronName not hiding in all places 7198 normal overdue report does not display patron name if firstname and/or surname are null 7215 normal callnumber versus itemcallnumber 7245 normal Errors in MySQL tables population with mandatory data for italian installation 7262 normal No calendar present in holidays module when there are quotes in title or description 7276 normal member entry Performance improvement 7277 normal keyword mapping needs spaces in the OPAC 7287 normal overdue notification is processed several times if some sites do not have rules 7313 normal Untranslatable strings in 'search to hold' feature 7332 normal Translated title (MARC21 field 242) doesn't display 7338 normal link to serial detail wrong 7349 normal Sorting patron search result by cardnumber doesn't work 7361 normal 'Default' encoding in staged marc import breaks diacritics 7363 normal Downloading a list in CSV format doesn't work 7381 normal wrong isbn showing on the staff search results 1623 enhancement Retain history of approved comments 2011 enhancement Link patron extra sort fields to authorized values 3184 enhancement Show creator and budget receiving a document 5327 enhancement Unit tests required for all C4 modules 5565 enhancement Default OAI UNIMARC to Dublin Core XSL adds superfluous blanks 5607 enhancement Make fields from issues table available in overdues 6193 enhancement Use memcached cache koha-conf.xml configuration variables 6663 enhancement would be nice to put ranges of dates in the calendar 6716 enhancement Database Documentation 6787 enhancement NORMARC needs a Fast Add framework 6865 enhancement Replace image-based gradient backgrounds with CSS3 gradients 6975 enhancement OPACBaseURL called as OPACBaseurl in many templates 7135 enhancement in addbiblio, make save button floating to have it on always on screen 7139 enhancement Log circulation messags 7143 enhancement Bug for tracking changes to the about page 7159 enhancement Add branchcode to circulation.pl search 7164 enhancement add Koha history timeline tab to 'About' page 7197 enhancement ES translation of the Debian readme 7220 enhancement Add IDs to check-in message dialogs to facilitate CSS customization 7240 enhancement Cleaning up import tables and action_logs 7247 enhancement rebuild_zebra.pl -v should show all Zebra log output 7309 enhancement Add NORMARCslim2intranetDetail.xsl for detail view in intranet 7324 enhancement Show alternate email as mailto link on patron summary 7326 enhancement longoverdue.pl was hardcoded to 1 year, is now a parameter 7373 enhancement new bridge icons 7439 enhancement Mailmap for git shortlog 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.8 (The numeral in the first column represents the number of patches included in this release): 1 Tomas Cohen Arazi 2 Alex Arnaud 1 Marc Balmer 3 Brendan 5 Jared Camins-Esakov 1 Frédérick Capovilla 1 Galen Charlton 1 Garry Collum 17 Chris Cormack 2 Christophe Croullebois 7 Frédéric Demians 3 Connor Dewar 8 Nicole Engard 3 Magnus Enger 12 Katrin Fischer 5 Chris Hall 1 Mason James 1 Srdjan Jankovic 1 Admin User Koha 1 Henri-Damien Laurent 20 Owen Leonard 1 Frère Sébastien Marie 1 Jesse Maseto 1 James Mason 2 Julian Maurice 4 Sophie Meynieux 3 Chris Nighswonger 1 Albert Oller 1 Dobrica Pavlinusic 9 Paul Poulain 3 Liz Rea 8 Marcel de Rooy 1 Fridolyn SOMERS 4 Adrien Saurat 1 Robin Sheat 2 Juan Sieira 11 Duncan Tyler 8 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 27 Jan 2012 14:02:53 Z #####

1 0

Koha 3.6.3 is now available
by Chris Nighswonger 26 Jan '12

26 Jan '12

It is with pleasure that I announce the release of Koha 3.6.3. The package can be retrieved from: http://download.koha-community.org/koha-3.06.03.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.06.03.tar.gz.MD5 http://download.koha-community.org/koha-3.06.03.tar.gz.MD5.asc http://download.koha-community.org/koha-3.06.03.tar.gz.sig Release notes for 3.6.3 are below. Come and get it! RELEASE NOTES FOR KOHA 3.6.3 26 Jan 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.6.3 can be downloaded from: http://download.koha-community.org/koha-3.06.03.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.6.3 is a bugfix/maintenance release. Highlights of 3.6.3 ====================== 6627 blocker [security] insecure file creation 2830 critical Hold not removed when "trapped" item on hold shelf is checked out to a different patron in the holds queue 3651 critical Require patron login to send shelves and baskets 5533 critical marking item lost diff in two places 6292 critical Overdue notices have a bug when multiple overdues exist 7193 critical can't remove end date from subscriptions 7360 critical Importing a SQL file for frameworks based on Default Framework deletes the default framework 7370 critical Longoverdue cronjob claims Undefined subroutine &main::LostItem 7394 critical Broken detail page for last link from result page 7407 critical HidePatronName not working anymore 2012 major Add bilio crashes under no zebra 6302 major Failing to send email notices - to_address not set 7226 major Can't add tags on list 7282 major invalid language selection Bugs fixed in 3.6.3 ====================== 2307 normal Calendar widget cannot be translated 3431 normal Catalog by itemtype report pulling from holdingbranch 4300 normal Display 866z summary holdings public note in OPAC 5226 normal MARC21 field 545 missing 5369 normal se queries with paranthesis fail 6098 normal zebra conf NSB NSE indexed as space 6142 normal CanBookBeReserved function is redefined in C4/ILSDI/Utility.pm 6374 normal Use "size" as names/hash keys leads to an unexpected results when using Template::Toolkit (name of a virtual method there) 6466 normal hung socket read causes SIP tests to fail 6700 normal Better handling of version numbers in updatedatabase 6717 normal Sub total doubled up on borrower pay fines page 6885 normal Superlibrarian users can't delete items from another library when IndependantBranches 7097 normal HidePatronName not hiding in all places 7266 normal overdue.pl : filter on flags "debarred" "suspended" and "gonenoaddress" not working 7276 normal member entry Performance improvement 7277 normal keyword mapping needs spaces in the OPAC 7311 normal Error when records have UNIMARC 461$0 or 773$0 for something other than bibnumber 7313 normal Untranslatable strings in 'search to hold' feature 7328 normal Expanded options in advanced search 7332 normal Translated title (MARC21 field 242) doesn't display 7338 normal link to serial detail wrong 7349 normal Sorting patron search result by cardnumber doesn't work 7356 normal Fix various typos and mis-spellings 7361 normal 'Default' encoding in staged marc import breaks diacritics 7363 normal Downloading a list in CSV format doesn't work 7381 normal wrong isbn showing on the staff search results 1623 enhancement Retain history of approved comments 3184 enhancement Show creator and budget receiving a document 5327 enhancement Unit tests required for all C4 modules 5565 enhancement Default OAI UNIMARC to Dublin Core XSL adds superfluous blanks 5607 enhancement Make fields from issues table available in overdues 5729 enhancement Add coins information to the intranet 6015 enhancement Enhancing the performance test suite 6193 enhancement Use memcached cache koha-conf.xml configuration variables 6787 enhancement NORMARC needs a Fast Add framework 6990 enhancement TransformKohaToMarc enhancement 7079 enhancement Default values for German system preferences (web installer) 7143 enhancement Bug for tracking changes to the about page 7220 enhancement Add IDs to check-in message dialogs to facilitate CSS customization 7240 enhancement Cleaning up import tables and action_logs 7247 enhancement rebuild_zebra.pl -v should show all Zebra log output 7278 enhancement In the items table, make items.materials of type text, and show its contents at circulation 7324 enhancement Show alternate email as mailto link on patron summary 7326 enhancement longoverdue.pl was hardcoded to 1 year, is now a parameter 7364 enhancement Fast-Add framework doesn't always get the branch for item creation 7373 enhancement new bridge icons 7439 enhancement Mailmap for git shortlog System requirements ====================== Changes since 3.4: * Perl 5.10 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.6/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: * Chinese (Taiwan) * Danish * English (USA) * English (UK) * French (France) * German * Italian * Portuguese (Brazil) * Spanish 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.6 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> QA Manager: Ian Walls <ian.walls(a)bywatersolutions.com> Bug Wranglers: MJ Ray, Marcel de Rooy, Paul Poulain, Mason James Release Maintainer (3.4.x): Chris Nighswonger <cnighswonger(a)foundations.edu> Release Maintainer (3.6.x): Chris Nighswonger <cnighswonger(a)foundations.edu> Credits ====================== We thank the following libraries who are known to have sponsored new features in Koha 3.6: * Los Gatos Public Library * NEKLS * East Brunswick Public Library * Athens County Public Libraries * Horowhenua Library Trust * Halton Borough Council * South Taranaki District Council We thank the following individuals who contributed patches to Koha 3.6.3. 1 Tomas Cohen Arazi 1 Alex Arnaud 2 Marc Balmer 2 D Ruth Bavousett 6 Jared Camins-Esakov 1 Frédérick Capovilla 1 Garry Collum 15 Chris Cormack 1 Christophe Croullebois 8 Frédéric Demians 3 Connor Dewar 2 Nicole Engard 2 Magnus Enger 14 Katrin Fischer 4 Chris Hall 1 Srdjan Jankovic 1 Admin User Koha 2 Henri-Damien Laurent 12 Owen Leonard 1 Frère Sébastien Marie 1 Jesse Maseto 1 James Mason 2 Julian Maurice 3 Sophie Meynieux 5 Chris Nighswonger 1 Albert Oller 1 Dobrica Pavlinusic 10 Paul Poulain 2 Liz Rea 7 Marcel de Rooy 1 Fridolyn SOMERS 1 Sam Sanders 5 Adrien Saurat 11 Duncan Tyler 5 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.6.x (i.e., this version of Koha and future bugfix releases) is 3.6.x. The next major feature release of Koha will be Koha 3.8.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 26 Jan 2012 15:06:56 Z #####

1 0

Official Koha Newsletter: Volume 3, Issue 1: January 2012
by Daniel Grobani 26 Jan '12

26 Jan '12

[Below is the text of the newsletter. For active links and a more readable format, please visit http://koha-community.org/koha-newsletter-volume-3-issue-1-january-2012] Official Koha Newsletter (ISSN 2153-8328) Volume 3, Issue 1: January 2012 Edited by Daniel Grobani, Koha Community Newsletter Editor. Please submit news items to danielg.koha(a)gmail.com. Table of Contents Koha Development Koha 3.6.3 Status Koha 3.4.8 Status Database Schema Bugs PostgreSQL Support Koha Community New Koha Libraries Community Gossip Donum: a Norwegian Koha Co-op Catalyst Open Source Academy 2012 Past Koha Events January General IRC Meeting Global Bug Squashing Day 2012-01-06 Upcoming Koha Events February General IRC Meeting Global Bug Squashing Day 2012-02-08 Marseille Hackfest KohaCon12 Koha Development Koha 3.6.3 Status by Chris Nighswonger The 3.6.x branch is in a string freeze. Koha 3.6.3 is scheduled for release on 25 January 2012. Koha 3.4.8 Status by Chris Nighswonger Koha 3.4.8 is scheduled for release on 28 January 2012. Database Schema Bugs Paul Poulain and Jonathan Druart have created a new wiki page, http://wiki.koha-community.org/wiki/DB_schema_bugs, documenting problems they’ve identified with Koha’s database design. They invite the community to read, add to, or discuss this page. PostgreSQL Support Marc Balmer plans to begin work on PostgreSQL support during the March hackfest in Marseille in order to pave the way for future PostgreSQL support in Koha. For more info, see http://wiki.koha-community.org/wiki/PostgreSQL. Koha Community New Koha Libraries Bethel University (via ByWater Solutions) Mental Health and Education Resource Centre, Christchurch (via Catalyst) New Zealand Institute of Chartered Accountants (via Catalyst) 246 libraries in the Philippines went live with Koha in the last year. For more info, see http://web.nlp.gov.ph/nlp/?q=node/2300. Community Gossip ByWater Solutions has an opening for a Development Specialist. Chris Cormack has posted a summary of Koha accomplishments in the year 2011 at http://blog.bigballofwax.co.nz/2012/01/01/2011-and-koha-by-the-numbers/. Chris has also posted sign-off statistics for December at http://blog.bigballofwax.co.nz/2012/01/23/sign-off-statistics-for-december/. Nicole Engard has been promoted to Vice President of Education at ByWater Solutions. Melia Meggs has been promoted to Chief Operations Officer at ByWater Solutions. Equinox Software has formed a Canadian subsidiary. Ian Walls, Koha 3.8 QA manager, has left ByWater Solutions for a position at the University of Massachusetts Amherst. Bob and Irma Birchall from Calyx and Chris Cormack and Kathryn Tyree from Catalyst will be holding a combined Koha stand at Vala2012 in Melbourne from 6-9 February. For more info, see http://www.vala.org.au/vala2012/conf2012. Donum: a Norwegian Koha Co-op by Magnus Enger Donum — Frie biblioteksystemer SA is a co-op that aims to further its members’ economic interests by cooperating in building, developing, and managing software, translations, knowledge, and networks. The co-op will also mediate relevant contracts and generate spin-offs and user utility by helping to promote and increase knowledge about free library systems and the values they build upon, both in the private and public sector. It also aims to assist with the development and delivery of services related to such systems. The main activities will be to carry out, organize, maintain, and quality check translations, as well as marketing, training and development of Koha and other free software for the library sector in Norway. The co-op will function as a network and maintainer of fora and meeting places through activities such as organizing user meetings, seminars, and conferences. The co-op will benefit its members through prioritized and possibly discounted access to training, conferences etc. It will also aid in organizing cost-sharing for new developments related to relevant software. For more info, see http://donum.no/. Catalyst Open Source Academy 2012 by Chris Hall, Chris Cormack, Grant Patterson, Javier Romero Twenty-three high school students from around New Zealand took the opportunity to learn more about open source software development during their summer holidays by participating in the Catalyst Open Source Academy 2012. In the first week, the students learned to install Ubuntu Linux on their training laptops, familiarised themselves with what the terms Freedom and Community mean for open source projects, and learned basic programming principles and how the web works. During the second week students worked on an open source project of their choosing. Amongst others there was a Koha group and a group who worked on kiritakikoha, an Android app for Koha (system and end) users. Four students from the Koha project group used jQuery to create graphs for many of the popular SQL reports at http://wiki.koha-community.org/wiki/SQL_Reports_Library. A sample of the graphs made by one student can be viewed at http://opac.koha.workbuffer.org/. These can be adapted to graph almost any SQL report and display it on the OPAC and/or the intranet. The other two students working on the Koha project went through the HTML test report page to improve unit testing coverage. The goal for the week was to increase the percentage of unit testing coverage of Koha by at least 2%, which they did! By the end of the week the Koha project group had: Committed 16 unit tests Changed 300 lines of Koha code Tested 598 lines of Koha code not previously tested (+2.1%) Tested 85 subroutines not previously tested (+2.6%) The group working on kiritakikoha made suggestions for future improvements in the client and in its appearance, e.g. customised icons for small devices. They worked collaboratively to implement the following features: Splitting up the existing search interface into simple and advanced search Highlighting search terms in the search results Displaying book covers from OpenLibrary and Google in the search results Providing a date picker for the place hold dates Displaying currently checked out/overdue Improved support for low-resolution devices Importing library settings via a Quick Response code (2D barcodes which upon scanning with a phone camera can configure kiritakikoha with that library’s settings) The Academy was an opportunity for these students to experience the software development cycle within the open source community and to make valuable contributions to open source projects. Past Koha Events January General IRC Meeting The January general IRC meeting was held on 4 January 2012. For more info, including the agenda and links to the minutes, see http://wiki.koha-community.org/wiki/General_IRC_Meeting,_4_January_2012. Global Bug Squashing Day 2012-01-06 by Magnus Enger Global Bug Squashing Day 2012-01-06 by Magnus Enger A Global bug squashing day was held on Friday, 6 January 2012, and there was much rejoicing. For the numbers, see http://wiki.koha-community.org/wiki/2012-01-06_Global_bug_squashing_day. Upcoming Koha Events February General IRC Meeting The February general IRC meeting will be held on 8 February 2012. For more info, see http://wiki.koha-community.org/wiki/General_IRC_Meeting,_8_February_2012. Global Bug Squashing Day 2012-02-08 by Magnus Enger Global Bug Squashing Days are days designated to a concerted effort to get bugs and patches moving along in the right direction. The next GBSD will be 8 February 2012. For more info, see http://wiki.koha-community.org/wiki/2012-02-08_Global_bug_squashing_day. Marseille Hackfest by Paul Poulain A reminder about the hackfest BibLibre is organizing in Marseille in March! It’s time to book your flights/trains/car/horse/boat, and tell us if you’re coming. We already have 6 people coming (plus all BibLibre staff, of course) from 4 different countries (France, Germany, Croatia, and USA). We have a lot of chairs and desktops still available! If you hope to come but still are not sure, don’t hesitate to email kim.nguyen -at- biblibre.com. Full details are at http://drupal.biblibre.com/en/blog/entry/2012-hackfest-in-europe. KohaCon12 KohaCon12 will take place this June in central Edinburgh, Scotland, UK. The main conference will be held Tuesday, 5 June to Thursday, 7 June. A hackfest will be held Saturday, 9 June to Monday, 11 June. For more info, see http://wiki.koha-community.org/wiki/Category:KohaCon12 and http://wiki.koha-community.org/wiki/Wishlist_for_KohaCon12.

1 0