- Koha - lists.katipo.co.nz

Fw: web installer not working
by RekhaSaraswat 13 May '10

13 May '10

Dear Koustubha, Error log and web installer both are not showing any error. error log file is empty and web installer simply displays, its working. What may be the problem? thanks Rekha. ----- Original Message ----- From: Koustubha Kale To: rekhasaraswat(a)cdacnoida.in Cc: Koha(a)lists.katipo.co.nz Sent: Wednesday, May 12, 2010 6:45 PM Subject: Re: [Koha] web installer not working rekha, Does the web installer give any error? and the koha error log? Since the db tables are created and populated by the web installer the table does not exist yet so the koha-zebraqueue-output.log is irrelevant at this point imho.. Regards, Koustubha Kale Anant Corporation Contact Details : Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), Maharashtra, India, Pin : 400601. TeleFax : +91-22-21720108, +91-22-21720109 Mobile : +919820715876 Website : http://www.anantcorp.com Blog : http://www.anantcorp.com/blog/?author=2 On Wed, May 12, 2010 at 6:28 PM, <rekhasaraswat(a)cdacnoida.in> wrote: Dear Friends, I have installed KOHA 3.00.04 on Debian machine today. Every thing installed properly, but when i tried to start web installer, i got the following error in koha-zebraqueue-output.log. DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at /usr/share/koha/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/bin/zebraqueue_daemon.pl line 124. any help regarding this would be highly appreciated. Zebra server and client, both are running properly. Regards Rekha _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

2 1

LibLime, a Division of PTFS Announces “Harley”, a New Stable Release of Koha Available for Immediate Download
by Sherman, Kelly 13 May '10

13 May '10

