[Koha] SQL for to generate the Libarian that pay, cancel or Write Off a fine

Tue Aug 16 20:33:12 NZST 2011

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 at lists.katipo.co.nz <koha-request at lists.katipo.co.nz> wrote:

From: koha-request at lists.katipo.co.nz <koha-request at lists.katipo.co.nz>
Subject: Koha Digest, Vol 70, Issue 32
To: koha at lists.katipo.co.nz
Date: Monday, August 15, 2011, 1:33 PM

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: 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 at myacpl.org>
To: "Akin Adigun (Akinomatics)" <akinomatics at yahoo.com>
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] SQL for reports
Message-ID:
    <CAO4qe2NeLSvcM-ZK5WZsOwu2Tg=WEFSK6QpyWtBnLQFhdUA2kg at 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 at 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 at galecia.com>
To: S?bastien Hinderer <Sebastien.Hinderer at ens-lyon.org>
Cc: Koha list <koha at lists.katipo.co.nz>
Subject: Re: [Koha] Koha and Drupal
Message-ID:
    <CAEJpJYVEjoaiB8O-U_i0=mnN+GCG8H=Hg+CQCxBtzqBdBhZfRA at 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 at galecia.com

<Lori.Ayre at 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 at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20110815/9a298532/attachment-0001.html>

------------------------------

Message: 3
Date: Mon, 15 Aug 2011 09:42:17 -0700
From: "Carlin, William" <WCarlin at washoecounty.us>
To: <koha at lists.katipo.co.nz>
Subject: [Koha] KohaCon
Message-ID:
    <3D21CC279BBF8940952E444C9A58A38E063692E9 at wcmailw.admin.washoecounty.us>

Content-Type: text/plain; charset="us-ascii"

Does anyone know where I can get the number of attendees over the years
at KohaCon?

Best wishes,

William Carlin

Systems

Washoe County Library System

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20110815/1cf89e31/attachment-0001.html>

------------------------------

Message: 4
Date: Mon, 15 Aug 2011 23:41:37 +0530
From: Koustubha Kale <kmkale at anantcorp.com>
To: Koha list <koha at lists.katipo.co.nz>,
    koha-devel at lists.koha-community.org
Subject: [Koha] Kohacon11 : Last date of paper submission extended
    till    August 30 2011
Message-ID:
    <CAP=kTZrMKKF0G5c1tcXnOtqp4aQEMhR0efH3Z5OzBCQiGCN6dA at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Hi All,
We have extended the last date of paper submission ( which was today 15th
August ) till 30th August 2011.

Request all of you who would like to present at Kohacon111 to step forward
and submit an abstract at
http://kohacon11.vpmthane.org/ocs/index.php/k/k11/schedConf/cfp  for review.

Also request all of you whose abstracts have been accepted to hurry up and
submit the full papers / presentations..

Regards,
Koustubha Kale
Anant Corporation

Contact Details :
Address  : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka,
Thane (w),
                Maharashtra, India, Pin : 400601.
TeleFax  : +91-22-21720108, +91-22-21720109
Mobile     : +919820715876
Website  : http://www.anantcorp.com
Blog : http://www.anantcorp.com/blog/?author=2
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20110815/11802d0c/attachment-0001.html>

------------------------------

Message: 5
Date: Mon, 15 Aug 2011 12:36:41 +0545
From: Dibyendra Hyoju <dibyendra at gmail.com>
To: narayan_g at usp.ac.fj
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] Koha installation on Debian/Ubuntu
Message-ID:
    <CALzo1D=zLOyLT8GreaoaMn0tek1s-M6D3QhUYUaTaj-9JidSig at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

Hi Gyaneshwar Narayan,

I had prepared this detail installation guide for the Koha workshop. I hope
it will be useful for you to install Koha on Ubunu.

Good luck!

With regards,

Dibyendra Hyoju

Madan Puraskar Pustakalaya
Patan Dhoka, Lalitpur, Nepal
Telephone: 977-1-5005515, 977-1-5549948
Web: http://madanpuraskar.org/

On Mon, Aug 15, 2011 at 6:00 AM, Gyaneshwar Narayan Junior <
narayan_g at usp.ac.fj> wrote:

> My apologies!!!
> Thanks for the infor by the way
>
> -----Original Message-----
> From: koha-bounces at lists.katipo.co.nz [mailto:
> koha-bounces at lists.katipo.co.nz] On Behalf Of Robin Sheat
> Sent: Monday, 15 August 2011 12:05 PM
> To: koha at lists.katipo.co.nz
> Subject: Re: [Koha] Koha installation on Debian/Ubuntu
>
> Gyaneshwar Narayan Junior schreef op ma 15-08-2011 om 09:07 [+1200]:
> > I am just wondering if anyone has a PDF/Word documentation of KOHA
> > installation on Debian or Ubuntu.
> > I am a first time user and I am finding it very difficult to install
> > KOHA.
> > Any prompt help will be highly appreciated.
>
> Two points:
> 1) Koha isn't an acronym, so it doesn't need to be in capitals. It's a
> normal word.
> 2) The wiki is full of information on installing Koha.
> For example:
> http://wiki.koha-community.org/wiki/Koha_3.2_on_Debian_Squeeze
>
> --
> Robin Sheat
> Catalyst IT Ltd.
> ? +64 4 803 2204
> GPG: 5957 6D23 8B16 EFAB FEF8  7175 14D3 6485 A99C EB6D
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20110815/3a2db49a/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Koha_3.4_installation_on_ubuntu_11_linux_[detail].pdf
Type: application/pdf
Size: 435603 bytes
Desc: not available
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20110815/3a2db49a/attachment.pdf>

------------------------------

_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

End of Koha Digest, Vol 70, Issue 32
************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20110816/5ef3d8bc/attachment-0001.html>