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

Summary 2005-06-06
by mjr＠phonecoop.coop 07 Jun '05

07 Jun '05

What have the koha developers been doing this week? tipaul added MARC new setup checks, added a new build_marc_Tword, changed iso2709 file sending to an attachment, changed pay page to redirect to patron page added systemprefs to control "lost" item display and logo image, fixed and improved dictionary searches, made some graphic improvements to default/en marctagstructure template, and fixed bugs in acqui.simple/additem, the order receive screen, overdue notices, help screens and css/en templates. hdl fixed bugs in opac-full-serial and opac-serial-issues, updated opac-full-serial-issues screens, added a default/de translation by hellen, fixed a bug requiring PDF::API2, added tabsub to css/en opac templates added email-sending to opac-sendbasket, made display changes to default/en marctagstructure, added date to overduenotices and list of books and barcodes, and added a subscription history to serials. hellen updated the default/de intranet translation for 2.2.2 gmccullagh split SearchBiblio and SearchMarc, added opac-search-biblio script, improved opac-search display genjimoto added availability features into SearchMarc and opac-search, added support and editors for mediatype, itemtypesubcategory and itemtypecategory, added search options sidebar to css/en templates, added a catalogsearch() feature to updatedatabase and SearchMarc, and fixed bugs in opac-search, issue/reserve overrides and MARC=OFF subject handling. doxulting updated a lot of unimarc plugins. oleonard fixed an sql_update() bug (870) in css/en opac-search. joshferraro fixed bug 981 in opac-userdetails (missing comma - so did tipaul?). -- MJR/slef Compiled from cvs logs and cvs2cl.pl Full changelog is at http://www.ttllp.co.uk/koha/changelog

2 1

Searching: Zebra
by Joshua Ferraro 06 Jun '05

06 Jun '05