*LibLime, a Division of PTFS Announces “Harley”, a New Stable Release of Koha Available for Immediate Download* LibLime has made available a tested, stable release of Koha for immediate download at http://koha.org/download. LibLime assembled Harley to provide many of the features developed by PTFS over the last 12 months into one stable and tested release that can be used immediately by libraries world-wide. PTFS acquired LibLime in mid-March, 2010 and has been transitioning the LibLime business into its existing PTFS library systems and services organization, all of which will operate under the LibLime brand going forward. While LibLime will be focused for the foreseeable future completing transition tasks to accomplish its contractual obligations, LibLime is committed to open source software, and wanted to make a significant contribution of code made available to the general public in the earliest reasonable timeframe. Harley provides this code as a tested, stable release of Koha that is ready for installation. Harley is the first offering provided by LibLime since the acquisition, less than 60 days ago. LibLime plans to continue to make significant new Koha functionality available to libraries around the world. Enhanced software development resources and the adoption of agile software development processes will allow LibLime to develop significantly more Koha software in the coming year faster and more reliably than was previously possible. This release includes all functionality in Koha as of October 2009, plus many new features not yet available. Harley is compatible with both 3.0x and upcoming 3.2 versions. The code for the individual new features included in this version has also been made available for download from the GIT repository. The features in this release were not ready for 3.2, but, pending acceptance by the 3.4 Koha Release Manager, could be included in release 3.4. The software development effort for Harley has been sponsored by both PTFS as well as multiple library customers. *Harley provides a host of new Koha features to include: *** *Administration* New Granular Permissions *Reports* Multiple Selections in Report Wizards Back Button in Report Creation *Patron and Holds Management* Patron Batch Edit and Batch Delete Patron Improved Searching Patron Hyphenated Name Searching Lost Card Tracking Override Max Fines Track Borrower Changes Borrower History Retention Limit On-Shelf Holds Maximum Fines, Maximum Holds, and Editing of Circulation Rules Predefined Borrower Notes Expired / Cancelled Holds Report and Setting Expiration Dates Display of Hold Expiration Date Allow Multiple Holds on Items for One Title Suspend and Reactivate Holds Hold Display Rules Place Hold Option on Checkout Tab Hold Policies by Patron Category Fees for Holds Turn off Various Hold Trigger Buttons if Desired Block OPAC Renewals for Excessive Fines Copy Patron Record Display Patron Middle Initial Prompt to Save Patron Edits Lost, Claims Returned Display on Patron Record *Fines/Fees* * * Partial Fine Payment Billing Notice and Debt Collection Calculate Fines on Claims Returned Items Pre-Defined Fee Types List Fines by Type on Checkout Tab Block Payment of Outstanding Fines *General Circulation* * * Block Checkout of Items on Hold Backdate Due Dates Change Checkin Date Print Option for Hold and Overdue Notices Item Type Trigger for Hold Notices Renewal Source Fast Adds at Circulation Check In Damaged Clear Borrower Record After Checkout Turn Off Returns Column in Patron Record Display *Cataloging* Batch Item Edit Other Item Statuses Adding Additional Items Copies Item Data In Processing/Shelving Cart Save Import Profiles *OPAC* Bestseller's Club and Email Notifications OPAC Inactivity Timeout Clear Reading History OPAC "Did You Mean" Feature Turn Off My Messaging Tab in OPAC OPAC and Staff Advanced Search Changes Sorting of Item Holdings in Staff and OPAC Rename OPAC Cart Feature as Desired Set Off Shelving Location in OPAC display Turn Off Place Holds Link at Top of OPAC Results List Allow OPAC and Staff to Use Different Settings for Advanced Search Display 866 Summary Holdings Note in OPAC Main Detail Section Control Display of ISBD Tab in OPAC Search by Shelving Location * * *Web-Based Self-Check System* Automated Staff Login The LibLime – PTFS Harley release can be found at http://koha.org/download Release documentation, installation notes and a FAQ list are found at http://koha.org/documentation. *About LibLime, a division of PTFS* LibLime is the global leader in open-source solutions for libraries. Rather than sell software licenses for static, hard-to-customize software products, The PTFS LibLime Division educates libraries about the benefits of open source, enabling them to make choices about how best to provide their communities and staff with better technology services. The PTFS LibLime Division then facilitates deployment of Koha in libraries by providing outstanding consulting, development, implementation, and support/hosting for libraries of all types and sizes. PTFS is also the developer of the world’s leading content management software, ArchivalWare, and specializes in meeting library personnel staffing requirements, digitization, and metadata keying services. For more information, seehttp://liblime.com or http://ptfs.com or http://archivalware.net -- Kelly Sherman PTFS, Inc. (301) 654 - 8088 Ext 176

4 3

Re: [Koha] SIP2/OpenNCIP development (was AGPLv3 discussion)
by Joe Atzberger 12 May '10

12 May '10

> > For example, the SIP2 implementation? > > That points to a problem. Koha's SIP2 implementation is actually a > fork of OpenNCIP [1], and I would like to merge in Koha's changes at > some point and remove the fork. But even if the fork never gets > resolved, there's a problem: OpenNCIP's license is GPL2, not GPL2+. > As GPL2 and GPL3 are incompatible licenses, if we license Koha using > the GPL3+, we couldn't use Koha's SIP2 support code until either > OpenNCIP is relicensed to GPL2+ or we get specific permission from the > original copyright holder (the Georgia Public Library Service). > > [1] http://sourceforge.net/projects/openncip/ I'm working on updating that implementation itself, incorporating many of the changes I previously made on the Koha version (but not all; some are Koha-specific hacks). I've pulled the repo out of it's CVS mausoleum and posted it to github: http://github.com/atz/SIPServer Updates will include 3M's checkin extensions that Koha already enjoys. This repo should serve as the de facto Koha-reconciliation codebase as well. Open to contributions, but the hard part isn't make patches: it's doing real testing with the resulting code. Long-term, I would like to see the perl stuff distributed as a proper CPAN module, but that will be a pain. Our namespace choices have been exceedingly poor, and test coverage is lacking (koha is ahead there). In particular the example ILS abstraction layer (already a poor choice for CPAN distribution) conflicts directly with Koha's self-serving reimplementation in the same namespace. I am responsible for some of that. So someday, I could imagine moving everthing under Business::SIP or OpenNCIP::ILS or similar non-root namespaces. And then, e.g: ILS::Item (example) => OpenNCIP::ILS::Item ILS::Item (Koha) => OpenNCIP::ILS::Item::Koha OpenILS::SIP::Item (EG) => OpenNCIP::ILS::Item::Evergreen Considering "SIP" is unrecognizable to most and also an acronym in VOIP circles, using it as a filename in root cpan namespace is a bad idea. And Sip.pm makes even less sense. Anyway, point being we have a venue for making changes to OpenNCIP, including license update should GPLS approve. --Joe

