- Koha - lists.katipo.co.nz

Messaging Preferences - Help
by SATISH 26 Aug '16

26 Aug '16

Dear All, Previously Koha 3.16 installed (later upgraded to 16.5.00.000) from packages method on Ubuntu 12.4 LTS (later upgraded to 14.4) and Postfix has been configured for smtp and Koha is working fine. ******** when new patron registration is done, email is sent to respective patrons. and "Messaging Preferences" set through Home › Patrons ›Specific Patron, (individually) is also working. 1. Individually enabling messaging preference is laborious task, and the Messaging Preferences are set / selected using "Home › Administration › Patron categories" - Item Due, Item Checkin, Item Checkout or any kind of emails are not sending. 2.Also there is no registration email has been sent when bulk import of patrons (for the new batch) using Home › Tools › Import patrons. But, email is sent when individually patron is registered. Is there any global system preference enabled to function this feature? or anybody else has faced the same issue?? or did I set anything wrong? Please advice. With Thanks. Satish MV Librarian Govt. Engineering College, Hassan Karnataka - 573 201 --

3 2

Koha 3.22.10 release
by Julian Maurice 25 Aug '16

25 Aug '16

The Koha community is proud to announce the release of Koha 3.22.10. This is a security release and contains several bugfixes. If you are running 3.22.x it is strongly recommended to upgrade. The full release notes are available at https://koha-community.org/koha-3-22-10-security-release/

1 0

Claim mail is not sent to Vendor - KOHA 16.05.02
by kamild 25 Aug '16

25 Aug '16

Helo, when claim order (Acquisitions › Late orders) I get information "Email has been sent." but Vendor don't get this email. In log exim I see the message is frozen 2016-08-25 09:36:41 1bcpDN-0007zx-82 ** xx(a)xx.xx R=smarthost T=remote_smtp_smarthost X=TLS1.0:RSA_ARCFOUR_128_SHA1:128 DN="C=xx,CN=*.xxx.xx.xx,EMAIL=xxx(a)xx.xx": SMTP error from remote mail server after MAIL FROM:<>< SIZE=2501: host xxxxxxx: 550 5.1.8 Sender address rejected 2016-08-25 09:36:41 1bcpDN-0007zx-82 Frozen (delivery error message) I defined Claim notice, in Contact details Vendor have email and select Primary acquisitions contact, Primary serials contact, Contact about late orders and Contact about late issues. In Log intranet lateorders.pl: CGI::param called in list context from package main line 109, this can lead to vulnerabilities. See the warning in "Fetching the value or values of a single named parameter" at /usr/share/perl5/CGI.pm line 436., referer: http://localhost:8080/cgi-bin/koha/acqui/lateorders.pl updatesupplier.pl: CGI::param called in list context from package main line 101, this can lead to vulnerabilities. See the warning in "Fetching the value or values of a single named parameter" at /usr/share/perl5/CGI.pm line 436., referer: http://localhost:8080/cgi-bin/koha/acqui/supplier.pl?booksellerid=1&op=enter Thx, Regards -- View this message in context: http://koha.1045719.n5.nabble.com/Claim-mail-is-not-sent-to-Vendor-KOHA-16-… Sent from the Koha-general mailing list archive at Nabble.com.

3 3

Re: [Koha] SQL Help - Add barcode column to SQL query that searches subject keywords
by Vinod Kabadi 24 Aug '16

24 Aug '16

