[otrs] Report For Survey
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
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
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