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

new features for borrowers
by Paul POULAIN 17 Feb '06

17 Feb '06

Hello all, (& specifically joshua, the RM) I was yesterday in OUEST-PROVENCE (called OP in this mail) to work with them on their version of Koha. We all agree on the following position : developp as many features as possible to be in official CVS. Even if it means developping a little bit more parameters tables, to have a behaviour that anyone can use. They worked on borrowers management, here is what they have done and will do in the next 2 weeks : * in koha 2.x we had 3 kinds of borrowers : Adults, Institutions, Childrens. Those 3 kinds of borrowers where hardcoded (A, I, C), and not fully functionnal. OP has defined a new row in categories table : "cateogy_type". a category_type can be <A>dult, <C>hildren, <I>nstitution, <P>rofessional. The library can thus define in the database which catagories are what (and we can have more than 1 category for <C> for example : Baby, boy, girl,...) * when a library want to add a borrower, it 1st must select what kind of borrower it want to add (A,I,C,P). Then the "member add" begins. Every category_type has it's own template. Add is divided in 3 parts : PART 1 : general information : name, surname (where applicable), category (baby, boy, girl in my previous sample, if you choose category_type='C'), and *city* The city refers to a new table with city/zipcode. The library can fill or ignore this table. If empty, the list does not appear. Otherwise, the list appear. Useful to put usefull a list of common cities your library has. PART 2 : addresses (personnal, professionnal, parent's one...), including mail, fax, ... In the previous part, if a city has been choosen, zip and city name are automatically filled and can be modified if necessary. The address has been modified to be separated in 3 parts : number, kind of road (avenue, road, place...), road name. The list of "road type" is defined in a separate table. If empty, once again, it does not appear. Separating address in 3 parts will be a useful thing to have Geographic information on borrowers. OP plans to connect Koha to a Geographic Information Système (SIG in french) on the long term. PART 3 : library use (opac note...) nothing new or important here, if I don't mind. On every PART value checking is done on client side (new behaviour, in javascript) AND server side (as previously). What is new and could be improved later is that the list of mandatory fields can be defined in a systempreference (zipcode is mandatory in France, for example, it's not is some countries) Last note : OP will also reorganize the borrowers table to normalize fields names. For instance, there are many addresses/zipcode..., each having it's own "nick". I suggested to adopt the following rules : each address/mail/phone/fax information begins with a A or a B, the A being "the most important one", the B being the alternative one. For example : Aaddress1, Aaddress2, Azipcode, Acity... Last note (2) : adding childrens : I suggested to add 3 ways to add a children : - from the parent, add a children = in this case, the guarantorcode is kept, and the B adress is automatically set to the parent one. - create a children from home page, and in PART 2, add a ... button to find the parent to set guarantorcode (and B address) - create a children that has no parent in the database (no guarantorcode, and thus no B address automatically set). This last behaviour being usefull for OP, as childs can subscribe to the library without their parents being members. Expected timeline : code working in around 3 weeks (next week being holidays for OP developpers), but on default templates. We agree to let me install a copy on bureau.paulpoulain.com to let you see how it works, and commit code if everybody agrees. Let me know your opinion on this. Joshua, I let you update release notes for 3.0 -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org)

1 0

yahoo tools
by Paul POULAIN 15 Feb '06

15 Feb '06

Hello, Yahoo just released (with a BSD license) 2 pieces of code for rich applications : http://developer.yahoo.net/ypatterns/ http://developer.yahoo.net/yui/ I think we should definetly look at them. (the ypatterns contains very useful & dev-friendly things imho : the solution to very common problems) -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org)

1 0

Koha 3.0 Meeting
by Joshua Ferraro 14 Feb '06

14 Feb '06

Hi all, I've scheduled another Koha 3.0 meeting to be held on Monday Feb 20th at 20:00GMT. Here's the time in your area: http://tinyurl.com/7mztb Our main focus will be the perl-zoom integration, but if you have other topics to discuss, feel free to add them to the agenda: http://www.saas.nsw.edu.au/koha_wiki/index.php?page=AgendAndNotes06feb20 Cheers, -- Joshua Ferraro VENDOR SERVICES FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS

1 0

who knows ?
by Paul POULAIN 14 Feb '06

14 Feb '06

who is http://www.gokoha.com/ ? -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org)

2 2

Koha 3.0 update for week ending Feb 11th 2006
by Joshua Ferraro 13 Feb '06

13 Feb '06

