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

Re: [Koha-devel] Bibliothesaurus table
by Jerome Vizcaino 12 May '03

12 May '03

Hello Paul Nope we didn't upgrade an old Koha version. We installed Koha 1.9.2 on a clean Debian Woody install. However we didn't install the sample information in the database. Maybe this is the problem. By the way the installation of Koha was a real problem and we had to install all the required Perl modules by hand due to a problem with the CPAN module. Building a debian package for Koha would be a good idea. If anyone knows how to do this... Jerome paul POULAIN wrote: > Jerome Vizcaino wrote: > >> Hello >> >> Inspecting the acquisition process we found that the editors popup >> didn't worked. >> The problem comes from the unimarc_210c.pl and thesaurus_popup.pl. >> The SQL instructions >> are looking for a 'father' field in the bibliothesaurus table. >> Unfortunately, this field doesn't exist. >> Can someone tell me what was this field used for and what is its new >> name ? (the hierarchy field maybe ?) > > > The bibliothesaurus table should be : > CREATE TABLE bibliothesaurus ( > id bigint(20) NOT NULL auto_increment, > freelib char(80) NOT NULL default '', > stdlib char(80) NOT NULL default '', > category char(10) NOT NULL default '', > father char(80) default NULL, > level tinyint(4) NOT NULL default '1', > hierarchy char(80) NOT NULL default '', > PRIMARY KEY (id), > KEY freelib (freelib), > KEY hierarchy (hierarchy), > KEY father (father), > KEY stdlib (stdlib), > KEY category (category), > FULLTEXT KEY category_2 (category,freelib) > ) TYPE=MyISAM; > > Why is the father row missing in your install is a good question ? Did > you upgrade from a 1.9.1 DB (we spoke of such an upgrade with Serge > IIRC)? > In updater/updatedatabase, line 109, the father table is here. > So... >

4 3

new developers
by Pat Eyler 12 May '03

12 May '03

In the course of the last week, I've added two new developers (from France) to our Sourceforge site. It looks like I'll be getting to add a couple more (from Argentina) in the near future. I'm really excited to see more groups joining up with Koha, and I can't wait to see the kinds of things that start happening. Let me take this opportunity to talk about four things: 1) If you're interested in working on Koha, please let Chris, Paul, or I know. We can always use people who want to work on coding, testing, writing documentation, or what have you. Even if your Perl skills aren't the greatest, there are plenty of ways you can contribute. 2) If you are registered as a developer, but you haven't been active in the last year or so, please get in touch with me. I promise I won't try to talk you into working on the project, I just want to see if you're still there and still interested. 3) We're hitting the home stretch towards 2.0.0, this means we need to be extra careful about what we do with our sourcecode. If you're a developer and you've got an idea for a cool new feature, please DON'T add it to koha yet. If you've just got to work on it, please do so outside the normal cvs tree -- once 2.0.0 is out, we'll be relaxing this stance. 4) If you want to work on Koha, but don't know where to start, please take a look at bugs.koha.org ... there are a lot of little things that need to be fixed. Please feel free to grab a bug and squash it. thanks, -pate

3 3

Bugzilla summary for last 3 days
by chris＠wilbur.katipo.co.nz 12 May '03

12 May '03

16 bugs found. ID Sev Pri Plt Owner State Result Summary 216 enh P2 PC tonnesen(a)cmsd.bc.ca NEW installer should create an initial librarian user account http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=216 239 nor P4 PC chris(a)katipo.co.nz NEW Issue limit doesn't work - able to check out more items than http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=239 242 nor P2 PC paul.poulain(a)free.fr NEW Current loan output is blank http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=242 377 maj P2 PC tonnesen(a)cmsd.bc.ca NEW Branch Category page does not allow adding or editing catego http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=377 387 nor P2 PC paul.poulain(a)free.fr REOP Request output does not show pick-up location in select list http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=387 417 blo P2 PC tonnesen(a)cmsd.bc.ca REOP installer.pl wants root http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=417 436 nor P2 PC chris(a)katipo.co.nz NEW circulation.pl only partially templated http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=436 437 enh P2 PC chris(a)katipo.co.nz NEW 'Browse Members' function should return paged results http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=437 439 nor P2 All paul.poulain(a)free.fr NEW Member search from circulation.pl will only search by last n http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=439 440 nor P2 PC chris(a)katipo.co.nz NEW JavaScript function openWindow is not defined http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=440 441 nor P2 PC paul.poulain(a)free.fr NEW Z39.50 search link doesn't work http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=441 443 nor P2 PC paul.poulain(a)free.fr NEW Adding a child creates that child in triplicate http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=443 444 maj P2 PC paul.poulain(a)free.fr NEW No where to add types for Manual Credit or Manual Invoice http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=444 450 min P2 PC paul.poulain(a)free.fr NEW Can't add supplier where List Item Price Includes GST http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=450 452 nor P2 PC paul.poulain(a)free.fr NEW Payment due flags not showing up for children http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=452 456 blo P2 PC paul.poulain(a)free.fr NEW Hardwired config file location http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=456 16 bugs found. Long Format Query Page Enter New Bug Change columns Edit this query

3 2

branchcategories => what's done for ?
by paul POULAIN 12 May '03

12 May '03

I spend a few minuts on bug #377 and related. I want to know what the branchcategories table is done for. It seems to be unused : * branchcategories has a row "categorycode". * branchrelation has a branchcode and a categorycode row. It means it's a relation between branches and branchcategories. but... Those infos seems to be used nowhere (a grep "branchrelations" and grep "branchcategories" reports values in installer and admin script only) . So, unless someone (katipo ?) explain what it's supposed to do (and where :-) ), it will be dropped soon... -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

3 4

Another acquisition module ?
by Jerome Vizcaino 12 May '03

12 May '03

Hello I'm working with another student at ESIEE (Michel Lerenard) on an implementation of the Koha 1.9.x system for our school library. Serge Renaux is leading us in this task. It will lead to an install of the Koha 2 system when ready. As our library uses a slightly different way to acquire documents, we have to rearrange the way information are entered by the user. We figured out that one way to do it is to create another template directory and to configure Koha to use this directory. It seems that in our case, template modification is not sufficient so we were thinking of a solution based on another acquisition module. There is already an option in Koha that sets the type of acquisition (normal or simple) but this option doesn't seem to work (we are using Koha 1.9.2). Therefore, our first question is "Is this option not working due to a bug or because of a "non implemented yet" function ?" Our second question is : "Will it be possible to set the option to "esiee" for example so that Koha will use the Perl scripts localised in a "acqui.esiee" directory ?" Thank you in advance. Sincerely Jerome Vizcaino

3 4

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