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

New Feature: Zebra Plugin for rel_2_2
by Joshua Ferraro 06 Mar '06

06 Mar '06

Hi all, As discussed at our last meeting, Zebra/ZOOM-Perl will be available as a plugin for rel_2_2 as a 'drop-in replacement' for the current MARC-in-SQL design. Of course, you don't _need_ to use Zebra in rel_2_2, but it is available as an option. So ... how do you get it going? Here's a brief installation overview for those of you who'd like to start testing: PREPARE THE SERVER 1. Install Koha 2.2.5 2. Install the latest versions of Yaz, Zebra, and Net::Z3950::ZOOM 2. Create two CVS repositories on your server, one for HEAD and one for rel_2_2 3. Symlink the Koha 2.2.5 installation to the rel_2_2 CVS repo as outlined in the 'Updating Koha' document on kohadocs.org UPDATE YOUR DATABASE ALTER TABLE biblioitems ADD marcxml TEXT NOT NULL; ALTER TABLE itemtypes ADD imageurl char(200); ALTER TABLE biblio ADD frameworkcode VARCHAR( 4 ) NOT NULL AFTER biblionumber; CONFIGURE ZEBRA 1. cd /path/to/rel_2_2_cvs/koha 2. ln -s /path/to/rel_2_2_cvs/kohahris/koha-head/misc/zebra/usmarc/ zebra 3. edit koha.conf add: zebradb=localhost:2100/kohaplugin 4. Start Zebra: sudo zebraidx create kohaplugin sudo zebrasrv localhost:2100 SYNC THE PLUGIN FILES WITH HEAD The following files in your rel_2_2 Koha need to be replaced with HEAD versions: Modules: Biblio.pm Context.pm SearchMarc.pm Amazon.pm Review.pm Search.pm Intranet: addbiblio.pl additem.pl detail.pl MARCdetail.pl ISBNdetail.pl OPAC: opac-detail.pl opac-MARCdetail.pl opac-ISBDdetail.pl You need to edit the new files to change the path from 'cataloging' back to 'acqui.simple' (in 3.0 the path will change). At this point, you should be able to import fresh batches of records using the bulkmarcimport.pl script in HEAD. Searching and acquisitions should also work. Once you get it going, you can easily keep it up to date by keeping your HEAD cvs repo up to data and copying over the above files each time. Let me know if these instructions don't work for you or if you have any questions. 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

Barcodes Generator status
by Eric Bégin 04 Mar '06

04 Mar '06

1 0

New Feature: Improved MARC editor
by Joshua Ferraro 04 Mar '06

04 Mar '06

Hi all, Chris and I have been working on the MARC editor and have made considerable progress. I thought I'd just summarize some of the original bugs and the fixes we found as well as some gotchas to watch out for along the way. Bug #1 was that blank subfields were being saved. Bug #2 was that subfield order was hardcoded to always start with 'a' for repeatable tags (because it was hardcoded in the addfield routine). Bug #3 was that it was only possible to specify one set of indicators for each set of tags (ie, one for all the 650s). (because they were stored in a hash with the tag as the key). Bug #4 was that the underlying routines didn't support subfield reordering or subfield repeatability. So here's what we did: we replaced the use of the MARChtml2marc routine with a MARChtml2xml that reads in the form data and converts it to a MARC::File::XML object. It then passes that to MARC::Record via the new_from_xml() method. This works perfectly and fixes all of the above bugs. However, there is one gotcha. The MARC::File::XML new_from_xml() method converts UTF-8 data into MARC-8 by default for historical reasons. This means that entry of characters outside the normal ascii range in UTF-8 will come out as gibberish in MARC-8. Never fear, there is a solution. As soon as I noticed the problem, I requested that Mike Rylander (who has contributed greatly to this module) add the ability to specify 'no conversion' for that method and he promptly did so and committed it to the SourceForge CVS for MARC::File::XML. The caveat is that it will take a few days for me to update the CPAN version (which I _finally_ have write access to). I'll ping the list as soon as that's done. The bottom line is that to properly encode records YOU WILL HAVE TO UPDATE MARC::File::XML to the new version when you upgrade to 2.2.6. Now ... I'm off to add subfield repeatability and reordering to the interface. 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 1

new contrib in HEAD : holidays and news
by Paul POULAIN 03 Mar '06

03 Mar '06

Hello all, I've just commited a contrib from Tümer Garip (from Turkey) : (tümer : question for you at the end of the mail) * holiday : ============ in /tools/ the holiday.pl script let you define holidays (days where the library is closed), branch by branch. You can define 3 types of holidays : - single day : only this day is closed - repet weekly (like "sunday") : the day is holiday every week - repet yearly (like "July, 4") : this day is closed every year. You can also put exception : - sunday is holiday, but "2006 March, 5th" the library will be open The holidays are used for return date calculation : the return date is set to the next date where the library is open. A systempreference (useDaysMode) set ON (Calendar) or OFF (Normal) the calendar calculation. * news system : ============ in /tools/ the opac-news.pl let you create small news : - for OPAC. You must select in which language the news are shown. - for librarian interface : it does not depend on the language, as all librarians are supposed to speak the same language. Note that : - news appear in librarian interface in mainpage.pl - news don't appear anywhere in OPAC, as there are no PROG templates yet. It has to be done (copy/past from mainpage.pl should be simple) - news don't have an expiry date, the library must delete them manually. - there is no possibility to have news on a branch/borrower category basis either, that could be a nice (and easy) improvement Questions to Tümer : * i sometimes have problem to reach you directly with your mail. which mail is the correct one ? * NewsChannel.pm deals with a news_channels and news_channels_categories tables that I don't have. Do you confirm it's useless ? did I miss some feature ? * NewsChannels.pm also deals with a opac_electronic table. Same question and note. -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org)