Hi Craig Butosi, There will be many copies for each biblionumber so you want to list out all the barcodes related to that biblionumber or biblioitemnumber? If you want every barcode related to that biblioitemnumber then the query will be as below: SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',items.biblionumber,'\">',items.biblionumber,'</a>') AS bibnumber, ExtractValue(marcxml,'//datafield[@tag="690"]/subfield[@code>="a"]') AS 'subjects', items.barcode FROM biblioitems LEFT JOIN items on items.biblioitemnumber = biblioitems.biblioitemnumber WHERE ExtractValue(marcxml,'//datafield[@tag="690"]/subfield[@code>="a"]') LIKE <<Enter keyword surrounded BY %>> and biblioitems.biblioitemnumber is not null GROUP BY items.biblionumber On Aug 17, 2016 5:30 AM, <koha-request(a)lists.katipo.co.nz> wrote: > Send Koha mailing list submissions to > koha(a)lists.katipo.co.nz > > To subscribe or unsubscribe via the World Wide Web, visit > https://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: Koha for beginners (Mehvish Farah) > 2. Re: Using perl module Koha::Contrib::Tamil koha-auth > (Pedro Amorim) > 3. SQL Help - Add barcode column to SQL query that searches > subject keywords (Craig Butosi) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 16 Aug 2016 00:50:59 -0700 > From: Mehvish Farah <mehvishfarah(a)gmail.com> > To: "King, Fred" <Fred.King(a)medstar.net> > Cc: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Koha for beginners > Message-ID: > <CAFL5uZA9Tx_9nnm+99o-GUiz=GLW7ipAXwx25zpvFzdDCMcoEQ(a)mail.gm > ail.com> > Content-Type: text/plain; charset=UTF-8 > > Thank you very much everyone, This community is awesome. I appreciate all > who gave me a sense of what MARC is > , although I still need to read the links that you guys have posted. > > Fred, I hope your mom feels better soon. Just in the morning, I felt dizzy > after reading about MARC. My head was spinning until i took a short nap.Its > a relief that MARC was at least not her reason for being in the hospital. > I would try to browse about z39.50 and OCLC once i finish reading the link > by all of you. > Thank you Indranil for your book suggestion. and everyone else with your > suggesting me for bilinguals code. that's really helpful. > > > > On Mon, Aug 15, 2016 at 3:19 PM, King, Fred <Fred.King(a)medstar.net> wrote: > > > Hi Mehvish, and welcome to Koha. I tried to explain MARC tags to my > mother > > last night and she fell asleep. I think that being in a hospital > emergency > > room late at night right after a hefty dose of Dilaudid may have had > > something to do with it... (She'll be okay, BTW.) > > > > MARC is complicated, but makes sense after a while. Think of all the > > various ways you can describe a book, musical recording, film, etc. > Author, > > publisher, year published, length, ISBN, ISSN, call number... well, you > get > > the idea. Now give each element a number. For example, the title goes in > > the 245 field. The main part of the title goes into 245$a. If the book is > > "Arnold. The tale of a chipmunk" the second part goes into 245$ > > somethingelseicantrememberbutmigjtbeb. Do that for every element you > want > > to describe and you got yourself a MARC record. You don't have to do > > original cataloging on everything; see OCLC and Z39.50. I'm typing this > on > > my iPhone so I'll let someone else explain those--my thumb is getting > weary. > > > > One thing I love about Koha is that it's infinitely customizable (yes, > > literally). If you want to add or change something, you can. All the real > > catalogers just turned green upon reading that, but you can. > > > > I'm away from work right now and I'm astonished that I can get email at > > all, but I can follow up next week if you want. > > > > Have fun with Koha, > > > > Fred King > > Fred.king(a)medstar.net > > > > > > > > Sent with Good (www.good.com) > > > > > > -----Original Message----- > > *From: *Mehvish Farah [mehvishfarah(a)gmail.com] > > *Sent: *Monday, August 15, 2016 01:25 PM Eastern Standard Time > > *To: *koha(a)lists.katipo.co.nz > > *Subject: *[Koha] Koha for beginners > > > > Hi, > > I am new to Koha and have no library science experience. > > I am trying to understand MARC but stuck at the terms where there are > some > > numbers with a dollar sign and then an alphabet. What is this basically? > > I would be grateful if someone can help me with a book or link that helps > > understand these terms or library/koha terms in general or in easy > > comprehension. > > > > other thing that i want to know is if a book is bilingual (Spanish and > > English or Arabic and English) , what should i write in Lnaguage code > > clumn? > > > > Thanks > > *Mehvish* > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > ------------------------------ > > > > > > > > > > > > > > > > > > > > > > > > MedStar Health is a not-for-profit, integrated healthcare delivery > system, > > the largest in Maryland and the Washington, D.C., region. Nationally > > recognized for clinical quality in heart, orthopaedics, cancer and GI. > > > > IMPORTANT: This e-mail (including any attachments) may contain > information > > that is private, confidential, or protected by attorney-client or other > > privilege. If you received this e-mail in error, please delete it from > your > > system without copying it and notify sender by reply e-mail, so that our > > records can be corrected... Thank you. > > > > Help conserve valuable resources - only print this email if necessary. > > > > > > > -- > *Mehvish* > > > ------------------------------ > > Message: 2 > Date: Tue, 16 Aug 2016 14:40:20 +0000 > From: Pedro Amorim <pjamorim91(a)gmail.com> > To: Frédéric Demians <f.demians(a)tamil.fr>, Koha list > <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Using perl module Koha::Contrib::Tamil koha-auth > Message-ID: > <CALWP7TK43Ja_VjQpWNcwhDgL2UNJbQ_qCb=L=JGbHiT0rYH59w@mail. > gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Hello Frédéric ! > > Thank you so much for replying my questions. > > 1) Yes '353.9(469)(094.4)' is supposed to be an authority that was just an > example - 'Wilkens, H. J.' is another example. > I think they are properly indexed as I can search for those exact terms and > the results are returned in the intra interface. > > 2) Picking up on your comment on having a malformed biblio record, I had > indeed some very incomplete records with no 6XX or 7XX in them, > consequently no authorities to link and I thought that may be causing the > behaviour. > However, on a different import with all the records having authority info > to link from, the same error is occurring. > > I think I might have figured part of the reason for 1) to be happening. > In > https://github.com/fredericd/Koha-Contrib-Tamil/blob/master/ > lib/Koha/Contrib/Tamil/Authority/FromBiblioTask.pm#L74 > Some characters, namely ',', are being stripped from the value and the > authorities are being saved without the ',' character. Upon running the > link task, ',' is still present in the biblios so the match fails. Does > that make sense? > > Anyway, I think that's only part of the reason because there are some other > authorities throwing not found warnings without any of those chars special > chars. > > Yet another possible reason could be encoding causing the match to fail, > for example 'Ossian, Séc. 3'. > > Another (probably) important piece of information is I have a UNIMARC > installation, is there some particular (indexing) configuration required? > > Please let me know if any of this makes sense. > > Thank you, > > Pedro Amorim > > > 2016-08-13 6:55 GMT+00:00 Frédéric Demians <f.demians(a)tamil.fr>: > > > > 1) For many biblios, the following message is presented: > > > WARNING: authority not found -- 353.9(469)(094.4) > > > > > But said authority indeed exists and is indexed. > > > > Is '353.9(469)(094.4)' supposed to be an authority? If it's not found, it > > means it isn't properly indexed. > > > > > 2) After about 400 biblios processed (I think), it throws this error > and > > it > > > hangs printing "405" forever: > > > > > > > > *** unhandled exception in callback: > > > *** Quantifier follows nothing in regex; marked by <-- HERE in m/* > <-- > > > HERE / at > > > /usr/local/share/perl/5.14.2/Koha/Contrib/Tamil/Authority/Li > > nkBiblioTask.pm > > > line 77. > > > > You must have a malformed biblio record. > > > > Kind regards, > > -- > > Frédéric DEMIANS > > http://www.tamil.fr/fdemians > > > > > ------------------------------ > > Message: 3 > Date: Tue, 16 Aug 2016 19:50:23 +0000 > From: Craig Butosi <craig.butosi(a)rcmusic.ca> > To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> > Subject: [Koha] SQL Help - Add barcode column to SQL query that > searches subject keywords > Message-ID: > <76B657F0CE544943AD3B3CD99B9C1C055B22EA(a)RCMMX1.rcmusic.local> > Content-Type: text/plain; charset="us-ascii" > > Hi all, > > I'm trying to get the barcodes column from the items database to display > on the results page after running the following SQL query: > > SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=', > biblionumber,'\">',biblionumber,'</a>') > AS bibnumber, lcsh > FROM > (SELECT biblionumber, ExtractValue(marcxml,'//datafi > eld[@tag="690"]/subfield[@code>="a"]') > AS lcsh FROM biblioitems) > AS subjects > WHERE lcsh > LIKE <<Enter keyword surrounded BY %>> > WHERE biblionumber.biblionumber=items.barcode > > > The above I found on the Koha SQL library, but this query only displays > the biblionumber and keyword query results in 690a. I'd like to add the > barcodes column to the report. Can't seem figure out how to do this in this > query. Help, please :) > > Many thanks! > > C > > Craig Butosi, MA, MLIS, B Mus (Hons.) > LIBRARY SERVICES MANAGER > the royal conservatory > TELUS Centre for Performance and Learning > 273 Bloor Street West > Toronto, ON M5S 1W2 > 416.408.2824 x338 > www.rcmusic.ca<http://www.rcmusic.ca/> > > > > Note: This email message and any attachments are intended only for the use > of the individual to which it is addressed, and may contain information > that is privileged, confidential and exempt from disclosure under > applicable law. If the recipient of this email is not the intended > recipient (or the employee or agent responsible for delivering the email to > the intended recipient), you are hereby notified that any review, > dissemination, distribution or copying or other use of this message is > strictly prohibited. If you have received this communication in error, > please notify the sender immediately by return email and delete this > message and attachments from your system, thank you. > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > End of Koha Digest, Vol 130, Issue 35 > ************************************* >