2 2

Re: [Koha] Authority control
by Amy Schuler 12 May '10

12 May '10

Hi again, Not exactly what I wanted to hear, but thanks for the response, Alejandro. In looking into this problem further, I found mention in the listserve archive of the link_bibs_to_authorities.pl utility. I tried running this and received an error "Can't locate object method "new_from_bib_field" via package "C4::Heading" (perhaps you forgot to load "C4::Heading"?) at /etc/perl/C4/Biblio.pm line 443." Does anyone know what this means? Is this link_bibs utility even a viable option? I am running Koha v. 3.0001005. Thanks as always, Amy Schuler From: tirabo(a)gmail.com [mailto:tirabo@gmail.com] On Behalf Of Alejandro Tiraboschi Sent: Tuesday, May 11, 2010 8:31 PM To: Amy Schuler Subject: Re: [Koha] Authority control Hello: 2010/5/11 Amy Schuler <schulera(a)caryinstitute.org<mailto:schulera@caryinstitute.org>> Hello, For some reason none of my biblios have authorities associated with them. The authority records exist, because I imported them and am able to find them when I search, but they have no biblios associated with them. I wonder why this is (maybe I should have imported the authorities first?) but regardless, this is how it is. Is there an easy way to establish authority control, linking the authorities with the bibs? If I reimport my bibs, will the link between the authorities and bibs be created? I think that there is no a global procedure to link the authorities with the bibs. When you reimport your bibs no links between the bibs and authorities are created. cheers, Alejandro Tiraboschi FaMAF-UNC Thanks! Amy C. Schuler Manager of Information Services Cary Institute of Ecosystem Studies PO Box AB Millbrook, NY 12545 (845) 677-7600 x164 schulera(a)caryinstitute.org<mailto:schulera@ecostudies.org> _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> http://lists.katipo.co.nz/mailman/listinfo/koha

2 1

Activate XSLT?
by Magdalena Söderqvist 12 May '10

12 May '10

Dear Koha-friends, would anyone happen to know WHERE and HOW you set XSLTDetailsDisplay and XSLTResultsDisplay to ON? Do you enter something in the empty boxes in Systempreferences/OPAC, or is it done elsewhere? Current version: 3.00.06.008 Sincerely, Magdalena Söderqvist SIPRI Library -- ***************************** Magdalena Söderqvist Librarian SIPRI Library and Documentation Signalistgatan 9 SE-169 70 SOLNA Telephone: +46 8 655 97 78 Fax: +46 8 655 97 33 E-mail: soderqvist(a)sipri.org *****************************

2 1

Re: [Koha] How to extract data from marcxml.biblioitmes ?
by Vimal Kumar 12 May '10

12 May '10