Hi all, Sorry I'm late getting last week's 3.0 Update out ... better late than never I suppose :-). Last week was especially exciting because we've finally got Perl-ZOOM in a working state -- many many thanks to Paul and the Index Data guys for all their hard work on this. MEETING ANNOUNCEMENT We'll be holding our weekly organizational meeting on Monday, February 13th at 19:00 GMT. Here's the time in your area: http://tinyurl.com/7bk2f MEETING NOTES (for Monday February 6th) Present: kados, owen, thd, sanspach, slef, hdl hdl announced that paul had solved 'problem #2' with perl-zoom, but problem #1 still remained (CQL queries) hdl also announced some new serials code he was working on to link a serial to an item record kados announced some code he committed to rel_2_2, several new sysprefs, some related to Amazon.com content, some to interface customization. group discussed some areas where Koha needed improvement to use mod_perl2 thd brought up his suggestion about improving framework for more SQL dbs: http://lists.nongnu.org/archive/html/koha-devel/2006-02/msg00020.html slef, kados, hdl agreed his plan is sound. still waiting for feedback from paul and chris before adding these suggestions to the Koha Coding Guidelines WHAT'S ON TAP FOR THIS WEEK paul: integrating perl-zoom and biblio functions hdl: Acquisitions chris: get keyword searching going with perl-zoom DEVELOPER ACTIVITY LAST WEEK paul: worked on perl-zoom hdl: Serialsitemization (in rel_2_2) Add a YesNo system preference serialsadditem If set to 1, each issue received will create a new item linked to the biblio with itemnotes filled with Serial number information. chris: testing mod_perl2 with head, ironing out some bugs planning new search module using Perl-ZOOM Cheers, -- Joshua Ferraro VENDOR SERVICES FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS

2 2

testing tool ?
by Paul POULAIN 13 Feb '06

13 Feb '06

Hi, could http://openqa.org/selenium-ide/ be something interesting for us ? -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org)

1 0

zebra config problem (still 0, yes, really 0 !)
by Paul POULAIN 10 Feb '06

10 Feb '06

Hello the list, This time it seems zebra work for both indexing and search. The last blocking problem was... a space in recordId: (bib1,Identifier-standard) just after the comma. Adam agreed it was a bug, and it should be solved soon. But now we are aware, we can avoid putting the space ! I've commited all what is needed to setup a working zebra DB in Unimarc (in misc/migration_tools and /zebra directories) : * collection.abs is UNIMARC specific and must be rewritten for MARC21, in marc21 directory * pdf.properties is to be copied unmodified in the marc21 directory (can also be put somewhere else) * rebuild_zebra.pl is SLOW, but 1 step reindexing tool, using ZOOM * rebuild_zebra_idx is FAST, but 2 step reindexing tool, and does not use zebra. run it, it will create all biblios XML files in /zebra/biblios directory, then zebraidx update biblios in your zebra directory * zebra.cfg is the zebra config file ;-) * test_cql2rpn.pl is a script that will query the database and show the results. Works for me, just change the query at the beginning to get answers you expect. What has to be done : * benchmarking : it seems the zebraidx update is faster than lightning (400biblios/sec : 10 000biblios in 25seconds), while ZOOM indexing is slow (something like 25biblios/second) More benchmarking could be done. * completing collection.abs for UNIMARC. I'll take care of it. * modifying Biblio.pm to use ZOOM instead of the "zebraidx through exec" running actually. I'll take care of it also. * modify the search API & tools & screens. I'll let the ball to someone else (chris ?) for this. I agree SearchMarc.pm can be dropped and replaced by something else (maybe a new-and-clean Search.pm package) -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org)

3 3

Koha 3.0 update for week ending Feb 4th 2006
by Joshua Ferraro 08 Feb '06

08 Feb '06

Hi all, As you're probably aware, our code sprint for Koha 3.0 is underway. As we approach our goal, I'm going to try to keep everyone well informed on what's happening by sending a weekly 'Koha 3.0 Update' email to koha-devel. In it, I'll summarize what's been done the previous week, what's on tap for next week, as well as any news items, meeting announcements, etc. My goal is to do one of these every Saturday from now until Koha 3.0 is released. To facilitate that, I'd greatly appreciate it if everyone working on Koha 3.0 jobs (mostly paul, hdl, and chris, but others too) could summarize what has been done in the past week, and what's on tap for next week, and send those lists to me by Friday each week. Also, if you have any news items to announce, I'd be happy to include them ... send 'em my way. Cheers, -- Joshua Ferraro VENDOR SERVICES FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS

3 2

Re: [Koha-devel] Zebra config problem (still 1)
by Tümer Garip 08 Feb '06

08 Feb '06

