Hi, I modified CSV.pm and my stats reports starting going out nicely. Then I tried to get CSV from the search in tickets and CSV format is not working again. It look like stats CSV is defined by the CSV.pm script and Search is not! Any ideas ?
Marijan Lesko -- Votre meilleur compliment à MontréalNetQuest Inc. est une référence auprès vos amis et partenaires d'affaires. Gestion Des Technologies Informatiques. 5250, ave. Ferrier, suite 805, Montréal (Québec) H4P 1L4 Tél: (514) 486-9005 x1001, Sans frais: 1-866-486-9005 x1001, Fax: (514) 486-5721 E-mail: [EMAIL PROTECTED], http://www.mnquest.com -- Les prix soumissionnés sont valides pour une période de 24 heures à moins d'avis contraire ~ Vérifier si le produit suggéré correspond à vos attentes. --------------- This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen Sent: Sunday, November 23, 2008 3:05 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] CSV This has to do with the list separator specified in Regional Options in Windows. If you use Dutch (or I guess German) localization on your PC, or even just Dutch preferences on US Windows, your List Separator will be a semicolon instead of a comma. In that case, the CSV file would open just fine. There are two solutions for this issue, you can fix it on your (and all other) PC's that use the report feature, or you can change the separator in a couple of lines of Perl in OTRS. Solution 1: workstation only To change the list separator in the Regional Options, go to Start -> Settings -> Control Panel, then double click on Regional Options, click on the Numbers tab, then change the List Separator to a semicolon. Solution 2: server change You can change the separator in a couple of lines of Perl, please refer to this thread: http://www.mail-archive.com/[email protected]/msg20621.html Please note that these (most probably, in your case, solution 2) will solve your problem, but these are not the 'real' solution. That would be to have the separator depending of the language of the user, with a possibility to override it on a per-user basis in the user's preferences. You can file an enhancement for this via http://bugs.otrs.org if you'd like. Regards, -- Michiel Beijen Software Consultant +31 6 - 457 42 418 Bee Free IT + http://beefreeit.nl 2008/11/22 LQ Marshall <[EMAIL PROTECTED]>: > Not a fix but, just tell excel the delimiter is a semi-colon rather than a > comma. (Import the file). > > _______________________________________________ > 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 > _______________________________________________ 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 _______________________________________________ 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
