Bug 3642 - New information in overdues CSV export
Summary: New information in overdues CSV export
Status: Patch doesn't apply
Alias: None
Product: Koha
Classification: Unclassified
Component: Circulation (show other bugs)
Version: master
Hardware: PC All
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-17 01:03 UTC by David Schuster
Modified: 2020-03-24 15:40 UTC (History)
8 users (show)

See Also:
Change sponsored?: ---
Patch complexity: Small patch
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Bug 3642 - New informations in overdues CSV export - prepare (1.44 KB, patch)
2015-08-14 10:50 UTC, Fridolin Somers
Details | Diff | Splinter Review
Bug 3642 - New informations in overdues CSV export - add cardnumber (850 bytes, patch)
2015-08-14 10:50 UTC, Fridolin Somers
Details | Diff | Splinter Review
Bug 3642 - New informations in overdues CSV export - add itemtype (1.50 KB, patch)
2015-08-14 10:51 UTC, Fridolin Somers
Details | Diff | Splinter Review
Bug 3642 - New informations in overdues CSV export - move streetnumber and streettype (1.26 KB, patch)
2015-08-14 10:52 UTC, Fridolin Somers
Details | Diff | Splinter Review
[SIGNED-OFF]Bug 3642 - New informations in overdues CSV export - prepare (1.51 KB, patch)
2015-10-05 14:14 UTC, Héctor Eduardo Castro Avalos
Details | Diff | Splinter Review
[SIGNED-OFF]Bug 3642 - New informations in overdues CSV export - add cardnumber (967 bytes, patch)
2015-10-05 14:15 UTC, Héctor Eduardo Castro Avalos
Details | Diff | Splinter Review
[SIGNED-OFF]Bug 3642 - New informations in overdues CSV export - add itemtype (1.62 KB, patch)
2015-10-05 14:15 UTC, Héctor Eduardo Castro Avalos
Details | Diff | Splinter Review
[SIGNED-OFF]Bug 3642 - New informations in overdues CSV export - move streetnumber and streettype (1.39 KB, patch)
2015-10-05 14:15 UTC, Héctor Eduardo Castro Avalos
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Chris Cormack 2010-05-21 01:13:13 UTC


---- 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

Comment 1 Katrin Fischer 2013-04-13 17:30:16 UTC
The listed fields are not exported using the download option in the overdues report on current master.
Comment 2 David Roberts 2015-01-17 20:57:28 UTC
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.
Comment 3 Fridolin Somers 2015-08-14 10:48:38 UTC
I propose some patches.
not only for borrower informations so I change a bit the title
Comment 4 Fridolin Somers 2015-08-14 10:50:34 UTC Comment hidden (obsolete)
Comment 5 Fridolin Somers 2015-08-14 10:50:59 UTC Comment hidden (obsolete)
Comment 6 Fridolin Somers 2015-08-14 10:51:19 UTC Comment hidden (obsolete)
Comment 7 Fridolin Somers 2015-08-14 10:52:40 UTC Comment hidden (obsolete)
Comment 8 Fridolin Somers 2015-08-14 10:53:25 UTC
Enjoy and please test ;)
Comment 9 Héctor Eduardo Castro Avalos 2015-10-05 14:14:40 UTC
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>
Comment 10 Héctor Eduardo Castro Avalos 2015-10-05 14:15:01 UTC
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
Comment 11 Héctor Eduardo Castro Avalos 2015-10-05 14:15:13 UTC
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
Comment 12 Héctor Eduardo Castro Avalos 2015-10-05 14:15:28 UTC
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
Comment 13 Jonathan Druart 2015-10-15 09:48:53 UTC
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?
Comment 14 Fridolin Somers 2015-10-15 13:01:45 UTC
(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
Comment 15 Jonathan Druart 2015-10-16 10:11:05 UTC
(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.
Comment 16 Fridolin Somers 2015-10-16 12:01:01 UTC
(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 ?
Comment 17 Nick Clemens 2019-07-01 10:54:06 UTC
Cardnumber appears to have been added, other info still not.
Comment 18 Fridolin Somers 2020-03-24 15:40:54 UTC
I quit this bug, feel free to take it ;)