1 0

How many Koha libraries are there worldwide?
by Michael Kuhn 24 Aug '16

24 Aug '16

Hi I wonder how many libraries worldwide are using Koha. At the moment Marshall Breedings wonderful website libraries.org lists 4'352 libraries using Koha: * http://www.librarytechnology.org/lwc-processquery.pl?ILS=Koha I always thought there are about 4'000 or meanwhile even 6'000 libraries using Koha, since of course not everyone is listing their library in libraries.org. But today I was thrilled to find the number of "around 15'000" Koha libraries in an article by Catalyst: * https://www.catalyst-eu.net/news/koha-introduction-courses Does anyone have other numbers? Or does anyone have the approximate numbers for his own country? For Austria, Germany and Switzerland I try to find every Koha library, these are the current numbers (http://adminkuhn.ch/wiki/Koha/Anwender) but not counting library branches: * Austria: 7 * Germany: 37 * Switzerland: 7 Best wishes, Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

6 5

Subject: Koha World Tour : Malaysia
by AklaEsmael 24 Aug '16

24 Aug '16

Hi, Es Jo arrived here in Kuala Lumpur last night 23/8. Todaywe have visit & Presentation in Library of islamic science University, the Koha user in Malaysia. On 26/8 we have another programe in Penang Public Library before she Leftist on 28/8 Cheras AklaEsmael

