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

outstanding important bugs in 2.0
by Pat Eyler 27 Jan '04

27 Jan '04

I wanted to give everyone a feel for where we're at with bugs and releases (although, Paul is the definitive voice for when a release will actually get made). I've tried to collect all of our critical or major bug reports -- we've already handled all the blockers. If anyone sees wants to claim one of these tickets for their own, please ask the listed owner. Critical bugs first, we need to get these stomped (or agree that they're really not critical after all) before we release 2.0.0 final. We're getting really close, so it would be nice to put together a big push and get a release out the door. 662 cri chris Probable insecure use of prepare() I think MJR is actually doing the bug stomping on this one 196 cri paul user input not checked for HTML tags 701 cri mjr 2.0.0RC1 apache complains "/usr/htdocs" doesn't exist 436 cri chris circulation.pl only partially templated I think that Owen (the bug reporter) has said that we can lower this to a 'normal' severity 702 cri mjr 2.0.0RC2 upgrade problem: Not enough arguments for Install Major bugs next, any of these that we can get closed would be nice. Once 2.0.0 is out the door, we might want to bump some of these to critical for 2.0.1. 539 maj chris 'Child' category code is built into insertjdata.pl 613 maj chris Deleting one of a patron's multiple reserves on a single it 661 maj chris circulation.pl no longer shows flags 700 maj paul. the MARC21 english default parameter setup is working, but s 610 maj chris Renewal limit cannot be set by libraries 617 maj chris OPAC renew function available even if item is on reserve 668 maj chris Cancelling reserve upon check-out does not work 612 maj chris Renewal failure gives no feedback 633 maj paul MARC Upload fails silently 670 maj chris "Waiting" status often inaccurate As always, please feel free to ask me for more information, to correct me, or to give me money ;^). thanks, -pate Pat Eyler Kaitiaki/manager migrant Linux sys admin the Koha project ruby, shell, and perl geek http://www.koha.org http://pate.eylerfamily.org

1 0

2.0.0RC3 tomorrow for french only
by paul POULAIN 27 Jan '04

27 Jan '04

Hi, Tomorrow, i'll release a 2.0.0RC3. It will include only fixes for french translation, as the 2.0.0RC2 had a dirty french version. No upgrade needed for english installations. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

Changing member searching
by Owen Leonard 26 Jan '04

26 Jan '04

Chris and I talked about member searching the other day on IRC, prompted by the fact that member searching in the current release doesn't work like it used to: A search for 'leonard, o' will return no results. You have to leave out the comma for it to work. Other problems exist in both the current version and in older versions: a search for the last name 'van dyke' will return no results, but a search for 'van' will bring up results which include the name 'van dyke.' Chris and I tried some changes to Search.pm which improved results in searches for names with spaces in the last name, but the requirement was that the comma had to be included. So whereas before a search for 'leonard o' would return the record for Owen Leonard, now you'd have to search for 'leonard, o'. At our library that requirement is perfectly acceptable--it's the way we're used to searching anyway. I think we should incorporate these changes into Search.pm, but I wanted to see what everyone else thought. -- Owen ---- Nelsonville Public Library http://www.athenscounty.lib.oh.us

1 0

items table
by Tom Madron 25 Jan '04

25 Jan '04

What is the function of the "itemnumber" field in the "items" table in Koha? Where does it come from? How is it used? In the MARC/Koha cross reference document on http://www.koha.org/wiki (which I realize is woefully out of date) the "itemnumber" field references MARC tag 890, subfield "c", which, as far as I can tell is not used elsewhere in Koha. In fact, neither MARC21 nor UNIMARC define tag 890 at all (see http://www.loc.gov/marc/bibliographic/ and http://www.ifla.org/VI/3/p1996-1/sec-uni.htm for tag definitions under MARC21 and UNIMARC, respectively). I have tried to put together a cross reference spreadsheet based not only on the cross reference document noted above, but also by reference to fields defined in Koha. Any information I can get on this or related questions will be appreciated. Thanks, Tom Madron Tom Madron Enterprise-Wide Computing, Inc. 1023 15th Avenue, South Nashville, TN 37212 Telephone: 1-615-259-2771 URL: http://www.ewcnet.com mailto:tmadron@ewc-inc.com

3 2

Koha from CVS
by Daniel Holth 25 Jan '04

25 Jan '04

Is there a tutorial somewhere on installing Koha from CVS? Thanks, Daniel Holth

3 2

Library of Congress
by Daniel Holth 24 Jan '04

24 Jan '04

Now that Koha 2 rc something is using more MARC and has a nice MARC editor it should be easier to use LC Call numbers. In the past I had wondered, 'how would I order search results by LC Call?' Well, format a sorting field like this in the database, with optional dots: BV.004529.200000.L3600 and it should sort lexicographically more or less like LC Call numbers are intended to sort. Does anyone know if there is a maximum length to each part of the number? Thanks, Daniel Holth

1 0

EAN to ISBN
by Daniel Holth 24 Jan '04

24 Jan '04