Hi everyone, I've spent the last couple of days playing around with Indexdata's Zebra (http://www.indexdata.dk/zebra/) Zebra is another example of a textual database engine. Zebra can natively index MARC records, so I started by dumping out NPL's records (which took about 20 minutes). Indexing 150K records took just under 3 minutes and all the searches I've done using Zebra's integrated Z39.50 Server have taken less than a second. I haven't had a chance to write a wrapper yet to integrate the search into our existing code but you can try it out at the LOC's generic Z39.50 gateway: http://www.loc.gov/cgi-bin/zgate?ACTION=INIT&FORM_HOST_PORT=/prod/www/data/… This link will allow you to search NPL's 150K database (you could also use any Z39.50 client (like Yaz) to do the search. The server's IP is 66.213.78.76:9999 and the db name is VOYAGER (because that's the only way I could get the LOC's gateway to connect). Zebra is very high performance (it's in use for systems with tens of millions of records). It supports incremental database updates on live systems, exact boolean search expressions, relevance-ranked free-text queries (not sure about stemming). Of the searching ideas we've come up with so far this one is by far the most impressive. There are still some other textual database engines out there (lucene, clucene, xapian, namzu, to name a few), so if anyone would like to try these out and commit some sample indexing/searching scripts I'd be happy to try them out. Coments, questions? -- Joshua Ferraro VENDOR SERVICES FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Koha ILS, Mambo Intranet, DiscrimiNet Filter jmf(a)liblime.com | Full Demos at http://liblime.com | 1(888)KohaILS

2 1

Adding new biblio problem....
by Silva, Ernesto - Webmaster 06 Jun '05

06 Jun '05

Hi everyone, It's been a while since my last post but Andres and I are still working on Koha for our University (Universidad ORT Uruguay), the system is in production state, about 90% of functionallity running. Now the bad news, our librarians reported some strange problems during the catalog process, it seems that one of them (Mr. A in branch A) adds a new biblio and after a while (minutes, hours) the record is modified by another librarian (from Mr. B in branch B). I know this may be a user mistake but they assure me they haven't modified any record, just added one. I've taken a look at the Biblio.pm code and everything seems to be ok ad the NEWnewbiblio function, the process is almost atomic, there is no big reason to begin thinking in concurrency problems (at least for now). Has anyone had this troubles before? Best regards Ernesto.

1 0

css help, please
by Paul POULAIN 06 Jun '05

06 Jun '05

Hi, Does anyone know why in this page : http://bureau.paulpoulain.com:9006/cgi-bin/koha/opac-serial-issues.pl?bibli… The table, that is very long, does not make the mainbloc (light blue) being extended. The look is really dirty & i don't see how to solve this problem. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

Marc tag_strucure & subfield_structure
by Partha Mukhopadhyay 06 Jun '05

06 Jun '05

Dear friends, Can any one send me the marc_tag_structure and marc_subfield_structure tables with data (compatible with koha win ver. 2.2.2b)? In fact, the previous win version of koha (2.0.0) includes a sample200 database from where the abovementioned two tables can be copied to blank200 database. But in the 2.2.2 version of koha there is only one database blank222 (which contains nothing) and the sample200 tables of marc tags and subfields are not compatible with the new version of koha due to presence of a new primary field in subfield table (frameworkcode). Under such circumstances, if any one wnat to test the new version he or she has to input all the marc tags and subfields in the database first. I want only this two tables to save manual labour and time. Hope someone will response. P S Mukhopadhyay Vidyasagar Universiy, WB, India -- India.com free e-mail - www.india.com. Check out our value-added Premium features, such as an extra 20MB for mail storage, POP3, e-mail forwarding, and ads-free mailboxes! Powered by Outblaze

1 0

optimising the opac a little
by Gavin McCullagh 05 Jun '05

05 Jun '05

Hi, I'm a newbie here so please be patient with me. I'm going to open up straight away into a proposal, I hope people don't think this rude. If it can't be done, chances are you know why and I don't cause I'm new :-) I have a proposal which I'd like to suggest to optimise the Koha web based opac system. I'd like your opinions as to whether I'm right on track, doing redundant work or just plain off my rocker. It seems from a fairly cursory look that the opac system is basically constructing queries with LIKE '%xxx%' within them to interrogate the biblio table. This works fine of course but if those columns are unindexed this LIKE query seems (in my experience) a little slow. Suggestions to optimise: 1. Add FULLTEXT indexes to each of the searched columns (author,title,...) 2. Change the LIKE queries to use something like the following: SELECT ......, MATCH biblio.title AGAINST ('$titleSearchString' IN BOOLEAN MODE) AS TitleRelevance FROM biblio ..... WHERE ..... AND MATCH biblio.title AGAINST ('$titleSearchString' IN BOOLEAN MODE) ORDER BY TitleRelevance DESC The where clause does a word search of the title field which is very quick, as long as the indexes are in place. The TitleRelevance field in the select gives a match relevance so that you're best matches appear first (ORDER BY TitleRelevance DESC). I was mullign it over in my head and I suspect the way to combine two different column relevances is to multiply them. -- Reservations -- 1. FULLTEXT indexes and MATCH are in MySQL as of version 3.23.23. Is it likely people are using other databases which don't have FULLTEXT indexes? Is it likely people are using older versions of MySQL? http://dev.mysql.com/doc/mysql/en/fulltext-search.html http://www.databasejournal.com/features/mysql/article.php/1578331 http://jeremy.zawodny.com/blog/archives/000576.html 2. BOOLEAN MODE is a very recent addition. Indeed it's not in the MySQL package in Debian Woody. It is in sarge though (Mysql >v4.0.1). This is strictly optional for now as it just makes the searching more powerful (allowing use of wildcards, string removal, etc.). I'm not sure if an old version will ignore it or complain, but this could be left out for now. http://dev.mysql.com/doc/mysql/en/fulltext-boolean.html http://www.databasejournal.com/features/mysql/article.php/1587371 Most people don't use the boolean mode stuff, so it might be nice to have a random "tip" on the search page like: Tip: to search for partial strings use the * wildcard eg "Mac*" will match "MacCarthaigh". and a link to some advanced searching tips. 3. The addition of indexes on the biblio table will slow insertions/updates down. This is a price you pay for faster searching. In my experience it's worth the sacrifice. So, is this all useless nonsense? Should I crawl back under that rock? I'm willing to roll up my sleeves and get at it but I'd like to know this work is useful and it would help to have someone known in the community to keep an eye on the code. As I see it this is a mainly sql task and there shouldn't be too many changes to the perl code itself but I'm not so familiar with the greater part of the project code so I'd rather have someone to look over my shoulder now and then. Here is an example I've just done in PHP on MySQL with a similar database structure. There are ~20K records. http://simms.celt.dias.ie/~gavin/opac/ You can search the titles for 'gael*', the author for 'breatnach', keywords for 'royal' and 'ireland'. I have not yet implemented cross-linking. I'll take this down in a few days. Gavin