1 0

Subject: Koha World Tour : Kuala Lumpur, Malaysia
by AklaEsmael 24 Aug '16

24 Aug '16

Hi All, Yes Jo arrived in KL last night 23/8, today we have talk & visit library Islamic Science University, one of the Koha user here. Cerd AklaEsmael

1 0

Regarding predue notices
by Sahadeo Taware 24 Aug '16

24 Aug '16

Dear Friends I am sending email alerts to the students. Overdue notices & due item notices is send automatically to the user. But the predue notices is not able to send the users. Kindly help me regarding this issue. -- Sahadeo D. Taware Librarian, M.L.I.Sc., NET Thakur College of Science and Commerce Thakur Village, Kandivli(E), Mumbai 400101 Mob. No 9324912816 Office 28870627 Extn. 126

2 1

Koha World Tour : Sydney, Australia.
by Irma Birchall 23 Aug '16

23 Aug '16

Jo Ransom wrote: "Hi all, Just a quick note to let you know that the itinerary for my Koha World Tour <http://www.tiki-toki.com/timeline/entry/665664/Round-the-World-Koha-Tour/> is complete and details are being added as they come to hand for events I will be attending as I travel around the globe. I hope to meet as many of you as possible so if you are able to attend an event somewhere please come and say hi. I will also be tweeting as @jransom using #kohaworldtour." Joann Ransom is one of the librarians who worked with Chris Cormack to develop the original Koha library management system back in 1999. Joann, ex CEO of Horowhenua Library Trust, is travelling around the world aiming to meet as many Koha community members as possible. Joann has three main topics that she is happy to speak on: 1) Origins of Koha, 2) The Koha Community and what that means and 3) Te Takere <http://www.horowhenua.govt.nz/Places-Events/Community-Centres-Libraries>: transforming a modest public library service into a 21st century community centre. Hi Koha community, We can let you know that Joann is now on her way. Following a small but enthusiastic gathering at the Koha-OZ meetup in Sydney last night, we delivered Joann to the airport this morning. Her next stop is Malaysia. Dear Malaysian Koha Community <http://www.tiki-toki.com/timeline/entry/665664/Round-the-World-Koha-Tour/>, Joann is looking forward to coming to you next. Thanks Jo for your visit and presentation about Koha in Sydney. Cheers, Irma CALYX

