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

IRC Meeting Reminder: 7 November 2:00 UTC
by Owen Leonard 06 Nov '12

06 Nov '12

The next general IRC meeting is coming up in a few hours: 7 November 2012 2:00 UTC http://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+IRC+General+M… The agenda is here: http://wiki.koha-community.org/wiki/General_IRC_meeting,_7_November_2012 I hope to see you there, Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

2 1

Searching for garbage characters
by Cab Vinton 06 Nov '12

06 Nov '12

We've managed to import a number of MARC records with corrupted diacritics and my attempts to retrieve these with a report haven't met w/ success. (Sample records in this list: http://catalog.splnh.com/cgi-bin/koha/opac-shelves.pl?viewshelf=8.) My thought is to search for 100, 700, etc. tags containing any characters outside of the ASCII 32 through 126 range, but my regex skills aren't up to the task. To wit: SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblionumber,'\">',biblionumber,'</a>') AS bibnumber, pname FROM (SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="100"]/subfield[@code>="a"]') AS pname FROM biblioitems) AS authors WHERE pname REGEXP '[\W]' These attempts also didn't seem to be getting me any closer: WHERE pname REGEXP '[^a-z]' WHERE pname LIKE '%[^a-zA-Z0-9]%' WHERE PATINDEX('%[^a-zA-Z0-9]%',pname) > 1 Any thoughts on how to write this report? Have tried the folks over on the MarcEdit list, but no solution as yet. Many thanks, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH Life is short. Read fast!

2 1

Re: [Koha-devel] Searching for garbage characters
by Paul 06 Nov '12

06 Nov '12

At 09:32 AM 11/6/2012 -0500, Cab Vinton wrote: >We've managed to import a number of MARC records with corrupted >diacritics and my attempts to retrieve these with a report haven't met >w/ success. (Sample records in this list: >http://catalog.splnh.com/cgi-bin/koha/opac-shelves.pl?viewshelf=8.) > >My thought is to search for 100, 700, etc. tags containing any >characters outside of the ASCII 32 through 126 range, but my regex >skills aren't up to the task. To wit: Try a last line such as WHERE NOT HEX(pname) REGEXP '^([0-7][0-9A-F])*$' or WHERE pname REGEXP '[^ -~]' But I'm afraid that this may find more (all|most accented chars) than what you're looking for (the black diamonds) - see for example a z39.50 search for L'évolution de l'aéronautique by Jauneaud at LoC. My understanding (and I definitely stand to be corrected) is that some cataloguers used (maybe still do?) two characters (in themselves both valid in UTF-8) as an [accent][letter] combination. I have asked our people, and they tell me that when they import, they edit these out (although I can still find a couple that sneaked into our db, but they do not appear to affect search capability.) Best - Paul >SELECT CONCAT('<a >href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblionumber,'\">',biblionumber,'</a>') >AS bibnumber, pname >FROM >(SELECT biblionumber, >ExtractValue(marcxml,'//datafield[@tag="100"]/subfield[@code>="a"]') >AS pname FROM biblioitems) >AS authors >WHERE pname REGEXP '[\W]' > >These attempts also didn't seem to be getting me any closer: > >WHERE pname REGEXP '[^a-z]' > >WHERE pname LIKE '%[^a-zA-Z0-9]%' > >WHERE PATINDEX('%[^a-zA-Z0-9]%',pname) > 1 > >Any thoughts on how to write this report? Have tried the folks over on >the MarcEdit list, but no solution as yet. > >Many thanks, > >Cab Vinton, Director >Sanbornton Public Library >Sanbornton, NH > >Life is short. Read fast! >_______________________________________________ >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://NavalMarineArchive.com> and <http://UltraMarine.ca>

2 1

QA: Passed-QA-by line in commit?
by Marcel de Rooy 05 Nov '12

05 Nov '12

Hi QA team, I see lines with Passed-QA-by: in some newer commits. Do we need them, should we add them? I think if we should, all qa team members should conform. Marcel

3 2

"Refine your search" option problem
by Mohamed zalabany 05 Nov '12

05 Nov '12

Hi all i have noticed in OPAC the "Refine your search" option when i search with Arabic word or Arabic data the words in "Refine your search" is not complete and appear in the end of the word "?" الطويل، تو�... الحضارة ال�... is there any way to permit viewing longer words in this part and i need to remove this symbol � Mohamed El ZalabanyIntegrated library systems consultant Zalabany Knowledge Systems Team© For Libraries and Information systems Development and support mh_zalabany(a)hotmail.com Mobile: 0111291444

2 1

Zebra and deleted biblios
by Paul 05 Nov '12

05 Nov '12

A couple of weeks ago I mentioned that in 3.8.5, deleting a biblio, after deleting any items attached, requires a complete re-index by Zebra, the cron -z fails. Logging the cron as verbose, I get: Records exported: 0 ==================== REINDEXING zebra ==================== ==================== CLEANING ==================== 17:48:02-04/11 zebraidx(7610) [warn] cannot delete record above (seems new) The error is reproducible: e.g. two biblios, one with a typo important enough that Koha doesn't ask "Duplicate?" during the cataloguing, both with a single item; "attach" the barcode of one to the other and delete the "empty" biblio. After cron -z, the unwanted biblio appears (with no item) in both staff and OPAC until a complete re-index is done. Could someone else please verify, and I'll file a bug if confirmed. For the record, I've tried (sandbox only) the cron with and without -x; the behaviour is identical (sandbox and production.) Best regards, Paul

3 2

Fwd: QA: Passed-QA-by line in commit?
by Chris Cormack 05 Nov '12

05 Nov '12

---------- Forwarded message ---------- From: Chris Cormack <chris(a)bigballofwax.co.nz> Date: 5 November 2012 23:02 Subject: Re: [Koha-devel] QA: Passed-QA-by line in commit? To: Marcel de Rooy <M.de.Rooy(a)rijksmuseum.nl> On 5 November 2012 22:59, Marcel de Rooy <M.de.Rooy(a)rijksmuseum.nl> wrote: > > Hi QA team, > > > > I see lines with Passed-QA-by: in some newer commits. > > Do we need them, should we add them? > > I think if we should, all qa team members should conform. > > > > Those were added where members of the QA team had marked the bug passed qa, but hadn't signed off the patch. It would be better if people signed off on the patches. Chris > > Marcel > > > > > > > _______________________________________________ > 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/

1 0

Some thoughts from QA team
by Paul Poulain 05 Nov '12

05 Nov '12

Hi koha-devel, The 3.10 and 3.12 QA teams ( Mason, Jonathan, Marcel & me, with the freshly elected Travis, Katrin -and Jared as RM-) have had a discussion about QA process and would like to propose the 2 following things: * Create a QA specific mailing list (qa(a)lists.koha-community.org ?) This list would be used for QA related discussions. We had some private discussions in the last months (mostly about koha-qa.pl tool = should we add this, remove that,...), and think it's better to have a public mailing list. [ One thing that worried us is "should we let anyone subscribe to the list or moderate list subscriptions to avoid non-QA threads". Not a big deal, but if you've an opinion... ] * Change the priority flag use on bugzilla. Currently, this flag is not really used by anyone. We would like to change it's content to the following values, to reflect the complexity of a patch: 1- trivial patch template/doc only 2- trivial patch - minor Perl code 3- low risk of side-effect 4- medium risk of side effect, but don't underestimate it 5- High risk of side effect, be very careful ! We would also add a wiki page explaining how to choose the value. The value can be set by anyone (patch submitter, sign-offer, QA team, RM), and will just be a helper when someone want to pick up a patch for testing or QAing. Comments welcomed. -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

16 21

RSS and SMS overdues cronjob
by Jared Camins-Esakov 05 Nov '12

05 Nov '12

Hello. As they currently stand, the cron jobs at misc/cronjobs/smsoverdues.pl and misc/cronjobs/rss/rss.pl will not work on an out-of-the-box Koha installation, as they require an obsolete templating system. I am wondering if anyone still uses these cron jobs, or whether they are obsolete legacy scripts that should just be removed at this point. So, are you using either of these scripts? Do you know anyone else who does? Regards, Jared -- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcamins(a)cpbibliography.com (web) http://www.cpbibliography.com/

4 4

docbook-xml triggers scary update-catalog message(s) under Ubuntu 12.10
by Mark Tompsett 05 Nov '12

05 Nov '12

Greetings, I know the instructions say use LTS for Ubuntu, so this shouldn’t be an immediate problem, but it seems like Ubuntu 12.10 may have a problem. Updating the super catalog... Setting up docbook-xml (4.5-7ubuntu1) ... update-catalog: Suppressing action on super catalog. Invoking trigger instead. update-catalog: Please rebuild the package being set up with a version of debhelper fixing #477751. Which is like: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=675007 I'll keep going, but I think the docbook-xml for debian and ubuntu differ and ubuntu's is broken. Is there a way to force the previous version to be used? 4.5.7? I think the Ubuntu 12.10 is using 4.5.7-1. Given that I have seen a lot of people do Ubuntu lately in the lists and on IRC, this may need consideration. GPML, Mark Tompsett

3 3