4 5

problem on Importing the MARC
by Mengistu Motbaynor 03 Jun '05

03 Jun '05

Hello I am deploying koha ver 2.2 for our school library system. But I have alot of problems in Importing the MARC record in the existing library ststem. My first problem is When I import records from MARC it did not import the Items copies(barcode, Price,...) that I export it including the catalogue. But I can import the Catalogue only. Thank You Mengistu _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

1 0

What Test::Harness & Test::More package do you have installed?
by Michael Lake 01 Jun '05

01 Jun '05

Hi all The Koha requirements are unclear on what versions or what authors Perl packages are required. For instance MARC-Record & HTML-Template need Test::More There is a package Test::Simple that contains Test::More by Michael G Schwern. This needs Test::Harness however. CPAN lists three Test::Harness packages: Test::Harness run perl standard test scripts with statistics POE-0.3101 - 19 May 2005 - Rocco Caputo Test::Harness Run Perl standard test scripts with statistics Test-Harness-2.48 - 22 Apr 2005 - Andy Lester Test::Harness run perl standard test scripts with statistics Net-ext-1.011 - 10 Apr 2002 - Spider Boardman My Question is: what is the author of the Test::Harness and Test::More packages that you are using? Mike -- Mike Lake Caver, Linux enthusiast and interested in anything technical. -- UTS CRICOS Provider Code: 00099F DISCLAIMER: This email message and any accompanying attachments may contain confidential information. If you are not the intended recipient, do not read, use, disseminate, distribute or copy this message or attachments. If you have received this message in error, please notify the sender immediately and delete this message. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views the University of Technology Sydney. Before opening any attachments, please check them for viruses and defects.

2 1

Circulation Lists ( gestion de périodiques )
by Luis Eduardo Samico 31 May '05

31 May '05

