This has to do with the list separator specified in Regional Options
in Windows. If you use Dutch (or I guess German) localization on your
PC, or even just Dutch preferences on US Windows, your List Separator
will be a semicolon instead of a comma. In that case, the CSV file
would open just fine.
There are two solutions for this issue, you can fix it on your (and
all other) PC's that use the report feature, or you can change the
separator in a couple of lines of Perl in OTRS.
Solution 1: workstation only
To change the list separator in the Regional Options, go to Start ->
Settings -> Control Panel, then double click on Regional Options,
click on the Numbers tab, then change the List Separator to a
semicolon.
Solution 2: server change
You can change the separator in a couple of lines of Perl, please
refer to this thread:
http://www.mail-archive.com/otrs@otrs.org/msg20621.html
Please note that these (most probably, in your case, solution 2) will
solve your problem, but these are not the 'real' solution. That would
be to have the separator depending of the language of the user, with a
possibility to override it on a per-user basis in the user's
preferences. You can file an enhancement for this via
http://bugs.otrs.org if you'd like.
Regards,
--
Michiel Beijen
Software Consultant
+31 6 - 457 42 418
Bee Free IT + http://beefreeit.nl
2008/11/22 LQ Marshall
Not a fix but, just tell excel the delimiter is a semi-colon rather than a comma. (Import the file).
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs