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