[Koha] Koha Digest, Vol 66, Issue 44

Nikunj Tyagi nikunj1 at gmail.com
Wed Apr 20 03:32:58 NZST 2011


Dear Vimal ji,

Please add WHERE date(issues.issuedate) BETWEEN '2011-02-08' AND
'2011-02-09' line in your sql query and generate with date limit

SELECT issues.issuedate,items.barcode,biblio.title,
author,borrowers.firstname,borrowers.surname FROM issues LEFT JOIN borrowers
ON borrowers.borrowernumber=issues.borrowernumber LEFT JOIN items ON
issues.itemnumber=items.itemnumber LEFT JOIN biblio ON
items.biblionumber=biblio.biblionumber
WHERE date(issues.issuedate) BETWEEN '2011-02-08' AND '2011-02-09'
ORDER BY issues.issuedate

Thanks & Regards,
Nikunj Tyagi, DPL

On Tue, Apr 19, 2011 at 6:31 PM, <koha-request at lists.katipo.co.nz> wrote:

> 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. Authorities (martin caris)
>   2. Ashik Rajbhandari invited you to Dropbox (Dropbox)
>   3. Koha behind proxy server (schwitzd)
>   4. Re: Accents in Irish Gaelic (Peter Lorimer)
>   5. Circulation report limited with date (Vimal Kumar)
>   6. Re: Accents in Irish Gaelic (Elaine Bradtke)
>   7. Koha move to 3.4 (Linda Culberson)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 19 Apr 2011 02:44:47 +0200
> From: martin caris <martin_caris at hotmail.com>
> Subject: [Koha] Authorities
> To: <koha at lists.katipo.co.nz>
> Message-ID: <COL101-W5529B39CE3A89B2AB49BFBF7900 at phx.gbl>
> Content-Type: text/plain; charset="iso-8859-1"
>
>
> Hello,
>
>  I have a problem with my authorities: I catalog my book in the framework
> and I save my bibliographic record, but when I see my authority record, no
> authorities are linked. How is it possible?
>  Koha version: 3.02.05.
>
>  Another question: is it possible to create, in the field 952 (copy field),
>  my own subfields?
>
>  Thank you.
>
>  Martin Caris
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.katipo.co.nz/pipermail/koha/attachments/20110419/75a68774/attachment-0001.htm
>
> ------------------------------
>
> Message: 2
> Date: Tue, 19 Apr 2011 06:35:04 +0000
> From: Dropbox <no-reply at dropboxmail.com>
> Subject: [Koha] Ashik Rajbhandari invited you to Dropbox
> To: koha at lists.katipo.co.nz
> Message-ID: <20110419063504.8E2AF482980 at mailman-2.dropboxmail.com>
> Content-Type: text/plain; charset="utf8"
>
> Ashik Rajbhandari wants you to try Dropbox! Dropbox lets you bring all your
> photos, docs and videos with you anywhere and share them easily.
>
> Get started here:
> http://www.dropbox.com/link/20.RvaCvlwouf/Njg2OTA3MjI1Nw?src=referrals_bulk9
>
> - The Dropbox Team
>
> ____________________________________________________
> To stop receiving invites from Dropbox, please go to
> http://www.dropbox.com/bl/0d4e454ad162/koha%40lists.katipo.co.nz
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.katipo.co.nz/pipermail/koha/attachments/20110419/78040caa/attachment-0001.htm
>
> ------------------------------
>
> Message: 3
> Date: Tue, 19 Apr 2011 00:16:26 -0700 (PDT)
> From: schwitzd <schwitzd at gmail.com>
> Subject: [Koha] Koha behind proxy server
> To: koha at lists.katipo.co.nz
> Message-ID: <1303197386133-4312674.post at n5.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> Hello
>
> I'm trying to using koha behind a proxy server, but I'm not able to contact
> the server using the z39.50 protocol. How I have to configure koha to works
> with the proxy?
> I have to enable something on the proxy server?
>
> Thanks a lot
> Daniel
>
> --
> View this message in context:
> http://koha.1045719.n5.nabble.com/Koha-behind-proxy-server-tp4312674p4312674.html
> Sent from the Koha - Discuss mailing list archive at Nabble.com.
>
>
> ------------------------------
>
> Message: 4
> Date: Tue, 19 Apr 2011 09:10:03 +0100
> From: Peter Lorimer <peter at oslo.ie>
> Subject: Re: [Koha] Accents in Irish Gaelic
> To: koha at lists.katipo.co.nz
> Message-ID: <1303200603.2834.9.camel at peter-laptop2.local>
> Content-Type: text/plain; charset="UTF-8"
>
> Hi
>
> I had a similar problem with Irish characters not displaying correctly.
> It was down to browser default character encoding.
>
> I overcome this by using the Perl 'Encode' module
>
> # use Encode;
>
> Where print $x was displaying Irish characters incorrectly, using
>
> print encode('utf-8',$x); renders Irish characters correctly. So each
> time a variable (string) is added to a template I use:
>
> $template->param (
>        testData => encode('utf-8', $data),
>
>                  );
>
> --
> Kind Regards
>
> Peter Lorimer
> Software Engineer
> OSLO (Open Source ILS Systems)
>
>
> -----Original Message-----
> From: koha-request at lists.katipo.co.nz
> Reply-to: koha at lists.katipo.co.nz
> To: koha at lists.katipo.co.nz
> Subject: Koha Digest, Vol 66, Issue 42
> Date: Tue, 19 Apr 2011 07:11:04 +1200
>
> Re: Accents in Irish Gaelic
>
>
>
> ------------------------------
>
> Message: 5
> Date: Tue, 19 Apr 2011 17:52:27 +0530
> From: Vimal Kumar <vimal0212 at gmail.com>
> Subject: [Koha] Circulation report limited with date
> To: Koha-List <koha at lists.katipo.co.nz>
> Message-ID: <BANLkTikUPbnLx3xvzDb51tSUEs7SOW3Gqw at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Dear Friends,
> I could generate the current checkouts with  following SQL query:
>
> SELECT issues.issuedate,items.barcode,biblio.title,
> author,borrowers.firstname,borrowers.surname FROM issues LEFT JOIN
> borrowers
> ON borrowers.borrowernumber=issues.borrowernumber LEFT JOIN items ON
> issues.itemnumber=items.itemnumber LEFT JOIN biblio ON
> items.biblionumber=biblio.biblionumber ORDER BY issues.issuedate
>
> Please help me to generate the same as per date limit. For example: I need
> to generate report of current checkouts as of 29th March 2011. How shall I
> modify the query so that I  can get the report limited with date.
>
> With best regards
>
>
> --
> Vimal Kumar V.
> Mahatma Gandhi University Library
> Kottayam, Kerala- 686 560
> Web: http://www.vimalkumar.co.nr
> Blog: http://vimalkumar.oksociety.in http://linuxhalwa.blogspot.com
> ---------------------------------------------------------------------------
> "I forget what I was taught. I only remember what I have learnt"
> -Patrick White
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.katipo.co.nz/pipermail/koha/attachments/20110419/452a0f56/attachment-0001.htm
>
> ------------------------------
>
> Message: 6
> Date: Tue, 19 Apr 2011 13:53:26 +0100
> From: Elaine Bradtke <eb at efdss.org>
> Subject: Re: [Koha] Accents in Irish Gaelic
> Cc: koha <koha at lists.katipo.co.nz>
> Message-ID: <BANLkTimEgYAi+5Ge99nJpc9oajYvjNWPWQ at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> We had a bit of gremlin trouble over the weekend. This included
> trouble with z39.50 searches returning no results, even for items that
> I knew were there. By the time I got around to looking at everything
> again, the problems had all resolved.  Accents are appearing as they
> should, z39.50 searches are returning results.  Phew.
> Thanks everyone for your help!
> Elaine
>
> On Mon, Apr 18, 2011 at 3:03 PM, Galen Charlton <gmc at esilibrary.com>
> wrote:
> > Hi Elaine,
> >
> > On Apr 18, 2011, at 9:23 AM, Elaine Bradtke wrote:
> >> We've checked the settings, and they are now correct according to the
> >> wiki. ?However, the Gaelic is still not downloading correctly. ?I've
> >> experimented with several settings in our targets, MARC8 seems the
> >> best but it's not perfect. ?I still get 'h' appearing before accented
> >> letters. ?Any other thoughts?
> >
> > Could you give us an example of a Z39.50 target and record that you're
> experiencing this problem with?
> >
> > Regards,
> >
> > Galen
> > --
> > Galen Charlton
> > VP, Data Services
> > Equinox Software, Inc. / Your Library's Guide to Open Source
> > email: ?gmc at esilibrary.com
> > direct: +1 352-215-7548
> > skype: ?gmcharlt
> > web: ? ?http://www.esilibrary.com/
> >
> >
>
>
>
> --
> Elaine Bradtke
> Data Wrangler
> VWML
> English Folk Dance and Song Society | http://www.efdss.org
> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> Tel? ? +44 (0) 20 7485 2206 ext 36
> --------------------------------------------------------------------------
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
> ---------------------------------------------------------------------------
> "Writing about music is like dancing about architecture"
> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
>
>
> ------------------------------
>
> Message: 7
> Date: Tue, 19 Apr 2011 08:01:18 -0500
> From: Linda Culberson <lculber at mdah.state.ms.us>
> Subject: [Koha] Koha move to 3.4
> To: koha <koha at lists.katipo.co.nz>,
>        koha-devel at lists.koha-community.org
> Message-ID: <4DAD879E.3070904 at mdah.state.ms.us>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> All,
> How is  the recommended way to move to the upcoming 3.4?  We were
> thinking of having two instances. One with our current 3.02.02.003 and
> one with 3.4.  Is that a good way to do it or should we upgrade to 3.2.7
> and go from there?
>
> Can we move our data or is it better to do a fresh load?  How different
> is the database in 3.4?
>
> Your advice to this newbie is greatly appreciated.
>
> --
> Linda Culberson                 lculber at mdah.state.ms.us
> Archives and Records Services Division
> Ms. Dept. of Archives & History
> P. O. Box 571
> Jackson, MS 39205-0571
> Telephone:  601/576-6873
> Facsimile:  601/576-6824
>
>
>
> ------------------------------
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> End of Koha Digest, Vol 66, Issue 44
> ************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110419/8e9702d9/attachment.htm 


More information about the Koha mailing list