- Koha - lists.katipo.co.nz

Uploading of Single Patron Image
by Sandeep Bhavsar 15 Nov '13

15 Nov '13

Respected All I am trying to upload the single patron image ( Koha 3.10.04.000) but getting the error as *"Image not imported because this patron does not exist in the database"* whereas if I click on the cardnumber Koha is redirecting me to patron details means data is exist in the database. I have search for this on google and found http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=14327 my error log is showing that : ======================================= :24 2013] [error] [client 10.1.6.30] [Fri Nov 15 17:16:24 2013] picture-upload.pl: Database returned error: Cannot add or update a child row: a foreign key constraint fails (`koha_koha`.`patronimage`, CONSTRAINT `patronimage_fk1` FOREIGN KEY (`cardnumber`) REFERENCES `borrowers` (`cardnumber`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/intranet/cgi-bin/tools/picture-upload.pl line 267., referer: http://10.1.6.14:9001/cgi-bin/koha/tools/picture-upload.pl [Fri Nov 15 17:16:52 2013] [error] [client 10.1.6.30] [Fri Nov 15 17:16:52 2013] circulation.pl: Use of uninitialized value in string eq at /usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 170., referer: http://10.1.6.14:9001/cgi-bin/koha/tools/picture-upload.pl [Fri Nov 15 17:16:52 2013] [error] [client 10.1.6.30] [Fri Nov 15 17:16:52 2013] circulation.pl: Use of uninitialized value in concatenation (.) or string at /usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 649., referer: http://10.1.6.14:9001/cgi-bin/koha/tools/picture-upload.pl =================== Please guide. -- *Regards* B.com, M.Lib.I.Sc SET, M.Phil, American Library Association - FERA 2011 fellow Librarian Dr. V N Bedekar Institute of Management Studies Thane (W) 400601 Mumbai INDIA Mobile : 9987049099 www.vpmthane.org

2 1

Follow up: Emergency medical info for the Philippines
by Fred King 15 Nov '13

15 Nov '13

Possibly the last I'll post on post-typhoon assistance: The Ovid/Wolters Kluwer web site has some expert searches on medical aspects of disaster relief. Michelle Brewer is delighted that her information is getting out to its intended audience, and will be happy to do more. Contact her at the address below. --Fred >If there are ANY other expert searches the Koha list recommends, please let them >know I can do them. Just have them send me their search topics. >Michelle M. Volesko Brewer >Librarian/Market Intelligence Manager >Wolters Kluwer Health Medical Research | Marketing Dept. >646-674-6471 tel >646-660-5817 mobile >mmvbrewer(a)verizon.net

1 0

Request
by k upender reddy 15 Nov '13

15 Nov '13

please send me koha instalation ppts with regards upenderreddy

2 1

Software errors while searching webopac by author field
by Shiva Kumara 15 Nov '13

15 Nov '13

Hi Koha forum members, Anyone can resolve the following typical problem about koha web opac search by author. We had installed koah 3.12.06 on ubuntu, we noticed that while searching webopac by author field got software errors. But we noticed small “a” prefixed with author name, if we go search like “aAuthor” then only search results are positive. What could be the problem? Kindly guide us to resolve the typical problem. We hope will get positive reply from the forum members, -- ***With Regards*** Shivakumara RM Digital Library Analyst Institute for Social and Economic Change Dr. VKRV Rao Road, Nagarabhavi, Bangalore - 560 072 https://sites.google.com/site/shivakumararm/<http://sites.google.com/site/aigslibrary> <https://sites.google.com/site/shivakumararm/>

2 2

OT: Resources for the Philippines
by Fred King 14 Nov '13

14 Nov '13

Thoroughly off-topic, for which I apologize, but since the list's subscribers are all over the world some of you may know of libraries in the Philippines that would benefit from this. --Fred -----Original Message----- From: Discussion list for registered DOCLINE users. [mailto:DOCLINE-L@LIST.NIH.GOV] On Behalf Of NLM DOCLINE (NIH/NLM) Sent: Tuesday, November 12, 2013 8:29 AM To: DOCLINE-L(a)LIST.NIH.GOV Subject: [DOCLINE-L] Resources for the Philippines All, The National Library of Medicine announces the activation of the Emergency Access Initiative in support of medical efforts in the Philippines and surrounding areas following the devastating typhoon. The Emergency Access Initiative is a collaborative partnership between NLM and participating publishers to provide free access to full-text articles from over 650 biomedical serial titles and over 4,000 reference books and online databases to healthcare professionals and libraries affected by disasters. The Emergency Access Initiative serves as a temporary collection replacement and/or supplement for libraries affected by disasters that need to continue to serve medical staff and affiliated users. It is also intended for medical personnel responding to the specified disaster. EAI is not an open access collection - it is only intended for those affected by the disaster or assisting the affected population. If your library is working with a library or organization involved in relief efforts in the Philippines or other affected areas, please let them know of this service. Emergency Access Initiative: http://eai.nlm.nih.gov NLM thanks the participating publishers for their generous support of this initiative: American Academy of Pediatrics, American Association for the Advancement of Science, American Chemical Society, American College of Physicians, American Medical Association, American Society of Health-Systems Pharmacists, ASM Press, B.C. Decker, BMJ, EBSCOHost, Elsevier, FA Davis, Mary Ann Liebert, Massachusetts Medical Society, McGraw-Hill, Merck Publishing, Oxford University Press, People's Medical Publishing House, Springer, University of Chicago Press, Wiley, and Wolters Kluwer. Sample journal titles: . Accident and emergency nursing . Annals of internal medicine . Archives of surgery . Burns . Depression and anxiety . Disaster medicine and public health preparedness . Environmental toxicology and pharmacology . International journal of cardiology . International journal of infectious diseases . JAMA : the journal of the American Medical Association . Journal of emergency medicine . Journal of traumatic stress . Lancet . New England journal of medicine . Surgery Sample book titles: . Merck manual of diagnosis and therapy . Public health & preventive medicine . Trauma . Handbook of critical care . Human virology . Infectious diseases: the clinician's guide to diagnosis, treatment and prevention . AHFS drug information Online databases: . Cochrane database of systematic reviews . DynaMed . Essential Evidence Plus For questions regarding the Emergency Access Initiative, please email custserv(a)nlm.nih.gov or call 1-888-346-3656 in the United States, or 301-594-5983 internationally. - Maria National Library of Medicine US: 1-888-FINDNLM (press 2) Intl: 301-594-5983 (press 2) NOTE: This e-mail was sent from a notification-only address. To obtain DOCLINE customer support, please complete the relevant form by clicking Contact Us in DOCLINE or send an e-mail message to custserv(a)nlm.nih.gov

4 3

Additional Emergency Medical Info Resources for Philippines
by Fred King 14 Nov '13

14 Nov '13

Here's additional emergency medical information for the Philippines. It's IP-validated, and available for 60 days. Fred -----Original Message----- From: Medical Libraries Discussion List [mailto:MEDLIB-L@list.uvm.edu] On Behalf Of mmvbrewer Sent: Wednesday, November 13, 2013 3:29 PM To: MEDLIB-L(a)LIST.UVM.EDU Subject: Emergency Medical Info Resources for Philippines Dear Colleagues: (Apologies for cross posting.) Please help us get the word out. If you have a clinical colleague or know a medical library group or health institution in the Philippines, please forward this message to them. In support of disaster relief efforts following typhoon Haiyan let them know: 1. Wolters Kluwer Health (WKH) Emergency Resources Portal http://demo.ovid.com/demo/philp1/philp1.htm is IP-validated for the Philippines, and available to hospitals, institutional libraries and other healthcare entities supporting the disaster relief efforts. It includes Ovid MEDLINER, LWW Total Access journal collection and several eBook collections for Emergency Medicine, Trauma etc. Immediate access, available for 60 days 2. WKH is participating in NLM's Emergency Access Initiative (EAI) http://eai.nlm.nih.gov providing more than 40 Lippincott Williams & Wilkins journals from November 11, 2013 - December 8, 2013. 3. Expert searches for post-Typhoon clinical needs are available for Ovid MEDLINE at: http://demo.ovid.com/demo/philp1/philp1.htm Topics include Tetanus; Dysentery; diarrhea in adult and child; bacterial, viral, respiratory or parasitic diseases, PTSD, vaccinations, etc. IP authenticated for region. If your hospital or organization is assisting with relief efforts in the Philippines, please contact Ovid Customer Support at support(a)ovid.com to learn more about the emergency resource access. WKH offers our deepest sympathies to the people suffering from this unprecedented natural disaster. Michelle M. Volesko Brewer Librarian/Market Intelligence Manager Wolters Kluwer Health Medical Research | Marketing Dept. 646-674-6471 tel 646-660-5817 mobile michelle.brewer(a)wolterskluwer.com

1 0

North American Users Group
by Brendan Gallagher 14 Nov '13

14 Nov '13

Hello All - Can anyone that is interested in setting up a users meeting in North America for sometime next year - please contact me (you can reply here or to me directly). I'd like to put a little group together to plan something like this out. I am willing to put the group together and provide conference lines,etc. (perhaps with the first meeting in a few weeks) But I really want this to be lead by the users and not a support company. So I'll help as much as I can - but I'm looking for a librarian and/or a group of librarians that want to take the lead and get this going. As I said earlier, I will be happy in leading setting up a hackfest. Thanks, Brendan -- --------------------------------------------------------------------------------------------------------------- Brendan A. Gallagher ByWater Solutions CEO Support and Consulting for Open Source Software Installation, Data Migration, Training, Customization, Hosting and Complete Support Packages Headquarters: Santa Barbara, CA - Office: Redding, CT Phone # (888) 900-8944 http://bywatersolutions.com info(a)bywatersolutions.com

2 1

Summary of Open session at KohaCon13 - with a focus on Funding the Future of Koha.
by Brendan Gallagher 13 Nov '13

13 Nov '13

Hello All - I’d like to give a summary of a open discussion that occurred at KohaCon14 in Reno. A spot opened up from a presenter not being able to attend - so I volunteered to lead a discussion on Funding the future of Koha. First we invited all current and past RM’s of Koha up to the front of the room, to educate the audience on some of the “plumbing” needs in the code. When I use the term “plumbing” - I really mean portions of the code that need to be “rewritten”, “updated for current coding practices”, and a “plan for placing newer technologies and practices into the code”. Mainly plumbing = what do we need to get completed in the near future and how are we going to get that done. Many of these “needs” are larger projects that not a single organization or library can fund, as we would really need to dedicate an expert programmer some uninterrupted time to accomplish these goals. Not one support vendor can brunt the front of the plumbing needs that need to happen. We need to work together to fund this and we need to have a place and plan going forward "now". Let's do this for Koha! Points that were raised. Many attendees felt that a clear plan on what path Koha should be developing towards would be a useful project. Although setting a ridged path is a difficult thing with a community like ours, maybe a place for everyone to get or stash ideas for future paths would be a good thing to organize. An important comment here from the attendees was that when someone is funding a development - they should not just fund the code, but also plan for time and funding for the Sign-Off process and the QA process. Funding and how would we organize this? Since many in the audience were from the USA - there was discussion of getting a users group going again OR creating some sort of “non-profit like org” where libraries could pool funding towards projects. An organization like this would be able to apply for grants etc. Something where we could crowd-source funding and then fund a developer for a number of hours towards a project. My thoughts on some things that we can do in the USA. Have a hackfest in Athen’s Ohio next summer. Next year will be 10 years since Koha migrated to the US and I think it’s about time we have a hackfest here. I have briefly talked with Owen Leonard about putting this together for next summer and would love for help and encourage those from overseas to join us. (Also a commitment here that we will be sending a few employees to the France Hackfest in March and will continue to do this every year that we can - that also being right around a feature freeze for releases it's important to have a solid week dedicated to hacking koha only) Gauge the interest of a North American Koha users group so at least we are having more of the community meeting together and sharing practices and ideas. Comments from Galen "As far as a US or North American user group goes: I think a relaunch should start off with just the goal of hosting a US/NA conference, as it would /not/ be necessary to set up a nonprofit first to run conferences. We'd just need willing hosts and, if necessary, a firm willing and able to act as a fiscal agent. That's not to say that such a group couldn't pursue nonprofit status later, but we can get a lot of education and user-connecting done without ever having to have a formal organization." Thanks all - this is to promote discussion and hopefully we can all do this together! Brendan -- --------------------------------------------------------------------------------------------------------------- Brendan A. Gallagher ByWater Solutions CEO Support and Consulting for Open Source Software Installation, Data Migration, Training, Customization, Hosting and Complete Support Packages Headquarters: Santa Barbara, CA - Office: Redding, CT Phone # (888) 900-8944 http://bywatersolutions.com brendan(a)bywatersolutions.com <info(a)bywatersolutions.com>

9 10

Bulk Patron Images
by Sandeep Bhavsar 13 Nov '13

13 Nov '13

Respected all I am using Mr. A. J. Tomson's python script for bulk uploading of patron images (9000). I have successfully run the python program and created the zip file but while uploading the same, facing the below error. [Wed Nov 13 20:32:59 2013] [error] [client 10.1.6.30] [Wed Nov 13 20:32:59 2013] picture-upload.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_koha`.`patronimage`, CONSTRAINT `patronimage_fk1` FOREIGN KEY (`cardnumber`) REFERENCES `borrowers` (`cardnumber`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/lib/C4/Members.pm line 1837., referer: http://10.1.6.14:9001/cgi-bin/koha/tools/picture-upload.pl [Wed Nov 13 20:32:59 2013] [error] [client 10.1.6.30] [Wed Nov 13 20:32:59 2013] picture-upload.pl: Error returned inserting 2008220483.image/png. at /usr/share/koha/lib/C4/Members.pm line 1838., referer: http://10.1.6.14:9001/cgi-bin/koha/tools/picture-upload.pl [Wed Nov 13 20:32:59 2013] [error] [client 10.1.6.30] [Wed Nov 13 20:32:59 2013] picture-upload.pl: Database returned error: Cannot add or update a child row: a foreign key constraint fails (`koha_koha`.`patronimage`, CONSTRAINT `patronimage_fk1` FOREIGN KEY (`cardnumber`) REFERENCES `borrowers` (`cardnumber`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/intranet/cgi-bin/tools/picture-upload.pl line 267., referer: http://10.1.6.14:9001/cgi-bin/koha/tools/picture-upload.pl -- *Regards * *Sandeep Bhavsar* B.com, M.Lib.I.Sc SET, M.Phil, American Library Association - FERA 2011 fellow Librarian Dr. V N Bedekar Institute of Management Studies Thane (W) 400601 Mumbai INDIA Mobile : 9987049099 www.vpmthane.org

2 1

Re: [Koha] NCIP
by Joel Sasse 13 Nov '13

13 Nov '13

Awesome. NCIP is a big deal in Minnesota. Joel Sasse Network Systems Administrator Plum Creek Library System 507-376-5803 O -----Original Message----- From: Chris Cormack [mailto:chrisc@catalyst.net.nz] Sent: Tuesday, November 12, 2013 2:33 PM To: Joel Sasse Cc: Koha(a)lists.katipo.co.nz Subject: Re: [Koha] NCIP * Joel Sasse (jsasse(a)plumcreeklibrary.net) wrote: > Hello Chris Cormack, > > Are you working on NCIP for Koha? I thought I heard you mention that > at the con. > I am, in concert with some Evergreen developers, to build a non specific one. Or at least one that will work with both Koha and Evergreen Here is my repository http://git.catalyst.net.nz/gw?p=NCIPServer.git;a=summary Here is the unified one http://git.evergreen-ils.org/?p=working/NCIPServer.git There's still a decent amount to do and lots of testing but it's not too far away Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand

1 0