ISBNs Not Found in Z39.5 and elsewhere.
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>*
Dear Nick, You may try with following Z39.50 servers of Indian libraries. 1. American Libraries in India Host: ali1.hosted.exlibrisgroup.com Port : 7090 Database Name: Voyager 2. University of Kashmir Host: 203.129.216.173 Port : 1111 Database Name: DEFAULT 3. Delhi Public Library- Host 59.176.17.111 Port 210 Database Name biblios Record syntaxes usmarc, sutrs, xml, grs-1 I acknowledge Mr. Mitch Miller's help to locate these If you find any thing else,please inform me. I think you may put this query to lis-forum@ncsi.iisc.ernet.in With warm regards, Mithun 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>*
participants (2)
-
mithun raj -
nico rubo