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

Problem upgrading to Koha 2.0.0RC3
by Edward M. Corrado 04 Feb '04

04 Feb '04

Hello all, I decide to upgrade my testing Koha install to 2.0.0RC3 tonight but I am having a problem. I am currently on 2.0.0RC1. When I try to tun the koha-upgrade script I get the following error: [root@localhost koha-2.0.0RC3]# ./koha.upgrade Not enough arguments for Install::getkohaversion at ./koha.upgrade line 17, near "() " Execution of ./koha.upgrade aborted due to compilation errors. Does anyone have an idea what might be wrong? I am running Mandrake 9.2 and Perl 5.8.1. Ed C.

3 2

Koha2.0.0RC3 released
by paul POULAIN 28 Jan '04

28 Jan '04

As stated yesterday, I've released a 2.0.0RC3 version of Koha. This version is mostly interesting for french users. Other may wait until 2.0.0RC4 (or 2.0.0 final ?) BUGS FIXED since 2.0.0RC2 : * LOT of bugs in french translation * fixed bug in z3950 client daemon that makes "mySQL connection lost during query". * 605 : circulation.pl only shows one waiting item * 293 : Error Issuing Book - 1 IMPROVEMENTS since 2.0.0RC2 : NONE -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

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