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

Anonymous OPAC Search History
by Julian Maurice 05 Jan '12

05 Jan '12

Hello all, I have a question about this commit (I didn't succeed to find the corresponding bug in Bugzilla) commit feeafa8168965183ba8651cf3113c3c32af863ec Author: Henri-Damien LAURENT <henridamien.laurent(a)biblibre.com> AuthorDate: Mon Aug 24 22:10:25 2009 +0200 Commit: Henri-Damien LAURENT <henridamien.laurent(a)biblibre.com> CommitDate: Wed Sep 30 11:22:21 2009 +0200 Adding Opac-SearchHistory feature Enables ppl to store their search history and delete the whole history Adding Storable required by Opac-Search-History Signed-off-by: Galen Charlton <gmcharlt(a)gmail.com> It adds the possibility for users to store their search queries. It's possible for both logged users and anonymous users. More than that, if an anonymous user with a search history log in, the whole anonymous history is loaded and stored as the user search history. Isn't there any privacy problems with this feature? I mean, if user_1 do some search as an anonymous user, and then user_2 go on the same computer and log in, the whole user_1 search history is saved into user_2 search history. This behaviour has been reported as a bug by some BibLibre customers, that's why I ask. -- Julian Maurice <julian.maurice(a)biblibre.com> BibLibre

3 2

work on the database (call for wiki discussion)
by Paul Poulain 05 Jan '12

05 Jan '12

Hello, Jonathan & me took 3 hours working on database design. We've created a wiki page with all the mistakes we've found. The page is http://wiki.koha-community.org/wiki/DB_schema_bugs you're welcomed to read it, add anything that could have been forgotten, or discuss what must be discussed. There are 2 kinds of entries in this page: * italic lines => we've found the problem, we don't have a solution, feel free to add your voice to the discussion tab of the wiki (http://wiki.koha-community.org/wiki/Talk:DB_schema_bugs, I already have filled it to ease the talk) * non italic lines => unless we made a mistake, those don't need to de discussed, they are obvious mistakes we will fix ASAP (which does not mean soon ;-) ) Enter the game ! -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

3 3

Cleaning up some files
by Marcel de Rooy 05 Jan '12

05 Jan '12

Paul, If the tests in t/db_dependent/lib and its subdir KohaTest are not working and should not be used anymore, could you please remove them from master? The files in t/data/db_schemas could be moved to docs/db_schemas, or deleted too. They just show the koha structure on some moments in time. Thanks, Marcel Van: Chris Cormack [mailto:chris@bigballofwax.co.nz] Verzonden: donderdag 22 december 2011 11:16 Aan: Marcel de Rooy CC: koha-devel(a)lists.koha-community.org Onderwerp: RE: [Koha-devel] Error on test in KohaTest They shouldn't be anymore, they dont work. Use the .t ones Chris On 22 Dec 2011 20:47, "Marcel de Rooy" <M.de.Rooy(a)rijksmuseum.nl<mailto:M.de.Rooy@rijksmuseum.nl>> wrote: Thanks, but how should they be run then? > -----Oorspronkelijk bericht----- > Van: Chris Cormack [mailto:chris@bigballofwax.co.nz<mailto:chris@bigballofwax.co.nz>] > Verzonden: donderdag 22 december 2011 02:27 > Aan: Marcel de Rooy > CC: koha-devel(a)lists.koha-community.org<mailto:koha-devel@lists.koha-community.org> > Onderwerp: Re: [Koha-devel] Error on test in KohaTest > > 2011/12/20 Marcel de Rooy <M.de.Rooy(a)rijksmuseum.nl<mailto:M.de.Rooy@rijksmuseum.nl>>: > > Hi, > > > > > > > > What am I doing wrong here? > > > > > > > > [marcel@RKM004 testclone]$ perl > > t/db_dependent/lib/KohaTest/AuthoritiesMarc.pm > > > > Invalid CODE attribute: Test( 1 ) at > > t/db_dependent/lib/KohaTest/AuthoritiesMarc.pm line 39 > > > > BEGIN failed--compilation aborted at > > t/db_dependent/lib/KohaTest/AuthoritiesMarc.pm line 39. > > > > > > > > [marcel@RKM004 testclone]$ perl t/db_dependent/lib/KohaTest/Search.pm > > > > Invalid CODE attribute: Test( 1 ) at t/db_dependent/lib/KohaTest/Search.pm > > line 35 > > > > BEGIN failed--compilation aborted at t/db_dependent/lib/KohaTest/Search.pm > > line 35. > > > > > > > The tests in that dir are not designed to be run that way, in fact we > should probably just remove them. > > The real tests for those files are > t/db_dependent/Search.t > and > t/AuthoritiesMarc_MARC21.t > t/AuthoritiesMarc.t > t/AuthoritiesMarc_UNIMARC.t > > Chris

1 0

TEST sending email and email administration
by Henri-Damien LAURENT 04 Jan '12

04 Jan '12

my little message -- Henri-Damien LAURENT BibLibre

1 0

sample databases for sandboxes
by Paul Poulain 02 Jan '12

02 Jan '12

Hello, In my RM application, I spoke of sandboxes that could be used for non-techies to test and signoff patches. I've started to work on this system, something should be visible this month. The system will work that way: * you reach a dedicated page * on this page, you enter 3 things (maybe some more to come) : - the bugzilla patch number you want to test - your email-address (to have a mail once your sandbox is set) - the database you want to setup, from a list of available sample databases * you hit the "OK" button * a few minuts later, you get a mail in your mailbox saying it's done * you connect to the sandbox, and, on the main page, you see if everything went well and you can work on this sandbox. QUESTION/REQUEST: if you have a sample database you'd like to see in the list, just send it to me by email, with some details about the content of this example database, that will be seen by ppl that want to test patches. For example : "this database has 1000 records, 100 patrons, with IndependantBranches=ON, and holds are not enabled anywhere. login with test/test to be superlibrarian from library A, and libB/libB to be a non-superlibrarian from library B" FAQ about this system: Q: how will we manage concurrency ? A: there won't be any automatic checking. But the timestamp of the creation of every sandbox will be visible on mainpage. So if the sandbox is very young, use another one ! If you've any doubt, go Q: what if something went wrong when applying the patch ? A: just add a comment on bugzilla to say "tried to test this patch with sandbox system, it does not work, you get the following message: <copy here the message you saw on mainpage>>". It will mean this patch must be tested by a developer with larger skills than this basic sandbox system has. Q: I want to setup my own sandboxes, how can I do that ? A: go to http://git.biblibre.com, and you'll see a project here with all the code (ie: still to be done) Q: I've tested the patch, and everything went well, what's next ? A: just go to bugzilla, change the status to "signed-off" and add a comment to say "i've tested, works well, signed-off". The RM or the QA team will take care of officially adding your signature to the patch. Q: how long will last a given sandbox setup ? A: Every night, everything will be reseted, Koha will be updated against an uptodate master. -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 0

DataTables How-To
by Julian Maurice 30 Dec '11

30 Dec '11

Hi all! I just wrote a brief explanation on how to use the jQuery library DataTables in Koha pages. Here is the link http://wiki.koha-community.org/wiki/DataTables_HowTo Please feel free to give feedback and to contribute ;-) -- Julian Maurice <julian.maurice(a)biblibre.com> BibLibre

1 0

Official Koha Newsletter: Volume 2, Issue 12: December 2011
by Daniel Grobani 30 Dec '11

30 Dec '11

Official Koha Newsletter: Volume 2, Issue 12: December 2011 [Below is the text of the newsletter. For active links and a more readable format, please visit http://koha-community.org/koha-newsletter-volume-2-issue-12-december-2011] Official Koha Newsletter (ISSN 2153-8328) Volume 2, Issue 12: December 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.2 Released Koha 3.4.7 Released Koha 3.2.11 Released Koha 3.4.8 Status Koha Community New Koha Libraries Community Gossip Koha in Fiji Past Koha Events December General IRC Meeting Global Bug Squashing Day 2011-12-07 Upcoming Koha Events January General IRC Meeting Global Bug Squashing Day 2011-01-06 Marseilles Hackfest Koha Development Koha 3.6.2 Released by Chris Nighswonger It is with pleasure that I announce the release of Koha 3.6.2. The package can be retrieved from: http://download.koha-community.org/koha-3.06.02.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.06.02.tar.gz.MD5 http://download.koha-community.org/koha-3.06.02.tar.gz.MD5.asc http://download.koha-community.org/koha-3.06.02.tar.gz.sig Release notes for 3.6.2 are at http://koha-community.org/koha-3-6-2. Koha 3.4.7 Released by Chris Nighswonger It is with pleasure that I announce the release of Koha 3.4.7. The package can be retrieved from: http://download.koha-community.org/koha-3.04.07.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.04.07.tar.gz.MD5 http://download.koha-community.org/koha-3.04.07.tar.gz.MD5.asc http://download.koha-community.org/koha-3.04.07.tar.gz.sig Release notes for 3.4.7 are at http://koha-community.org/koha-3-4-7. Koha 3.2.11 Released by Chris Nighswonger It is with pleasure that I announce the release of Koha 3.2.11. The package can be retrieved from: http://download.koha-community.org/koha-3.02.11.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.02.11.tar.gz.MD5 http://download.koha-community.org/koha-3.02.11.tar.gz.MD5.asc http://download.koha-community.org/koha-3.02.11.tar.gz.sig Release notes for 3.2.11 are at http://koha-community.org/koha-3-2-11. Koha 3.4.8 Status by Chris Nighswonger Koha 3.4.8 will be released on 14 January 2012. The 3.4.x branch will enter a string freeze on 8 Jan 2012 00:00 UTC. Koha Community New Koha Libraries Centro de Investigación y Educación Popular – Programa por la Paz (via Organizadatos) Colegio San Bartolomé La Merced (via Organizadatos) Corporación Universitaria CENDA (via Organizadatos) Instituto Amazónico de Investigaciones Científicas, SINCHI (via Organizadatos) Red de Museodata para Bibliotecas de Museos (via Organizadatos) Community Gossip Equinox Software has bought a new office building and is moving into it. Kyle Hall has updated his Koha virtual appliances to 3.6, a complete rebuild using Debian 6.0 (Squeeze) instead of Lenny. For more info, see http://millruntech.com/koha/koha-virtual-appliances. Owen Leonard is working on replacing the YUI Library in Koha with jQueryUI. For more info, see his blog post at http://www.myacpl.org/koha/?p=701. Stefano Bargioni has made available MARCgrep.pl, a Perl script to filter or count MARC records based on the contents of tag names, indicators, or subfields. For more info, see http://en.pusc.it/bib/MARCgrep. Koha in Fiji by Smita Biswas I was seconded along with the Manager of Tauranga City Library, Jill Best, to implement Koha in the first public library in Fiji. The Nadi Town Council Library went live on Dec 6 2011 on version 3.6. We did it as a pilot project, which took about 4 months for me to learn and install on a local machine and then assist the Nadi Council IT officer to download a stable release. I then visited Nadi for a week along with Jill for implementation and training. We did a simple LAN set up between the Server and two staff machines, one being used for circulation and other for cataloguing and acquistion. Hopefully they will able to host their database on the web in the future. There is considerable interest among other Fiji public libraries, due to the enthusiastic campaign by Jill, who has been a long-time volunteer and donor of books to the Fiji Libraries. Since I had never worked with Koha or Linux I was finding it quite hard in the beginning just following the downloading instructions from the wiki. I am very grateful for the help provided by Steven and Richard from Technology Wise Ltd, Tauranga, NZ. They were amazing, they took me under their wing and assisted me with the first install. Thereafter I could do a second install under Richard’s guidance. Richard was also very good in assisting the Nadi Council IT officer to do the install, including working on his server remotely when the Council IT officer found it hard going due to lack of experience and knowledge of Linux. I also need to thank Paul Nielsen, Library Manager of Hauraki District Council Library, NZ, for helping me with the system settings. What a great user group we have here!! I am definitely a Koha convert now, seeing how easy it is to install and implement–this coming from a Librarian (with some systems backgroaund). I hope to convince our Council IT to consider Koha in future. I am also happy to talk to any other groups or libraries about my experience of doing this project. Jill is already lining me up for next year for Suva libraries and maybe Solomon Islands. I am just taking a breather at the moment. It was very very hot… Smita Biswas, ALIANZA, RLIANZA Collections & Information Manager Tauranga City Library Tauranga City Council Ph 07 5777260 M 0275999241 E smita.biswas(a)tauranga.govt.nz www.tauranga.govt.nz Past Koha Events December General IRC Meeting The December general IRC meeting was held on 7 December 2011. For more info, including the agenda and links to the minutes, see http://wiki.koha-community.org/wiki/General_IRC_Meeting,_7_December_2011. Global Bug Squashing Day 2011-12-07 by Magnus Enger A Global Bug Sqashing Day was held on 7 December 2011, and there was much rejoicing. For the numbers, see http://wiki.koha-community.org/wiki/2011-12-07_Global_bug_squashing_day. Upcoming Koha Events January General IRC Meeting The January general IRC meeting will be held on 4 January 2012. For more info, 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 Days are days designated to a concerted effort to get bugs and patches moving along in the right direction. The next GBSD will be 6 January 2012. For more info, see http://wiki.koha-community.org/wiki/2012-01-06_Global_bug_squashing_day. Marseilles Hackfest by Paul Poulain BibLibre will be hosting a hackfest in Marseilles, France, from Monday to Friday, 19-23 March 2012. For more info, see http://drupal.biblibre.com/en/blog/entry/2012-hackfest-in-europe.

1 0

Re: [Koha-devel] FIXME in biblio.pm
by Paul 30 Dec '11

30 Dec '11

At 10:16 PM 12/16/2011 -0500, Chris Nighswonger wrote: >On Fri, Dec 16, 2011 at 10:12 PM, Chris Nighswonger ><<mailto:cnighswonger@foundations.edu>cnighswonger(a)foundations.edu> wrote: >On Fri, Dec 16, 2011 at 7:09 PM, Paul ><<mailto:paul.a@aandc.org>paul.a(a)aandc.org> wrote: >Lines 3006-3008 of <http://biblio.pm>biblio.pm called from ><http://additem.pl>additem.pl: >Â Â Â Â # get title of the record (to store the 10 first letters with >the index) >Â Â Â Â my ( $titletag, $titlesubfield ) = GetMarcFromKohaField( >'biblio.title', '' ); Â Â # FIXME: should be >GetFrameworkCode($biblionumber) ?? >Â Â Â Â $title = lc( $record->subfield( $titletag, $titlesubfield ) ); > >Before I start looking elsewhere, can someone kindly help me with the use >of FIXME comments? [snip] >Based on the commit message it looks like Joe was thinking that the second >argument passed to GetMarcFromKohaField might should be populated with the >results of GetFrameworkCode($biblionumber). In any case, it is still more >likely to be corrupted data than the empty framework parameter passed to >GetMarcFromKohaField that is causing your error. Just back from a few days holidays, I cannot find "corrupted data" (this was an sql dump of our 3.2 data file), EXCEPT that we appear to have completely lost "authorities." Could this be the "empty framework parameter" you mention? While I was away, our most experienced cataloguer entered 25 [biblios + items] at my request for debugging purposes. The biblios went fine, the items all produced the biblio.pm line 3009 error, but both OPAC and staff search find the items perfectly. However our "authorities" (personal names) which has some 15,000 entries is unsearchable (only the latest 25 appear.) Perhaps I'm way off-track, but this may have something to do with re-indexing zebra. I thought I had set up a cron job at 1 min intervals (as on the old server) but using both users (root and Koha) $ crontab -l gives nothing - so I am trying to set it up again, but find at <http://wiki.koha-community.org/wiki/Koha_on_Ubuntu> that "Do Either Option#1 [OPTION 1 is Highly RECOMMENDED for Koha version 3.06.02] or Option #2 DO NOT DO BOTH. Option #1: Use the Zebra Queue Daemon to manage indexing." I had always understood that the "daemon" was deprecated in favour of a cron job (has this changed for 3.6?) and am now afraid that the "daemon" may have been working in the background damaging {something} as our searches (staff and OPAC) find titles, authors etc -- just not "authorities." Fearing I'm getting into a potential mess here, could anyone please come up with suggestions? Thanks in advance and happy new year, Paul

1 0

RM monthly newsletter
by Paul Poulain 29 Dec '11

29 Dec '11

Hello, I'll try to release every month a newsletter that will summarize what has been done during the previous month. i've started my job one month ago, so, here is my 1st newsletter == Starting my job == We had a few trouble to setup the permissions on git repository. Thanks to chris & brendan work, I could start pushing during the KohaCon11. I have written on the wiki how I push patches on git.koha-community.org (http://wiki.koha-community.org/wiki/How_the_RM_push) There are a few patches i've pushed directly (and only) on master branch. That's only documentation of typo fixes. == Roadmap == I've written a roadmap on the wiki (see http://wiki.koha-community.org/wiki/Roadmap_to_3.8) There are 2 differents parts on this roadmap: technical improvements and functionnal improvements. Some of those improvements already have a bugzilla entry, and some of them even have a patch. For technical improvements, i've made an omnibus entry: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7119 For functionnal improvements promized by BibLibre, there is an omnibus entry as well: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7163 I highlight 2 points on the roadmap that have seen some progress this month: === Updatedatabase news === There has been a lot of discussions about database update, and how to de-linearize the DB update process. The bug is the number 7167, and some code will be submitted very soon === YUI/Jquery stuff === We plan to remove YUI in favor of jquery. Owen has started a lot of work on this, you can look at bug 5481, that provide a link to his gitorious repository. We also have to replace the old calendar picker by a more recent one, owen's work does that as well Last comment on jquery: Julian has submitted some code in bug 6836. Jared & Owen are working on this patch, and I hope it will be signed-off & pushed quickly. One it's OK, the hardest part will have to be made= work on each page with a table to replace tablesorter by datatables ! == Important patch pushed == This paragraph highlight some patches that are not related to features, but to the code itself === mySQL error trapping === (Bug 7184) If you set DEBUG=1 in your Apache virtual host, any MySQL error will result in a die with the exact error. This will prevent Koha being silent in case of a wrong SQL query and help a lot fixing any problem === docbook documentation === (Bug 4877) Many documentation has been added to manage koha-* tools. Thanks to Magnus == Perl::Critic compliance == (Bug 6697) Many scripts have been updated to be Perl::Critic compliant. Thanks to chris for the effort, hoping other will join. It's quite "easy" to identify what must be done: just run "perlcritic scriptname.pl" to test if scriptname.pl is compliant or no. If it is not, you'll have errors detailled. For example: perlcritic tools/export.pl says: tools/export.pl: I/O layer ":utf8" used at line 59, column 5. Use ":encoding(UTF-8)" to get strict validation. (Severity: 5) == Hilighted patches needing signoff == All patches are worth being signed-off, but i'd like to hilight some of them: - Bug 6836, to replace tablesorter by datatable - Bug 7127, to have templates be valid XHTML - Bug 7240, to clean up the database from out-of-date datas (old imported_records for example) - Bug 6990, to improve performances of MARC to Koha decoding. This sub is called in many places, so the improvement will be a big boost ! - Bug 6875, to improve performances, by de-nesting nested C4::Packages. Some of the proposed bugs have already been pushed, but many are still to be signed-off. If everything was signed-off, that would mean -24% in the number of perl statements executed on mainpage.pl and -16% for opac-details ! - Bug 6716, to improve the database documentation. This will be usefull for schema.koha-community.org and all users wanting to build SQL queries == Bugzilla == When I push a patch, I usually check the following things: - is the patch "assigned" ? Sometimes, it's still "NEW". In this case, I set the patch to "ASSIGNED", and, if needed update the assignee to reflect the author of the patch pushed - if the patch is an ENH, set version to rel_3_8. Otherwise, set version to rel_3_6. It help chris_n knowing which patch must be pushed on 3.6.x, and will also help knowing what is in rel_3_8 == Jenkins == At the moment, jenkins says that master is unstable. It means some test have failed. If someone want to volunteer to investigate why and fix the problem, he will be warmly welcomed ! It can be because a patch has been pushed with a problem, or because the test is wrong. In this case, just fix the test in t/ directory, and, once it's pushed by me, jenkins will automatically run the updated test. See you next month for the 2nd RM newsletter ! PS: is this newsletter worth being published on koha-community.org website ? somewhere else (send me your ideas !) -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

3 3

mailman mailing lists hosting
by Paul Poulain 27 Dec '11

27 Dec '11

Hello & merry christmas, our contract with the provider that hosts the mailing lists (and also mails, DNS, and some other important things) will end on february 18th. We won't renew it for various reasons. So there are two options: * we move the mailing lists to a new server (a virtual one). * someone else want to host those mailing lists. To speak frankly, we (BibLibre) don't manage mailman for anything outside from koha mailing lists. So we are not experts in mailman, so if someone want to do it, we will be happy to switch. If no-one want to take the ball, we will continue on a new server, don't worry. So, the question: is there any volunteer ? -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

4 8