Hello everybody, First of all, I'm going to introduce myself: I'm a 22 years old student of ESIEE-Paris ( another ESIEE students have already worked with koha and proposed the Ldap authentication... ). Excuse me everybody if my question is destinated to user's list. So, I'm in a project that I have to choose and implement an Opensource solution for a Documentation Center where I work.. Actually they already have a SIGB but its "newer version" is very expensive, so ... Well, I've a lot of documentation about Koha, and I've found in one of them that Koha has a complete "periodics" management (like magazines). My problem is about the "periodics" circulation. I've already seen the circulation permission in the user flags, that allows the staff to work with a circulation desk. I've not found anything about circulation lists ( that's what my client needs ).... It would work like this: Every "periodic" biblio/biblioitem has a circultation list composed of Y users.... So, every time a new item ( exemplaire ) arrives, after being available to be borrowed, it goes to that Y users of these list for X days each user, where X is a delay to be defined by the administrator.... I'm sorry if Koha already has this features, but I've not managed to found it... If it doesn't, it would be a good suggestion for the newer version.... :). I've already some ideas about how it would be done in the database but, actually, how my project is for the end of July I think, unfortunatelly, I've not too much time to be an "active develloper" for koha. Sorry for my english that is not that good, but I think everybody could understand.... Thanks a lot.. Luis SAMICO Bonjour à tous, Je suis un élève en 4ème année de l'ESIEE-Paris et pour le moment je fais du stage sur migration de base de données. Mon doute c'est sur la gestion de périodiques. J'avais lu que koha, il avait un complète gestion de périodiques, mais je n'ai pas arrivé a trouver des listes de circulation ( j'en ai besoin... en effect, c'est a mon client).... Bon, la liste de circulation est un groupe des utilisateurs ( lecteurs ) associés à un périodique. Donc, dés que un exemplaire du périodique arrive, il reste quelques jours avec ceux-là ( les utilisaterus) avant d'être disponible à prêt. Alors, excuse moi si Koha a déjà c'est option mais moi, je n'ai pas trouvé.... s'il n'ai pas, ça peut être une bonne suggestion pour la prochaine version. J'ai déjà des idées mais comme c'est un stage de presque 2 mois,malheureusement, je n'aurai pas du temps de revenir un développeur koha.... Pardon pour mes erreurs de français... mais je pense qu'on peut comprendre quand même... ( en effect, je suis brésillien ... enchanté!!! ) Merci par avance Luis SAMICO --------------------------------- Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de stockage pour vos mails, photos et vidéos ! Créez votre Yahoo! Mail

3 2

Bugsquashing Session Notes
by Joshua Ferraro 31 May '05

31 May '05

Hi everyone, We had a very successful bug squashing session today -- we have assigned, fixed or closed all the 9xx bugs (started wth 87 total bugs and now we have 77). Let's plan another meeting for early next week. Any time requests forward them to me please. Here's the summary of assigned/closed/fixed bugs: Paul: 986: checkmarc.pl should notice null frameworkcode 975: serials : renewal of a subscription 966: Attempting to add a biblio results in warning about possible duplicate 958: Field "notes" becomes empty at receipt 957: Bad calcul of the total in the order line after receipting 950: Issue limit set to zero 949: error when adding an acquisition wihtout budget 944: We need to be able to delete a subscription. 932: default theme is used for 'nohelp.tmpl' even if other template 938: If you delete notice without item it deletes notice linked (minor) 919: problems with subfield $0 of unimarc authorities structure (minor) 982: Internal Server Error (fixed) 981: opac-userdetails.pl crash (fixed) 961: Error message, when deleting an authority(fixed) 943: pb accentuations LDAP <=> KOHA(closed) 942: (closed) 933: Cancel process results in untemplated dialogue (fixed) 910: repeating a field (+), bring you back to the first page of m (fixed) HDL: 951: PDF::API2 mandatory in error 924: Database Update failed 2.2.0RC2 -> 2.2.0 (worksforme) Genji: 969: Overriding waiting item results in cancelled reserve (fixed) MJ: 984: Bug in installer appears to not correctly escape password 952: updatedatabase not checking whether table already populated Josh: 971: Incorrect use of term 'keyword' in searching template 953: Request for translation page 923: printer config in barcode generator gives error 987: Please create an "authority" component on bugzilla. 911: Intranet with safari (macintosh browser) 985: Deleting from OPAC Virtual Shelves crashes (closed) 967: In Katipo templates if acquistions set to normal, the links 925: Currency search doesn't appear to do anything 915: opac-MARCdetail.pl incorrectly shows request status Owen: 926: Many form tags lack method and/or action attributes 980, 978 (fixed) The following bugs were moved to 'enhancement': 976: duplicating a MARC field (with +) 917: plugins for coded fields in unimarc authorities 900: Unimarc Authorities -- Joshua Ferraro VENDOR SERVICES FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Koha ILS, Mambo Intranet, DiscrimiNet Filter jmf(a)liblime.com | Full Demos at http://liblime.com | 1(888)KohaILS

1 0