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@lists.katipo.co.nz> wrote:
Send Koha mailing list submissions to koha@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@lists.katipo.co.nz
You can reach the person managing the list at koha-owner@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@gmail.com> To: Nicole Engard <nengard@gmail.com> Cc: Koha <Koha@lists.katipo.co.nz> Subject: Re: [Koha] Report Help Message-ID: <CADF4kvQYUY2M7BtwU-L3pDPA=02-OHSx= SyTWytO_6h1zyPZYg@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@gmail.com
On Mon, Apr 22, 2013 at 4:18 PM, Nicole Engard <nengard@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@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@163.com> To: koha@lists.katipo.co.nz Subject: [Koha] Opac can't show non-latin characters correctly Message-ID: <3007ca14.81f9.13e358e66ae.Coremail.peterzhaonj@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@bsz-bw.de> To: "Peter Zhao" <peterzhaonj@163.com>, <koha@lists.katipo.co.nz> Subject: Re: [Koha] Opac can't show non-latin characters correctly Message-ID: <028B1A54D03E7B4482CDCA4EC8F06BFD02BCA251@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@lists.katipo.co.nz [mailto:koha- bounces@lists.katipo.co.nz] On Behalf Of Peter Zhao Sent: Tuesday, April 23, 2013 8:22 AM To: koha@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@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@bsz-bw.de> To: "Bernardo Gonzalez Kriegel" <bgkriegel@gmail.com>, "Galen Charlton" <gmc@esilibrary.com> Cc: Koha-List <koha@lists.katipo.co.nz>, koha-translate@lists.koha-community.org, Koha Devel <Koha-devel@lists.koha-community.org> Subject: Re: [Koha] [Koha-devel] Translation manager for v3.14 Message-ID: <028B1A54D03E7B4482CDCA4EC8F06BFD02BCA0F9@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@lists.katipo.co.nz [mailto:koha- bounces@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@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@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@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@kohaaloha.com> To: schnydszch <eugenegf@yahoo.com> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] koha lost/missing items Message-ID: <53F4CFFC-6FAD-478D-A157-678DCBC871F1@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@yahoo.com> To: "Koha@lists.katipo.co.nz" <Koha@lists.katipo.co.nz> Subject: [Koha] Please unsubscribe me Message-ID: <1366719001.9727.YahooMailNeo@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@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@gmail.com> To: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> Cc: Koha <Koha@lists.katipo.co.nz> Subject: Re: [Koha] Report Help Message-ID: < CAC0K6VFwzvTct1vd1DW4tPy+XXNG-r7g_ZnjH-7rzhdqS+puvg@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@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@gmail.com
On Mon, Apr 22, 2013 at 4:18 PM, Nicole Engard <nengard@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
End of Koha Digest, Vol 90, Issue 31 ************************************