- Koha - lists.katipo.co.nz

Upgrade from Koha 3.00.01 to 3.4 on Debian
by David Whelchel 25 Aug '11

25 Aug '11

Hi All, Is here a direct upgrade path from Koha 3.00.01 to 3.4 on Debian? I know that the link http://koha-community.org/documentation/faq/installingupgrading/ does not contain any information. Also the INSTALL.debian file suggests running ./koha_perl_deps.pl that does not appear to exist in the 3.00.01 environment. A step-by-step upgrade guide would be very helpful. Thanks Dave ------------------------------------------------------------------------------- David L. Whelchel 725 SE Derby Street Pullman, WA 99163 whelchel(a)pullman.com<mailto:whelchel@pullman.com> http://www.dlwa.com

2 1

Issue in starting koha and apache
by deepak.bhatia 25 Aug '11

25 Aug '11

Hi, I followed all the steps in INSTALL.ubuntu for installing Koha. Then restarted the machine, then I following errors *koha@10:~/koha-3.2.10$ sudo -u koha zebrasrv -f /etc/koha/koha-conf.xml* 12:32:25-25/08 [log] zebra_start 2.0.44 419ad759807269fdfa379799a051ed3a551c6541 12:32:25-25/08 [log] config /etc/koha/zebradb/zebra-biblios.cfg 12:32:25-25/08 [log] Loaded filter module /usr/lib/idzebra-2.0/modules/mod-alvis.so 12:32:25-25/08 [log] Loaded filter module /usr/lib/idzebra-2.0/modules/mod-grs-xml.so 12:32:25-25/08 [log] Loaded filter module /usr/lib/idzebra-2.0/modules/mod-dom.so 12:32:25-25/08 [log] Loaded filter module /usr/lib/idzebra-2.0/modules/mod-grs-regx.so 12:32:25-25/08 [log] Loaded filter module /usr/lib/idzebra-2.0/modules/mod-grs-marc.so 12:32:25-25/08 [log] Loaded filter module /usr/lib/idzebra-2.0/modules/mod-text.so 12:32:25-25/08 [fatal] lock file /var/lock/koha/zebradb/biblios/zebrasrv.pid [No such file or directory] *koha@10:~/koha-3.2.10$ sudo apache2ctl restart* apache2: Could not reliably determine the server's fully qualified domain name, using 10.0.1.228 for ServerName -- View this message in context: http://koha.1045719.n5.nabble.com/Issue-in-starting-koha-and-apache-tp47340… Sent from the Koha - Discuss mailing list archive at Nabble.com.

3 2

Not able to installation of Koha on ubuntu
by toreachdeepak 25 Aug '11

25 Aug '11

Dear All, I am wondering, if it is difficult to install the Koha on Ubuntu or any other linux. I have been trying for the last one week and I am not getting the initial screen of the Koha. Please share with me the correct steps for installation. Regards Deepak Bhatia -- View this message in context: http://koha.1045719.n5.nabble.com/Not-able-to-installation-of-Koha-on-ubunt… Sent from the Koha - Discuss mailing list archive at Nabble.com.

1 1

Migration from 2.2.5 to 3.4 - call numbers and item update
by Peter Thompson 25 Aug '11

25 Aug '11

Thanks to Everyone who replied - the system is now coming together . I upgraded to 3.00 and imported the database, and followed the processes outlined in the http://wiki.koha-community.org/wiki/Upgrading_2.2 document. I have two remaining issues: In the Mysql database (prior to running any scripts etc), the call numbers seemed to be in the 082 field, judging by the contents of the `tag` and `subfieldvalue` fields of the `marc_subfield_tag' file, not in the `itemcallnumber` field of the `items` file. After running the process detailed in the upgrade document, the call numbers dont' appear in the catalogue. They seem to have been moved to a file ' temp_upg_biblioitems_call_num. Any advice on how I can get these call numbers indexed properly? Also, when I try to add an item, the process fails with an error. In the error log, it refers to the record wrapper missing at /usr/local/share/perl/5.10.1/MARC/file/XML.pm. Thanks again, Peter Thompson Whenever I add an item Peter Thompson Database Administrator Information Technology & Communications Unit

1 0

Re: Report Help
by Msgr. Marion J. Makarewicz 25 Aug '11

25 Aug '11

Perhaps this can help set up where 5 is the number of years you choose. The YEAR() function trims the dates returned in the datelastborrowed field and NOW() gives the present date. CURDATE() also is a possible function to use. DATEDIFF() can give you the difference in days. SELECT b.title, b.author, b.copyrightdate, i.itemcallnumber, i.barcode, i.datelastborrowed, i.issues as totalcheckouts, i.dateaccessioned FROM items i LEFT JOIN issues USING (itemnumber) LEFT JOIN biblio b USING (biblionumber) WHERE i.itemnumber NOT IN (SELECT issues.itemnumber FROM issues) AND YEAR(NOW())-YEAR(i.datelastborrowed) > 5 UNION SELECT b.title, b.author, b.copyrightdate, i.itemcallnumber, i.barcode, i.datelastborrowed, i.issues as totalcheckouts, i.dateaccessioned FROM items i LEFT JOIN issues USING (itemnumber) LEFT JOIN biblio b USING (biblionumber) WHERE i.itemnumber NOT IN (SELECT old_issues.itemnumber FROM old_issues) AND YEAR(NOW())-YEAR(i.datelastborrowed) > 5; Marion > Can someone help me out here. I need to alter this to show only titles >that haven't circulated in X number of years.

