Hi everyone, Whenever I print stat report in CVS format I get something like this: Priority;"Sat 1";"Sun 2";"Mon 3";"Tue 4";"Wed 5";"Thu 6";"Fri 7";"Sat 8";"Sun 9";"Mon 10";"Tue 11";"Wed 12";"Thu 13";"Fri 14";"Sat 15";"Sun 16";"Mon 17";"Tue 18";"Sum" Instead of getting a nice excel spreadsheet, all records end up in the same cell, the first one. Is there any problem with the CSV converter in OTRS? If yes is there any fix for it? 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 mailto:marijan@mnquest.com , http://www.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.
Not a fix but, just tell excel the delimiter is a semi-colon rather than a comma. (Import the file).
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
Thanks !!!
Solution #1 fixed the issue.
Now, I tried to open the mail archive but got an error.
Any news on that ?
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
Marijan Lesko (MLK) wrote:
Now, I tried to open the mail archive but got an error. Any news on that ?
http://www.mail-archive.com/otrs@otrs.org/msg20621.html Link works for me? Steve -- Steven Carr Engineer - Khipu Networks Ltd. support@khipu-networks.com - www.khipu-networks.com Secure - Compliant - Infrastructure Registered Office: Fairfax House, 15 Fulwood Place, London WC1V 6AY Registered in England. Company Number 5218573
Thanks, it worked now ! I tried yesterday at home and it did not work on my laptop! Now it opened. 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 Steven Carr Sent: Monday, November 24, 2008 3:57 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] CSV Marijan Lesko (MLK) wrote:
Now, I tried to open the mail archive but got an error. Any news on that ?
http://www.mail-archive.com/otrs@otrs.org/msg20621.html Link works for me? Steve -- Steven Carr Engineer - Khipu Networks Ltd. support@khipu-networks.com - www.khipu-networks.com Secure - Compliant - Infrastructure Registered Office: Fairfax House, 15 Fulwood Place, London WC1V 6AY Registered in England. Company Number 5218573
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
participants (4)
-
LQ Marshall -
Marijan Lesko (MLK) -
Michiel Beijen -
Steven Carr