I've been frustrated that Koha woudn't accept EAN numbers like this, that I scan with a certain cat-shaped barcode wand: 9780061020674 This is the EAN for a paperback edition of Sourcerer (a novel of Discworld) by Terry Pratchett. It's encoded in a barcode. The ISBN is 0-06-102067-2 - embedded in the EAN, except the EAN has its own checksum. Enter a module I dub ISBNParse.pm - in my tree (newest 2.x .tar.gz downloaded from sourceforge) I put this in koha/intranet/modules/C4/ISBNParse.pm; then files like isbnsearch.pl can be modified: ---- use C4::ISBNParse; if ( !$isbn && !$title ) { print $input->redirect('addbooks.pl'); } else { $isbn = C4::ISBNParse::isbnfu($isbn); $input->param('isbn', $isbn); ---- If Business::ISBN is installed you get EAN-to-ISBN conversion, and this agrees nicely with my barcode scanner. If I had a CueCat that output scrambled data, I would further enhance ISBNParse.pl to unscramble the CueCat data (if /that/ module was available). I hope this can work for somebody! The main trick is figuring out where to insert it; perhaps the isbnfu() calls could find a home in Search.pm. It might make sense to enforce dashes (or their absence) in ISBN numbers? - Daniel Holth -------- ISBNParse.pm: # Convert EAN to ISBN when given EAN; when given ISBN, pass through. # When given unrecognizable text, pass through. package C4::ISBNParse; # This is free software; you can redistribute it and/or modify it under the # terms of the GNU General Public License as published by the Free Software # Foundation; either version 2 of the License, or (at your option) any later # version. # # This is distributed in the hope that it will be useful, but WITHOUT ANY # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR # A PARTICULAR PURPOSE. See the GNU General Public License for more details. # # Copyright 2004 Daniel Holth <dholth(a)fastmail.fm> use strict; require Exporter; use vars qw($VERSION @ISA @EXPORT $HaveISBN); $VERSION = 0.01; @ISA = qw(Exporter); @EXPORT = qw(&isbnfu); BEGIN { eval 'use Business::ISBN qw ( is_valid_checksum isbn_to_ean ean_to_isbn )'; $HaveISBN=1 unless $@; } sub isbnfu { my $input = shift; print STDERR "\n$HaveISBN isbnfu $input\n"; my $isbn; if($HaveISBN) { print $input; $isbn = ean_to_isbn($input); if($isbn) { $isbn = new Business::ISBN($isbn)->as_string; } unless($isbn) { $isbn = new Business::ISBN($_); if($isbn) { $isbn = $isbn->as_string; } } unless($isbn) { $isbn = $input; } } else { $isbn = $input; } return $isbn; }

2 1

(no subject)
by None 22 Jan '04

22 Jan '04

--=====================_23239326==_.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed What is the function of the "itemnumber" field in the "items" table in Koha? Where does it come from? How is it used? In the MARC/Koha cross reference document on http://www.koha.org/wiki (which I realize is woefully out of date) the "itemnumber" field references MARC tag 890, subfield "c", which, as far as I can tell is not used elsewhere in Koha. In fact, neither MARC21 nor UNIMARC define tag 890 at all (see http://www.loc.gov/marc/bibliographic/ and http://www.ifla.org/VI/3/p1996-1/sec-uni.htm for tag definitions under MARC21 and UNIMARC, respectively). I have tried to put together a cross reference spreadsheet based not only on the cross reference document noted above, but also by reference to fields defined in Koha. Any information I can get on this or related questions will be appreciated. Thanks, Tom Madron Tom Madron Enterprise-Wide Computing, Inc. 1023 15th Avenue, South Nashville, TN 37212 Telephone: 1-615-259-2771 URL: http://www.ewcnet.com mailto:tmadron@ewc-inc.com --=====================_23239326==_.ALT Content-Type: text/html; charset="us-ascii" <html> What is the function of the "itemnumber" field in the "items" table in Koha?  Where does it come from?  How is it used? In the MARC/Koha cross reference document on <a href="http://www.koha.org/wiki" eudora="autourl">http://www.koha.org/wiki</a> (which I realize is woefully out of date) the "itemnumber" field references MARC tag 890, subfield "c", which, as far as I can tell is not used elsewhere in Koha.  In fact, neither MARC21 nor UNIMARC define tag 890 at all (see http://www.loc.gov/marc/bibliographic/ and http://www.ifla.org/VI/3/p1996-1/sec-uni.htm for tag definitions under MARC21 and UNIMARC, respectively). I have tried to put together a cross reference spreadsheet based not only on the cross reference document noted above, but also by reference to fields defined in Koha. Any information I can get on this or related questions will be appreciated. Thanks, Tom Madron <x-sigsep></x-sigsep> <div align="center">Tom Madron Enterprise-Wide Computing, Inc. 1023 15th Avenue, South Nashville, TN 37212 Telephone: 1-615-259-2771 URL: <a href="http://www.ewcnet.com/" eudora="autourl">http://www.ewcnet.com</a> <a href="mailto:tmadron@ewc-inc.com" eudora="autourl">mailto:tmadron@ewc-inc.com</a> </div> </html> --=====================_23239326==_.ALT--

