[Bug 29968] New: CSV export of cash register misses newlines
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29968 Bug ID: 29968 Summary: CSV export of cash register misses newlines Change sponsored?: --- Product: Koha Version: 21.11 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Reports Assignee: koha-bugs@lists.koha-community.org Reporter: mik@adminkuhn.ch QA Contact: testopia@bugs.koha-community.org When using the German language (and maybe other languages) and accessing Koha menu "Reports > Cash register" and exporting the output, the resulting CSV file does not contain the newline character, so all records will be in one line which is incorrect. This problem does not appear when using the English language so using the English interface can be used as a workaround. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29968 --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- This is probably due to the translation tools removing \n new lines. There is also a common fix for this we used for other csv exports. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29968 --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Confirmed in 20.11 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29968 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |29271 --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I thik 29271 is the culprit, as it removed the explicit newlines: [%- INCLUDE empty_line.inc -%] They are not needed in English, but very much needed for the translated templates, as the translation process removes any new lines... Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29271 [Bug 29271] Cash register report not displaying or exporting correctly -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29968 --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- This appears to work well: [%- USE ItemTypes -%] [%- INCLUDE csv_headers/reports/cash_register_stats.tt -%] [%- INCLUDE empty_line.inc -%] [%- FOREACH row IN rows -%] [%- FOREACH field IN row; field IF !loop.last; ItemTypes.GetDescription(field) IF loop.last; sep IF !loop.last; END -%] [%- INCLUDE empty_line.inc -%] [%- END -%] TOTAL[%- INCLUDE empty_line.inc -%] -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29968 --- Comment #5 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hm, have to check into the total not getting printed (might be our old version, but in case someone wants to do more work here) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29968 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #6 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- *** Bug 30704 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29968 --- Comment #7 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Minor correction for the TOTAL line: [%- USE ItemTypes -%] [%- INCLUDE csv_headers/reports/cash_register_stats.tt -%] [%- INCLUDE empty_line.inc -%] [%- FOREACH row IN rows -%] [%- FOREACH field IN row; field IF !loop.last; ItemTypes.GetDescription(field) IF loop.last; sep IF !loop.last; END -%] [%- INCLUDE empty_line.inc -%] [%- END -%] TOTAL[% sep %][%- FOREACH field IN total; field; sep IF !loop.last; END -%] -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29968 Maude <maude.boudreau@collecto.ca> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |maude.boudreau@collecto.ca -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29968 Koha collecto <koha@collecto.ca> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |koha@collecto.ca --- Comment #8 from Koha collecto <koha@collecto.ca> --- +1 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org