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 . thanks --- On Mon, 8/15/11, koha-request@lists.katipo.co.nz <koha-request@lists.katipo.co.nz> wrote: From: koha-request@lists.katipo.co.nz <koha-request@lists.katipo.co.nz> Subject: Koha Digest, Vol 70, Issue 32 To: koha@lists.katipo.co.nz Date: Monday, August 15, 2011, 1:33 PM 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: SQL for reports (Owen Leonard) 2. Re: Koha and Drupal (Lori Bowen Ayre) 3. KohaCon (Carlin, William) 4. Kohacon11 : Last date of paper submission extended till August 30 2011 (Koustubha Kale) 5. Re: Koha installation on Debian/Ubuntu (Dibyendra Hyoju) ---------------------------------------------------------------------- Message: 1 Date: Mon, 15 Aug 2011 12:18:21 -0400 From: Owen Leonard <oleonard@myacpl.org> To: "Akin Adigun (Akinomatics)" <akinomatics@yahoo.com> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] SQL for reports Message-ID: <CAO4qe2NeLSvcM-ZK5WZsOwu2Tg=WEFSK6QpyWtBnLQFhdUA2kg@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1
I am using Koha 3.4 and on Ubuntu. Can any one help me out with the sql statement that can generate librarian that pay, cancel or writeoff a fine in koha.
Have you looked here? http://wiki.koha-community.org/wiki/SQL_Reports_Library Also, please don't reply to and quote the entire Koha digest when posting. Please start a new thread by emailing Koha@lists.katipo.co.nz. Thanks, Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org ------------------------------ Message: 2 Date: Mon, 15 Aug 2011 09:51:37 -0700 From: Lori Bowen Ayre <lori.ayre@galecia.com> To: S?bastien Hinderer <Sebastien.Hinderer@ens-lyon.org> Cc: Koha list <koha@lists.katipo.co.nz> Subject: Re: [Koha] Koha and Drupal Message-ID: <CAEJpJYVEjoaiB8O-U_i0=mnN+GCG8H=Hg+CQCxBtzqBdBhZfRA@mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1" Have you seen eXtensible Catalog? It provides a top layer that is Drupal based (one node per record as you mentioned). And they have some nice conversion utilities for grabbing catalog content and converting it to the XC Schema which relies on Drupal for the OPAC layer. http://www.extensiblecatalog.org/ Lori =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-= Lori Bowen Ayre // Library Technology Consultant / The Galecia Group Oversight Board & Communications Committee / Evergreen (707) 763-6869 // Lori.Ayre@galecia.com <Lori.Ayre@galecia.com>Specializing in open source ILS solutions, RFID, filtering, workflow optimization, and materials handling =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= On Sun, Aug 14, 2011 at 11:46 AM, S?bastien Hinderer < Sebastien.Hinderer@ens-lyon.org> wrote:
Hello Henri-Damien, many thanks for your so detailed response !
you may find on git.biblibre.com koha_biblibre.git (which are also on git.koha-community.org/koha.git in so far as all the ils-di required infrastructure is concerned), sopac.git and locuum.git and insurge.git, which contains all the patches we had to do to install SOPAC on top of a Koha installation.
Okay, many thanks for the pointers !
It is working but it not that handy to install.
I see. Does it mean that, altough it is difficult to install, once the initial installation is done it is working relatively well and easy to maintain ?
And some choices for SOPAC makes that project quite difficult to run (namely sphinx and the insurge/locum technology and the fact that it relies on old drupal version), along with quite hard coded css quite restrict the potential of SOPAC.
Okay. I'd like to ask several questions here. 1. Which version of drupal does it rely on ? 2. I have to say I did not understand what locum and insurge are. Any clue for me ?
We tried to contribute the patches we wrote in order to fix some bugs. But it is free software, ppl may or may not take on your contributions and proposals.
Indeed. Does it mean that there are currently no exchanges with sopac maintainers ?
It is in production for some libraries. We can assist in the realization of that or provide you with url for that.
I'm interested in any URL. I'm trying to build yet another digital library. Now that I know about Koha and how good it is for cataloging and exploring an OPAC, I have to say it is difficult for me to renounce to powerful cataloguing/opac features. My first idea was ths a three component solution: Drupal for the protal, Koha for the OPAC and a third component yet to be chosen to handle files pertaining to each book. Such an approach has, however, several pitfalls: it is heavy and there is a problem if one wants to share authenticaiton. So I thought that SOPAC could help: the (Koha) OPAC and Drupal would merge, and then I could use Drupal to store and give access to the files associated with each book.
Any comment here would be warmly appreciated.
We are still convinced that drupal is really a nice thing and the fact that solr could be also used in drupal could make it really handy.
Yeah I'd love to be able to use drupal for my digital library, find it rather convenient, too.
Maybe you could also take a look at mkdrul from indexdata and find something interesting.
Is such a module interesting even when you'd query only one Z39.50 server ? In my case, I think I'd query only my local Koha where everything would be catalogued. And would such an approach let one see from within drupal the virtual shelves defined in Koha. And finally: the fact that it seems to rely heavily on javascript makes me think it would perhaps not be very accessible, but I didn't try it out...
Hope that helps.
It helps, thanks a lot and best wishes, S?bastien. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha