[Koha-bugs] [Bug 21035] runreport.pl prints only a newline when printing a row that has a field that contains an embedded newline.

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri Jul 13 21:44:44 CEST 2018


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21035

Maryse Simard <maryse.simard at inlibro.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #76698|0                           |1
        is obsolete|                            |

--- Comment #2 from Maryse Simard <maryse.simard at inlibro.com> ---
Created attachment 76964
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=76964&action=edit
Bug 21035: Handle new lines when running reports

See https://metacpan.org/pod/Text::CSV_XS#Embedded-newlines

Test plan:

1) Choose two items, say barcode '123' and '456'
2) Change the public note on 123 to read

Line1
Line2

(I.e. type 'Line1', then press Enter, type 'Line2' and click update).
3) Change the public note on 456 to read

Public note has one and only one line.

Click update.
4) Create a report with the followng query:

select barcode, itemnotes from items where barcode in ( '123', '456' )

Let's say that this is report number 10.

5) run ./misc/cronjobs/runreport.pl --format=csv REPORT_ID:

=> You should see both lines

Signed-off-by: Maryse Simard <maryse.simard at inlibro.com>
Followed the test plan and it works.

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list