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

Re: [Koha] Database Schema
by Pat Eyler 10 May '03

10 May '03

On Sat, 10 May 2003, Timothy R. Butler wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi, Hi Tim, > I was just wondering, if I want to take a bunch of entries and insert them > into MySQL, is there a certain way this should be done? What tables should > the items go into? I thought perhaps someone could point me to a document > explaining the schema or something so that I can insure I can get the data in > efficiently. > Assuming you don't need to worry about the MARC stuf, there is a good diagram at http://irref.mine.nu/user/dchud/koha-schema/biblio-with-datatypes.jpg If you need the MARC stuff, you'll probably want to talk to Paul. Also, if your working wih Koha at this level, you might want to join the devel-list (on the CC: line). thanks, -pate > Thanks, > Tim > > - -- > - --------------------------------------------------------------- > Timothy R. Butler Universal Networks www.uninet.info > ==================== <tbutler(a)uninet.info> ==================== > | Christian Portal: | Have you not learned great lessons | > | www.faithtree.com | from those who braced themselves | > | GNU/Linux News: | against you and disputed the | > | www.ofb.biz | passage with you? --Walt Whitman | > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.1 (GNU/Linux) > > iD8DBQE+vVUTK37Cns9gJ0gRAsCpAJ9teNtIVLgjE2ZfxS6VY5MWQOnfMACeOVAJ > 0rPSihDDzPrQuEZELSqm/GY= > =4lyb > -----END PGP SIGNATURE----- > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >

1 0

Error when returning reserved item
by Owen Leonard 09 May '03

09 May '03

I get an error when I try to return an item which has a reserve on it. The entry in koha-error_log is this: Unknown error code ResFound at /usr/local/koha/intranet/cgi-bin/circ/returns.pl line 254. My Perl knowledge is lacking, so I can't puzzle it out from returns.pl. What does ResFound signify? -- Owen Nelsonville Public Library Koha 1.9.2

2 1

Software Testing and Internationalization - Free book by LISA/Lemoine Intl (fwd)
by Pat Eyler 09 May '03

09 May '03

This might be a resource people want to look into. Pat Eyler Kaitiaki/manager migrant Linux sys admin the Koha project ruby, shell, and perl geek http://www.koha.org http://pate.eylerfamily.org ---------- Forwarded message ---------- Date: Wed, 07 May 2003 17:10:04 -0000 From: alexlam01 <alex(a)lisa.org> Reply-To: pragprog(a)yahoogroups.com To: pragprog(a)yahoogroups.com Subject: [pragprog] Software Testing and Internationalization - Free book by LISA/Lemoine Intl Dear colleague, LISA, in collaboration with Lemoine International has made "Software Testing and Internationalization" by Galileo Computing freely available for download. This 330 page book will transform how you view testing methodologies and procedures. It introduces the reader to essential concepts and approaches used by practitioners in the software testing arena, while also taking into account the realities of low budgets and real schedule deadlines. It is in this context that the specific needs of small, agile project teams are covered in detail. Topics covered: * New approaches to quality * Risk analysis and evaluation * Risk-based testing * Exploratory testing * Testing and tuning * Testing by using * Use cases, requirements, and test cases * Debugging * Myths and realities of Automated Testing * Windows scripting * Test frameworks * Testing-based application development * Tools for developers and testers * Agile test management * International planning and architecture * International development issues * Internationalization testing To download a copy, please visit http://www.lisa.org/interact/2003/swtestregister.html Founded in 1990 as a non-profit association, LISA is the premier organization for the GILT (Globalization, Internationalization, Localization, and Translation) business communities. Over 400 leading IT manufacturers and solutions providers, along with industry professionals and an increasing number of vertical market corporations with an international business focus, have helped establish LISA best practice guidelines and language-technology standards for enterprise globalization. ------------------------ Yahoo! Groups Sponsor ---------------------~--> Rent DVDs Online - Over 14,500 titles. No Late Fees & Free Shipping. Try Netflix for FREE! http://us.click.yahoo.com/YoVfrB/XP.FAA/uetFAA/nhFolB/TM ---------------------------------------------------------------------~-> To unsubscribe from this group, send an email to: pragprog-unsubscribe(a)yahoogroups.com Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

2 1

Some doubts
by Emiliano Marmonti 09 May '03

09 May '03

Hello all I'm part of a workgroup that are evaluating (and starting Spanish translation) for Argentinian Universities of Koha 1.92 and have some problems, perhaps somebody could clarify me what I´m doing wrong, or if correspond that this observations are bugs that are already reported. 1. Aquisitions Module. I have set into System Preferences Aquisitions to normal and don't see any changes, I mean that in older versions of Koha from this place I could access to biblio or biblio items under Catalogue Maintainance. I suppose this is replaced by MARC option isn't it? In a lot of places of the software are references that indicates to go to Acquisition... 2. I have set MARC OFF and don't see any changes. From MARC/Biblio I could access to MARC records only, I could access to biblio record from the OPAC but could not add for example an item. From MARC option I could access to MARC (that don't works) and items but could not add an item (see below). 3. MARC Module. If I try to edit a record only could access to groups 0XX, 1XX y 2XX the rest are blank and the data is not filled in fields and no Javascript/Perl or Apache error is reported... I'm using MARC::Record 0.93. If I try to add Items from this screen the system looks like adding items but are not related to the biblio record. I could see that MARC structure is complete, I mean that are all the fields for MARC21 (2XX,3XX,4XX, etc) from System Preferences. 4. Aquisitions. I could not add a supplier, simply adding it does nothing. I have to touch something like deleting an input field in orders.tmpl for accessing. Only could access biblio from here. Idem for an order. 5. Somebody could explain me the use of ethnicity (sorry I'm trying to translate to spanish and don't understand the meaning and use) and the utility of the option Virtual Shelves? 6. I've seen that anybody could place a request, that is anybody that isn't identified for example. In the other hand I've seen that when I try to make an issue of a book that has request, Koha makes an advice indicating that this book has requests, and prompts if I wish to delete the request. But the process enters in a loop, I mean after all the answers continues with the first question of the set... Well, that's all. I'm trying to test if all this things are happening in this Koha version or could have something in my deploy that is not working OK. Thanks a lot Emiliano Marmonti ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/

3 2

Bugs Resolved in the last 3 days
by chris＠wilbur.katipo.co.nz 08 May '03

08 May '03

25 bugs found. ID Sev Pri Plt Owner State Result Summary 169 nor P2 PC mwhansen(a)hmc.edu RESO FIXE dateformat not used anywhere http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=169 193 nor P2 All paul.poulain(a)free.fr RESO FIXE Multiple search criteria in OPAC gives misleading feedback http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=193 197 nor P2 All a.c.li(a)ieee.org RESO FIXE cannot search for author with a space http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=197 204 nor P2 PC chris(a)katipo.co.nz RESO FIXE Can't add organization member http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=204 218 nor P2 PC paul.poulain(a)free.fr RESO FIXE Home/street address not showing or showing postal address in http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=218 359 nor P2 PC paul.poulain(a)free.fr RESO FIXE Biblio ID drill down gives 500 Internal Server Error http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=359 401 nor P2 PC paul.poulain(a)free.fr RESO FIXE Aquisitions - Incorrect instructions http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=401 405 enh P2 PC paul.poulain(a)free.fr RESO FIXE Guarantees do show name but just library card number http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=405 408 nor P2 PC paul.poulain(a)free.fr RESO DUPL Shopping basket - nowhere to enter Authorised by http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=408 411 min P2 PC paul.poulain(a)free.fr RESO FIXE Supplier ID referenced on Search page but shown no where http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=411 413 min P2 PC paul.poulain(a)free.fr RESO FIXE Aquistion - Budget & bookfund money should line up on decima http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=413 420 min P2 PC paul.poulain(a)free.fr RESO FIXE Modify category doesn't output category code http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=420 422 nor P2 PC paul.poulain(a)free.fr RESO WORK Search.pl isn't in the right place http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=422 425 nor P2 PC paul.poulain(a)free.fr RESO WORK Add new website feature doesn't work http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=425 438 nor P2 All paul.poulain(a)free.fr RESO FIXE Returning item with reserve results in error http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=438 442 tri P2 PC paul.poulain(a)free.fr RESO FIXE Confirm delete bookfund </table> missing http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=442 445 nor P2 PC paul.poulain(a)free.fr RESO FIXE Can't make reserves cause owe money but nowhere to enter tha http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=445 446 min P2 PC paul.poulain(a)free.fr RESO FIXE Logged into OPAC but it says Log In to Koha http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=446 447 tri P2 PC paul.poulain(a)free.fr RESO FIXE Bookcount page has a holder gif that needs to be commented o http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=447 448 tri P2 PC paul.poulain(a)free.fr RESO FIXE Bookcount - the word since used 2x - since since http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=448 449 nor P2 PC paul.poulain(a)free.fr RESO LATE acqui.simple/additem-nomarc.pl? Gives blank white page http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=449 451 nor P2 PC paul.poulain(a)free.fr RESO FIXE Patron information not passed to pay.pl?bornum= from returns http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=451 453 nor P2 PC paul.poulain(a)free.fr RESO FIXE Need parameter to set amount owed before can't borrow more. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=453 454 tri P2 PC paul.poulain(a)free.fr RESO FIXE request.pl - need to delete ")" http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=454 455 min P2 All paul.poulain(a)free.fr RESO FIXE Unused userpage.pl and userpage.tmpl should be removed http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=455 25 bugs found. Long Format Query Page Enter New Bug Change columns Edit this query

1 0

Koha and MARC::Record 1.25
by paul POULAIN 08 May '03

08 May '03

Hi ed, I've just dl and install the last version of MARC::Record. In my error log, i get dozens of : Use of uninitialized value in hash element at /usr/lib/perl5/site_perl/5.8.0/MARC/Record.pm line 206, <fh00001env174.1.txt> line 1. I hadn't such lines before. Do you have an explanation ? This happends (at least) in the following code. The MARC data comes from an external source (various sources doesn't change anything) : In Breeding.pm : my $marcrecord = MARC::File::USMARC::decode($marcarray[$i]."\x1D"); ... my $oldbiblio = MARCmarc2koha($dbh,$marcrecord); ... MARCmarc2koha calls MARCmarc2kohaOneField for each field : sub MARCmarc2kohaOneField { my ($sth,$kohatable,$kohafield,$record,$result)= @_; my $res=""; my $tagfield; my $subfield; $sth->execute($kohatable.".".$kohafield); ($tagfield,$subfield) = $sth->fetchrow; foreach my $field ($record->field($tagfield)) { if ($field->subfield($subfield)) { if ($result->{$kohafield}) { $result->{$kohafield} .= " | ".$field->subfield($subfield); } else { $result->{$kohafield}=$field->subfield($subfield); } } } return $result; } NOTE : I haven't found marc::record mailing lists ? -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

Ingrid's departure
by Pat Eyler 08 May '03

08 May '03

It's always sad to see someone leave a community like the one I believe that we've been building here. I hope that Ingrid and the Cherry Hill Company find success on their new road.

1 0

(no subject)
by Ingrid Lacis 08 May '03

08 May '03

As the company that I work for has made the decision to pursue another avenue in regards to open source integrated library systems, I will resign from my position as Koha's QA Manager effective immediately. I've enjoyed working with you all and wish you and Koha the best. Warm regards, Ingrid Ingrid Lacis The Cherry Hill Company www.chillco.com 11664 National Blvd. #143 Los Angeles, CA 90064 (310) 397-2999 ilacis.@.chillco.com _________________________________________________________________ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail

1 0

Re: [Koha] Some doubts
by baljkas＠mb.sympatico.ca 07 May '03

07 May '03

Wednesday, May 7, 2003 22:53 CDT !Ola Emiliano¡ I can't answer most of the questions that you asked, but I am sure someone knowledgeable will draft a useful response soon. I think the word you are translating as "ethnicity" may be for "language". The idea of Virtual Shelves options, with Koha and other pricey library systems, is to give a patron the sense of what he or she would see on the same shelf (same general area) of the collection as the specific title sought. Hope that helps a bit. Steven F. Baljkas Koha neophyte eagerly awaiting full-MARC21 Winnipeg, MB

2 1

The ILS, the Library Catalog, and Information Gathering
by Joshua Ferraro 07 May '03

07 May '03

Hi All: Pat suggested that I post this link: http://www.libraryopensourcesolutions.com/ilsbiblio.html It's to an annotated bibliography that I prepared a while back on the topic, "The Integrated Library System, the Library Catalog and Information Gathering." Right now it includes only a few summaries and links: Roy Tenant's relevant articles, a Koha2010 thread, and a few search services that demonstrate several different approaches to information gathering. Obviously there's a lot of room for expansion. If anyone has any further content--descriptions, links, or other resources--email me and I will gladly add it. Joshua

1 0