- Koha - lists.katipo.co.nz

importing items with records
by vishnu varthan 09 Jun '10

09 Jun '10

Hi all, I have book details in csv and i managed to converted into marc format using Custom script and MARC::RECORD 2.0 Perl library.I can import record successfully now however i could not figure out importing items with records. Script i use for converting csv to marc record is hosted here http://pastebin.com/UuAgbEFw I would like to know what change in need to do for this. with regards vishnuvarthan perumal vishnu(a)e-ndicus.com http://e-ndicus.com

2 1

Resend: Runtime Error on patron name search with new KOC
by Richard Pritsky 09 Jun '10

09 Jun '10

No response yet...resubmitting... Thanks! ---------- Forwarded message ---------- From: Richard Pritsky <rpritsky(a)gmail.com> Date: Wed, Jun 2, 2010 at 10:59 AM Subject: Runtime Error on patron name search with new KOC To: koha(a)lists.katipo.co.nz I fear I'm being dense with the new Offline Circulation program. --It appears to install successfully on XP, Vista, and 7. --I create the borrowers db with the sqllite3 switch and copy it to the PCs. --The app opens fine... but when I go to search for a patron, the menu pops up, I enter the name, click the search button and I get Runtime Error! Program.....\KohaOfflineCirculation.exe This application has requested the Runtime to terminate it in an unusual way. Pleas contact the application's support team for more information. What am I missing? Btw, the older version works fine on all of our PCs. Any help appreciated! :) Richard vokal

2 1

biblio.frameworkcode set up at import
by Frédéric Rouyre 08 Jun '10

08 Jun '10

Hi, I've tried to set up the biblio.frameworkcode at import time by setting up a link between the 099$e subfield and biblio.frameworkcode in koha. But it seems this fields in not updated in either way. Even if i create a new non-default notice and that I export the notice, the 099$e subfield is not created in the export files (marcxml, ...). Do i miss something? I'm using koha-3.00.06. Best Regards, Frédéric

1 2

Steps on how to borrow a book in OPAC (KOHA ILS)
by bariki.kamara＠out.ac.tz 08 Jun '10

08 Jun '10

Hi all, Hope you are doing fine. Can any one send me the steps on how to borrow a book as patron in KOHA OPAC. Regards, Bariki G. Kamara ---------------------- CONFIDENTIALITY NOTICE -------------------------------- PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL This email is intended only for the person to whom it is addressed and may contain confidential information and may be legally privileged. If you are not the intended recipient, you are notified that you may not use, distribute or copy this document in any manner whatsoever. Kindly also notify the sender by email and/or delete this e-mail. Any views or opinions expressed in this e-mail are those of the sender and do not necessarily coincide with those of the Open University of Tanzania. --------------------THE OPEN UNIVERSITY OF TANZANIA--------------------------

2 1

Granthalaya.org announcement of Koha hosting service
by Koustubha Kale 08 Jun '10

08 Jun '10

Friends, Granthalaya.org ( www.granthalaya.org ) and Anant Corporation ( www.anantcorp.com ) are very pleased to announce general availability of Koha hosting on granthalaya.org server located in VPM, Thane ( www.vpmthane.org ) datacenter. Our first user of this service is already live, please see opac.kalibindia.com This initiative is to provide a revenue stream for sustained operation and maintenance of the Granthalaya.org project ( which is a project of Vidya Prasarak Mandal, Thane; an educational trust.) which intends to create bibliographic union database of holdings of all the public libraries in Konkan area including Thane in India. Granthalaya.org also intends to help libraries in computerizing their holdings by providing them hosted / local installation of Koha, user training and data migration services. Key features of this offering are.. * Independent install of Koha version of your choice on a shared Ubuntu server. * Full access to your home directory and Koha code. * Separate mysql database. Full access via phpmyadmin. * Separate Zebra database * Installation, Initial setup and NBD Annual Support included. * Can offer customization, data migration and user training services if required. * Nightly full dump of database in your home directory with backup to disk and tape. * We are open to discuss any additional requirements Initially we are offering this service at USD 250 for initial setup (one time charge) + USD 350 as Annual Recurring fees. Please contact me if you would like to avail this offer or to help the Granthalaya.org project in any manner. 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

1 0

in-house use
by Kohn, Karen 08 Jun '10

08 Jun '10

