otrs  

[otrs] TSV output to CSV

Mike Alsweiler
Sun, 22 Jun 2008 15:13:57 -0700

Hello all. I would like to change to output of the Search CSV format
to be comma separated rather than tab separated. I am running version
2.2. I found the tip below in the mailing list. My quesiotn is (sorry,
I'm a newbie!) if I change this code as suggested below, will I need
to recompile the application?

Thanks in advance
Mike


> Has any one noticed that any reports that you try to generate in CSV
> format never come out correctly because data is separated by ; (semi
> colon) instead of , (comma) . Does anyone have a fix for this?

...unfortunately there's no CSV-separator config param (yet). So you
find the code in Kernel::System::CSV (sub Array2CSV). In version
1.10.2.1 the following two lines 'are responsible' for the semicolon:

106:    $Output .= "\"$Entry\";";
121:    $Output .= "\"$Content\";";
_______________________________________________
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
Support or consulting for your OTRS system?
=> http://www.otrs.com/