- Koha - lists.katipo.co.nz

Re: [Koha] What if mysql stops being around?
by BWS Johnson 24 Jul '09

24 Jul '09

>These last couple of hours, i've been trying to access different >*.mysql.com sites (for my non-Koha work). None of them responding to a >http request. I'm not being a fear-monger or crystal gazer here, but >I'm dependent on MySQL for several apps that i commercially support, >which includes Koha. > >I wonder just how ready or MySQL dependent are we (Koha users) as a >community, just in case, Oracle decides to stop further work on MySQL? >I'm aware of efforts like Drizzle. But how are we positioned w.r.t >MySQL deps and what could hypothetically could be a possible life >after MySQL (if it ever comes to that) To this, I can only say: http://www.engin.umd.umich.edu/CIS/course.des/cis400/cobol/cobol.html Cheers, Brooke

3 2

download page
by mourik jan c heupink 23 Jul '09

23 Jul '09

Hi, I read in the news section that 3.0.3 has been released on Jun 26 (http://koha.org/news/koha-3.0.3-released) However, the download page lists 3.0.2 as the most recent stable version. I guess the download page needs updating..? Regards, Mourik Jan

1 0

SQL report for duplicate items
by Banks, Joy M 23 Jul '09

23 Jul '09

Hi everyone- We're a hosted Koha library using whatever the most recent release of the product is. I've been asked if I can generate a report through Koha that would tell us all the duplicate items in the collection. Try as I might, I can't seem to figure out a simple way of doing this without pulling a report of every single item, sorting by call number, and sifting through the tens of thousands of items. Has anyone generated a report like this? It wouldn't be enough to pull titles that have more than one record because then we'll get multi-volume sets too. And there isn't a single identifying entry in the call number (e.g. pt. or c.) because there hasn't been any consistency with our tracking of duplicate items. If anyone has ideas, please let me know. I'll only be able to copy/paste generated SQL into the Report Wizard. We have no access to the backend of the system. Thank you! ~Joy Joy M. Banks Catalog Librarian Roux Library Florida Southern College 111 Lake Hollingsworth Dr. Lakeland, FL 33801 (863)680-4736 jbanks(a)flsouthern.edu

4 3

Re: [Koha] Overdue reports
by ils rehoboth 23 Jul '09

23 Jul '09

Hi all, I am using koha-3.00 and i am trying to generate list of patrons who have overdue fines but i am not finding how to do it. Can something please help me. Thanks in advance Rehoboth

3 3

Integrating with your ILS through Web services and APIs
by Breeding, Marshall 23 Jul '09

23 Jul '09

I am in the process of writing an issue of Library Technology Reports for ALA TechSource titled "Hype or reality: Opening up library systems through Web Services and SOA." Today almost all ILS products make claims regarding offering more openness through APIs, Web services, and through a service-oriented architecture (SOA). This report aims to look beyond the marketing claims and identify specific types of tasks that can be accomplished beyond the delivered interfaces through programmatic access to the system internals. As part of the research for this article I am soliciting feedback from libraries that taken advantage of Web Services or other API's in conjunction with their core Integrated Library System (ILS) to meet specific needs. I'm interested in hearing about how you might have been able to integrate library content and services into applications, extracted data, automated processes or other novel applications. Please tell me about your experiences with your ILS in regard to the APIs it offers: - Do you feel like you can pretty much do anything you want with the system, or do you feel constrained? -Are the APIs offered able to address all the data and functionality within the ILS? -On the flip side, do you feel like your ILS is too closed? -Do you find the APIs offered by the developer of the ILS to be well documented? - What programming languages or other tools were you able to use to take advantage of these APIs? - What level of programming proficiency is required: Systems librarian with scripting languages, software development engineer, or something in between? - What's on your wish list? What kind of APIs would you like to see incorporated into your current or next ILS? - I'm interested in responses from those that use open source ILS products as well. Are you able to programmatically interact with the ILS? - Do you consider your ILS as embracing a true Service-oriented architecture? Systems vendors increasingly promote their ILS as SOA. Can you provide examples where the ILS does or does not exhibit traits of SOA in your environment. While it's important for the ILS to offer support for standard protocols such as Z39.50, NCIP, and OAI, that's not the core of the issue here. What I'm looking for are API's that allow the library to get at data and functionality not addressed by these protocols. Thanks in advance for sharing your experiences in ILS API's with me for this report. I appreciate your assistance. -marshall Summary excerpt: Libraries increasingly need to extract data, connect with external systems, and implement functionality not included with the delivered systems. Rather than being reliant on the products developers for enhancements to meet these needs, libraries increasingly demand the ability to exploit their systems using APIs, Web Services, or other technologies. Especially in libraries that exist in complex environments where many different systems need to interact, the demand for openness abounds. As libraries develop their IT infrastructure, it's imperative to understand the extent to which their automation products are able to interoperate and thrive in this growing realm of Web services. This report aims to assess the current slate of major library automation systems in regard to providing openness through API's, Web Services, and the adoption of SOA. Marshall Breeding Director for Innovative Technology and Research Vanderbilt University Library Editor, Library Technology Guides http://www.librarytechnology.org 615-343-6094

2 1

Editing BIBLIO Record
by hasina＠bracu.ac.bd 23 Jul '09

23 Jul '09

Dear all We will really appreciate it if anyone help us for solving the following problem in KOHA If we do any change/edit in any of our BIBLIO record then in OPAC it displays two same item. If we delete one item then both the item disappear. Can anyone give us some suggestion regarding this problem. Regards Hasina Afroz Head of Library BRAC University > Send Koha mailing list submissions to > koha(a)lists.katipo.co.nz > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.katipo.co.nz/mailman/listinfo/koha > or, via email, send a message with subject or body 'help' to > koha-request(a)lists.katipo.co.nz > > You can reach the person managing the list at > koha-owner(a)lists.katipo.co.nz > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Koha digest..." > > > Today's Topics: > > 1. Re: Overdue notices (Wagner, Jane) > 2. Re: koha doubts (MJ Ray) > 3. Re: Holds (Justin Davis) > 4. Re: Holds (Joe Atzberger) > 5. Re: [was: Holds] (Cab Vinton) > 6. Re: problem in catalog search (Krishnan M) > 7. Re: as_usmarc error / biblio encoding (Rachel Hollis) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 16 Jul 2009 09:50:09 -0400 > From: "Wagner, Jane" <jwagner(a)ptfs.com> > Subject: Re: [Koha] Overdue notices > To: "Cab Vinton" <bibliwho(a)gmail.com>, "Koha list" > <koha(a)lists.katipo.co.nz> > Message-ID: > <AA56A589DBA425479834C1F68C150DA2013F2E3B(a)PTFSMAIL01.corporate.ptfs.com> > > Content-Type: text/plain; charset="us-ascii" > > There is a syspref AutoEmailPrimaryAddress (under Administration, system > preferences, patrons) which lets you specify which email field should be > used for notices -- email or emailpro. However, so far as I know, Koha > doesn't have the ability to use both. I think it would be a useful > enhancement to set it up so that if field A in email priority list is > empty, use address in field B. > > Jane Wagner > Library Systems Analyst > PTFS Inc. > Content Management and Library Solutions > 6400 Goldsboro Road, Suite 200 > Bethesda, MD 20817 > (301) 654-8088 x 151 > jwagner(a)ptfs.com > > > -----Original Message----- > From: koha-bounces(a)lists.katipo.co.nz > [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Cab Vinton > Sent: Thursday, July 16, 2009 9:16 AM > To: Koha list > Subject: [Koha] Overdue notices > > Is it correct to assume that Overdue notices are only sent to Home > email addresses (borrowers.email)? > > Some patrons provide both a home & a work email (borrowers.emailpro). > > Ideally, the Patron DB would be setup to allow staff to specify the > default email address to be used for notices. > > Otherwise, Koha should send notices to any available address (work if > no home address available, & vice versa.) > > At present, I believe we would have to copy work addresses into empty > home address fields to ensure that Notices are sent out. > > Thank you, > > Cab Vinton, Director > Sanbornton Public Library > Sanbornton, NH > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > Message: 2 > Date: Thu, 16 Jul 2009 15:04:20 +0100 > From: MJ Ray <mjr(a)phonecoop.coop> > Subject: Re: [Koha] koha doubts > To: sivasankari.muthuraja(a)gmail.com, oleonard(a)myacpl.org > Cc: koha(a)lists.katipo.co.nz > Message-ID: <4a5f3364.a7TtHQ0vtaKfUFbP%mjr(a)phonecoop.coop> > Content-Type: text/plain; charset=us-ascii > > Owen Leonard <oleonard(a)myacpl.org> wrote: >> > 1.how to make the payment through koha. >> > Is there any online payment, payment gateway using creditcard for >> fine,books >> > lost.or the payments made offline >> >> There is no online payment component included in Koha. It is assumed >> that payments are handled in person. > > I'm interested in this enhancement (software.coop also does web shops) > and it wouldn't be hard, but I think we don't yet have anyone > sponsoring it. > > Hope that explains, > -- > MJ Ray (slef) LMS developer and webmaster at | software > www.software.coop http://mjr.towers.org.uk | .... co > Notice http://mjr.towers.org.uk/email.html | .... op > > > ------------------------------ > > Message: 3 > Date: Thu, 16 Jul 2009 09:11:44 -0500 > From: Justin Davis <justindavis(a)mail.utexas.edu> > Subject: Re: [Koha] Holds > To: Koha list <koha(a)lists.katipo.co.nz> > Message-ID: <4A5F3520.5080703(a)mail.utexas.edu> > Content-Type: text/plain; charset=us-ascii; format=flowed > > Thank you for nothing the bug -- I've been trying to get mail > notifications working for days now. > > Is this feature officially deprecated? > > I understand that the web interface works for most users and most > workflows -- email notifications would be extremely useful for our > implementation. We have several small colleges that each get a handful > of hold requests a week. It would be nice to be notified outside of the > website itself. > > On 07/16/2009 08:22 AM, Cab Vinton wrote: >> On Fri, Jul 10, 2009 at 11:26 AM, Joe Atzberger<ohiocore(a)gmail.com> >> wrote: >>> On Fri, Jul 10, 2009 at 10:53 AM, Cab Vinton<bibliwho(a)gmail.com> >>> wrote: >>>> A cronjob for daily emails w/ a list of the Holds to pull would be a >>>> great idea& a time& labor-saver for librarians. >>> Not really. Checking and printing your email isn't any easier or more >>> time >>> saving than checking and printing the web interface you're already >>> using. >> >> Just stumbled across a relevant Circ preference: >> emailLibrarianWhenHoldIsPlaced >> >> However, it does not seem to be working, see Bug 3242. >> >> Not sure if this will be fixed or simply removed from future versions >> ... >> >> Cab Vinton, Director >> Sanbornton Public Library >> Sanbornton, NH >> _______________________________________________ >> Koha mailing list >> Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > Message: 4 > Date: Thu, 16 Jul 2009 10:35:04 -0400 > From: Joe Atzberger <ohiocore(a)gmail.com> > Subject: Re: [Koha] Holds > To: Justin Davis <justindavis(a)mail.utexas.edu> > Cc: Koha list <koha(a)lists.katipo.co.nz> > Message-ID: > <235bf14f0907160735n708805bek970a16a3b8bacd64(a)mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > emailLibrarianWhenHoldIsPlaced has no implementation in the codebase. > It's > just a fantasy syspref. In the future I think it we will be less > permissive > about allowing the appearance of features to persist in the software with > no > code to back it up. > -- > Joe Atzberger > LibLime - Open Source Library Solutions > > On Thu, Jul 16, 2009 at 10:11 AM, Justin Davis > <justindavis(a)mail.utexas.edu>wrote: > >> Thank you for nothing the bug -- I've been trying to get mail >> notifications working for days now. >> >> Is this feature officially deprecated? >> >> I understand that the web interface works for most users and most >> workflows -- email notifications would be extremely useful for our >> implementation. We have several small colleges that each get a handful >> of hold requests a week. It would be nice to be notified outside of the >> website itself. >> >> On 07/16/2009 08:22 AM, Cab Vinton wrote: >> > On Fri, Jul 10, 2009 at 11:26 AM, Joe Atzberger<ohiocore(a)gmail.com> >> wrote: >> >> On Fri, Jul 10, 2009 at 10:53 AM, Cab Vinton<bibliwho(a)gmail.com> >> wrote: >> >>> A cronjob for daily emails w/ a list of the Holds to pull would be a >> >>> great idea& a time& labor-saver for librarians. >> >> Not really. Checking and printing your email isn't any easier or >> more >> time >> >> saving than checking and printing the web interface you're already >> using. >> > >> > Just stumbled across a relevant Circ preference: >> emailLibrarianWhenHoldIsPlaced >> > >> > However, it does not seem to be working, see Bug 3242. >> > >> > Not sure if this will be fixed or simply removed from future versions >> ... >> > >> > Cab Vinton, Director >> > Sanbornton Public Library >> > Sanbornton, NH >> >

2 1

What if mysql stops being around?
by Indranil Das Gupta 23 Jul '09

23 Jul '09

Hi all, These last couple of hours, i've been trying to access different *.mysql.com sites (for my non-Koha work). None of them responding to a http request. I'm not being a fear-monger or crystal gazer here, but I'm dependent on MySQL for several apps that i commercially support, which includes Koha. I wonder just how ready or MySQL dependent are we (Koha users) as a community, just in case, Oracle decides to stop further work on MySQL? I'm aware of efforts like Drizzle. But how are we positioned w.r.t MySQL deps and what could hypothetically could be a possible life after MySQL (if it ever comes to that) -indra

4 4

Next project IRC meeting - 5 August 2009
by Galen Charlton 23 Jul '09

23 Jul '09

Hi, The next general IRC meeting of the Koha project will take place on 5 August 2009 at 10:00 UTC+0. The agenda currently includes the following items: 1. Update on Roadmap to 3.2 2. Update on Koha 3.0 Roadmap 3. Follow-up on actions from General IRC Meeting 1 July 2009 4. Management of KohaSocialNetworks To propose additional agenda items, please go to the wiki page for this meeting located at <http://wiki.koha.org/doku.php?id=meetingnotes09aug05>. As a reminder, the IRC meetings taken place on the #koha channel on the IRC server irc.katipo.co.nz. Regards, Galen -- Galen Charlton VP, Research & Development, LibLime galen.charlton(a)liblime.com p: 1-888-564-2457 x709 skype: gmcharlt

2 1

DBD Driver Error on KOHA
by Sunita Barve 22 Jul '09

22 Jul '09

Dear All, We are not able to yet solve the following error on Debian-5.0.1 can someone on the listserv help us to solve this. The KOHA is installed as per the instructions on INSTALL.debian-lenny. 1. Here is our error while accessing koha admin page. Koha error The following fatal error has occurred: DBD driver has not implemented the AutoCommit attribute at /usr/lib/perl5/DBI.pm line 690. Compilation failed in require at /usr/share/koha/lib/C4/Circulation.pm line 25. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Circulation.pm line 25. Compilation failed in require at /usr/share/koha/lib/C4/Overdues.pm line 24. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Overdues.pm line 24. Compilation failed in require at /usr/share/koha/lib/C4/Members.pm line 27. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Members.pm line 27. Compilation failed in require at /usr/share/koha/lib/C4/Auth.pm line 27. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 27. 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. 2. Here is KOHA install log file # This file contains settings used # during the installation of Koha. # It is meant for use during future # upgrades of Koha, and should not # be edited. KOHA_INSTALLED_VERSION=3.00.02.012 LOG_DIR=/var/log/koha DB_TYPE=mysql DB_NAME=koha DB_HOST=localhost DB_PORT=3306 DB_USER=kohaadmin DB_PASS=root123 WEBMASTER_EMAIL=webmaster@lib-pc WEBSERVER_DOMAIN=lib-pc WEBSERVER_HOST=lib-pc WEBSERVER_IP=127.0.1.1 WEBSERVER_PORT=80 WEBSERVER_PORT_LIBRARIAN=8080 ZEBRA_SRU_HOST=localhost ZEBRA_SRU_BIBLIOS_PORT=9998 ZEBRA_SRU_AUTHORITIES_PORT=9999 KOHA_USER=koha KOHA_GROUP=koha ZEBRA_PASS=root123 ZEBRA_USER=kohauser INTRANET_CGI_DIR=/usr/share/koha/intranet/cgi-bin INTRANET_TMPL_DIR=/usr/share/koha/intranet/htdocs/intranet-tmpl INTRANET_WWW_DIR=/usr/share/koha/intranet/htdocs OPAC_CGI_DIR=/usr/share/koha/opac/cgi-bin OPAC_TMPL_DIR=/usr/share/koha/opac/htdocs/opac-tmpl OPAC_WWW_DIR=/usr/share/koha/opac/htdocs PERL_MODULE_DIR=/usr/share/koha/lib KOHA_CONF_DIR=/etc/koha ZEBRA_CONF_DIR=/etc/koha/zebradb PAZPAR2_CONF_DIR=/etc/koha/pazpar2 MISC_DIR=/usr/share/koha/misc SCRIPT_DIR=/usr/share/koha/bin MAN_DIR=/usr/share/koha/man DOC_DIR=/usr/share/koha/doc ZEBRA_LOCK_DIR=/var/lock/koha/zebradb ZEBRA_DATA_DIR=/var/lib/koha/zebradb ZEBRA_RUN_DIR=/var/run/koha/zebradb ZEBRA_MARC_FORMAT=marc21 ZEBRA_LANGUAGE=en ZEBRA_AUTH_CFG=zebra-authorities.cfg AUTH_RETRIEVAL_CFG=retrieval-info-auth-grs1.xml MERGE_SERVER_HOST=lib-pc MERGE_SERVER_PORT=11001 PAZPAR2_HOST=lib-pc PAZPAR2_PORT=11002 INSTALL_MODE=standard INSTALL_BASE=/usr/share/koha INSTALL_ZEBRA=yes INSTALL_SRU=yes INSTALL_PAZPAR2=no AUTH_INDEX_MODE=grs1 RUN_DATABASE_TESTS=no PATH_TO_ZEBRA=/usr/bin reg, Sunita Barve, Ph. D. SIRC-In-Charge National Centre for Radio Astrophysics Post Bag No. 3, Pune Univ. Campus Pune 411 007, INDIA Phone : Office : 91-20-25719211 Residence : 91-020- 24470022 Mobile: 9922753827 Email : sunitab(a)ncra.tifr.res.in ; sunitabarve(a)gmail.com

3 2

RFID EQUIPMENT....
by Homero Almeida 22 Jul '09

22 Jul '09

Hello All We want to implement RFID in our library, you can see the tags and reader that could use.... Maybe Someone has experience using this kind of tangs.... or you could send some suggestions to our work?? best regards homero --- El mar 21-jul-09, Jenny Cabascango <mijennyliz(a)gmail.com> escribió: De: Jenny Cabascango <mijennyliz(a)gmail.com> Asunto: Especificaciones equipo y tags A: "Homero Almeida" <homero1958(a)yahoo.com> Cc: biee(a)epn.edu.ec Fecha: martes, 21 julio, 2009, 2:50 pm Tags RFID: DK-002 EPC tag Project Description Remarks Manufacturer／Chip Alien/higgs2 protocol according with ISO/IEC 18000-6C EPC Class1 Gen2 Storage area EPC area 96Bits can read and write TID area 32Bits can read, not write Password area 32Bits visit(access) password 32Bits destroy (kill)password can read and write Apply carrier wave frequency 860～960MHz Operating mode Passive Reading/writing tool Reader/writer and antenna Working life Writing 100,000 times, data can be saved for 10 years. Writing speed 15pcs tags／second EPC code Folding rate semidiameter More than 35mm Reading distance 2-10M DLC-6820 Integrated UHF Reader （2.5M） Technical parameters ： Model DLC-6820 Integrated UHF Reader （2.5M） Frequency ISM 902-928MHz or 865-868MHz Operation Mode Fixed Frequency or FHSS or Software Programmable RF Power Output Adjustable Power Output Adjustable Range：0.1W --- 1W Built- in Antenna Type Built-in Circularly polarized antenna. Communication Ports 1）RS-232 2）RS-485 3）Weigand 26 bits \ 32bits Communication Rates Up to 57,600bps and software programmable Reading/Writing Capability 1） Capability of Reading/Writing agreement of ISO18000-6B 、EPC Passive tags and software programmable. 2） Able to decode ISO-18000B、EPC. 3） Reading Rang(Max).: 5M Reading Rang(Reliable):2.5M Programmable Application Platform 1） Allows Programmable Interface with host applications; 2） Currently Supports Visual Basic or VC applications. Power Consumed +5V DC， Average power of less than 2W Dimension / Weight 220×220×50MM 1.5KG Operation Temp Working Temp.：-35°~ +60 ° Storage Temp.：-50°~ +80° ____________________________________________________________________________________ ¡Obtén la mejor experiencia en la web! Descarga gratis el nuevo Internet Explorer 8. http://downloads.yahoo.com/ieak8/?l=e1

1 0