RE: [otrs] CSV reports
That did it. Thanks a lot. You are 2 for 2 now -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Torsten Thau Sent: Thursday, January 10, 2008 3:23 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] CSV reports -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Maurice, Maurice James Ny schrieb: > 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\";"; regards, Torsten Thau - -- Torsten Thau, Dipl. Inform. c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 fax: +49 371 5347 625 http://www.cape-it.de -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHhdXSvXo8m5PgoXQRAmdkAJ9Srj382ypoB9xyZLYOtgmv4pLn9gCeIfgQ YYI6x2UEf76epgIY1wlNZkg= =cZKx -END PGP SIGNATURE- ___ 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/ ___ 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/
Re: [otrs] CSV reports
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Maurice, Maurice James Ny schrieb: > 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\";"; regards, Torsten Thau - -- Torsten Thau, Dipl. Inform. c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 fax: +49 371 5347 625 http://www.cape-it.de -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHhdXSvXo8m5PgoXQRAmdkAJ9Srj382ypoB9xyZLYOtgmv4pLn9gCeIfgQ YYI6x2UEf76epgIY1wlNZkg= =cZKx -END PGP SIGNATURE- ___ 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/
Re: [otrs] CSV reports
Maurice James Ny wrote: 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? We don't use CSV export, but AFAIK the semicolon is a common delimiter for CSV files (the most common one being the comma). Usually you set the delimiter when importing data. http://en.wikipedia.org/wiki/Comma-separated_values says: "CSV is one implementation of a delimited text file, which uses a comma to separate values (where many implementations of CSV import/export tools allow an alternate separator to be used; as is shown in the MS Access screen shot, below)." Nils Breunese. ___ 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/