1 0

Re: [Koha-devel] Koha 2.0.0RC1 is dead. Long live to koha 2.0.0RC2!!!
by Owen Leonard 21 Jan '04

21 Jan '04

> This one is not yet completely fixed: > > * 662 : poor SQL calls, that could be used for > > SQL injection (security problem) By the way, thanks to MJR for putting in a lot of time on this bug. It's never as fun to this kind of important polishing as it is to add new stuff. > > Are these three the only blockers? > > I see the following as blockers/critical in bugzilla: > 196 cri P1 user input not checked for HTML tags > 436 cri P2 circulation.pl only partially templated > 662 cri P2 Probable insecure use of prepare() > 293 cri P2 Error Issuing Book - 1 436 is a pernicious one, but enough progress has been made that I wouldn't consider it a blocker, even though it still irritates me :) 293 is definitely a problem for circ staff. I don't know about the proper use of blocker/critical/major etc., but I'll toss in these bugs that make day-to-day life hard for our staff: 612 maj P2 Renewal failure gives no feedback 670 maj P2 "Waiting" status often inaccurate 605 maj P2 circulation.pl only shows one waiting item 613 maj P2 Deleting one of a patron's multiple reserves on a single item deletes all 661 maj P2 circulation.pl no longer shows flags 617 maj P2 OPAC renew function available even if item is on reserve 668 maj P2 Cancelling reserve upon check-out does not work -- Owen ---- Nelsonville Public Library http://www.athenscounty.lib.oh.us

1 0

Koha 2.0.0RC1 is dead. Long live to koha 2.0.0RC2 !!!
by paul POULAIN 21 Jan '04

21 Jan '04

koha 2.0.0RC2 has been released : http://sourceforge.net/project/shownotes.php?release_id=211242 This version of Koha is the second in the 2.0 "stable" series. It does not mean that it has no bugs, but many libraries are using it and don't encounter unsolvable problems. If you want to adopt Koha, please do, but you're warned that this release candidate version may still have some bugs and missing features. If you test it and let us know about any we haven't seen yet, it will help us to fix them. The 2.0.x series version is "feature freezed". Only bugs or minor changes will be made in this branch. The koha team is already working on the 2.2.x version. In CVS (HEAD branch), developpers can already get 1st draft of a working z3950 server. BUGS FIXED: * 318 : allow or not a book to be loan * 537 : in borrower screen, the "fine & debts" now shows only amount due if >0, "nothing due" if borrower has no debts. * 557 : spelling error in message for no search criteria entered * 564 : Member card number not checked unique * 586 : additem.tmpl displays incorrect biblio number * 605 : circulation.pl only shows one waiting item (1 small problem remaining, see bugs.koha.org) * 614 : opac-user.pl doesn't show which items are waiting * 625 : dateformat under system prefs is confusing * 646 : Member flag must be either 'parameters' or 'superlibrarian' to log in (now, any flag enable login) * 662 : poor SQL calls, that could be used for SQL injection (security problem) * 671 : Add institutional member confirmation screen has no details * 672 : readingrec can not be reordered * 675 : "logged in" info missing * 683 : Search for barcode or illustrator says ' You did not specify any seach criteria' * minor HTML modifs & tweaks * minor improvements/bugfixes in installer * biblio & item deletion bugs fixed. * bug fixed in MARC editor, that appeared on specific MARC configuration & makes biblio adding impossible. IMPROVEMENTS: * z3950 client daemon improved a lot : many deadlock situations solved, improved problem reporting, ignoring invalid z3950 servers (or server not responding) * new french translation. Note that only english and french are up to date. Other won't work, probably. Note also that a tool for translator is now ready, and should ease a lot translating and maintaining translations. * new OPAC theme. it's called "css". It's a XHTML1.0 strict OPAC. In librarian interface, just change systempref opactheme to css to get it. Will be the default opac in 2.2 * publisher added in acquisition process (the one with basket & supplier) Basket now ordered by publisher. * notforloan field management added in itemtype administration screen * new migration script : misc/rebuildthesaurus.pl => this script can rebuild thesaurus/authority file after importing records with misc/bulkmarcimport.pl DB change : *index added into z3950results table UNIQUE KEY query_server (queryid,server) (added by installer & updater) KNOWN BUGS : * MARC upload fails silently (in breeding farm) if the file provided is not iso2709 (works fine with a valid file) * autobarcode not calculated even if autobarcode system parameter is set and MARC=on. * the MARC21 english default parameter setup is working, but some librarians reports that some choices are poor. If you use MARC21, tweak some setups to fit your needs. (note : the subject refers to what french people said when we had a king, 2 centuries ago : "the king is dead. Long live to the king" (the 1st being the old king, the 2nd being the new one. Not sure everybody around the world uses such a sentence, so I explain :-) ) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

3 2