Adam wrote in reply to Paul: > cwd=/home/paul/koha.dev/head/misc/zebra/unimarc > 15:40:34-03/02 zebrasrv(1) [log] record 0 type XML > 15:40:34-03/02 zebrasrv(1) [log] 3129 bytes: > <?xml version="1.0" encoding="UTF-8"?> > <collection xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.l ... >> Your root element is collection. Not record. I don't think melm will match that. Had you used record as root >> element - it should do it. >> >> >> It's always a good idea to try things out with >> zebraidx -s update testrec.xml >> and see what gets matched.. (Look for the Idx: lines). Ooops, this is getting more complicated for me. MARC21 slim defines the MARCXML as <collection><record></record></collection>. The perl MARC module produces XML according to this. When you run zebraidx with a proper MARCXML you get an error saying collection.abs could not be found. So you are forced to rename marc21.abs as collection.abs by zebraidx or by ZOOM in that sense. To make things more complicated everything seems to work until you try to use the recordID feature. If your XML file omits the MARC tags below 10 then RecordID works everytime. However if you have tags below 10 out of 50k records I got 30% with bad-match error. So I am trying to eliminate whether its KOHA reproduced records doing or not. I'll post the outcome on this list. Regards, Tumer Garip

2 1

Zebra config problem (still 1)
by Paul POULAIN 08 Feb '06

08 Feb '06

OK guys, the problem with CQL2RPN seems solved. But the other one is still here. I explain again (sorry to bug you, but i'm really stuck) : zebra.cfg is : ================================ profilePath: ${srcdir:-.}:/usr/local/share/idzebra/tab/ attset: bib1.att attset: explain.att recordId: (bib1, Identifier-standard) recordType: grs.xml lockDir: lock setTmpDir: tmp keyTmpDir: tmp memMax: 100 perm.anonymous: rw encoding utf-8 storeKeys:1 storeData:1 =============================== I have a collection.abs in my directory, to be able to read MARC::Record->as_XML : ======================== name collection attset bib1.att esetname F @ esetname B @ marc usmarc.mar xpath disable all any melm 090$a identifier-standard,identifier-standard:p melm 700 author,author:p melm 200$a title,title:p melm 200$e title,title:p melm 020$a isbn melm 011$a issn (yes, on my sample the 090$a is my primary key) ======================== and when I run the following script : my $Zpackage = $Zconn->package(); $Zpackage->option(databaseName => 'Koha'); $Zpackage->option(action => "specialUpdate"); $Zpackage->option(record => $record); $Zpackage->send("update"); $Zpackage->destroy; I get : 15:40:34-03/02 zebrasrv(1) [log] Received DB Update 15:40:34-03/02 zebrasrv(1) [log] action 15:40:34-03/02 zebrasrv(1) [log] specialUpdate 15:40:34-03/02 zebrasrv(1) [log] database: Koha 15:40:34-03/02 zebrasrv(1) [log][app2] zebra_register_open rw = 1 useshadow=0 p=0x8146570,n=,rp=(none) 15:40:34-03/02 zebrasrv(1) [log] profilePath=.:/usr/local/share/idzebra/tab/ cwd=/home/paul/koha.dev/head/misc/zebra/unimarc 15:40:34-03/02 zebrasrv(1) [log] record 0 type XML 15:40:34-03/02 zebrasrv(1) [log] 3129 bytes: <?xml version="1.0" encoding="UTF-8"?> <collection xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.l ... 15:40:34-03/02 zebrasrv(1) [warn] Record didn't contain match fields in (bib1, identifier-standard) 15:40:34-03/02 zebrasrv(1) [warn] Bad match criteria (recordID) 15:40:34-03/02 zebrasrv(1) [log] zebra_update_record returned res=1 15:40:34-03/02 zebrasrv(1) [warn] zebra_update_record failed r=1 15:40:34-03/02 zebrasrv(1) [log] zebra_end_trans 15:40:34-03/02 zebrasrv(1) [log] sorting section 1 15:40:34-03/02 zebrasrv(1) [log] Iterations . . . 36 15:40:34-03/02 zebrasrv(1) [log] Distinct words . 18 15:40:34-03/02 zebrasrv(1) [log] Updates. . . . . 14 15:40:34-03/02 zebrasrv(1) [log] Deletions. . . . 2 15:40:34-03/02 zebrasrv(1) [log] Insertions . . . 2 15:40:34-03/02 zebrasrv(1) [log][app2] zebra_register_close p=0x8146570 15:40:34-03/02 zebrasrv(1) [log] Records: 0 i/u/d 0/0/0 15:40:34-03/02 zebrasrv(1) [log] user/system: 1/0 15:40:34-03/02 zebrasrv(1) [request] EsRequest ERROR 224 update_record failed 15:40:34-03/02 zebrasrv(1) [session] Connection closed by client If I remove the recordId line in zebra.cfg, everything goes well, except I need this line to be able to modify my records ! PS : bib1 is the standard bib1.att file, containing : att 1007 Identifier-standard -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org)

2 3