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

WHERE CAN I FIND THE DATABASE STRUCTURE
by JAVIER RICARDO MEJIA C. 30 Jun '03

30 Jun '03

----- Original Message ----- From: JAVIER RICARDO MEJIA C. To: koha-devel(a)lists.sourceforge.net Sent: Saturday, July 05, 2003 4:01 PM Subject: WHERE CAN I FIND THE DATABASE STRUCTURE Hi, I´m Javier Where i can find the database structure of koha, i saw one time on a web site but i don´t remmember where.... sombebody can help me? thnaks javier

1 0

E-Mail reminder for late issues
by Jerome Vizcaino 27 Jun '03

27 Jun '03

Hi all Just to let you know we finally developped a module to display late issues and generate e-mail for borrowers who have late issues. As there's a feature freeze until 2.0 is out, we can't commit it now. If anyone's interested in testing, please contact me, I'll send you the files with the apropriate information. Jerome

3 2

The hottest day of the summer so far was drawing to a close and a drowsy silence lay over SourceForge...
by paul POULAIN 27 Jun '03

27 Jun '03

... when Koha 2.0.0pre1 was released. RELEASE NOTES ============= This release add many bugfixes, and some improvment in z3950 and repetable fields management. It has been placed in the "unstable tree" because there are still some bugs. But it's fully usable, and should not be modified a lot until a stable version is released. PACKAGE NEEDED : --------- Nothing new. Note MARC::Record has new releases, but older one (1.26) works fine. DB modifications : --------- * added field in aqbudget, primary key : aqbudgetid tinyint(4) NOT NULL auto_increment PRIMARY KEY (aqbudgetid) * added field in systempref : options text * bibliothesaurus field father changed to char(80) (was bigint) added full text index : FULLTEXT KEY category_2 (category,freelib) z3950 : --------- * works on biblio adding & modifying * works on ISBN, author, title, the 1st found being the one used. various : ---------- * added subject and subtitle to MARC subfields mapped to Koha old-DB. * reordered bookfunds/budget admin tools. languages/languages : ------------- DEFAULT template : * english works. * french should work, mostly. If you experiment some problems, test with english templates, and report the problem as general or french specific NEW template : a "unido" template is in this release. It's uncomplete, and based on vanilla template. GUI reordering ------------------ * Some unused links have been dropped. * a "submenu" shows some operation below main menu. * the MARC link disappeared. It's managed by the MARC=ON/OFF systempref. (the breeding import is now in Parameters section) * acquisition and cataloguing are now separated. acquisition=simple/normal in systempref and cataloguing is MARC/nonMARC depending on MARC=ON/OFF systempref. Should be easier to understand. Bugs still open in bugs.koha.org ======================= always some, but less than in 1.9.3 (40 at this time. more than 20 of them are minor : spellcheck, image missing...) Some of them (for more details, see http://bugs.koha.org) : * 426 Reserving a book (with a reserve fee) results in a hostile message * 452 Payment due flags not showing up for children * 185 Barcode not auto-calculated when autobarcode is on * 425 Add new website feature doesn't work * 318 allow or not a book to be loan * 236 Reserve book on future date doesn't work or copy is wrong bugs not reported here are either unconfirmed, not understood, minor, or partially fixed. Feel free to ask for bugfixes and new features in bugs.koha.org. NOTE that NEW FEATURES or IMPROVEMENTS will only be for 2.0.1 unless it's a very trivial or blocking one. TODO ===== * bug fixes (everybody) * cleaning z3950 old searches (more than 1 hour/day old ?) (paul) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

2 5

Installer request: no screen clearing
by Paul Gear 26 Jun '03

26 Jun '03

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 (Somebody tell me if this info should be going to a better place...) The practice of clearing the screen in the installer is not the best idea, IMO. As you can see, i've had a lot of error messages, and these might get missed by the installer clearing the screen. Additionally, i can't scroll back in my terminal to see the full install output. I'd rather see the installer just write to the screen as normal, with some sort of colour (as it does at present) or separator to show that a new task is being started. - -- Paul http://paulgear.webhop.net -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE++Djk0yv0OWRYqWwRAgU3AJ4xwargkRbzfiEpQdXLxAiRQPhsTACfcowy 8/vkdUI9QP6lISsTGhgAaoo= =sSuh -----END PGP SIGNATURE-----

3 2

Re: [Koha] restriction with a member
by Rachel Hamilton-Williams 26 Jun '03

26 Jun '03

Hi > hi , how can add a limit of books for the diferents users, i go to a the > option in system parameters and add a new category for the diferents users for > example Doctor with limit of issues 7, Student with limit of issues 3, and > Teacher with limit of issues 5, then it is that at the time of lending books to > the users it does not put any restriction to me and I can request the books > that are does, not establish any limits in nobody category that it has chosen, > please I need as I can do correct that problem, I hope can solve my doubt > thanks It sounds like you are doing the right thing, so maybe there is a bug in Koha. Are you using Koha version 1.9.3? Cheers Rachel_____________________________________________________________ Rachel Hamilton-Williams Katipo Communications WEBMISTRESS ph 021 389 128 or +64 04 934 1285 mailto:rachel@katipo.co.nz PO Box 12487, Wellington http://www.katipo.co.nz New Zealand Koha Open Source Library System http://www.koha.org

