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, <[email protected]> wrote: > Send Koha mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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 <[email protected]> > To: Nicole Engard <[email protected]> > Cc: Koha <[email protected]> > Subject: Re: [Koha] Report Help > Message-ID: > <CADF4kvQYUY2M7BtwU-L3pDPA=02-OHSx= > [email protected]> > 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 > [email protected] > > > On Mon, Apr 22, 2013 at 4:18 PM, Nicole Engard <[email protected]> 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 > > [email protected] > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ------------------------------ > > Message: 2 > Date: Tue, 23 Apr 2013 14:22:04 +0800 (CST) > From: "Peter Zhao" <[email protected]> > To: [email protected] > Subject: [Koha] Opac can't show non-latin characters correctly > Message-ID: <[email protected]> > 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" <[email protected]> > To: "Peter Zhao" <[email protected]>, <[email protected]> > Subject: Re: [Koha] Opac can't show non-latin characters correctly > Message-ID: > <[email protected]> > 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: [email protected] [mailto:koha- > > [email protected]] On Behalf Of Peter Zhao > > Sent: Tuesday, April 23, 2013 8:22 AM > > To: [email protected] > > 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 [email protected] > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ------------------------------ > > Message: 4 > Date: Mon, 22 Apr 2013 10:22:34 +0200 > From: "Fischer, Katrin" <[email protected]> > To: "Bernardo Gonzalez Kriegel" <[email protected]>, "Galen > Charlton" <[email protected]> > Cc: Koha-List <[email protected]>, > [email protected], Koha Devel > <[email protected]> > Subject: Re: [Koha] [Koha-devel] Translation manager for v3.14 > Message-ID: > <[email protected]> > 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: [email protected] [mailto:koha- > > [email protected]] On Behalf Of Bernardo Gonzalez Kriegel > > Sent: Saturday, April 20, 2013 9:22 PM > > To: Galen Charlton > > Cc: Koha-List; [email protected]; 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 <[email protected]> > 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 [email protected] > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ------------------------------ > > Message: 5 > Date: Tue, 23 Apr 2013 20:43:45 +1200 > From: Mason James <[email protected]> > To: schnydszch <[email protected]> > Cc: [email protected] > Subject: Re: [Koha] koha lost/missing items > Message-ID: <[email protected]> > 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 <[email protected]> > To: "[email protected]" <[email protected]> > Subject: [Koha] Please unsubscribe me > Message-ID: > <[email protected]> > Content-Type: text/plain; charset=iso-8859-1 > > Hello, > > Please unsubscribe me from this list. > > Thank You !! > ? > ---- > Muhammad Usman > Phone : +923215823532 > IM : [email protected] > Skype: usmi_usman > Profile:http://www.linkedin.com/in/usmiusman > > ------------------------------ > > Message: 7 > Date: Tue, 23 Apr 2013 08:34:02 -0400 > From: Nicole Engard <[email protected]> > To: Bernardo Gonzalez Kriegel <[email protected]> > Cc: Koha <[email protected]> > Subject: Re: [Koha] Report Help > Message-ID: > < > cac0k6vfwzvtct1vd1dw4tpy+xxng-r7g_znjh-7rzhdqs+p...@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 < > [email protected]> 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 > > [email protected] > > > > > > On Mon, Apr 22, 2013 at 4:18 PM, Nicole Engard <[email protected]> > 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 > >> [email protected] > >> http://lists.katipo.co.nz/mailman/listinfo/koha > >> > > > > > > > ------------------------------ > > _______________________________________________ > Koha mailing list > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > > > End of Koha Digest, Vol 90, Issue 31 > ************************************ > _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