1 0

Re: MARC Label in English
by Paul POULAIN 03 Mar '06

03 Mar '06

毛慶禎 a écrit : > Hi Mr. Poulain, Hello, > This is Anthony Mao writing from Department of Library and Information > Science, Fu Jen Catholic University, Taipei, Taiwan. 1st, please note it is better to ask mailing lists, to avoid 2 things : * having to wait 3 days because i'm off from my desktop computer and can't answer mails * letting me answering dozens (hundreds ?) of mails that many other people could answer. (I've seen you just asked on koha-devel for another question related to this one, it's a good idea !) > Before going further I was confused with Koha on > "MARC tag structure admin for default MARC framework". > > The label is in French only. Could I change it to English? During install, you have choosen "UNIMARC". UNIMARC tables are in french only, where MARC21 tables are in english only. To switch to MARC21 english, search marc_datas/marc21_en/structure_def.sql in you installation directory. in mysql, empty marc_tag_structure and marc_subfield_structure and loast the previous file to refill them. If you need authorities, you also can load : sql-datas/english/authorities_normal_marc21.sql HTH -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org)

2 1

question about MARC 995 Text
by 毛慶禎 03 Mar '06

03 Mar '06

Dear Poulain, This is Anthony Mao, associate professor of Department of Library and Informaiton Science, Fu-Jen Catholic University, Taipei, Taiwan. I have a question about Koha. MARC subfield structure admin for 995 (framework ) Second column Text is in French which is beyond my knowledge. Could I have English version from you? We installed Koha 2.2.5 http://koha.smoc.com.tw few weeks ago. -- Best regards 毛慶禎, Anthony Mao, mao at lins dot fju dot edu dot tw ICQ 30941847 Department of Library and Information Science http://www.lins.fju.edu.tw/mao/index.htm TEL +886 2 29052334, FAX +886 2 29017405 Fu-jen Catholic University, Taipei, Taiwan, R.O.C.

1 0

RE: Some script for item deletion - ambiguity
by Tümer Garip 02 Mar '06

02 Mar '06

Hi, Ther was an ambiguity in my previous mail. Sorry. The first line should read: We noticed that the librarian can actaully delete an item (by mistake or while correcting some biblios) even the book is ON LOAN ! -----Original Message----- From: Tümer Garip [mailto:tgarip@neu.edu.tr] Sent: Wednesday, March 01, 2006 3:56 PM To: 'paul(a)koha-fr.org' Cc: 'koha-devel(a)nongnu.org' Subject: Some script for item deletion - suggestion Hi Paul, We noticed that the librarian can actaully delete an item (by mistake or while correcting some biblios). Although KOHA keeps records of deleted items its too much work trying to retrive it. So we think KOHA should prevent deletion of such items. We have added the following script to additem.pl } elsif ($op eq "delitem") { #----------------------------------------------------------------------- ------------------------------------------------------- # retrieve item if exist => then, it's a modif + my $sth=$dbh->prepare("select * from issues i where i.returndate is +null and i.itemnumber=?"); + $sth->execute($itemnum); + my $onloan=$sth->fetchrow; + push @errors,"book_on_loan" if ($onloan); +##error book_on_loan added to template as well + if ($onloan){ + $nextop = "additem"; + }else{ + &NEWdelitem($dbh,$bibid,$itemnum); + $nextop="additem"; + } We also believe a similar code should be inserted to addbiblio.pl as well If you think the sameway can you please commit these, thanks Tumer

1 0

Some script for item deletion - suggestion
by Tümer Garip 01 Mar '06

01 Mar '06

Hi Paul, We noticed that the librarian can actaully delete an item (by mistake or while correcting some biblios). Although KOHA keeps records of deleted items its too much work trying to retrive it. So we think KOHA should prevent deletion of such items. We have added the following script to additem.pl } elsif ($op eq "delitem") { #----------------------------------------------------------------------- ------------------------------------------------------- # retrieve item if exist => then, it's a modif + my $sth=$dbh->prepare("select * from issues i where i.returndate is null and i.itemnumber=?"); + $sth->execute($itemnum); + my $onloan=$sth->fetchrow; + push @errors,"book_on_loan" if ($onloan); ##error book_on_loan added to template as well + if ($onloan){ + $nextop = "additem"; + }else{ &NEWdelitem($dbh,$bibid,$itemnum); $nextop="additem"; + } We also believe a similar code should be inserted to addbiblio.pl as well If you think the sameway can you please commit these, thanks Tumer

1 0

What is GoKoha.com
by Eric Bégin 01 Mar '06

01 Mar '06

1 0

New Feature: Amazon.com Content
by Joshua Ferraro 27 Feb '06

27 Feb '06

Hi all, I've just committed a fully-preferences-based Amazon.com module to rel_2_2. There are three new system preferences: AmazonContent AmazonDevKey AmazonAssocTag To use this new feature, you'll need an Associates login: https://associates.amazon.com/gp/flex/associates/apply-login.html and a developer's key: https://aws-portal.amazon.com/gp/aws/developer/registration/index.html Once you have recieved both IDs from Amazon, and put them into the appropriate system preferences, you can set AmazonContent to 'yes'. At this point, you should have the following content from Amazon.com displaying in your OPAC (NPL template only): * Cover images * "Read it now" * "Search inside" * Descriptions * Reviews * Ratings To see what this will look like, please view this example record from LibLime's OPAC: http://opactest.liblime.com/cgi-bin/koha/opac-detail.pl?bib=21752 Note that if you don't touch these systemprefs, no Amazon.com code will be called. Paul/HDL, if you want to add this to default templates, please take a peek at commits to NPL template files. 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