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:[EMAIL PROTECTED]) 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Hamson Sent: Tuesday, June 21, 2005 7:27 PM To: [email protected] Subject: RE: [otrs] Reporting / .csv files Mark, Many thanks for that - i think that is the easiest way to go. Rich >From: "Mark Croonen" <[EMAIL PROTECTED]> >Reply-To: "User questions and discussions about OTRS.org" ><[email protected]> >To: "'User questions and discussions about OTRS.org'" <[email protected]> >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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > > Of Richard Hamson > > Sent: 21 June 2005 00:28 > > To: [email protected] > > 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/ _______________________________________________ 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\xFCr Ihr OTRS System? => http://www.otrs.de/
