- Koha - lists.katipo.co.nz

Sip error in Community Koha on my local git copy
by Scott Kushner 23 Apr '13

23 Apr '13

Has anyone seen this error? root@mtplkohacomm:/home/koha/kohaclone# perl -I ./SIPServer.pm /home/koha/kohaclone/etc/SIPconfig.xml syntax error at /home/koha/kohaclone/etc/SIPconfig.xml line 2, near "-->" Unterminated <> operator at /home/koha/kohaclone/etc/SIPconfig.xml line 5. Thanks, Scott Kushner Middletown Library

1 0

Re: [Koha] Koha Digest, Vol 90, Issue 31
by عبد الرزاق محمود 23 Apr '13

23 Apr '13

i use koha 3.8 when i add new item type did not appear in catalog , but the biblio appear without item , and when rebuild-zebra , appear with record . Are there any solutions to show directly On Tue, Apr 23, 2013 at 8:34 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 > 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: Report Help (Bernardo Gonzalez Kriegel) > 2. Opac can't show non-latin characters correctly (Peter Zhao) > 3. Re: Opac can't show non-latin characters correctly > (Fischer, Katrin) > 4. Re: [Koha-devel] Translation manager for v3.14 (Fischer, Katrin) > 5. Re: koha lost/missing items (Mason James) > 6. Please unsubscribe me (Usman) > 7. Re: Report Help (Nicole Engard) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 22 Apr 2013 22:19:10 -0300 > From: Bernardo Gonzalez Kriegel <bgkriegel(a)gmail.com> > To: Nicole Engard <nengard(a)gmail.com> > Cc: Koha <Koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Report Help > Message-ID: > <CADF4kvQYUY2M7BtwU-L3pDPA=02-OHSx= > SyTWytO_6h1zyPZYg(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Nicole, > you want for each guarantor it's guarantees, Q: it's ok to repeat guarantor > information on each guarantee tuple? > > you could use something like this (put any data you want in first select, > and change order by if needed) > > SELECT > IFNULL(concat(g.surname, ', ', g.firstname, ' (',g.cardnumber, ')'),'') > AS guarantor, > IFNULL(concat(p.surname, ', ', p.firstname, ' (',p.cardnumber, ')'),'') > AS guarantee > FROM > ( > SELECT * > FROM borrowers > WHERE guarantorid IS NOT NULL > ) AS p > LEFT JOIN borrowers AS g > ON p.guarantorid = g.borrowernumber > ORDER BY g.borrowernumber > ; > > Bernardo > > -- > Bernardo Gonzalez Kriegel > bgkriegel(a)gmail.com > > > On Mon, Apr 22, 2013 at 4:18 PM, Nicole Engard <nengard(a)gmail.com> wrote: > > > I'm looking to change this report around. It shows patrons with their > > guarantor information. I want a report that shows me the guarantees for > > each guarantor instead. > > > > > > SELECT p.categorycode, p.dateofbirth, p.cardnumber, p.surname, > p.firstname, > > p.dateexpiry, IFNULL(concat(g.surname, ', ', g.firstname, ' (', > > g.cardnumber, ')'),'') AS guarantor, p.relationship, > > ifnull(FORMAT(SUM(a.amountoutstanding),2),'0.00') AS due > > FROM borrowers p > > LEFT JOIN accountlines a USING (borrowernumber) > > LEFT JOIN borrowers g ON (p.guarantorid=g.borrowernumber) > > WHERE p.dateexpiry < NOW() > > GROUP BY p.borrowernumber > > ORDER BY p.dateexpiry ASC > > > > > > > > Nicole > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ------------------------------ > > Message: 2 > Date: Tue, 23 Apr 2013 14:22:04 +0800 (CST) > From: "Peter Zhao" <peterzhaonj(a)163.com> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] Opac can't show non-latin characters correctly > Message-ID: <3007ca14.81f9.13e358e66ae.Coremail.peterzhaonj(a)163.com> > Content-Type: text/plain; charset=GBK > > Hi, > > Warmly greetings. > > Could anyone know why in the "Refine your search" column area of OPAC > can not show non-latin characters ? But in the other area of the OPAC can > show non-latin characters. Anyone know how to fix this problem? Thanks a > lot. > > Peter > > > > > > ------------------------------ > > Message: 3 > Date: Tue, 23 Apr 2013 09:37:54 +0200 > From: "Fischer, Katrin" <Katrin.Fischer(a)bsz-bw.de> > To: "Peter Zhao" <peterzhaonj(a)163.com>, <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Opac can't show non-latin characters correctly > Message-ID: > <028B1A54D03E7B4482CDCA4EC8F06BFD02BCA251(a)Bodensee.bsz-bw.de> > Content-Type: text/plain; charset="UTF-8" > > Hi Peter, > > the facets should work correctly with non-latin characters. > Which version of Koha are you using? > What is the problem you see? > > Katrin > > > -----Original Message----- > > From: koha-bounces(a)lists.katipo.co.nz [mailto:koha- > > bounces(a)lists.katipo.co.nz] On Behalf Of Peter Zhao > > Sent: Tuesday, April 23, 2013 8:22 AM > > To: koha(a)lists.katipo.co.nz > > Subject: [Koha] Opac can't show non-latin characters correctly > > > > Hi, > > > > Warmly greetings. > > > > Could anyone know why in the "Refine your search" column area of OPAC > > can not show non-latin characters ? But in the other area of the OPAC can > > show non-latin characters. Anyone know how to fix this problem? Thanks a > > lot. > > > > Peter > > > > > > > > _______________________________________________ > > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ------------------------------ > > Message: 4 > Date: Mon, 22 Apr 2013 10:22:34 +0200 > From: "Fischer, Katrin" <Katrin.Fischer(a)bsz-bw.de> > To: "Bernardo Gonzalez Kriegel" <bgkriegel(a)gmail.com>, "Galen > Charlton" <gmc(a)esilibrary.com> > Cc: Koha-List <koha(a)lists.katipo.co.nz>, > koha-translate(a)lists.koha-community.org, Koha Devel > <Koha-devel(a)lists.koha-community.org> > Subject: Re: [Koha] [Koha-devel] Translation manager for v3.14 > Message-ID: > <028B1A54D03E7B4482CDCA4EC8F06BFD02BCA0F9(a)Bodensee.bsz-bw.de> > Content-Type: text/plain; charset="UTF-8" > > Hi Bernardo, > > thank you for volunteering! > > I have been helping out with setting up permissions and accounts for > translators on Pootle and can continue doing that if the new translation > manager would like me to. > > Katrin > > > -----Original Message----- > > From: koha-bounces(a)lists.katipo.co.nz [mailto:koha- > > bounces(a)lists.katipo.co.nz] On Behalf Of Bernardo Gonzalez Kriegel > > Sent: Saturday, April 20, 2013 9:22 PM > > To: Galen Charlton > > Cc: Koha-List; koha-translate(a)lists.koha-community.org; Koha Devel > > Subject: Re: [Koha] [Koha-devel] Translation manager for v3.14 > > > > Hi all, > > > > On Fri, Apr 19, 2013 at 5:29 PM, D Ruth Bavousett <druthb(a)gmail.com> > wrote: > > > > Given my situation, and after discussing the matter with Galen, I've > > > decided > > > > that my term as Translation Manager should end after the release of > > > > 3.12 next month. I'll be happy to help hand off matters, and will > > > > update the wiki page to reflect current processes, in order to make > > > > for a smooth transition, once someone is elected. > > > > > > > > Ruth, as many others have expressed , is sad news that you need to leave. > > Also, we all expect that you remain involved as far as you can. > > > > > > > As far as the election is concerned, I suggest that folks interested > > > in being the Translation Manager for 3.14 submit their proposals in > > > time for discussion to take place at the next general IRC meeting, > > > which is scheduled for 7 May 2013. In case there isn't a quick > > > consensus achieved at that meeting, I further suggest that the vote > > > for TM be held at the June meeting. > > > > > > > > About the role of TM, I want to volunteer for the post. > > I currently run the site dedicated to the translation of the manual, also > > using Pootle. Certainly is a small site, there are only > > 2 active translations (Arabic and Spanish), but that gives me a glimpse > of > > the tasks involved. > > > > I know there are some ideas about migrating out of Pootle to better > tools, > > but I am also appointed as RM for 3.10.x, for that reason I prefer not to > > change our tools at this moment. > > > > So, I think I can deal with both posts but without changes in current > > infrastructure; or someone could take RM 3.10.x, I have no problem to > step > > back; or we found another volunteer for TM with more time. > > > > As far as I know, there is no need to relocate current translate.k-c > > server, anyone interested could use it without problem. > > > > Best regards, > > Bernardo > > _______________________________________________ > > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ------------------------------ > > Message: 5 > Date: Tue, 23 Apr 2013 20:43:45 +1200 > From: Mason James <mtj(a)kohaaloha.com> > To: schnydszch <eugenegf(a)yahoo.com> > Cc: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] koha lost/missing items > Message-ID: <53F4CFFC-6FAD-478D-A157-678DCBC871F1(a)kohaaloha.com> > Content-Type: text/plain; charset=windows-1252 > > > On 2013-04-22, at 7:15 PM, schnydszch wrote: > > > I have Koha 3.10.4 installed in debian server. Whenever I set status to > an > > item in moredetail.pl as lost it does not reflect that it's lost. > > this is nearly always caused by the slight lag in zebra indexing > > reindex your zebra? is the problem solved? > > > > > ------------------------------ > > Message: 6 > Date: Tue, 23 Apr 2013 05:10:01 -0700 (PDT) > From: Usman <usmi_usman(a)yahoo.com> > To: "Koha(a)lists.katipo.co.nz" <Koha(a)lists.katipo.co.nz> > Subject: [Koha] Please unsubscribe me > Message-ID: > <1366719001.9727.YahooMailNeo(a)web141001.mail.bf1.yahoo.com> > Content-Type: text/plain; charset=iso-8859-1 > > Hello, > > Please unsubscribe me from this list. > > Thank You !! > ? > ---- > Muhammad Usman > Phone : +923215823532 > IM : usman_usmi4(a)hotmail.com > Skype: usmi_usman > Profile:http://www.linkedin.com/in/usmiusman > > ------------------------------ > > Message: 7 > Date: Tue, 23 Apr 2013 08:34:02 -0400 > From: Nicole Engard <nengard(a)gmail.com> > To: Bernardo Gonzalez Kriegel <bgkriegel(a)gmail.com> > Cc: Koha <Koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Report Help > Message-ID: > < > CAC0K6VFwzvTct1vd1DW4tPy+XXNG-r7g_ZnjH-7rzhdqS+puvg(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Thank you! That's a step in the right direction :) I have shared it (in > your name) on the Koha wiki for others to benefit from. > > Nicole > > > On Mon, Apr 22, 2013 at 9:19 PM, Bernardo Gonzalez Kriegel < > bgkriegel(a)gmail.com> wrote: > > > Nicole, > > you want for each guarantor it's guarantees, Q: it's ok to repeat > > guarantor information on each guarantee tuple? > > > > you could use something like this (put any data you want in first select, > > and change order by if needed) > > > > SELECT > > IFNULL(concat(g.surname, ', ', g.firstname, ' (',g.cardnumber, ')'),'') > > AS guarantor, > > IFNULL(concat(p.surname, ', ', p.firstname, ' (',p.cardnumber, ')'),'') > > AS guarantee > > FROM > > ( > > SELECT * > > FROM borrowers > > WHERE guarantorid IS NOT NULL > > ) AS p > > LEFT JOIN borrowers AS g > > ON p.guarantorid = g.borrowernumber > > ORDER BY g.borrowernumber > > ; > > > > Bernardo > > > > -- > > Bernardo Gonzalez Kriegel > > bgkriegel(a)gmail.com > > > > > > On Mon, Apr 22, 2013 at 4:18 PM, Nicole Engard <nengard(a)gmail.com> > wrote: > > > >> I'm looking to change this report around. It shows patrons with their > >> guarantor information. I want a report that shows me the guarantees for > >> each guarantor instead. > >> > >> > >> SELECT p.categorycode, p.dateofbirth, p.cardnumber, p.surname, > >> p.firstname, > >> p.dateexpiry, IFNULL(concat(g.surname, ', ', g.firstname, ' (', > >> g.cardnumber, ')'),'') AS guarantor, p.relationship, > >> ifnull(FORMAT(SUM(a.amountoutstanding),2),'0.00') AS due > >> FROM borrowers p > >> LEFT JOIN accountlines a USING (borrowernumber) > >> LEFT JOIN borrowers g ON (p.guarantorid=g.borrowernumber) > >> WHERE p.dateexpiry < NOW() > >> GROUP BY p.borrowernumber > >> ORDER BY p.dateexpiry ASC > >> > >> > >> > >> Nicole > >> _______________________________________________ > >> Koha mailing list http://koha-community.org > >> Koha(a)lists.katipo.co.nz > >> http://lists.katipo.co.nz/mailman/listinfo/koha > >> > > > > > > > ------------------------------ > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > End of Koha Digest, Vol 90, Issue 31 > ************************************ >

1 0

Please unsubscribe me
by Usman 23 Apr '13

23 Apr '13

Hello, Please unsubscribe me from this list. Thank You !! ---- Muhammad Usman Phone : +923215823532 IM : usman_usmi4(a)hotmail.com Skype: usmi_usman Profile:http://www.linkedin.com/in/usmiusman

2 1

Report Help
by Nicole Engard 23 Apr '13

23 Apr '13

I'm looking to change this report around. It shows patrons with their guarantor information. I want a report that shows me the guarantees for each guarantor instead. SELECT p.categorycode, p.dateofbirth, p.cardnumber, p.surname, p.firstname, p.dateexpiry, IFNULL(concat(g.surname, ', ', g.firstname, ' (', g.cardnumber, ')'),'') AS guarantor, p.relationship, ifnull(FORMAT(SUM(a.amountoutstanding),2),'0.00') AS due FROM borrowers p LEFT JOIN accountlines a USING (borrowernumber) LEFT JOIN borrowers g ON (p.guarantorid=g.borrowernumber) WHERE p.dateexpiry < NOW() GROUP BY p.borrowernumber ORDER BY p.dateexpiry ASC Nicole

2 2

koha lost/missing items
by schnydszch 23 Apr '13

23 Apr '13

I have Koha 3.10.4 installed in debian server. Whenever I set status to an item in moredetail.pl as lost it does not reflect that it's lost. And when I try to edit the item in additem.pl in 952$1, it also does not reflect. The framework for the particular book is Fast-add Framework and I check the MARC bibliographic framework, 952$1 is enabled or open. I have authorized values for LOST: Long Overdue (Lost), Lost, Lost and Paid For, Missing, Replaced and Withdrawn. Could I be missing something? And one more thing, can I ask the community how do you deal with replaced items? Thanks and Good day! -- View this message in context: http://koha.1045719.n5.nabble.com/koha-lost-missing-items-tp5751775.html Sent from the Koha-general mailing list archive at Nabble.com.

2 1

Marc framework errors
by rfblanchard 22 Apr '13

22 Apr '13

Using koha 3.10.4 If I run a 'MARC bibliographic framework test' I get this: -------------------------- MARC bibliographic framework test Test Result itemnum The field itemnum MUST be mapped The corresponding subfield MUST be in with -1 (ignore) tab OK All item fields are in the same tag and in item tab OK Only 1 MARC tag mapped to items OK biblioitems.itemtype defined homebranch NOT mapped the items.homebranch field MUST : be mapped to a MARC subfield, the corresponding subfield MUST have authorised value=branches holdingbranch NOT mapped the items.holdingbranch field MUST : be mapped to a MARC subfield, the corresponding subfield MUST have authorised value=branches OK at least 1 item type defined OK at least 1 library defined biblio and biblionumber The biblio.biblionumber and biblioitems.biblioitemnumber fields be mapped to a MARC subfield, OK no NULL value in frameworkcode subfields not in same tabs Not all subfields for the following tags are in the same tab (or marked 'ignored'). Code Description Tag Tabs in use Default framework 999 1,0 NEW new 999 1,0 OK all authority types used in the frameworks are defined TOTAL You have 5 error(s) in your MARC configuration. Please fix them before using Koha ------------------------------- I'm trying to fix the homebranch first. I choose 'koha to marc mapping' -> items -> and see that homebranch is mapped to '952 a Permanent location'. Tried saving it to something else as well. nothing sees to fix the error. same issue with holdingbranch Why am I getting this error in my marc framework and is there anyway to fix it? Any queries I could run on the db as a test? Thanks -- View this message in context: http://koha.1045719.n5.nabble.com/Marc-framework-errors-tp5751439.html Sent from the Koha-general mailing list archive at Nabble.com.

2 2

Unexpected report results - returning old data
by Elaine Bradtke 22 Apr '13

22 Apr '13

I'm running Koha 3.10.02 We have a report that looks for 6XX fields that are not linked to authorities and spits out a list of the unauthorized headings. It was very useful a few months ago in helping us find and correct an error with some imported data. We're about to import another big batch of data, and I ran the report again, just to check for anything that needed to be looked at first. But it's returning all the headings that were fixed the last time. Could it possibly searching cached data somewhere? I spot checked the headings and they are indeed properly linked. It's like I've discovered a time machine that takes us back to our old problems! We have re-indexed, and tried it again with the same results. Here's the SQL for the report: SELECT DISTINCT heading FROM ( SELECT ExtractValue(marcxml, '//datafield[@tag="650"]/subfield[@code="a"]') AS heading FROM biblioitems WHERE length(ExtractValue(marcxml, '//datafield[@tag="650"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(marcxml, '//datafield[@tag="650"]/subfield[@code="9"]')) = 0 UNION SELECT ExtractValue(marcxml, '//datafield[@tag="610"]/subfield[@code="a"]') AS heading FROM biblioitems WHERE length(ExtractValue(marcxml, '//datafield[@tag="610"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(marcxml, '//datafield[@tag="110"]/subfield[@code="9"]')) = 0 UNION SELECT ExtractValue(marcxml, '//datafield[@tag="600"]/subfield[@code="a"]') AS heading FROM biblioitems WHERE length(ExtractValue(marcxml, '//datafield[@tag="600"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(marcxml, '//datafield[@tag="600"]/subfield[@code="9"]')) = 0 UNION SELECT ExtractValue(marcxml, '//datafield[@tag="130"]/subfield[@code="a"]') AS heading FROM biblioitems WHERE length(ExtractValue(marcxml, '//datafield[@tag="611"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(marcxml, '//datafield[@tag="611"]/subfield[@code="9"]')) = 0 ) AS heads ORDER BY heading -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

1 0

Translation manager for v3.14
by D Ruth Bavousett 22 Apr '13

22 Apr '13

To my friends around the world in the Koha community: When the election cycle for v3.14 was ramping up, I had just recently left ByWater and moved to Houston for a new job. My hope was that enough of my time would be freed up for me to spend more time on translation-related developments when things had settled down some. That has, unfortunately, not been the case, and I'm just barely able to keep things afloat with keeping the Pootle server happy! Frustrations with that have persisted, and I so appreciate the patience of all the translators, the RM, and the RMaint as I've struggled to keep things afloat during this stressful period. I also want to thank Katrin for loads of help with the role that she has freely given while I've been in and out. Given my situation, and after discussing the matter with Galen, I've decided that my term as Translation Manager should end after the release of 3.12 next month. I'll be happy to help hand off matters, and will update the wiki page to reflect current processes, in order to make for a smooth transition, once someone is elected. I'll still be around some; several of the people that I am closest to are Koha people, and that doesn't change. I just need some uncommitted time to get my home and life in a little better order. With sincerest regards, D Ruth Bavousett Translation Manager, Koha v3.12

4 3

Re: [Koha] Problem with patrons import
by Sonia P. 22 Apr '13

22 Apr '13

Hello Thanks all for your help. I use a Mac too, but I don't know that Numbers application (I am not good with Mac, but somehow it is the only thing I am allowed to use here... >.<). Maybe this is a Mac problem? I will have to reinstall a spreadsheet application on my PC to try again. It worked very well the previous times I tried to import patrons, but then I was on my PC... Anyway, back on that Mac, I opened my .csv file and it reads: borrowernumber,cardnumber,surname,firstname,title,address,address2,city,state,zipcode,email,phone,fax,branchcode,categorycode,gonenoaddressT1,T1,TARTAMPION,Philip,Mr & Mrs,Po BOX xxx,,Birdcity,,2608,email(a)email.com.au,6123 4567,6987 6543,CANB,A,T2,T2,MACHINTRUC,Bidule,"Ms",Pink House,,City,,2600,,,,CANB,A,13,13,PATATRUC,Philip,Mr,Po Box xxx,,Fishcity,,2604,email(a)email.com.au,0412 1234 5678,02 6123 4567,CANB,A, ETC ETC Aman, thanks for your help, but it has been done as mentioned again and again... :) Cheers, Sonia. Date: Wed, 17 Apr 2013 14:38:18 +1200 Subject: Re: [Koha] Problem with patrons import From: amurphy(a)katikaticollege.school.nz To: sossolapro(a)hotmail.com Hi Sonia I too had this problem. I have a work around; it's not pretty but it works.I open the .csv file in Excel, cut/copy the patrons and paste them into a template spreadsheet with the correct headings. I work out the information for attributes, library code and patron categories then save and close. I open the file in Numbers (I use a Mac — I'm not sure of the PC equivalent) then export (in the file menu) the file using .csv and text encoding Unicode (UTF-8). Then I delete the .csv from the file_name (the message asks if I am sure I want to do this — yes). It then uploads just fine. I don't know why this works but it does. Every now and then I try the direct way, but so far no go. Good Luck -- Ann Murphy Librarian Katikati College Beach Road, Katikati, 3129 New Zealand 0064 7 5492647 amurphy(a)katikaticollege.school.nz

1 1

(no subject)
by Abdullah Al-Modabber 21 Apr '13

21 Apr '13

http://avicolafarms.com/wp-content/plugins/akismet/serviceg/mall/media

1 0