[Koha-bugs] [Bug 18331] CSV exports need to be fixed once and for all

[bugzilla-daemon at bugs.koha-community.org]

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

Jonathan Druart <jonathan.druart at bugs.koha-community.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Failed QA                   |Needs Signoff

--- Comment #17 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
Well, we have a problem here. Still works for me.
Please follow carefully the following, there is something you are or I am
missing.

- Apply the patches
- Restart plack and memcached # useless, but just in case...
- perl translate update de-DE
- Edit po/de-DE-staff-prog.po and modify the two following blocks (for the CSV
content, then for the headers):

#: intranet-tmpl/prog/en/modules/acqui/csv/lateorders.tt:1
msgid ""
"%s %s %s %s \"%s (%s days)\",\"%s\",\"%s\",\"%s %sAuthor: %s.%s%sPublished "
"by: %s.%s\",\"%s x %s = %s (%s)\",\"%s (%s)\",\"%s\",\"%s\" %s %s ,,Total "
"orders in late, %s "
msgstr ""
"%s %s %s %s \"%s (%s Tage)\",\"%s\",\"%s\",\"%s %sVerfasser:
%s.%s%sVeröffentlicht "
"von: %s.%s\",\"%s x %s = %s (%s)\",\"%s (%s)\",\"%s\",\"%s\" %s %s ,,Anzahl "
"verspäteter Bestellungen, %s "

#: intranet-tmpl/prog/en/includes/csv_headers/acqui/lateorders.tt:1
msgid ""
"%sORDER DATE,ESTIMATED DELIVERY DATE,VENDOR,INFORMATION,TOTAL COST,BASKET,"
"CLAIMS COUNT,CLAIMED DATE%s "
msgstr ""
"%sBestelldatum,Berechnetes Lieferdatum,Lieferant,Informaton,Gesamtkosten,"
"Bestellung,Anzahl Reklamationen,Reklamationsdatum%s "

Make sure the fuzzy lines are removed!

- perl translate install de-DE
- Create 2 orders, close the basket
- hit /cgi-bin/koha/acqui/lateorders.pl
- Export the 2 orders (English template), I get:
ORDER DATE,ESTIMATED DELIVERY DATE,VENDOR,INFORMATION,TOTAL COST,BASKET,CLAIMS
COUNT,CLAIMED DATE
"2017-07-10 (0 days)","07/13/2017","My Vendor","E Street shuffle : Author:
Heylin, Clinton..","111.00 x 1 = 111.00 (Fund 1_2)","My Basket (1)","0",""
"2017-07-10 (0 days)","07/13/2017","My Vendor","Introduction to Attic Greek /
Author: Mastronarde, Donald J..Published by: University of California
Press,.","22.00 x 1 = 22.00 (Main fund)","My Basket (1)","0",""
,,Total orders in late, 2

- Enable de-DE (pref language)
- Export the 2 orders, I get:
Bestelldatum,Berechnetes
Lieferdatum,Lieferant,Informaton,Gesamtkosten,Bestellung,Anzahl
Reklamationen,Reklamationsdatum
 "2017-07-10 (0 Tage)","07/13/2017","My Vendor","E Street shuffle : Verfasser:
Heylin, Clinton..","111.00 x 1 = 111.00 (Fund 1_2)","My Basket (1)","0",""
 "2017-07-10 (0 Tage)","07/13/2017","My Vendor","Introduction to Attic Greek /
Verfasser: Mastronarde, Donald J..Veröffentlicht von: University of California
Press,.","22.00 x 1 = 22.00 (Main fund)","My Basket (1)","0",""
 ,,Anzahl verspäteter Bestellungen, 2

% wc /tmp/lateorders_en.csv
  4  55 486 /tmp/lateorders_en.csv
% wc /tmp/lateorders_de.csv
  4  50 541 /tmp/lateorders_de.csv

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