<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Dear Community,</span></div><div><span>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.</span></div><div><br><span></span></div><div><span>Nick</span></div><div><span>SICHE Library</span></div><div><span>Honiara, Solomon Is.</span></div><div><br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"><font face="Arial" size="2"><hr size="1"><b><span style="font-weight:bold;">From:</span></b>
"koha-request@lists.katipo.co.nz" <koha-request@lists.katipo.co.nz><br><b><span style="font-weight: bold;">To:</span></b> koha@lists.katipo.co.nz<br><b><span style="font-weight: bold;">Sent:</span></b> Thursday, 20 October 2011 10:00 AM<br><b><span style="font-weight: bold;">Subject:</span></b> Koha Digest, Vol 72, Issue 42<br></font><br>Send Koha mailing list submissions to<br> <a ymailto="mailto:koha@lists.katipo.co.nz" href="mailto: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="mailto: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="mailto: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: report help - total amount writeoff (Wagner, Jane)<br> 2. Re: Additional packages for install_misc/debian.packages<br> (Robin Sheat)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Wed, 19 Oct 2011 15:24:58 -0400<br>From: "Wagner, Jane" <<a ymailto="mailto:jwagner@liblime.com" href="mailto:jwagner@liblime.com">jwagner@liblime.com</a>><br>To: Peel Lisa <<a ymailto="mailto:lisa.peel@ritz.edu" href="mailto:lisa.peel@ritz.edu">lisa.peel@ritz.edu</a>>, <a ymailto="mailto:koha@lists.katipo.co.nz"
href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a><br>Subject: Re: [Koha] report help - total amount writeoff<br>Message-ID: <<a ymailto="mailto:3ab247946ba96552813c39184520130a@mail.gmail.com" href="mailto:3ab247946ba96552813c39184520130a@mail.gmail.com">3ab247946ba96552813c39184520130a@mail.gmail.com</a>><br>Content-Type: text/plain; charset="windows-1252"<br><br>Try something like this:<br><br><br><br>SELECT round(Sum(accountlines.amount),2) AS 'Writeoffs Last 3 Months' FROM<br>accountlines WHERE accounttype = 'W' and date like<br>concat(date_format(LAST_DAY(now() - interval 3 month),'%Y-%m-%'))<br><br><br><br>(haven?t tested this variant, but I run similar reports for 1 month and<br>payments)<br><br><br><br>Jane Wagner<br><br>Senior Project Manager<br><br>LibLime, a division of PTFS<br><br>Content Management and Library Solutions<br><br>11501 Huff Court<br><br>North Bethesda, MD 20895<br><br>(301) 654-8088 x 151<br><br><a
ymailto="mailto:jwagner@liblime.com" href="mailto:jwagner@liblime.com">jwagner@liblime.com</a> <<a ymailto="mailto:jwagner@ptfs.com" href="mailto:jwagner@ptfs.com">jwagner@ptfs.com</a>><br><br><br><br>*From:* <a ymailto="mailto:koha-bounces@lists.katipo.co.nz" href="mailto: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="mailto:koha-bounces@lists.katipo.co.nz">koha-bounces@lists.katipo.co.nz</a>] *On Behalf Of *Peel Lisa<br>*Sent:* Wednesday, October 19, 2011 3:08 PM<br>*To:* '<a ymailto="mailto:koha@lists.katipo.co.nz" href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a>'<br>*Subject:* [Koha] report help - total amount writeoff<br><br><br><br>Hello<br><br><br><br>Report help again I am afraid!<br><br><br><br>Could anyone supply me with the SQL for a report which will show me the<br>amount of fines being written off at a specific library for a
given period<br>of time (for example the last three months?)<br><br><br><br>Regards and thanks in advance<br><br><br><br>Lisa<br><br><br><br><br><br>[image: Description: Description: Description: CR_logo_POS_COULEUR b]**<br><br>* *<br><br>* *<br><br>*LISA PEEL, PGDip, MA.***<br><br>Librarian<br><br>C?sar Ritz Colleges Switzerland<br><br>1897 Le Bouveret - Switzerland<br><br>Tel: +41 24 482 82 82 Fax: +41 24 482 82 80<br><br>E-mail: *<a ymailto="mailto:lisa.peel@ritz.edu" href="mailto:lisa.peel@ritz.edu">lisa.peel@ritz.edu</a> <<a ymailto="mailto:hortense.hofer@ritz.edu" href="mailto:hortense.hofer@ritz.edu">hortense.hofer@ritz.edu</a>>*<br><br><a href="http://www.ritz.edu" target="_blank">http://www.ritz.edu</a> - <a href="http://www.culinaryarts.ch" target="_blank">http://www.culinaryarts.ch</a><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a
href="http://lists.katipo.co.nz/pipermail/koha/attachments/20111019/25987bec/attachment-0001.html" target="_blank">http://lists.katipo.co.nz/pipermail/koha/attachments/20111019/25987bec/attachment-0001.html</a>><br>-------------- next part --------------<br>A non-text attachment was scrubbed...<br>Name: image001.jpg<br>Type: image/jpeg<br>Size: 4030 bytes<br>Desc: not available<br>URL: <<a href="http://lists.katipo.co.nz/pipermail/koha/attachments/20111019/25987bec/attachment-0001.jpg" target="_blank">http://lists.katipo.co.nz/pipermail/koha/attachments/20111019/25987bec/attachment-0001.jpg</a>><br><br>------------------------------<br><br>Message: 2<br>Date: Thu, 20 Oct 2011 11:04:42 +1300<br>From: Robin Sheat <<a ymailto="mailto:robin@catalyst.net.nz" href="mailto:robin@catalyst.net.nz">robin@catalyst.net.nz</a>><br>To: <a ymailto="mailto:koha@lists.katipo.co.nz"
href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a><br>Subject: Re: [Koha] Additional packages for<br> install_misc/debian.packages<br>Message-ID: <1319061882.28975.5.camel@zarathud><br>Content-Type: text/plain; charset="utf-8"<br><br>Eduardo Tr?pani schreef op wo 19-10-2011 om 10:56 [-0200]:<br>> Right now libcgi-session-driver-memcached-perl is available on<br>> testing[1], not on stable. But you can download it from here[2] and<br>> install it manually, there are no dependency problems. <br><br>You'll also find it (and libgravatar-url-perl, which is too old in<br>Debian stable, I think) in the Koha debian repository at<br><a href="http://debian.koha-community.org/" target="_blank">http://debian.koha-community.org/</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>-------------- next part --------------<br>A
non-text attachment was scrubbed...<br>Name: signature.asc<br>Type: application/pgp-signature<br>Size: 198 bytes<br>Desc: This is a digitally signed message part<br>URL: <<a href="http://lists.katipo.co.nz/pipermail/koha/attachments/20111020/cdaf8807/attachment-0001.pgp" target="_blank">http://lists.katipo.co.nz/pipermail/koha/attachments/20111020/cdaf8807/attachment-0001.pgp</a>><br><br>------------------------------<br><br>_______________________________________________<br>Koha mailing list<br><a ymailto="mailto:Koha@lists.katipo.co.nz" href="mailto: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 72, Issue 42<br>************************************<br><br><br></div></div></blockquote></div></div></body></html>