2 1

Koha - cataloging statistics
by Linda Culberson 25 Aug '11

25 Aug '11

All, We are required to keep detailed cataloging statistics for performance standards reporting. So I have cataloging logging turned on, even though it is not recommended. I've written php scripts that query by a range of dates to return the number of biblios added, biblios modified, and items added by each cataloger. My problem is with item modification, since Koha seems to mark an item as modified in the action_logs in the cataloguing module when it is simply checked in and out. I have modified my queries to filter those out (I think), but was wondering if anyone else has a similar requirement and has already come up with a better solution. Thanks! -- Linda Culberson lculber(a)mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Fax: 601/576-6824

2 1

importing Library of Congress authority records
by Linda Culberson 25 Aug '11

25 Aug '11

All, Has anyone tried importing Library of Congress authorities into Koha? We are considering purchasing the retrospective subject authorities, so while it would be a great many records (353,000 records), it wouldn't be the full database. -- Linda Culberson lculber(a)mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Fax: 601/576-6824

2 1

ByWater Solutions - seeking a Perl developer for Support Desk.
by Brendan Gallagher 24 Aug '11

24 Aug '11

Hi All (nice and brief) - We are a small company that is based in Santa Barbara, CA. We are looking for a perl programmer that would help man our support helpdesk. We mainly work on Koha (http://koha-community.org) We are fine with someone working from home. Ideally this person would be comfortable reading others code and fixing bugs. (We are small and growing - so this job does have potential to grow into a development position beyond support needs at first) Just a little bit about our company - http://bywatersolutions.com If you know of anyone who is looking for a job please forward this email along. Thanks much, Brendan Gallagher CEO ByWater Solutions

1 0

Equinox job posting - Library Data and Support Specialist
by Galen Charlton 24 Aug '11

24 Aug '11

Equinox Software, a growing and dynamic software development and support company based in Norcross, Georgia, is seeking a talented and dedicated Library Data and Support Specialist. This position is responsible for extracting, translating, munging, and loading library data as well as providing general Evergreen and Koha technical support to our customers. We are looking for the following qualities in a candidate: * Familiarity with library operations and practices, particularly technical services and library systems administration * Experience with library data formats, including ISO 2709. * Experience operating or managing an integrated library system is required * Experience with Evergreen and/or Koha is preferred * High comfort level with Linux, a shell prompt, scripting, SQL, and programming * The ability to communicate effectively both orally and in writing * Strong customer service focus * Ability to work well in a team environment with minimum direction A MLS or equivalent is helpful, but not required * Summary of essential job functions: * Performing analysis of legacy data and helping to advise customers on the best way to migrate and manipulate their data to a new ILS. * Performing data extracts, data translation, and data cleanup as part of larger projects to implement a new ILS and assist with policy configuration. * Performing special data change and data cleanup projects. * Providing excellent technical support to Equinox customers The ideal candidate is prepared not only to help our customers migrate to a new ILS, but to also help create and maintain the tools to make this process as efficient and painless for our customers as possible. Equinox offers a strong benefits package including family health, dental, and vision insurance, fully paid for by the company. We also offer a 401k plan with matching contributions. Salary starts at $40,000 a year but is negotiable and commensurate with experience. Please send your resume, 3 professional references, and salary requirements to careers(a)esilibrary.com About Equinox Equinox Software is a growing team of skilled professionals who provide comprehensive support and services for open source solutions for public, special, and academic libraries worldwide. Equinox offers consultation, software development, comprehensive support and training, migration and data services. -- Galen Charlton Director of Support and Implementation Equinox Software, Inc. / Your Library's Guide to Open Source email: gmc(a)esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org -- Galen Charlton Director of Support and Implementation Equinox Software, Inc. / Your Library's Guide to Open Source email: gmc(a)esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org

1 0

Installed Koha 3.2.10 - Error Message
by deepak.bhatia 24 Aug '11

24 Aug '11

Hi, I installed the Koha 3.2.10 but I am getting the below error message Access denied for user 'root'@'localhost' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 692. Compilation failed in require at /usr/share/koha/lib/C4/Auth.pm line 33. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 33. Compilation failed in require at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 23. BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 23. Regards Deepak Bhatia -- View this message in context: http://koha.1045719.n5.nabble.com/Installed-Koha-3-2-10-Error-Message-tp473… Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1