---- Reported by dschust1@gmail.com 2009-09-17 13:03:57 ---- In exporting the overdue.pl - as Plano ISD sponsored we would now like to include a few more fields from the borrower record cardnumber borrowertype and all the extended attributes displaying their DESCRIPTION from the authorized values table in seperate columns if possible. That way we could run a mailmerge against it to build our on demand overdues for students showing name, cardnumber, we put grade in the borrowertype and homeroom is an extended attribute. --- Bug imported by chris@bigballofwax.co.nz 2010-05-21 01:13 UTC --- This bug was previously known as _bug_ 3642 at http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3642 Unknown operating system Windows 2000. Setting to default OS "All". Actual time not defined. Setting to 0.0
The listed fields are not exported using the download option in the overdues report on current master.
I'd like to add support for having the user's barcode number included in the output of the report, especially in the CSV export. Exporting the borrower number in this format is of little use to most users.
I propose some patches. not only for borrower informations so I change a bit the title
Created attachment 41490 [details] [review] Bug 3642 - New informations in overdues CSV export - prepare This patch prepare columns list to ease other patches
Created attachment 41491 [details] [review] Bug 3642 - New informations in overdues CSV export - add cardnumber This patch adds patron cardnumber to overdues CSV export Test plan : - Go to overdues page : <server>/cgi-bin/koha/circ/overdue.pl - Find some overdues - Click on "Download file of displayed overdues" - Open generated CSV => You see cardnumber column with data
Created attachment 41492 [details] [review] Bug 3642 - New informations in overdues CSV export - add itemtype This patch adds record itemtype to overdues CSV export, from item or biblioitems depending on syspref "item-level_itypes" Test plan : - Go to overdues page : <server>/cgi-bin/koha/circ/overdue.pl - Find some overdues - Click on "Download file of displayed overdues" - Open generated CSV => You see itemtype column with data
Created attachment 41493 [details] [review] Bug 3642 - New informations in overdues CSV export - move streetnumber and streettype This patch moves columns streetnumber and streettype next to address. This is more logical to read the CSV. For example : streetnumber,streettype,address,address2,zipcode,city 181,rue,Breteuil,,13001,Marseille Test plan : - Go to overdues page : <server>/cgi-bin/koha/circ/overdue.pl - Find some overdues of patrons with streetnumber and streettype - Click on "Download file of displayed overdues" - Open generated CSV => You see streetnumber and streettype before address
Enjoy and please test ;)
Created attachment 43135 [details] [review] [SIGNED-OFF]Bug 3642 - New informations in overdues CSV export - prepare This patch prepare columns list to ease other patches Signed-off-by: Hector Castro <hector.hecaxmmx@gmail.com>
Created attachment 43136 [details] [review] [SIGNED-OFF]Bug 3642 - New informations in overdues CSV export - add cardnumber This patch adds patron cardnumber to overdues CSV export Test plan : - Go to overdues page : <server>/cgi-bin/koha/circ/overdue.pl - Find some overdues - Click on "Download file of displayed overdues" - Open generated CSV => You see cardnumber column with data Signed-off-by: Hector Castro <hector.hecaxmmx@gmail.com> Works as advertised. Cardnumber appeared
Created attachment 43137 [details] [review] [SIGNED-OFF]Bug 3642 - New informations in overdues CSV export - add itemtype This patch adds record itemtype to overdues CSV export, from item or biblioitems depending on syspref "item-level_itypes" Test plan : - Go to overdues page : <server>/cgi-bin/koha/circ/overdue.pl - Find some overdues - Click on "Download file of displayed overdues" - Open generated CSV => You see itemtype column with data Signed-off-by: Hector Castro <hector.hecaxmmx@gmail.com> Works as advertised. itemtype appered on CSV
Created attachment 43138 [details] [review] [SIGNED-OFF]Bug 3642 - New informations in overdues CSV export - move streetnumber and streettype This patch moves columns streetnumber and streettype next to address. This is more logical to read the CSV. For example : streetnumber,streettype,address,address2,zipcode,city 181,rue,Breteuil,,13001,Marseille Test plan : - Go to overdues page : <server>/cgi-bin/koha/circ/overdue.pl - Find some overdues of patrons with streetnumber and streettype - Click on "Download file of displayed overdues" - Open generated CSV => You see streetnumber and streettype before address Signed-off-by: Hector Castro <hector.hecaxmmx@gmail.com> Works as advertised. streetnumber and streettype appered on CSV
Frido, The description of this bug report mentions """ cardnumber # ok borrowertype and all the extended attributes displaying their DESCRIPTION from the authorized values table in seperate columns if possible. """ Don't you think they should be added too?
(In reply to Jonathan Druart from comment #13) > Frido, > The description of this bug report mentions > """ > cardnumber # ok > borrowertype > and all the extended attributes displaying their DESCRIPTION from the > authorized values table in seperate columns if possible. > """ > > Don't you think they should be added too? This whould make the patch really more complexe, I propose to move this part in a new bug
(In reply to Fridolin SOMERS from comment #14) > (In reply to Jonathan Druart from comment #13) > > Frido, > > The description of this bug report mentions > > """ > > cardnumber # ok > > borrowertype > > and all the extended attributes displaying their DESCRIPTION from the > > authorized values table in seperate columns if possible. > > """ > > > > Don't you think they should be added too? > > This whould make the patch really more complexe, I propose to move this part > in a new bug So you have to either move your patch or open a new bug report. And also edit the title of the bug report.
(In reply to Jonathan Druart from comment #15) > And also edit the title of the bug report. "New informations in overdues CSV export" is not correct ?
Cardnumber appears to have been added, other info still not.
I quit this bug, feel free to take it ;)