RE: [otrs] Reporting / .csv files
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" > >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: [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/
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" 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: [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ür 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ür 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ür Ihr OTRS System? => http://www.otrs.de/
RE: [otrs] Reporting / .csv files
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ür 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ür Ihr OTRS System? => http://www.otrs.de/
