- Koha - lists.katipo.co.nz

Import MARC Records
by SANDEEP BHAVSAR 28 Jun '12

28 Jun '12

Dear All I have converted the data into MARC and importing the same on Koha. But from last one hour import job progress is showing on 0% Kindly guide me about how can we check that MARC importing work is going on or not. Kindly guide step by step about how to check the import job status. -- Thanks and Regards Sandeep Bhavsar Librarian Dr.V.N.Bedekar Institute of Management Studies Thane(W) 400601 MUMBAI. INDIA @@@@@@@@@@@@@@@@@@@@@@@@@@ email : sandeep.bhavsar(a)gmail.com Mob : 9029 345777 elibrary :http://www.vpmthane.org/im/elib/main.htm @@@@@@@@@@@@@@@@@@@@@@@@@@

1 0

Availability - No items Available
by SANDEEP BHAVSAR 28 Jun '12

28 Jun '12

Respected All I am using koha ver 3.09.00.017. Just imported the data into catalogue and index the same with nozebra I am getting the search of all records in OPAC but Koha is showing Availability : No Items available and for every records showing 7 holdings. Kindly guide -- Thanks and Regards Sandeep Bhavsar Librarian Dr.V.N.Bedekar Institute of Management Studies Thane(W) 400601 MUMBAI. INDIA @@@@@@@@@@@@@@@@@@@@@@@@@@ email : sandeep.bhavsar(a)gmail.com Mob : 9029 345777 elibrary :http://www.vpmthane.org/im/elib/main.htm @@@@@@@@@@@@@@@@@@@@@@@@@@

2 1

8 Perl Modules are Not Detected by koha_perl_deps.pl on VDS (was Re: Installing Koha on CentOS+cPanel Hosting Server)
by Andi Sugandi 28 Jun '12

28 Jun '12

Hi all, On Mon, Jun 4, 2012 at 7:07 PM, Bernardo Gonzalez Kriegel <bgkriegel(a)gmail.com> wrote: > Hi, > >> cPanel only provides Perl 5.8, but Perl module Modern::Perl can only >> be installed on Perl 5.10 environment[1]. >> > Koha (last versions) can only be installed on Perl >= 5.10 > > >> What do you think? >> > In a situation like yours, I have downloaded and compiled Perl (on > /usr/local, 5.14), > then I installed all the required modules from CPAN (a long long work) > Then Koha. It works. > >> Get rid of cPanel and start providing Perl modules based on CentOS >> environment will simplify the installing process of Koha? >> > My advice would be not to touch anything in the system. > Only install what is needed by Koha in /usr/local I'm running Perl 5.16 now, installed manually in /usr/local directory: # perl -v | grep version This is perl 5, version 16, subversion 0 (v5.16.0) built for x86_64-linux Then trying to see whether all required Perl modules are already installed or not. But unfortunately something happened: There are 8 left, not detected by 'koha_perl_deps.pl' script [0], though these modules are already in place: cpan[1]> install CGI Reading '/root/.cpan/Metadata' Database was generated on Sat, 23 Jun 2012 16:47:04 GMT CGI is up to date (3.59). cpan[2]> install CGI::Carp CGI::Carp is up to date (3.51). cpan[3]> install Digest::SHA Digest::SHA is up to date (5.71). cpan[4]> install HTTP::OAI HTTP::OAI is up to date (3.28). cpan[5]> install Net::Z3950::ZOOM Net::Z3950::ZOOM is up to date (1.28). cpan[6]> install Template::Plugin::HtmlToText Template::Plugin::HtmlToText is up to date (0.03). cpan[7]> install Test::Harness Test::Harness is up to date (3.25). cpan[8]> install Test::More Test::More is up to date (0.98). [0] http://paste.opensuse.org/view/simple/94354226 Does it mean that the Perl environment is not configured properly? How to solve this issue? Any help will be very much appreciated. Thanks in advance. Best regards, -- Andi Sugandi.

3 7

Re: [Koha] Koha Digest, Vol 80, Issue 45
by Jill Griffiths 27 Jun '12

27 Jun '12

Hi, I'm no longer working at the Wright Institute. If you have a question, please email Jason at jstrauss(a)wi.edu Thanks! Jill (Griffiths) Thompson

