Yes, this is great info - thank you. I reported this as a bug, since they were all bunched up in the left column. I guess on other systems, the default delimiter is a semi colon. Best Regards, Rick -->-->-->-->-->-->-->-->-->-->-->-->-->-->-->-->-->-->--> Rick Cogley (mailto:rick.cogley@esolia.co.jp) Tel: 03-5940-6880 || Fax: 03-5940-6881 || Cell: 090-4423-5475 (Outside Japan, remove leading zero -- +81-3-5940-6880) English: http://www.esolia.com || Japanese: http://www.esolia.co.jp Bilingual IT solutions and management firm -- eSolia. -->-->-->-->-->-->-->-->-->-->-->-->-->-->-->-->-->-->--> -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Richard Hamson Sent: Tuesday, June 21, 2005 7:27 PM To: otrs@otrs.org Subject: RE: [otrs] Reporting / .csv files Mark, Many thanks for that - i think that is the easiest way to go. Rich

From: "Mark Croonen" Reply-To: "User questions and discussions about OTRS.org" To: "'User questions and discussions about OTRS.org'" Subject: RE: [otrs] Reporting / .csv files Date: Tue, 21 Jun 2005 07:20:17 +0800

Hi Richard,

What I do is simply use the import external data function in Excel which is under the data menu. Import the csv files as is but specify that the delimiter is a semi colon instead of a comma. This does the job and it is better than modifying the code, well IMHO it is.

Regards Mark

"Imagination is more important than knowledge, the important thing is to not stop questioning." -- Albert Einstein

...

-----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Richard Hamson Sent: 21 June 2005 00:28 To: otrs@otrs.org Subject: [otrs] Reporting / .csv files

Hello,

I am currently looking into setting up reports by exporting .csv file out of OTRS. Unfortunately the .csv files are coming out with ; instead of , between the columns of data thus Excel (in this case) is putting all of the information in one column.

Does anyone know where to amend the syntax so that , are used and not ;?

Regards

Richard

_________________________________________________________________ Want to block unwanted pop-ups? Download the free MSN Toolbar now! http://toolbar.msn.co.uk/

_______________________________________________ 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 oder Consulting f・ Ihr OTRS System? => http://www.otrs.de/

_______________________________________________ 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 oder Consulting f・ Ihr OTRS System? => http://www.otrs.de/

_________________________________________________________________ Be the first to hear what's new at MSN - sign up to our free newsletters! http://www.msn.co.uk/newsletters _______________________________________________ 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 oder Consulting f・ Ihr OTRS System? => http://www.otrs.de/