Re: [Koha] Overdue reports
Hi all, I am using koha-3.00 and i am trying to generate list of patrons who have overdue fines but i am not finding how to do it. Can something please help me. Thanks in advance Rehoboth
I have contributed this very type of report to the SQL Reports page: http://wiki.koha.org/doku.php?id=sql_library 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/ 2009/7/23 ils rehoboth <rehoboth_ils@yahoo.com>:
Hi all, I am using koha-3.00 and i am trying to generate list of patrons who have overdue fines but i am not finding how to do it. Can something please help me. Thanks in advance Rehoboth
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hello, I have on installed Koha 3.00.02.012 on a test/training server. My current task is to export test patrons from our existing Millennium system into Koha. I created a program using c# to generate a csv file into the appropriate format for import into Koha. Looking at the output file, it seems to me that the format is how Koha wants it. Unfortunately, I get many errors upon import: # Line 2 Critical field "surname" missing (borrowernumber: UNDEF; surname: UNDEF). 'p14614479','0014437362','THAW','SPRING'','','',,'','','1640 LINDBERGH BLVD','ST LOUIS MO 63131'','','','nonotice@slcl.org','##314-555-0232','','','','','','','','',' ','','','01/01/1986','h ','ARES','06/11/99','10/31/2009','','','','','','','','Record contains system default birthdate','','','','','','','','','','','','','','','','','','','','MONEY:' $0.60','GEO:'1', # Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; surname: UNDEF). 'p14614479','0014437362','THAW','SPRING'','','',,'','','1640 LINDBERGH BLVD','ST LOUIS MO 63131'','','','nonotice@slcl.org','##314-555-0232','','','','','','','','',' ','','','01/01/1986','h ','ARES','06/11/99','10/31/2009','','','','','','','','Record contains system default birthdate','','','','','','','','','','','','','','','','','','','','MONEY:' $0.60','GEO:'1', # Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; surname: UNDEF). 'p14614479','0014437362','THAW','SPRING'','','',,'','','1640 LINDBERGH BLVD','ST LOUIS MO 63131'','','','nonotice@slcl.org','##314-555-0232','','','','','','','','',' ','','','01/01/1986','h ','ARES','06/11/99','10/31/2009','','','','','','','','Record contains system default birthdate','','','','','','','','','','','','','','','','','','','','MONEY:' $0.60','GEO:'1', # Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; surname: UNDEF). 'p14614479','0014437362','THAW','SPRING'','','',,'','','1640 LINDBERGH BLVD','ST LOUIS MO 63131'','','','nonotice@slcl.org','##314-555-0232','','','','','','','','',' ','','','01/01/1986','h ','ARES','06/11/99','10/31/2009','','','','','','','','Record contains system default birthdate','','','','','','','','','','','','','','','','','','','','MONEY:' $0.60','GEO:'1', # Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; surname: UNDEF). 'p14614479','0014437362','THAW','SPRING'','','',,'','','1640 LINDBERGH BLVD','ST LOUIS MO 63131'','','','nonotice@slcl.org','##314-555-0232','','','','','','','','',' ','','','01/01/1986','h ','ARES','06/11/99','10/31/2009','','','','','','','','Record contains system default birthdate','','','','','','','','','','','','','','','','','','','','MONEY:' $0.60','GEO:'1', All of the categorycodes and branchcodes match the system entries. All of these "patrons" aren't real people, in case anyone was wondering :-). I've attached my output.csv file. Does anyone know what I am doing wrong? Let me know if there's any additional information that would help. Thanks!! Stephanie Nordmann System Administration Manager St Louis County Library www.slcl.org <http://www.slcl.org/>
I was able to solve my problem. The single quotes weren't necessary. Not to mention, I had branch codes that hadn't been defined quite yet. Stephanie Nordmann System Administration Manager St Louis County Library www.slcl.org _____ From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Stephanie Nordmann Sent: Thursday, July 23, 2009 12:38 PM To: koha@lists.katipo.co.nz Subject: [Koha] Import Patron errors Hello, I have on installed Koha 3.00.02.012 on a test/training server. My current task is to export test patrons from our existing Millennium system into Koha. I created a program using c# to generate a csv file into the appropriate format for import into Koha. Looking at the output file, it seems to me that the format is how Koha wants it. Unfortunately, I get many errors upon import: # Line 2 Critical field "surname" missing (borrowernumber: UNDEF; surname: UNDEF). 'p14614479','0014437362','THAW','SPRING'','','',,'','','1640 LINDBERGH BLVD','ST LOUIS MO 63131'','','','nonotice@slcl.org','##314-555-0232','','','','','','','','',' ','','','01/01/1986','h ','ARES','06/11/99','10/31/2009','','','','','','','','Record contains system default birthdate','','','','','','','','','','','','','','','','','','','','MONEY:' $0.60','GEO:'1', # Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; surname: UNDEF). 'p14614479','0014437362','THAW','SPRING'','','',,'','','1640 LINDBERGH BLVD','ST LOUIS MO 63131'','','','nonotice@slcl.org','##314-555-0232','','','','','','','','',' ','','','01/01/1986','h ','ARES','06/11/99','10/31/2009','','','','','','','','Record contains system default birthdate','','','','','','','','','','','','','','','','','','','','MONEY:' $0.60','GEO:'1', # Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; surname: UNDEF). 'p14614479','0014437362','THAW','SPRING'','','',,'','','1640 LINDBERGH BLVD','ST LOUIS MO 63131'','','','nonotice@slcl.org','##314-555-0232','','','','','','','','',' ','','','01/01/1986','h ','ARES','06/11/99','10/31/2009','','','','','','','','Record contains system default birthdate','','','','','','','','','','','','','','','','','','','','MONEY:' $0.60','GEO:'1', # Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; surname: UNDEF). 'p14614479','0014437362','THAW','SPRING'','','',,'','','1640 LINDBERGH BLVD','ST LOUIS MO 63131'','','','nonotice@slcl.org','##314-555-0232','','','','','','','','',' ','','','01/01/1986','h ','ARES','06/11/99','10/31/2009','','','','','','','','Record contains system default birthdate','','','','','','','','','','','','','','','','','','','','MONEY:' $0.60','GEO:'1', # Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; surname: UNDEF). 'p14614479','0014437362','THAW','SPRING'','','',,'','','1640 LINDBERGH BLVD','ST LOUIS MO 63131'','','','nonotice@slcl.org','##314-555-0232','','','','','','','','',' ','','','01/01/1986','h ','ARES','06/11/99','10/31/2009','','','','','','','','Record contains system default birthdate','','','','','','','','','','','','','','','','','','','','MONEY:' $0.60','GEO:'1', All of the categorycodes and branchcodes match the system entries. All of these "patrons" aren't real people, in case anyone was wondering :-). I've attached my output.csv file. Does anyone know what I am doing wrong? Let me know if there's any additional information that would help. Thanks!! Stephanie Nordmann System Administration Manager St Louis County Library www.slcl.org <http://www.slcl.org/>
participants (3)
-
ils rehoboth -
Nicole Engard -
Stephanie Nordmann