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/[email protected]/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 <[EMAIL PROTECTED]>: > 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 > _______________________________________________ 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
