- Koha - lists.katipo.co.nz

Patron account created notification mail could not be send
by vishnu varthan 10 Jun '10

10 Jun '10

Hi All, I have some problem in keeping patrons username and password informed for OPAC screen. When i create a new patron i expect koha to send email containing username and password to patron account email address but it is not doing so. i have koha autoemailopacuser set to ON. i even ran process_message_queue.pl cron job (queue table always remains empty) and created notice of type members for this purpose but nothing seems to work as expected. i am using ubuntu 9.10 with sendmail and mailutils. echo mailbody | mail -s subject mailaddress - sends mail to inbox i suspect i am missing some configuration in koha level.Any help to fix this will be appriciated. with regards vishnuvarthan perumal <vishnu(a)e-ndicus.com>

2 2

Re: [Koha] Koha Digest, Vol 56, Issue 13
by Stacy Pober 10 Jun '10

10 Jun '10

Hi Jos, We're using a Koha-like system (Liblime Enterprise Koha, a/k/a LEK), but I think our method would work for you. I've added a lot of ebooks to our catalog. Before I upload the records into the catalog, I pre-process them in MarcEdit. MarcEdit is a free program you can download from: <http://people.oregonstate.edu/~reeset/marcedit/html/downloads.html> or <http://bit.ly/9SOCay> With MarcEdit you can do bulk operations to add fields, delete them, and edit them along with a number of much more sophisticated functions. Install MarcEdit, and open your MRC file. To add a field, you go to Tools->Add/Delete Field In the first box, you type the field name, in the second, you put both the MARC indicators and the subfields. For our ebooks, the 952 data looks like this: \\$aMAN$bMAN$cEBOOKS$oELECTRONIC BOOKS$yEBOOKS$8EBOOKS You can find information on these subfields in the Koha manual at: <http://koha.org/documentation/manual/3.0/cataloging/item-fields-data-migrat…> Although the books are electronic so there is no physical copy, we still fill the subfields for location, sublocation, and call number because we ran into problems when we omitted the $a and $b fields (and you can read about the questions I asked about those fields in this list's archives, I think.) Here are some things to watch out for when processing ebook records : - check that the ebook vendor has given you clean records. I noticed that some of the vendors are not vetting the records properly, and are including 856 fields (Electronic Location and Access) with URL's for other ebook vendors in their records. So there will be the good link to their subscription service and another link to another ebook vendor's version to which that your patrons will have no access. - use the MarcEdit Field Report tool to see there are no anomalies in the records that you might want to clean up. Some of the vendors sent records with occasional 5xx and 9xx fields with data specific to some other library. - consider adding a field with a unique identifier for that ebook set. We add a MARC 500 field with the name of the vendor or the particular book set so that if we want to search in the opac for just a book from that set, we have a way to do that. - consider if there are any fields you want to delete from the record. One of the vendors added four separate fields to each record which happen to mention their company's name. Some of those fields were appropriate, but some seemed to duplicate other fields, so we just removed them. - if you are using the XLST display, then the icons will be mapped primarily to characters in the MARC leader, and will NOT be determined by your ITYPE or CCODE designations. This may cause some confusion. We found that some vendors correctly changed the leaders to show that these were books in electronic format. Springer Verlag uses leader codes that indicate that the books are actually non-text computer files. Another ebook vendor used leader codes that erroneously indicated that the ebooks were actually print books in paper format. You can change the leader codes in MarcEdit if there's a problem and you're using the XSLT display - use the MARC Validator tool in MarcEdit to look for errors in the records. One warning about that, though: the tool is extremely strict, so you might want to go into the marcrules.txt file that it uses and actually loosen the validation rules. A specific example is that many MARC records from ebook vendors include a notation in the 020 field as to whether the ISBN listed is for the paperback, hardbound, or electronic version. These will generate an error using the default marcrules file for validation, so I changed that rule. - if you use a proxy server such as EZproxy for off-site access to the ebooks, you can use MarcEdit to add the proxy server prefix to the URL field $856$u of each item. You would use Tools->Edit Subfield Data for that. MarcEdit is a wonderful tool for batch editing MARC records. It's powerful and flexible and there is a nice email listserv for support. It's not open source, but it is free. There are youtube videos that Terry Reese has put up to help people learn how to use the program. It's a reasonably user-friendly program, but for mastering some of the functions, I found the videos very helpful. After you've made the changes you want to the file in MarcEdit, you can upload the batch with the new 952 fields, etc. and they should not have the same problems you're seeing now. You may find that your ebook vendor gives you updates that are additional records, but some of the vendors also do deletions, which gives you two choices. When your collection changes, you can either use the Undo Import function to remove the initial upload, then upload the new version. Or, you can add the new titles, and then manually delete any records for books or editions that the vendor is no longer offering. I think using the Undo Import and just re-loading the new batches is the easy course for updates, but unfortunately, we will not have that as an option. LEK is in constant development and testing mode and here is some new software in the next release that did not work well in testing with the batch upload "undo" feature that is standard in open-source Koha. The vendor is removing the "Undo Import" function as a result. Since most of the books I uploaded were on subscription rather than permanent purchases, this means I'm going to have a lot more hassle when we need to remove the batches. Without 'undo import' removal will require a special request to LEK support for manual removal, and I can't even contact them directly. So, I'm going to miss the undo import feature. Ebrary supplies the largest number of ebooks to us and they recently contacted me to say that they'd fixed some problems I reported and now have improved versions of their MARC records available for download (there were bad diacritics in the batches we used). In the past, I would have taken out the old batches and uploaded the new versions, since it was so easy. Now, I'll probably stick with the version we have since removing batches is not available to LEK end-users. Since you're using the free, open source version of Koha so if you need to update the ebook holdings you can just undo the old batches and replace the records pretty easily. One more thing: if you are replacing an old batch of ebook records with an updated file, I would not use the "record matching rule" to replace old versions with new ones. Unfortunately, some of the ebook vendors do not supply unique ISBN numbers for their electronic version of a paper book. If you use the ISBN as your matching rule and you have a record for the paper version of the book already in the catalog, you may overwrite that record with the ebook record. I hope you find this information helpful. -- Stacy Pober Information Alchemist Riverdale, NY 10471 stacy.pober(a)manhattan.edu On Mon, Jun 7, 2010 at 4:10 PM, <koha-request(a)lists.katipo.co.nz> wrote: > Message: 3 > Date: Mon, 7 Jun 2010 11:08:57 +0100 > From: Jos Black <jos.kohado(a)gmail.com> > Subject: [Koha] Items for bulk ebook MARC records > To: koha(a)lists.katipo.co.nz > Message-ID: > <AANLkTikzbbvQkQ3izoKETFplfmuzjTO53OXxd5XesU2F(a)mail.gmail.com> > Content-Type: text/plain; charset="windows-1252" > > Hello > > This is my first question to the list since introducing myself a few months > ago, > so please forgive me if I?m asking a silly question, but I haven?t yet been > able to find an > answer out there. > > I?m currently trying to set Koha up as a catalogue and access gateway to our > eresources collection, as our current (proprietary) library system is a > nightmare to import anything into. As a first attempt I have successfully > imported nearly 3000 MARC21 bib records from one of our ebook suppliers into > a > test install of Koha (3.00.00.107, hope to upgrade soon!). However, when I > search for any of the titles in the OPAC, I get the ?Availability? message > ?No > items available? in the brief results, and in the detail holdings tab I get > ?No > physical items for this record?. The MARC records as supplied don?t have > any > item data, either in the Koha 952 item tag, or even item data I could map > across > in the 852, and I?m yet to hear from the supplier that they can supply item > data. > > These messages will be off-putting for most of our readers, many of whom are > new > to using libraries, and the vast majority probably won?t ask for help, so I > need > to find a way to sort this out. > > How could I tackle this apart from a huge effort in reader education, > modifying > my copy of Koha, or individually creating thousands of items? I have a > couple > of ideas but don?t want to reinvent the wheel so would truly appreciate your > help. > > Thanks! > Jos

1 0

KUDOS at ALA
by vtl＠scls.lib.wi.us 09 Jun '10

09 Jun '10

There will be a KUDOS meeting at ALA at 11am on Monday, June 28. Location is still being determined, but there will be one! As of right now, there is no formal agenda. We will probably develop the agenda at the meeting so be prepared to bring topics to discuss. KUDOS <http://kudos.koha.org/> is a group of individuals that are interested in promoting the use of Koha in the United States. Vicki -- 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

1 0

bad records (error 404)
by Amy Schuler 09 Jun '10

09 Jun '10

Hello, I have two bad records in my Koha database; actually they are error 404s and not real records at all. Therefore, I am unable to delete them the usual way (deleting attached items followed by deleting the entire record). Does anyone know what table these records live in? I am running Koha v. 3.0001005. Thanks, Amy 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>

2 1

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