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: marijan@mnquest.com, 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: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] 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/otrs@otrs.org/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
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