Dear Daniel, I applied the SQL query in Tools > Reports > Guided Reports Wizard > Create from SQL. I saved the csv file. But CSV file contain the following message, <h1>Koha error</h1> <p>The following fatal error has occurred:</p> <pre><code>Can't use an undefined value as an ARRAY reference at /usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl line 461. </code></pre> <table> Can you check what the problem happened while generating report? Following is the SQL query for the reference of other community members who have interest in this topic, SELECT extractValue(marcxml," collection/record/datafield[@tag='952'][1]/subfield[@code='p']"), extractValue(marcxml,"collection/record/datafield[@tag='024'][1]/subfield[@code='a']"), extractValue(marcxml,"collection/record/datafield[@tag='020'][1]/subfield[@code='a']"), extractValue(marcxml,"collection/record/datafield[@tag='100'][1]/subfield[@code='a']"), extractValue(marcxml,"collection/record/datafield[@tag='245'][1]/subfield[@code='a']"), extractValue(marcxml,"collection/record/datafield[@tag='650'][1]/subfield[@code='a']"), extractValue(marcxml,"collection/record/datafield[@tag='500'][1]/subfield[@code='a]"), extractValue(marcxml,"collection/record/datafield[@tag='520'][1]/subfield[@code='a']"), extractValue(marcxml,"collection/record/datafield[@tag='650'][1]/subfield[@code='a']") FROM biblioitems I request other community members attention to this topic. Regards -- Vimal Kumar V. Asst. Librarian Asian School of Business Technopark, Trivandrum-695 581 Web: www.vimalkumar.co.nr Blog: http://vimalkumar.oksociety.in OK Society Volunteer. http://oksociety.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

1 0

Deleting Sample Data Koha 3.0.0.4
by Sheldon T. 12 May '10

12 May '10

Hello, We have installed Koha 3.0.0.4 along with the sample data that came with it and now we want to get rid of that data and start afresh. Can we safely empty the database without affecting Koha in any way? Regards, Imran Mohamed -- View this message in context: http://old.nabble.com/Deleting-Sample-Data-Koha-3.0.0.4-tp28529269p28529269… Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

KUDOS at ALA 2010
by vtl＠scls.lib.wi.us 12 May '10

12 May '10

We would like to hold a meeting of KUDOS <http://kudos.koha.org/> in conjunction with ALA 2010 in Washington D.C. In order to give us an idea of interest and availability, please complete this Doodle poll by the end of the day, Friday, May 21. The slots are set up in three hour increments. If you are not available during any part of that three hour period, do not check it. http://www.doodle.com/x3csny8n7ynv4wks Thanks, Vicki (on behalf of the KUDOS officers) -- Vicki Teal Lovely Helping our 52 member libraries provide the best possible service to the public. ILS Project Manager South Central Library System Madison, WI vtl(a)scls.lib.wi.us (608)242-4713

3 3

Authority control
by Amy Schuler 11 May '10

11 May '10

Hello, For some reason none of my biblios have authorities associated with them. The authority records exist, because I imported them and am able to find them when I search, but they have no biblios associated with them. I wonder why this is (maybe I should have imported the authorities first?) but regardless, this is how it is. Is there an easy way to establish authority control, linking the authorities with the bibs? If I reimport my bibs, will the link between the authorities and bibs be created? Thanks! Amy C. Schuler Manager of Information Services Cary Institute of Ecosystem Studies PO Box AB Millbrook, NY 12545 (845) 677-7600 x164 schulera(a)caryinstitute.org<mailto:schulera@ecostudies.org>

1 0

How to extract data from marcxml.biblioitmes ?
by Vimal Kumar 11 May '10

11 May '10

Dear Friends, I would like to prepare a report from "marcxml" field in "biblioitems" table. The report should include author, title, subject and abstract. I got some hint from koha wiki page, http://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC But I failed to wrote an SQL query for the purpose. I am not familiar with writing query to extract data from XML part in MySQL. Can you help me to prepare a report from "marcxml" ? If anybody from developers or users give guideline with examples, that will be a good contribution to Koha community. -- Vimal Kumar V. Asst. Librarian Asian School of Business Technopark, Trivandrum-695 581 Web: www.vimalkumar.co.nr Blog: http://vimalkumar.oksociety.in OK Society Volunteer. http://oksociety.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

5 5