[Koha] SQL for reports

Tue Aug 16 04:14:20 NZST 2011

Hello,
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.

thanks

--- On Sun, 8/14/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 30
To: koha at lists.katipo.co.nz
Date: Sunday, August 14, 2011, 5:00 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: Koha and Drupal (S?bastien Hinderer)
   2. git bz setup question (Nicole Engard)
   3. Re: git bz setup question (Chris Cormack)
   4. Re: 3.4.3 on opensuse 11.4 SMS::Send Date::ICal problem.
      (Chris Cormack)
   5. Koha installation on Debian/Ubuntu (Gyaneshwar Narayan Junior)

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

Message: 1
Date: Sun, 14 Aug 2011 20:46:08 +0200
From: S?bastien Hinderer <Sebastien.Hinderer at ens-lyon.org>
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] Koha and Drupal
Message-ID: <20110814184608.GA3817 at pema>
Content-Type: text/plain; charset=iso-8859-1

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.

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

Message: 2
Date: Sun, 14 Aug 2011 15:16:13 -0500
From: Nicole Engard <nengard at gmail.com>
To: Koha <Koha at lists.katipo.co.nz>
Subject: [Koha] git bz setup question
Message-ID:
    <CAC0K6VEUGUqkCODhgnHTZd96rWUAKHtA-PbBa1p-X2fCWTGfoA at mail.gmail.com>
Content-Type: text/plain; charset=UTF-8

I have followed the instructions on the wiki, but every time I restart
my virtual machine I need to repeat the path line before git bz will
work. Is there a way to have tat path figured out automatically?

nengard at debian:~/kohaclone$ git bz attach -e 6716 HEAD
git: 'bz' is not a git command. See 'git --help'.

Did you mean one of these?
        am
        gc
        mv
        rm
nengard at debian:~/kohaclone$ PATH=$PATH:/usr/sbin:/usr/bin:/usr/local/bin
nengard at debian:~/kohaclone$ git bz attach -e 6716 HEAD

Thanks in advance
Nicole

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

Message: 3
Date: Mon, 15 Aug 2011 08:17:44 +1200
From: Chris Cormack <chris at bigballofwax.co.nz>
To: Nicole Engard <nengard at gmail.com>
Cc: Koha <Koha at lists.katipo.co.nz>
Subject: Re: [Koha] git bz setup question
Message-ID:
    <CA+95qVS9scaO03eSHfP4=z=V0kZiegDQyxR2H5+E37CiroWOdg at mail.gmail.com>
Content-Type: text/plain; charset=UTF-8

Im gonna answer you over on Koha-devel :)

On 15 August 2011 08:16, Nicole Engard <nengard at gmail.com> wrote:
> I have followed the instructions on the wiki, but every time I restart
> my virtual machine I need to repeat the path line before git bz will
> work. Is there a way to have tat path figured out automatically?
>
> nengard at debian:~/kohaclone$ git bz attach -e 6716 HEAD
> git: 'bz' is not a git command. See 'git --help'.
>
> Did you mean one of these?
> ? ? ? ?am
> ? ? ? ?gc
> ? ? ? ?mv
> ? ? ? ?rm
> nengard at debian:~/kohaclone$ PATH=$PATH:/usr/sbin:/usr/bin:/usr/local/bin
> nengard at debian:~/kohaclone$ git bz attach -e 6716 HEAD
>
> Thanks in advance
> Nicole
> _______________________________________________
> 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, 15 Aug 2011 08:25:41 +1200
From: Chris Cormack <chrisc at catalyst.net.nz>
To: "clint.deckard" <clint.deckard at frontiers.co.nz>
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] 3.4.3 on opensuse 11.4 SMS::Send Date::ICal
    problem.
Message-ID: <20110814202541.GJ3364 at rorohiko.wgtn.cat-it.co.nz>
Content-Type: text/plain; charset="us-ascii"

* clint.deckard (clint.deckard at frontiers.co.nz) wrote:
> Greetings,
> First time poster, long time lurker. Met some of you at Kohacon 2010
> and around. Thank you in advance.
> 
> I have installed Koha 3.4.3 on a fresh install of Opensuse 11.4.
> 
> Web installer reports SMS::Send and Date::ICal as missing but are installed.
> 
> Google searching found similar reported problem and reported bug
> 6560 and 6561
> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6560
> but resolution so far.
> What to do now?
> Some (hopefully) relevant info belong.
> 
Hi Clint

Hopefully someone who uses Opensuse will chip in with why it's not
working there. I do know that people have gotten it working
successfully in the past.

Chris

-- 
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: Digital signature
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20110815/fedcdcc8/attachment-0001.pgp>

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

Message: 5
Date: Mon, 15 Aug 2011 09:07:26 +1200
From: "Gyaneshwar Narayan Junior" <narayan_g at usp.ac.fj>
To: "'Koha'" <Koha at lists.katipo.co.nz>
Subject: [Koha] Koha installation on Debian/Ubuntu
Message-ID: <008601cc5ac6$2b79f8a0$826de9e0$@ac.fj>
Content-Type: text/plain;    charset="UTF-8"

Good morning All

Sorry to disturb you guys.
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.

Regards.

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

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

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