[Koha] Koha Digest, Vol 41, Issue 80

Nicole Engard nicole.engard at liblime.com
Thu Apr 2 04:16:44 NZDT 2009


It should be showing you all of the students with fines - that's what
it does for me - have you tried exporting the list to Excel and
manipulating the data there?

---

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 Mon, Mar 30, 2009 at 12:44 AM, jksamyal <jksamyal at gmail.com> wrote:
> 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
>> ************************************
>>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>


More information about the Koha mailing list