CSV output separated by semi-colons

[Mothra]

Since OTS 2.4, I've had a hard time pursuading the developers that the "C" in "CSV" stands for "comma" and that, according to RFC 4180, the comma is the only legal separator.

The default in OTRS has always been a semi-colon, as in some countries (including the one where OS comes from), the decimal separator is a comma, so MS Excel (and probably some other spreadsheet programs) default to this in their region.

Given that my select language is English (United Kingdom), and the corresponding Kernel/Language/en_GB.pm file shows a comma as the separator, I'm not sure why my stats CSV output is still semi-colon separated, but my only workaround so far has been to keep modifying CSV.pm after every update.

Has anyone else encountered this problem (particularly in OTRS 3) and come up with a more permanent workaround?


EDIT: Actually, it's been a problem since 2.3.4 - here's the bug I raised, which has been assigned but never implemented: http://bugs.otrs.org/show_bug.cgi?id=3697

[crythias]

Excel *does* allow you to choose delimiter on Open, but not on double-click .csv