1 0

Authority main heading indexing for UNIMARC
by Pedro Amorim 23 Aug '16

23 Aug '16

Hello all, Koha 3.22 from packages UNIMARC install on Debian. This is not a fresh install but all the configuration (and indexing) files have not been modified. Everything was seemly working fine up until the point we started using authority records. This is a follow-up on a previous mail I sent: https://lists.katipo.co.nz/public/koha/2016-August/045991.html I have narrowed the problem down to the indexing (or lack of) of the Heading:p index for authorities. Say I have this authority (NP) record: 200 a$Amorim $bPedro $f1991-1992 Conducting an authority search from the staff interface with search term: "Amorim Pedro 1991-1992" With exact match on main heading, should result on the above record. But it doesn't. Instead, an exact search for each of the above subfields alone ('Amorim', 'Pedro' or '1991-1992') will all return the same expected correct record. As if the authority indexing is indexing all the subfields, but as words instead of a whole phrase. Additional info: I've stumbled upon the GRS-1/DOM terms but from what I understand, after Koha 3.18 it's the DOM indexing that's used and GRS-1 is deprecated. Also, all config files point to DOM by default. ------ I conducted test searches on (UNIMARC) Koha implementations for this incorrect behaviour and oddly enough, it's quite common. The UNIMARC demo test Biblibre implements this search as phrase correctly, searching for all the subfields in the heading will result in the correct record: http://intranet-demo.biblibre.com/ However, Tamil doesn't. It behaves the same as my installation, not interpreting phrase but only words: https://kpro.tamil.fr/ ------ Additional yaz info results: Z> f @and @attr 1=authtype NP @attr 1=Heading @attr 4=1 @attr 6=3 "Amorim" Sent searchRequest. Received SearchResponse. Search was a success. Number of hits: 1, setno 1 SearchResult-1: term=NP cnt=1, term=Amorim cnt=1 records returned: 0 Elapsed: 0.005944 Z> f @and @attr 1=authtype NP @attr 1=Heading @attr 4=1 @attr 6=3 "Amorim Pedro 1991-1992" Sent searchRequest. Received SearchResponse. Search was a success. Number of hits: 0, setno 2 SearchResult-1: term=NP cnt=1, term=Amorim Pedro 1991-1992 cnt=0 records returned: 0 Elapsed: 0.000615 Z> scan @attr 1=Personal-name @attr 4=1 @attr 6=3 "amorim" query: @attr 1=Personal-name @attr 4=1 @attr 6=3 "amorim" Received ScanResponse 6 entries, position=1 Scan returned code 5 * Amorim (1) Pedro (1) Elapsed: 0.037127 The yaz results make it obvious the indexes are wrong and only indexing words, I think. ----------------------- Sorry for long post, wanted to provide as much as useful info as possible. Any help would be greatly appreciated. Thank you, Pedro Amorim

3 2