1 0

ResourceMate migration?
by Heather Braum (NEKLS) 27 Jun '12

27 Jun '12

Has anyone ever tried to get MARC data out of a ResourceMate system before? We've got several questions, starting with how do you get MARC records out of it? Thanks in advance! Heather Braum Digital and Technical Services Librarian Northeast Kansas Library System hbraum(a)nekls.org 4317 W. 6th St. Lawrence, KS 66049 Office: (785) 838-4090 Fax: (785) 838-3989 http://www.nekls.org/ | http://www.nexpresslibrary.org/ "My guess is (it will be) about 300 years until computers are as good as, say, your local reference library in search." ~Craig Silverstein, director of technology, Google.com "The illiterate of the 21st century will not be those cannot read and write, but those who cannot learn, unlearn, and relearn." ~Alvin Toffler, *Rethinking the Future*

1 0

sax_parser_print.pl Issue on VDS (CentOS)
by Andi Sugandi 27 Jun '12

27 Jun '12

Hi all, I am now on preparing to install Koha after upgrading default Perl installation to newer version (5.16): http://lists.katipo.co.nz/public/koha/2012-June/033255.html I run misc/sax_parser_print.pl on /koha-3.8.2 directory, then this issue appears [*] [**]: [*] -------------begin-of-script------------- # misc/sax_parser_print.pl Koha wants something like: XML::LibXML::SAX::Parser=HASH(0x81fe220) You have: XML::SAX::Expat=HASH(0x16c9ea8) Looks bad, check INSTALL.* documentation. -------------end-of-script------------- [**] -------------begin-of-script------------- # /usr/local/bin/perl misc/sax_parser_print.pl Koha wants something like: XML::LibXML::SAX::Parser=HASH(0x81fe220) You have: XML::LibXML::SAX=HASH(0xaa1cf0) Looks bad, check INSTALL.* documentation. -------------end-of-script------------- ParserDetails.ini files: [***] # locate ParserDetails.ini /usr/local/lib/perl5/site_perl/5.8.8/XML/SAX/ParserDetails.ini /usr/local/lib/perl5/site_perl/5.8.8/XML/SAX/ParserDetails.ini.ORIG /usr/local/share/perl5/XML/SAX/ParserDetails.ini /usr/local/share/perl5/XML/SAX/ParserDetails.ini.ORIG Contain of /usr/local/lib/perl5/site_perl/5.8.8/XML/SAX/ParserDetails.ini file: [****] --------------------------begin-of-script-------------------------- [XML::SAX::Expat] http://xml.org/sax/features/namespaces = 1 http://xml.org/sax/features/external-general-entities = 1 http://xml.org/sax/features/external-parameter-entities = 1 [XML::LibXML::SAX::Parser] http://xml.org/sax/features/namespaces = 1 [XML::LibXML::SAX] http://xml.org/sax/features/namespaces = 1 --------------------------end-of-script-------------------------- Contain of /usr/local/share/perl5/XML/SAX/ParserDetails.ini [*****] --------------------------begin-of-script-------------------------- [XML::LibXML::SAX::Parser] http://xml.org/sax/features/namespaces = 1 [XML::SAX::Expat] http://xml.org/sax/features/namespaces = 1 http://xml.org/sax/features/external-general-entities = 1 http://xml.org/sax/features/external-parameter-entities = 1 --------------------------end-of-script-------------------------- Why the issue still persists even though the ParserDetails.ini file has proper configuration? Does this issue will "harm" my Koha installation? Any help will be very much appreciated. Thanks in advance. Best regards -- Andi Sugandi.

1 1

SOLVED: Re: Installing XML::SAX Does Not Install "ParserDetails.ini" File (was Re: sax_parser_print.pl Issue on VDS (CentOS))
by Andi Sugandi 27 Jun '12

27 Jun '12

