2011/10/20 nico rubo <n4ocin@yahoo.com.au>

Dear Community,
We recently acquired some books from India. A very high number of them do not have their ISBNs registered in any databases where we can copy catalogue from. Do they (India) have their own version of the Z39.50 to which we can subscribe? Please help.

Nick
SICHE Library
Honiara, Solomon Is.

From: "koha-request@lists.katipo.co.nz" <koha-request@lists.katipo.co.nz>
To: koha@lists.katipo.co.nz
Sent: Thursday, 20 October 2011 10:00 AM
Subject: Koha Digest, Vol 72, Issue 42

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: report help - total amount writeoff (Wagner, Jane)
2. Re: Additional packages for install_misc/debian.packages
(Robin Sheat)

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

Message: 1
Date: Wed, 19 Oct 2011 15:24:58 -0400
From: "Wagner, Jane" <jwagner@liblime.com>
To: Peel Lisa <lisa.peel@ritz.edu>, koha@lists.katipo.co.nz
Subject: Re: [Koha] report help - total amount writeoff
Message-ID: <3ab247946ba96552813c39184520130a@mail.gmail.com>
Content-Type: text/plain; charset="windows-1252"

Try something like this:

SELECT round(Sum(accountlines.amount),2) AS 'Writeoffs Last 3 Months' FROM
accountlines WHERE accounttype = 'W' and date like
concat(date_format(LAST_DAY(now() - interval 3 month),'%Y-%m-%'))

(haven?t tested this variant, but I run similar reports for 1 month and
payments)

Jane Wagner

Senior Project Manager

LibLime, a division of PTFS

Content Management and Library Solutions

11501 Huff Court

North Bethesda, MD 20895

(301) 654-8088 x 151

jwagner@liblime.com <jwagner@ptfs.com>

*From:* koha-bounces@lists.katipo.co.nz [mailto:
koha-bounces@lists.katipo.co.nz] *On Behalf Of *Peel Lisa
*Sent:* Wednesday, October 19, 2011 3:08 PM
*To:* 'koha@lists.katipo.co.nz'
*Subject:* [Koha] report help - total amount writeoff

Hello

Report help again I am afraid!

Could anyone supply me with the SQL for a report which will show me the
amount of fines being written off at a specific library for a given period
of time (for example the last three months?)

Regards and thanks in advance

Lisa

[image: Description: Description: Description: CR_logo_POS_COULEUR b]**

* *

* *

*LISA PEEL, PGDip, MA.***

Librarian

C?sar Ritz Colleges Switzerland

1897 Le Bouveret - Switzerland

Tel: +41 24 482 82 82 Fax: +41 24 482 82 80

E-mail: *lisa.peel@ritz.edu <hortense.hofer@ritz.edu>*

http://www.ritz.edu - http://www.culinaryarts.ch
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20111019/25987bec/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 4030 bytes
Desc: not available
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20111019/25987bec/attachment-0001.jpg>

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

Message: 2
Date: Thu, 20 Oct 2011 11:04:42 +1300
From: Robin Sheat <robin@catalyst.net.nz>
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Additional packages for
    install_misc/debian.packages
Message-ID: <1319061882.28975.5.camel@zarathud>
Content-Type: text/plain; charset="utf-8"

Eduardo Tr?pani schreef op wo 19-10-2011 om 10:56 [-0200]:
> Right now libcgi-session-driver-memcached-perl is available on
> testing[1], not on stable. But you can download it from here[2] and
> install it manually, there are no dependency problems.

You'll also find it (and libgravatar-url-perl, which is too old in
Debian stable, I think) in the Koha debian repository at
http://debian.koha-community.org/

--
Robin Sheat
Catalyst IT Ltd.
? +64 4 803 2204
GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20111020/cdaf8807/attachment-0001.pgp>

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

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

End of Koha Digest, Vol 72, Issue 42
************************************

_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha