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@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@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@lists.katipo.co.nz> wrote:
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: 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@gmail.com> Subject: Re: [Koha] fines list is not generated To: koha@lists.katipo.co.nz Message-ID: <22754215.post@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@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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@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@solanco.k12.pa.us> Subject: Re: [Koha] {Possible SPAM} RE: [Koha-devel] Barcode Don't Found To: <koha-devel@lists.koha.org>, <koha@lists.katipo.co.nz> Message-ID: <ACFB645515A2A143A2066BE75BF6D87A01D155B6@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@tech.washk12.org] Sent: Friday, March 27, 2009 12:00 PM To: Roche III, Edward Cc: koha-devel@lists.koha.org; koha@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@tech.washk12.org] Sent: Friday, March 27, 2009 11:29 AM To: Roche III, Edward Cc: koha-devel@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@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Owen Leonard Sent: Friday, March 27, 2009 9:52 AM To: koha@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@smfpl.org> Subject: Re: [Koha] Video camera at Kohacon To: koha@lists.katipo.co.nz Message-ID: <loom.20090328T135242-426@post.gmane.org> Content-Type: text/plain; charset=us-ascii
Chris Cormack <chris@...> 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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
End of Koha Digest, Vol 41, Issue 80 ************************************
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha