[Koha] Koha Digest, Vol 41, Issue 80

Mon Mar 30 17:44:46 NZDT 2009

hello nicole,
thanks for fine reply.
its running but the problem is that it is showing only one page of
fine, but there are too many  defaulters.

thanks

jatinder kumar

On Sun, Mar 29, 2009 at 4:30 AM,  <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. Re: fines list is not generated (jatinder.KUMAR)
>   2. Re: {Possible SPAM}  RE: [Koha-devel]   Barcode Don't Found
>      (Roche III, Edward)
>   3. Re: Video camera at Kohacon (Darrell Ulm)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 27 Mar 2009 23:47:11 -0700 (PDT)
> From: "jatinder.KUMAR" <jksamyal at gmail.com>
> Subject: Re: [Koha] fines list is not generated
> To: koha at lists.katipo.co.nz
> Message-ID: <22754215.post at talk.nabble.com>
> Content-Type: text/plain; charset=UTF-8
>
>
> Thankyou very much nicole
>
> Nicole Engard wrote:
>>
>> Sounds like you need a custom report - I have one that gives me all
>> the patrons with fines and the amount of the fine:
>>
>> SELECT
>> borrowers.cardnumber,borrowers.surname,borrowers.firstname,FORMAT(SUM(accountlines.amountoutstanding),2)
>> as due FROM borrowers LEFT JOIN accountlines on
>> (borrowers.borrowernumber=accountlines.borrowernumber)  WHERE
>> accountlines.amountoutstanding > 0 GROUP BY borrowers.cardnumber ORDER
>> BY borrowers.surname asc
>>
>>
>> ---
>>
>> Nicole C. Engard
>> Open Source Evangelist, LibLime
>> (888) Koha ILS (564-2457) ext. 714
>> nce at liblime.com
>> AIM/Y!/Skype: nengard
>>
>> http://liblime.com
>> http://blogs.liblime.com/open-sesame/
>>
>>
>>
>> On Thu, Mar 26, 2009 at 11:51 PM, jksamyal <jksamyal at gmail.com> wrote:
>>> We are using Koha 3.0 version. Now we are closing the semester and
>>> ? exam are on. we want to generate a list of fines of defaulted
>>> ? students.
>>> ? Please guide me for this.
>>> ? jatinder kumar
>>> _______________________________________________
>>> Koha mailing list
>>> Koha at lists.katipo.co.nz
>>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>> _______________________________________________
>> Koha mailing list
>> Koha at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>>
>
> --
> View this message in context: http://www.nabble.com/fines-list-is-not-generated-tp22735709p22754215.html
> Sent from the Koha - Discuss mailing list archive at Nabble.com.
>
>
>
> ------------------------------
>
> Message: 2
> Date: Sat, 28 Mar 2009 08:41:06 -0400
> From: "Roche III, Edward" <edward_roche at solanco.k12.pa.us>
> Subject: Re: [Koha] {Possible SPAM}  RE: [Koha-devel]   Barcode Don't
>        Found
> To: <koha-devel at lists.koha.org>,        <koha at lists.katipo.co.nz>
> Message-ID:
>        <ACFB645515A2A143A2066BE75BF6D87A01D155B6 at exchange.solanco.local>
> Content-Type: text/plain;       charset="utf-8"
>
> I missed replying to the groups.....
>
> I am being dumb but where does this patch go? I found what I need to do for the sys.pref but not sure where to put the patch.
>
> Thanks!
> Ed
>
> Edward J. Roche
> Network Administrator
> Solanco School District
> 717.786.2151 x2437
>
> "At the End of the Day, Did You Play to Win or Not to Lose?"
>
>
>
> -----Original Message-----
> From: Michael Hafen [mailto:mdhafen at tech.washk12.org]
> Sent: Friday, March 27, 2009 12:00 PM
> To: Roche III, Edward
> Cc: koha-devel at lists.koha.org; koha at lists.katipo.co.nz
> Subject: {Possible SPAM} RE: [Koha-devel] [Koha] Barcode Don't Found
> Importance: Low
>
> I'll attach a modified patch to do it.  You'll still have to update the sys. pref. options to enable this feature.  Look at the changes to installer/data/mysql/en/mandatory/sysprefs.sql for an idea of what to set the sys. pref. to.
>
> Good luck.
>
> On Fri, 2009-03-27 at 11:42 -0400, Roche III, Edward wrote:
>> How do you create the filter?
>>
>> Thanks!
>> Ed
>>
>> Edward J. Roche
>> Network Administrator
>> Solanco School District
>> 717.786.2151 x2437
>>
>> "At the End of the Day, Did You Play to Win or Not to Lose?"
>>
>>
>>
>> -----Original Message-----
>> From: Michael Hafen [mailto:mdhafen at tech.washk12.org]
>> Sent: Friday, March 27, 2009 11:29 AM
>> To: Roche III, Edward
>> Cc: koha-devel at lists.koha.org
>> Subject: Re: [Koha-devel] [Koha] Barcode Don't Found
>>
>> I have in my libraries several copies with a "T " before the number
>> part of the barcode.  Koha works with it fine.  I find the trick is to
>> make sure what's in the Koha database and what's encoded in the
>> barcode are the same.  It is possible with itemInputBarcodeFilter
>> processing.  I've used that sys. pref. to strip leading spaces ( which
>> I put in ) from some barcodes.
>>
>> If what you want is to be able to enter just the number, or the "T "
>> and the number ( like from a barcode scanner ), then I think making a
>> custom itemInputBarcodeFilter ( like I did to trim leading spaces )
>> would be a good solution.
>>
>> On Fri, 2009-03-27 at 10:00 -0400, Roche III, Edward wrote:
>> > That is an idea but I would think there was a way to have Koha
>> > except the T+space.
>> >
>> > Thanks!
>> > Ed
>> >
>> > Edward J. Roche
>> > Network Administrator
>> > Solanco School District
>> > 717.786.2151 x2437
>> >
>> > "At the End of the Day, Did You Play to Win or Not to Lose?"
>> >
>> >
>> >
>> > -----Original Message-----
>> > From: koha-bounces at lists.katipo.co.nz
>> > [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Owen Leonard
>> > Sent: Friday, March 27, 2009 9:52 AM
>> > To: koha at lists.katipo.co.nz
>> > Subject: Re: [Koha] [Koha-devel] Barcode Don't Found
>> >
>> > > Currently doing it by hand but have tried with the scanner with no
>> > luck.
>> >
>> > I asked because sometimes scanners are configured to add characters
>> > where you might not expect them. I did a quick test in my 3.0
>> > installation and didn't have any problem typing in the barcode.. I
>> > don't have any prefix options specified.
>> >
>> > What I wonder is if you couldn't store just the numeric portion of
>> > the barcode (if it's the T+space causing the problem) and configure
>> > your scanners to strip off the "T "? Of course you'd have to consult
>> > the documentation for your scanners to know if that was possible.
>> > We've done something similar in the past.
>> >
>> >   -- Owen
>> >
> --
> Michael Hafen
> Systems Analyst and Programmer
> Washington County School District
> Utah, USA
>
> for Koha checkout
> http://koha-dev.washk12.org
> or
> git://koha-dev.washk12.org/koha
>
> ------------------------------
>
> Message: 3
> Date: Sat, 28 Mar 2009 13:57:13 +0000 (UTC)
> From: Darrell Ulm <darrellulm at smfpl.org>
> Subject: Re: [Koha] Video camera at Kohacon
> To: koha at lists.katipo.co.nz
> Message-ID: <loom.20090328T135242-426 at post.gmane.org>
> Content-Type: text/plain; charset=us-ascii
>
> Chris Cormack <chris at ...> writes:
>> If there is anyone who owns a digital video camera and is coming to
>> Kohacon. If they could bring their camera along that would be
>> fantastic.
>> We are getting lots of requests for video of the sessions from people
>> who can't make it.
>
> I think many would like to see video of KohaCon sessions.
>
> The upload to YouTube is easy.
>
> Hope video is produced since I cannot attend this year. It would be a fantastic
>  promotional tool to have video available for anyone interested.
>
> If someone just shoots video I am willing to do the uploading and some simple
> editing in my spare time.
>
> Thank you! :)
>
>
>
>
>
> ------------------------------
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> End of Koha Digest, Vol 41, Issue 80
> ************************************
>