<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Can anyone help with the sql statement that can display the Librarian that cancel, pay or write off and the amount of fine each Librarian pay,cancel or write off .<br>thanks<br><br>--- On <b>Mon, 8/15/11, koha-request@lists.katipo.co.nz <i><koha-request@lists.katipo.co.nz></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: koha-request@lists.katipo.co.nz <koha-request@lists.katipo.co.nz><br>Subject: Koha Digest, Vol 70, Issue 32<br>To: koha@lists.katipo.co.nz<br>Date: Monday, August 15, 2011, 1:33 PM<br><br><div class="plainMail">Send Koha mailing list submissions to<br> <a ymailto="mailto:koha@lists.katipo.co.nz" href="/mc/compose?to=koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a><br><br>To subscribe or unsubscribe via the World Wide Web,
visit<br> <a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>or, via email, send a message with subject or body 'help' to<br> <a ymailto="mailto:koha-request@lists.katipo.co.nz" href="/mc/compose?to=koha-request@lists.katipo.co.nz">koha-request@lists.katipo.co.nz</a><br><br>You can reach the person managing the list at<br> <a ymailto="mailto:koha-owner@lists.katipo.co.nz" href="/mc/compose?to=koha-owner@lists.katipo.co.nz">koha-owner@lists.katipo.co.nz</a><br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Koha digest..."<br><br><br>Today's Topics:<br><br> 1. Re: SQL for reports (Owen Leonard)<br> 2. Re: Koha and Drupal (Lori Bowen Ayre)<br> 3. KohaCon (Carlin, William)<br> 4. Kohacon11 : Last date of paper
submission extended till<br> August 30 2011 (Koustubha Kale)<br> 5. Re: Koha installation on Debian/Ubuntu (Dibyendra Hyoju)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Mon, 15 Aug 2011 12:18:21 -0400<br>From: Owen Leonard <<a ymailto="mailto:oleonard@myacpl.org" href="/mc/compose?to=oleonard@myacpl.org">oleonard@myacpl.org</a>><br>To: "Akin Adigun (Akinomatics)" <<a ymailto="mailto:akinomatics@yahoo.com" href="/mc/compose?to=akinomatics@yahoo.com">akinomatics@yahoo.com</a>><br>Cc: <a ymailto="mailto:koha@lists.katipo.co.nz" href="/mc/compose?to=koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a><br>Subject: Re: [Koha] SQL for reports<br>Message-ID:<br> <CAO4qe2NeLSvcM-ZK5WZsOwu2Tg=<a ymailto="mailto:WEFSK6QpyWtBnLQFhdUA2kg@mail.gmail.com"
href="/mc/compose?to=WEFSK6QpyWtBnLQFhdUA2kg@mail.gmail.com">WEFSK6QpyWtBnLQFhdUA2kg@mail.gmail.com</a>><br>Content-Type: text/plain; charset=ISO-8859-1<br><br>> I am using Koha 3.4 and on Ubuntu. Can any one help me out with the sql statement that can<br>> generate librarian that pay, cancel or writeoff a fine in koha.<br><br>Have you looked here?<br><br><a href="http://wiki.koha-community.org/wiki/SQL_Reports_Library" target="_blank">http://wiki.koha-community.org/wiki/SQL_Reports_Library</a><br><br>Also, please don't reply to and quote the entire Koha digest when<br>posting. Please start a new thread by emailing<br><a ymailto="mailto:Koha@lists.katipo.co.nz" href="/mc/compose?to=Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a>.<br><br>Thanks,<br><br> Owen<br><br>--<br>Web Developer<br>Athens County Public Libraries<br><a href="http://www.myacpl.org"
target="_blank">http://www.myacpl.org</a><br><br><br>------------------------------<br><br>Message: 2<br>Date: Mon, 15 Aug 2011 09:51:37 -0700<br>From: Lori Bowen Ayre <<a ymailto="mailto:lori.ayre@galecia.com" href="/mc/compose?to=lori.ayre@galecia.com">lori.ayre@galecia.com</a>><br>To: S?bastien Hinderer <<a ymailto="mailto:Sebastien.Hinderer@ens-lyon.org" href="/mc/compose?to=Sebastien.Hinderer@ens-lyon.org">Sebastien.Hinderer@ens-lyon.org</a>><br>Cc: Koha list <<a ymailto="mailto:koha@lists.katipo.co.nz" href="/mc/compose?to=koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a>><br>Subject: Re: [Koha] Koha and Drupal<br>Message-ID:<br> <CAEJpJYVEjoaiB8O-U_i0=mnN+GCG8H=Hg+<a ymailto="mailto:CQCxBtzqBdBhZfRA@mail.gmail.com" href="/mc/compose?to=CQCxBtzqBdBhZfRA@mail.gmail.com">CQCxBtzqBdBhZfRA@mail.gmail.com</a>><br>Content-Type: text/plain; charset="iso-8859-1"<br><br>Have you seen eXtensible Catalog? It
provides a top layer that is Drupal<br>based (one node per record as you mentioned). And they have some nice<br>conversion utilities for grabbing catalog content and converting it to the<br>XC Schema which relies on Drupal for the OPAC layer.<br><br><a href="http://www.extensiblecatalog.org/" target="_blank">http://www.extensiblecatalog.org/</a><br><br>Lori<br><br>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=<br>Lori Bowen Ayre //<br>Library Technology Consultant / The Galecia Group<br>Oversight Board & Communications Committee / Evergreen<br>(707) 763-6869 // <a ymailto="mailto:Lori.Ayre@galecia.com" href="/mc/compose?to=Lori.Ayre@galecia.com">Lori.Ayre@galecia.com</a><br><br><<a ymailto="mailto:Lori.Ayre@galecia.com" href="/mc/compose?to=Lori.Ayre@galecia.com">Lori.Ayre@galecia.com</a>>Specializing in open source ILS solutions, RFID,<br>filtering,<br>workflow optimization, and materials
handling<br>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=<br><br><br><br>On Sun, Aug 14, 2011 at 11:46 AM, S?bastien Hinderer <<br><a ymailto="mailto:Sebastien.Hinderer@ens-lyon.org" href="/mc/compose?to=Sebastien.Hinderer@ens-lyon.org">Sebastien.Hinderer@ens-lyon.org</a>> wrote:<br><br>> Hello Henri-Damien, many thanks for your so detailed response !<br>><br>> > you may find on git.biblibre.com koha_biblibre.git (which are also on<br>> > git.koha-community.org/koha.git in so far as all the ils-di required<br>> > infrastructure is concerned), sopac.git and locuum.git and insurge.git,<br>> > which contains all the patches we had to do to install SOPAC on top of a<br>> > Koha installation.<br>><br>> Okay, many thanks for the pointers !<br>><br>> > It is working but it not that handy to install.<br>><br>> I see. Does it mean that, altough it is difficult to install, once the<br>>
initial installation is done it is working relatively well and easy to<br>> maintain ?<br>><br>> > And some choices for SOPAC makes that project quite difficult to run<br>> > (namely sphinx and the insurge/locum technology and the fact that it<br>> > relies on old drupal version), along with quite hard coded css quite<br>> > restrict the potential of SOPAC.<br>><br>> Okay. I'd like to ask several questions here.<br>> 1. Which version of drupal does it rely on ?<br>> 2. I have to say I did not understand what locum and insurge are. Any<br>> clue for me ?<br>><br>> > We tried to contribute the patches we wrote in order to fix some bugs.<br>> > But it is free software, ppl may or may not take on your contributions<br>> > and proposals.<br>><br>> Indeed. Does it mean that there are currently no exchanges with sopac<br>> maintainers ?<br>><br>> > It is in production for some
libraries. We can assist in the realization<br>> > of that or provide you with url for that.<br>><br>> I'm interested in any URL. I'm trying to build yet another digital<br>> library. Now that I know about Koha and how good it is for cataloging<br>> and exploring an OPAC, I have to say it is difficult for me to renounce<br>> to powerful cataloguing/opac features. My first idea was ths a three<br>> component solution: Drupal for the protal, Koha for the OPAC and a third<br>> component yet to be chosen to handle files pertaining to each book.<br>> Such an approach has, however, several pitfalls: it is heavy and there<br>> is a problem if one wants to share authenticaiton. So I thought that<br>> SOPAC could help: the (Koha) OPAC and Drupal would merge, and then I<br>> could use Drupal to store and give access to the files associated with<br>> each book.<br>><br>> Any comment here would be warmly
appreciated.<br>><br>> > We are still convinced that drupal is really a nice thing and the fact<br>> > that solr could be also used in drupal could make it really handy.<br>><br>> Yeah I'd love to be able to use drupal for my digital library, find it<br>> rather convenient, too.<br>><br>> > Maybe you could also take a look at mkdrul from indexdata and find<br>> > something interesting.<br>><br>> Is such a module interesting even when you'd query only one Z39.50<br>> server ? In my case, I think I'd query only my local Koha where<br>> everything would be catalogued. And would such an approach let one see<br>> from within drupal the virtual shelves defined in Koha. And finally: the<br>> fact that it seems to rely heavily on javascript makes me think it would<br>> perhaps not be very accessible, but I didn't try it out...<br>><br>> > Hope that helps.<br>><br>> It helps, thanks a lot
and best wishes,<br>> S?bastien.<br>> _______________________________________________<br>> Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br>> <a ymailto="mailto:Koha@lists.katipo.co.nz" href="/mc/compose?to=Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>> <a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a href="http://lists.katipo.co.nz/pipermail/koha/attachments/20110815/9a298532/attachment-0001.html" target="_blank">http://lists.katipo.co.nz/pipermail/koha/attachments/20110815/9a298532/attachment-0001.html</a>><br><br>------------------------------<br><br>Message: 3<br>Date: Mon, 15 Aug 2011 09:42:17 -0700<br>From: "Carlin, William" <<a ymailto="mailto:WCarlin@washoecounty.us"
href="/mc/compose?to=WCarlin@washoecounty.us">WCarlin@washoecounty.us</a>><br>To: <<a ymailto="mailto:koha@lists.katipo.co.nz" href="/mc/compose?to=koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a>><br>Subject: [Koha] KohaCon<br>Message-ID:<br> <<a ymailto="mailto:3D21CC279BBF8940952E444C9A58A38E063692E9@wcmailw.admin.washoecounty.us" href="/mc/compose?to=3D21CC279BBF8940952E444C9A58A38E063692E9@wcmailw.admin.washoecounty.us">3D21CC279BBF8940952E444C9A58A38E063692E9@wcmailw.admin.washoecounty.us</a>><br> <br>Content-Type: text/plain; charset="us-ascii"<br><br>Does anyone know where I can get the number of attendees over the years<br>at KohaCon?<br><br> <br><br>Best wishes,<br><br> <br><br>William Carlin<br><br>Systems<br><br>Washoe County Library System<br><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a
href="http://lists.katipo.co.nz/pipermail/koha/attachments/20110815/1cf89e31/attachment-0001.html" target="_blank">http://lists.katipo.co.nz/pipermail/koha/attachments/20110815/1cf89e31/attachment-0001.html</a>><br><br>------------------------------<br><br>Message: 4<br>Date: Mon, 15 Aug 2011 23:41:37 +0530<br>From: Koustubha Kale <<a ymailto="mailto:kmkale@anantcorp.com" href="/mc/compose?to=kmkale@anantcorp.com">kmkale@anantcorp.com</a>><br>To: Koha list <<a ymailto="mailto:koha@lists.katipo.co.nz" href="/mc/compose?to=koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a>>,<br> <a ymailto="mailto:koha-devel@lists.koha-community.org" href="/mc/compose?to=koha-devel@lists.koha-community.org">koha-devel@lists.koha-community.org</a><br>Subject: [Koha] Kohacon11 : Last date of paper submission extended<br> till August 30 2011<br>Message-ID:<br> <CAP=<a
ymailto="mailto:kTZrMKKF0G5c1tcXnOtqp4aQEMhR0efH3Z5OzBCQiGCN6dA@mail.gmail.com" href="/mc/compose?to=kTZrMKKF0G5c1tcXnOtqp4aQEMhR0efH3Z5OzBCQiGCN6dA@mail.gmail.com">kTZrMKKF0G5c1tcXnOtqp4aQEMhR0efH3Z5OzBCQiGCN6dA@mail.gmail.com</a>><br>Content-Type: text/plain; charset="iso-8859-1"<br><br>Hi All,<br>We have extended the last date of paper submission ( which was today 15th<br>August ) till 30th August 2011.<br><br>Request all of you who would like to present at Kohacon111 to step forward<br>and submit an abstract at<br><a href="http://kohacon11.vpmthane.org/ocs/index.php/k/k11/schedConf/cfp" target="_blank">http://kohacon11.vpmthane.org/ocs/index.php/k/k11/schedConf/cfp</a> for review.<br><br>Also request all of you whose abstracts have been accepted to hurry up and<br>submit the full papers / presentations..<br><br>Regards,<br>Koustubha Kale<br>Anant Corporation<br><br>Contact Details :<br>Address : 103, Armaan Residency, R. W Sawant
Road, Nr. Golden Dyes Naka,<br>Thane (w),<br> Maharashtra, India, Pin : 400601.<br>TeleFax : +91-22-21720108, +91-22-21720109<br>Mobile : +919820715876<br>Website : <a href="http://www.anantcorp.com" target="_blank">http://www.anantcorp.com</a><br>Blog : <a href="http://www.anantcorp.com/blog/?author=2" target="_blank">http://www.anantcorp.com/blog/?author=2</a><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a href="http://lists.katipo.co.nz/pipermail/koha/attachments/20110815/11802d0c/attachment-0001.html" target="_blank">http://lists.katipo.co.nz/pipermail/koha/attachments/20110815/11802d0c/attachment-0001.html</a>><br><br>------------------------------<br><br>Message: 5<br>Date: Mon, 15 Aug 2011 12:36:41 +0545<br>From: Dibyendra Hyoju <<a ymailto="mailto:dibyendra@gmail.com"
href="/mc/compose?to=dibyendra@gmail.com">dibyendra@gmail.com</a>><br>To: <a ymailto="mailto:narayan_g@usp.ac.fj" href="/mc/compose?to=narayan_g@usp.ac.fj">narayan_g@usp.ac.fj</a><br>Cc: <a ymailto="mailto:koha@lists.katipo.co.nz" href="/mc/compose?to=koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a><br>Subject: Re: [Koha] Koha installation on Debian/Ubuntu<br>Message-ID:<br> <CALzo1D=<a ymailto="mailto:zLOyLT8GreaoaMn0tek1s-M6D3QhUYUaTaj-9JidSig@mail.gmail.com" href="/mc/compose?to=zLOyLT8GreaoaMn0tek1s-M6D3QhUYUaTaj-9JidSig@mail.gmail.com">zLOyLT8GreaoaMn0tek1s-M6D3QhUYUaTaj-9JidSig@mail.gmail.com</a>><br>Content-Type: text/plain; charset="utf-8"<br><br>Hi Gyaneshwar Narayan,<br><br>I had prepared this detail installation guide for the Koha workshop. I hope<br>it will be useful for you to install Koha on Ubunu.<br><br>Good luck!<br><br>With regards,<br><br>Dibyendra Hyoju<br><br>Madan Puraskar Pustakalaya<br>Patan Dhoka,
Lalitpur, Nepal<br>Telephone: 977-1-5005515, 977-1-5549948<br>Web: <a href="http://madanpuraskar.org/" target="_blank">http://madanpuraskar.org/</a><br><br><br>On Mon, Aug 15, 2011 at 6:00 AM, Gyaneshwar Narayan Junior <<br><a ymailto="mailto:narayan_g@usp.ac.fj" href="/mc/compose?to=narayan_g@usp.ac.fj">narayan_g@usp.ac.fj</a>> wrote:<br><br>> My apologies!!!<br>> Thanks for the infor by the way<br>><br>> -----Original Message-----<br>> From: <a ymailto="mailto:koha-bounces@lists.katipo.co.nz" href="/mc/compose?to=koha-bounces@lists.katipo.co.nz">koha-bounces@lists.katipo.co.nz</a> [mailto:<br>> <a ymailto="mailto:koha-bounces@lists.katipo.co.nz" href="/mc/compose?to=koha-bounces@lists.katipo.co.nz">koha-bounces@lists.katipo.co.nz</a>] On Behalf Of Robin Sheat<br>> Sent: Monday, 15 August 2011 12:05 PM<br>> To: <a ymailto="mailto:koha@lists.katipo.co.nz"
href="/mc/compose?to=koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a><br>> Subject: Re: [Koha] Koha installation on Debian/Ubuntu<br>><br>> Gyaneshwar Narayan Junior schreef op ma 15-08-2011 om 09:07 [+1200]:<br>> > I am just wondering if anyone has a PDF/Word documentation of KOHA<br>> > installation on Debian or Ubuntu.<br>> > I am a first time user and I am finding it very difficult to install<br>> > KOHA.<br>> > Any prompt help will be highly appreciated.<br>><br>> Two points:<br>> 1) Koha isn't an acronym, so it doesn't need to be in capitals. It's a<br>> normal word.<br>> 2) The wiki is full of information on installing Koha.<br>> For example:<br>> <a href="http://wiki.koha-community.org/wiki/Koha_3.2_on_Debian_Squeeze" target="_blank">http://wiki.koha-community.org/wiki/Koha_3.2_on_Debian_Squeeze</a><br>><br>> --<br>> Robin Sheat<br>> Catalyst IT Ltd.<br>> ? +64 4 803
2204<br>> GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D<br>><br>> _______________________________________________<br>> Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br>> <a ymailto="mailto:Koha@lists.katipo.co.nz" href="/mc/compose?to=Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>> <a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a href="http://lists.katipo.co.nz/pipermail/koha/attachments/20110815/3a2db49a/attachment.html" target="_blank">http://lists.katipo.co.nz/pipermail/koha/attachments/20110815/3a2db49a/attachment.html</a>><br>-------------- next part --------------<br>A non-text attachment was scrubbed...<br>Name:
Koha_3.4_installation_on_ubuntu_11_linux_[detail].pdf<br>Type: application/pdf<br>Size: 435603 bytes<br>Desc: not available<br>URL: <<a href="http://lists.katipo.co.nz/pipermail/koha/attachments/20110815/3a2db49a/attachment.pdf" target="_blank">http://lists.katipo.co.nz/pipermail/koha/attachments/20110815/3a2db49a/attachment.pdf</a>><br><br>------------------------------<br><br>_______________________________________________<br>Koha mailing list<br><a ymailto="mailto:Koha@lists.katipo.co.nz" href="/mc/compose?to=Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br><a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br><br><br>End of Koha Digest, Vol 70, Issue 32<br>************************************<br></div></blockquote></td></tr></table>