Hello, I am trying to run a report on in-house use of books, and the manual does not have much information. (http://koha.org/documentation/manual/3.0/circulation/tracking-inhouse-u se) We are using the statistical patron called In-House Use, but when I try to run a report from the Reports Wizard, I don't know what options to select. Could someone provide more detail? Thanks. We are using Koha 3.01.00.061. Karen Kohn Collection Development Manager Landman Library Arcadia University 450 S. Easton Road Glenside, PA 19038 ph: 215-572-8528 fax: 215-572-0240

3 2

Call for Koha Newsletter Articles
by Nicole Engard 08 Jun '10

08 Jun '10

Hello all, It's that time again, time to gather up all your Koha news (big and small) and send them to me for publication in our next issue of the Koha Newsletter. Articles can be as short as 1 line and as long as 20 (with links to read more content). They should include news about our Koha library, features you're working on, tips & tutorials you want to share. In short the sky's the limit. Please email me your articles by the 12th of June so that I can edit everything and get it organized for the June 15th release. Past newsletters can be found here: http://koha-community.org/category/koha-newsletter/ and you can subscribe to updates via RSS: http://feeds.feedburner.com/KohaNewsletter Thanks in advance, Nicole C. Engard Koha Documentation Manager/Newsletter Editor

1 1

Update errors
by bariki.kamara＠out.ac.tz 08 Jun '10

08 Jun '10

Hi all, Hope you all are pretty fine. Am trying to upgrade my Koha System version, from version 3.00.00.107 to version 3.00.05.003. As Web Installer tried to update database Am getting the following errors below; Update errors : * [Wed Jun 2 23:35:40 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AllowRenewalLimitOverride' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase30.pl line 416. * [Wed Jun 2 23:35:40 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'reserves-HOLD' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase30.pl line 430. * [Wed Jun 2 23:35:40 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '4' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase30.pl line 434. * [Wed Jun 2 23:35:40 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '4-sms-0' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase30.pl line 435. * [Wed Jun 2 23:35:40 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '4-email-0' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase30.pl line 436. * [Wed Jun 2 23:35:40 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate key name 'issn' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase30.pl line 443. * [Wed Jun 2 23:35:40 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '1-override_renewals' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase30.pl line 500. * [Wed Jun 2 23:35:41 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'RenewalPeriodBase' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase30.pl line 548. Continue to log in to Koha. What Should I do to fix these errors. Thanx for your cooperation, Regards, Bariki G. Kamara ---------------------- CONFIDENTIALITY NOTICE -------------------------------- PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL This email is intended only for the person to whom it is addressed and may contain confidential information and may be legally privileged. If you are not the intended recipient, you are notified that you may not use, distribute or copy this document in any manner whatsoever. Kindly also notify the sender by email and/or delete this e-mail. Any views or opinions expressed in this e-mail are those of the sender and do not necessarily coincide with those of the Open University of Tanzania. --------------------THE OPEN UNIVERSITY OF TANZANIA--------------------------

4 7

ILS Survey Pt. 2
by Vandana Singh 07 Jun '10

07 Jun '10

*Greetings! * *This is a call for participation in a survey about technical support for your Integrated Library System. This survey is part of a research project, funded by IMLS, comparing the technical support of Open Source Integrated Libary Systems with technical support of proprietary Integrated Library Systems. This is the second survey for the project. In first survey we collected data regarding expectations of libarians for the technical support of thier ILS. If you participated in that survey Thank you very much for your participation. We really appreciate the informative, quick and large number of responses we got!!! Now, we invite you to participate in the second survey which is assessing the effectiveness of your current ILS technical support. We will then compare this current status to the expectations to idenify any gaps or accolades!* *If you are willing to participate in this study and fill the survey, please follow the link below:* *ILS Survey* * More information about the project and progress updates can be found at ** www.oss-research.com* <http://www.oss-research.com/>*. If you know of anyone who would be interested in the study or taking the survey please direct them to our site where they can fill the public survey. * *You can also direct any queries or suggestions to ** utk.ils.research(a)gmail.com* <utk.ils.research(a)gmail.com>* with the subject “ILS Survey” in the subject line. We really appreciate your time and support and look forward to reporting back the results from this study! * *Cheers, The OSS Lib Tech Team* *Principle Investigator Vandana Singh Assistant Professor, School of Information Sciences, University of Tennessee Knoxville, 449 Communications Bldg. 1345 Circle Park Drive Knoxville, TN 37996-0341 Email: **vandana(a)utk.edu* <vandana(a)utk.edu> *Website: **www.vandanasingh.com* <http://www.vandanasingh.com/>

1 0

Migration to Koha and Koha field/UNIMARC mapping
by Frédéric Rouyre 07 Jun '10

07 Jun '10

Hi, I'm trying to switch our old ILS to Koha but I'm stuck with how I'll import Serials in the system. The information I have in the old database is rather sparse but I have a value I don't know how to map. I have a publication date, which is normally linked to one item notice (and not a serial notice). The problem is there is no mapping in the koha standard (sample?) UNIMARC definition. Moreover, I don't know which koha field to map to? I've found "timestamp" and "dateaccessioned" but do not know which one to choose and if i'm in the right direction. I plan to add a 995$w field to map to the koha field. I have to admit i'm computer scientist only ... and that the person who manage the old ILS is not a librarian, so I'm on my own to handle the issues. Hope you can help! Thanks a lot! Regards, Frédéric

2 4