1 0

2.0 release meeting
by Pat Eyler 25 Jun '03

25 Jun '03

During our 2.0 release irc meeting, we identified a mechanism for prioritizing bugs currently listed on bugs.koha.org. We've got six that we're considering 'must fix' issues. There are twenty-nine more that are 'should fix', and four that are 'might fix'. 'Must fix' bugs will be corrected before the 2.0.0 release is made. We will try to fix all 'should fix' bugs, but won't delay the relase unduly to do so. 'Might fix' bugs will be fixed if someone manages to get it done before the 2.0.0 release is made. If you have a bug that has not yet been reported, please report it soon. At some point, we're going to start putting off fixing newly reported bugs until the 2.0.1 release. If you think we've mis-prioritized a bug, please let me know which bug, how critical you think it is, and why. The following bugs have been identified as 'must-fix' bugs for the 2.0.0 release: BugId Vers Summary 253 1.9.2 Thesaurus management doesn't work 293 1.9.1 Error Issuing Book - 1 489 1.9.3 Poor file copying 503 1.9.3 Installer places z3950 scripts in /cgi-bin/z3950 505 CVS moredetail.pl/tmpl problem 510 2.0.0 need new docs integrated These are should fix for 2.0.0: 50 458 65 469 185 471 225 474 236 475 239 478 247 479 272 480 295 484 318 487 322 492 379 500 426 504 436 506 452 These are 'might fix': 98 237 316 490 (to look at a ticket, you can use this url: http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=XXX where XXX is replaced with the bug id listed above.) 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

STUPID MAJOR BUG in 2.0.0.pre1
by paul POULAIN 25 Jun '03

25 Jun '03

Hi, there is a stupid bug in 2.0.0pre1 that broke MARC editor. It's fixed in CVS. If you test with official 2.0.0pre1, PLEASE : * open $intranet/htdocs/default/en/addbiblio.tmpl * search <TMPL_LOOP name="0XX"> This 0XX is repeated 10 times. Replace them by 0XX to 9XX. For example : <DIV name="3XX" id="3XX" style="position:absolute;visibility:hidden;width:90%"> <table width=100% cellspacing=0 cellpadding=2 border=0> <TMPL_LOOP name="3XX"> <<== HERE CHANGE 0XX to 3XX <TMPL_IF name="tag"> <tr background="<TMPL_VAR name="themelang"> ... Thanks, and sorry for this stupid bug, due to an unchecked copy/paste... (exists in french templates too Fixed in CVS too) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

ANNOUNCE: Koha perl dependency RPMs for Red Hat 9
by Paul Gear 25 Jun '03

25 Jun '03

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi folks, Apologies for the cross-posting, but i'm not sure where is the best place to send this info: I've created a number of RPMs that provide the perl dependencies necessary to install Koha on Red Hat Linux 9 (and probably 8.0) as well. A brief description can be found at: http://paulgear.webhop.net/linux/#Koha and the RPMs themselves are at: http://paulgear.webhop.net/linux/RPMS/noarch/ and http://paulgear.webhop.net/linux/SRPMS/ I'd really appreciate it if one of the developers could mirror these to sourceforge.net so i don't overrun my 1 Gb monthly quota. :-) I've checked the packages visually, but have done no testing apart from installing them on my machine. Surprisingly, Koha still seems to work. ;-) The RPM spec files have all been hacked in a rather cookie-cutter-like manner from Red Hat's perl-HTML-Tagset-3.03-28.src.rpm. I'm interested to know whether they work for others. Hope this helps some people with their Koha installation. Watch this space: i might even manage an RPM package for Koha itself. <g> Paul http://paulgear.webhop.net -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+87nC0yv0OWRYqWwRArJOAJ9oQnjABtX93w5Lk5UH6LHPFiZ9zwCfR+A1 Kdf1qDozxX5KoZRTdAmD1xk= =N6D6 -----END PGP SIGNATURE-----

3 2

HOW CUSTOMIZE THE CARDNUMBER
by JAVIER RICARDO MEJIA C. 24 Jun '03

24 Jun '03

Hi, How can i do change the cardnumber parameters for my own parameters i need introduce my own cardnumber i can´t use the number that koha give me. for example When i create a new member i want put to the member the cardnumber 01062108 but koha is not accept this number... what can i do? Javier

2 1

new Koha mailing list
by Pat Eyler 24 Jun '03

24 Jun '03

We've just created a new mailing list to support the Brazilian effort to create a Portuguese translation of Koha. If you're interested in helping out, or just interested in seeing how things go, please subscribe to the mailing list by sending email to: koha-subscribe(a)br.koha.org and following the directions in the response you receive. -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