[otrs] Report For Survey

2013-04-18 Thread Yousef Hamad
Hi Susan,
I resolved the problem and made the next State as mandatory without remove the 
Close option , but still how can make reports for survey I need to the
Survey results can be exported to excel (csv) file with the individual ratings, 
which includes ticket number, customer name, SLA response, SLA resolution and 
average score of the questions.




Thanks,
Yousef Hamad
Technical Support
Mob +962 799372852




___

This message contains confidential information and is intended only for the 
individual named. If you are not the named addressee you should not 
disseminate, distribute or copy this e-mail. Please notify the sender 
immediately by e-mail if you have received this e-mail by mistake and delete 
this e-mail from your system. E-mail transmission cannot be guaranteed to be 
secured or error-free, as information could be intercepted, corrupted, lost, 
destroyed, arrive late or incomplete, or contain viruses. The sender therefore 
does not accept liability for any errors or omissions in the contents of this 
message, which arise as a result of e-mail transmission. If verification is 
required please request a hard-copy version.
Any views or opinions presented in this email are solely those of the author 
and do not necessarily represent those of the company. Employees of Aspire 
Infotech are expressly required not to make defamatory statements and not to 
infringe or authorize any infringement of copyright or any other legal right by 
email communications.

Aspire Infotech, 130 Queen Rania Street, PO Box 840098 Amman 11181 Jordan
-
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


Re: [otrs] Report For Survey

2013-04-18 Thread Gerald Young
use the -f CSV option in otrs.GenerateStats.pl

Please don't ask questions directly to people on a public mailing list
unless they address you. This isn't that person's email and it's not good
etiquette to send to a personal email address and to a public forum at the
same time.


On Thu, Apr 18, 2013 at 7:38 AM, Yousef Hamad yha...@aspire-infotech.netwrote:

 Hi Susan,
 I resolved the problem and made the next State as mandatory without remove
 the Close option , but still how can make reports for survey I need to the
 Survey results can be exported to excel (csv) file with the individual
 ratings, which includes ticket number, customer name, SLA response, SLA
 resolution and average score of the questions.




 Thanks,
 Yousef Hamad
 Technical Support
 Mob +962 799372852





 ___

 This message contains confidential information and is intended only for
 the individual named. If you are not the named addressee you should not
 disseminate, distribute or copy this e-mail. Please notify the sender
 immediately by e-mail if you have received this e-mail by mistake and
 delete this e-mail from your system. E-mail transmission cannot be
 guaranteed to be secured or error-free, as information could be
 intercepted, corrupted, lost, destroyed, arrive late or incomplete, or
 contain viruses. The sender therefore does not accept liability for any
 errors or omissions in the contents of this message, which arise as a
 result of e-mail transmission. If verification is required please request a
 hard-copy version.
 Any views or opinions presented in this email are solely those of the
 author and do not necessarily represent those of the company. Employees of
 Aspire Infotech are expressly required not to make defamatory statements
 and not to infringe or authorize any infringement of copyright or any other
 legal right by email communications.

 Aspire Infotech, 130 Queen Rania Street, PO Box 840098 Amman 11181 Jordan
 -
 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

Re: [otrs] Report For Survey

2013-04-18 Thread David Boyes
 still how can make reports for survey I need to
 the Survey results can be exported to excel (csv) file with the individual
 ratings, which includes ticket number, customer name, SLA response, SLA
 resolution and average score of the questions.

You've been told this several times.

There's no OTRS supplied code to do this. You have to either:

1) write it yourself
2) pay someone to write it for you

Asking repeatedly isn't going to change that answer. 

Your best option is to access the data directly from the database via a 
reporting tool. The OTRS database schema isn't all that complicated, and it is 
documented. Any reasonably-competent MS Access or Excel user should be able to 
construct a SQL query against the ticket table that produces the desired 
result. Documentation for using ODBC data sources is in the reporting tool 
manuals, and setting up ODBC access to the database is usually not difficult to 
find (google: ODBC MySQL or ODBC your database name here) . That will let 
you create any report or data you want. 

-
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