Hi all, So.. IMHO, this was an old issue: http://lists.katipo.co.nz/public/koha/2007-October/012527.html :) On Wed, Jun 27, 2012 at 2:57 PM, Andi Sugandi <andisugandi(a)gmail.com> wrote: [...] > I just realize that installing XML::SAX module Perl (5.16) via cpan on > my VDS (CentOS) does not install "ParserDetails.ini" file: > > "... > Appending installation info to > /usr/local/lib/perl5/5.16.0/x86_64-linux/perllocal.pod > could not find ParserDetails.ini in > /root/.cpan/build/XML-SAX-0.99-a2ItfE/blib/lib/XML/SAX > ... " [1] > > [1] http://paste.opensuse.org/view/simple/45939574 > > Perl 5.16 does not have it [2] while my old version (5.8.8) does [3]. > > [2] http://paste.opensuse.org/view/simple/91380094 > [3] http://paste.opensuse.org/view/simple/45731456 This has been documented well on the Perl-XML FAQ: http://perl-xml.sourceforge.net/faq/#parserdetails.ini Solution: 1. After installing Installing XML::SAX (via cpan), I should install other module: XML::SAX::Expat or XML::LibXML. 2. Proceed by running: perl -MXML::SAX -e "XML::SAX->add_parser(q(XML::SAX::PurePerl))->save_parsers()" 3. Make sure that "ParserDetails.ini" file (anywhere on the system) has only these 2 lines: [XML::LibXML::SAX::Parser] http://xml.org/sax/features/namespaces = 1 4. Test it (inside your extracted Koha direcotry, mine: ./koha-3.8.2): # /usr/local/bin/perl misc/sax_parser_print.pl Koha wants something like: XML::LibXML::SAX::Parser=HASH(0x81fe220) You have: XML::LibXML::SAX::Parser=HASH(0x2671db8) Looks good. or: # ./misc/sax_parser_print.pl Koha wants something like: XML::LibXML::SAX::Parser=HASH(0x81fe220) You have: XML::LibXML::SAX::Parser=HASH(0x1187e78) Looks good. Any comments are valuable (especially) for me. Best regards, -- Andi Sugandi.

1 0

Tools section of the manual
by Nicole Engard 27 Jun '12

27 Jun '12

Hello everyone, With the release of 3.8 (and all future releases) I have updated the Tools section of the manual to be broken out in to the columns on the Tools page. I tell you this in case you have any links in your guides to Tools related pages in the manual. They have all changed with 3.8: http://manual.koha-community.org/3.8/en/tools.html As always, feel free to submit your edits, ideas, comments, criticisms, etc regarding the manual to me and I'll do my best to make the changes necessary to make it easy to use and follow. Thanks Nicole C. Engard Documentation Manager

1 0

Official Koha Newsletter: Volume 3, Issue 6: June 2012
by Daniel Grobani 27 Jun '12

27 Jun '12

Official Koha Newsletter: Volume 3, Issue 6: June 2012 [Below is the text of the newsletter. For active links and a more readable format, please visit http://koha-community.org/koha-newsletter-volume-3-issue-6-june-2012] Official Koha Newsletter (ISSN 2153-8328) Volume 3, Issue 6: June 2012 Edited by Daniel Grobani, Koha Community Newsletter Editor. Please submit news items to danielg.koha(a)gmail.com. Table of Contents Koha Development Koha 3.8.2 Released Koha 3.6.5 Released Koha 3.6.6 Released Koha Statistics Release Manager’s Newsletter MARC Records in PostgreSQL Adding VIAF Autosuggest for New NAME Authorities Koha Community New Koha Libraries Community Gossip Koha-Kobli News Past Koha Events June General IRC Meeting KohaCon12 Upcoming Koha Events July General IRC Meeting KohaCon13 Koha Development Koha 3.8.2 Released by Chris Cormack The Koha community is proud to release Koha version 3.8.2. This is a bugfix release, and contains a large number of fixes. You can obtain Koha 3.8.2 here. Release notes are here. Koha 3.6.5 Released by Jared Camins-Esakov The Koha release team is happy to announce the release of Koha 3.6.5. This is a stable release and contains bugfixes as well as updated translations. You can download Koha 3.6.5 here. Release notes are here. Koha 3.6.6 Released by Jared Camins-Esakov The Koha release team is happy to announce the release of Koha 3.6.6. This is a stable release and contains bugfixes as well as updated translations. You can download Koha 3.6.6 here. Release notes are here. Koha Statistics Chris Cormack, unofficial Koha Community Statistics Wizard, has posted statistics for Koha 3.6.5, May bugs & enhancements, Koha 3.8.2, and Koha 3.6.6. Release Manager Newsletter Paul Poulain, Koha 3.8 Release Manager, is publishing a monthly newsletter dedicated to Koha 3.8 development. It can be found on the Koha Community website in the Koha News category. The latest issue is here. Experimental Support for MARC Records as a Proper Datatype in the PostgreSQL Database by Marc Balmer Sitting in one of the nice pubs in Edinburgh during KohaCon, I had this idea to add MARC records as a proper datatype to the PostgreSQL database server. After a discussion with Marc Véron and Dobrica Pavlinusic about what that could mean, I decided to just try it and I have now a basic implementation (or, more a proof of concept). Here is some information on this: If MARC records are a proper datatype, that means they are stored right in the database, are backed-up, can be restored, replicated, etc., just with the standard database tools. If a function is provided to access individual fields of a MARC record, then this can be used in SQL expressions, e.g. for selects or to create views, etc. As PostgreSQL supports functional indexes, you can create indexes on individual MARC fields, giving you super fast access to your data. How does it look? There is a datatype called ‘marc’ for now: CREATE TABLE books ( id serial, sig varchar(16), marc_record marc ); MARC records are loaded into the database as raw, binary records, encoded in hexadecimal: INSERT INTO books (sig, marc_record) VALUES (‘a01b’, ’3030383830…..’); To access individual MARC fields, the function ‘marc_field()’ was created; it returns VARCHAR: SELECT id, marc_field(marc_record, ’020') AS isbn FROM books WHERE sig = ‘a01b’; Of course MARC fields can be used to search data: SELECT id, marc_field(marc_record, ’020') AS isbn FROM books WHERE marc_field(marc_record, ’245') like ‘whatever%’; An index on a specific field can easily be created: CREATE INDEX books_isbn_idx ON books (marc_field(marc_record, ’020')); As syntactic sugar, the expression marc_record@’020' is equal to marc_field(marc_record, ’020'). Marijana Glavica kindly let me use a MARC database of ~250,000 records to make some tests, here are some real world examples: books=# \d test_marc Table “public.test_marc” Column | Type | Modifiers ——–+———+——————————————————– id | integer | not null default nextval(‘test_marc_id_seq’::regclass) marc21 | marc | books=# select count(id) from test_marc; count ——– 246727 (1 row) How many Croatian books do they have? books=# select count(id) from test_marc where substring(marc_field(marc21, ’008'), 37, 3) = ‘hrv’; count ——- 52582 (1 row) Of course much more complex queries are possible with this, and using the right indexes it is really, really fast. One query I tested went from 8.4 seconds to 0.21 ms with the right index. That’s a speedup of 40,000 times. Thanks to Marijana, Dobrica, and Marc for feedback, interesting discussions and ideas! Feedback and suggestions are of course more than welcome at marc(a)msys.ch. Adding VIAF Autosuggest for New NAME Authorities by Stefano Bargioni The Pontificia Università della Santa Croce has written a script to enhance authority cataloguing using VIAF. While adding new authorities of type *NAME, the VIAF catalog can be browsed using its autosuggest API. The script adds a field on top of the /cgi-bin/koha/authorities/authorities.pl page. Typing three or more letters, a popup will be populated with the first ten names. Upon selecting a name, information about the sources of the authority name will be displayed, as well as the full authority record from VIAF, or LC if available. This is an initial version. The next version will try to copy the VIAF authority record into Koha. Comments and help to bargioni(a)pusc.it will be appreciated. Koha Community New Koha Libraries Bethlehem Public Library (via ByWater Solutions) Cooperative Information Network (via ByWater Solutions) Fresnes-en-Woëvre (via BibLibre) New Zealand Education Institute Te Riu Roa Library (via Catalyst) New Zealand Ministry of Education Library (via Catalyst) Pierrefitte-sur-Aire (via BibLibre) San Francisco Maritime National Historical Park (via ByWater Solutions) Spincourt (via BibLibre) Université Rennes 2 (via BibLibre) Valley Automated Library Network (via ByWater Solutions) Vigneulles-les-Hattonchatel (via BibLibre) Community Gossip Silvia Giannitrapani, a student of Library and Information Studies at London’s UCL, is researching open source library management systems for her dissertation “Can Koha and other open source library management systems compete with proprietary systems?” To support her research she is inviting Koha community members to share their views and overall satisfaction with Koha in a brief survey. For more information, email silviag(a)bu.edu. Four French libraries are now using Koha with Solr. Nicole Engard has created a version of Koha 3.8 release notes addressed to users and librarians. A discussion on the Koha-devel list addressed alternatives to having to participate in an IRC meeting in order to vote on a question before the community. D Ruth Bavousett posted her thoughts on diversity in open-source communities. Mirko Tietgen has Koha running on a Raspberry Pi, “An ARM GNU/Linux box for $25?. More information is here. Heather Hernandez, Technical Services Librarian at San Francisco Maritime National Historical Park, blogged about her experience with setting up Koha. An RFC on the Koha namespace has been posted to the wiki. Gaetan Boisson reports that Biblibre recently submitted to the Drupal community an opac module that allows Drupal to connect to Koha (or other ILS’s). More information is here. Koha-Kobli News by Domingo Arroyo The Koha-Kobli release team is happy to announce the second stable release of Koha-Kobli 1.8, based on Koha 3.8. Kobli is a customized version of Koha ILS developed by the Working Group of BAGEs (Spanish General State Authority Libraries). Kobli 1.8 is released in two versions: one for normal installation, and one as a VMware virtual appliance. Koha-Kobli’s 1.8 download is here. More information is here. Recent implementations of Koha-Kobli include the Spanish Ministry of the Presidency Library and the Library of the Center for Analysis and Forescasting of the Spanish Civil Guard. More information is here and here. Past Koha Events June General IRC Meeting The June general IRC meeting was held on 13 June 2012. More information, including the agenda and links to the minutes, is here. KohaCon12 KohaCon12 has come and gone! David Nind (with others) has done an excellent job of updating the conference’s schedule page with lots of links to blog posts, photos, slides, and more. The Hackfest page has also been updated with links to some slides, posts, and tools. Upcoming Koha Events July General IRC Meeting Details on the July general IRC meeting are not yet available as we go to press. KohaCon13 The deadline for posting bids to host KohaCon2013 is almost here. See the conference’s wiki page for the current bids or to add yours.

2 1

Installing XML::SAX Does Not Install "ParserDetails.ini" File (was Re: sax_parser_print.pl Issue on VDS (CentOS))
by Andi Sugandi 27 Jun '12

27 Jun '12

Hi all, I am afraid it'll be a bit out of topic, i apologize. On Wed, Jun 27, 2012 at 11:24 AM, Andi Sugandi <andisugandi(a)gmail.com> wrote: > I am now on preparing to install Koha after upgrading default Perl > installation to newer version (5.16): > http://lists.katipo.co.nz/public/koha/2012-June/033255.html [...] > ParserDetails.ini files: > [***] > # locate ParserDetails.ini > /usr/local/lib/perl5/site_perl/5.8.8/XML/SAX/ParserDetails.ini > /usr/local/lib/perl5/site_perl/5.8.8/XML/SAX/ParserDetails.ini.ORIG > /usr/local/share/perl5/XML/SAX/ParserDetails.ini > /usr/local/share/perl5/XML/SAX/ParserDetails.ini.ORIG I just realize that installing XML::SAX module Perl (5.16) via cpan on my VDS (CentOS) does not install "ParserDetails.ini" file: "... Appending installation info to /usr/local/lib/perl5/5.16.0/x86_64-linux/perllocal.pod could not find ParserDetails.ini in /root/.cpan/build/XML-SAX-0.99-a2ItfE/blib/lib/XML/SAX ... " [1] [1] http://paste.opensuse.org/view/simple/45939574 Perl 5.16 does not have it [2] while my old version (5.8.8) does [3]. [2] http://paste.opensuse.org/view/simple/91380094 [3] http://paste.opensuse.org/view/simple/45731456 Any suggestions? Thanks in advance. Best regards, -- Andi Sugandi.

1 0