Automatic Generating & Emailing Stats
Moderator: crythias
Automatic Generating & Emailing Stats
Hi,
I would like to test whether a stat report can be automatically generated and email to particular user. I saw a post but it was for V2 of otrs and used a file mkstat.pl file to do this job. The same file is not available in v3.
I would like to test whether a stat report can be automatically generated and email to particular user. I saw a post but it was for V2 of otrs and used a file mkstat.pl file to do this job. The same file is not available in v3.
OTRS 3.1.10
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Automatic Generating & Emailing Stats
try otrs/bin/otrs.GenerateStats.pl
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: Automatic Generating & Emailing Stats
Below is the error message im receiving.
I checked the language folder and all mentioned files are present.
Pointers to resolve this issue are welcome
I checked the language folder and all mentioned files are present.
Pointers to resolve this issue are welcome
Code: Select all
otrs\bin>perl otrs.GenerateStats.pl -n 10001 -r mail
@domain.com -s mail@domain.com -m 'test' -f Print
Use of uninitialized value $PDF::API2::Version::VERSION in pattern match (m//) at /otrs/Kernel/System/PDF.pm line 95.
ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011
Message: PDF support activated in SysConfig but PDF::API2 0.57 or newer is required!
Traceback (3020):
Module: Kernel::System::PDF::new (v1.44) Line: 103
Module: otrs.GenerateStats.pl (v1.3) Line: 69
Unrecognized escape \i passed through in regex; marked by <-- HERE in m/^C:\i <-- HERE netpub\wwwroot\otrs/(.*)\.pm$/ at /otrs/Kernel/Language.pm line 154.
Unrecognized escape \o passed through in regex; marked by <-- HERE in m/^C:\inetpub\wwwroot\o <-- HERE trs/(.*)\.pm$/ at C:/Inetpub/wwwroot/otrs/Kernel/Language.pm line 154.
ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011
Message: Module C:\inetpub\wwwroot\otrs/Kernel/Language/en_CA.pm.pm not found!
Traceback (3020):
Module: Kernel::Language::new (v1.77) Line: 168
Module: otrs.GenerateStats.pl (v1.3) Line: 120
ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011
Message: Sorry, can't load C:\inetpub\wwwroot\otrs::Kernel::Language::en_CA.pm!
Check the C:\inetpub\wwwroot\otrs::Kernel::Language::en_CA.pm (perl -cw)!
Traceback (3020):
Module: Kernel::Language::new (v1.77) Line: 169
Module: otrs.GenerateStats.pl (v1.3) Line: 120
ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011
Message: Module C:\inetpub\wwwroot\otrs/Kernel/Language/en_Custom.pm.pm not found!
Traceback (3020):
Module: Kernel::Language::new (v1.77) Line: 168
Module: otrs.GenerateStats.pl (v1.3) Line: 120
ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011
Message: Sorry, can't load C:\inetpub\wwwroot\otrs::Kernel::Language::en_Custom
.pm! Check the C:\inetpub\wwwroot\otrs::Kernel::Language::en_Custom.pm (perl -cw)!
Traceback (3020):
Module: Kernel::Language::new (v1.77) Line: 169
Module: otrs.GenerateStats.pl (v1.3) Line: 120
ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011
Message: Module C:\inetpub\wwwroot\otrs/Kernel/Language/en_FAQ.pm.pm not found!
Traceback (3020):
Module: Kernel::Language::new (v1.77) Line: 168
Module: otrs.GenerateStats.pl (v1.3) Line: 120
ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011
Message: Sorry, can't load C:\inetpub\wwwroot\otrs::Kernel::Language::en_FAQ.pm
! Check the C:\inetpub\wwwroot\otrs::Kernel::Language::en_FAQ.pm (perl -cw)!
Traceback (3020):
Module: Kernel::Language::new (v1.77) Line: 169
Module: otrs.GenerateStats.pl (v1.3) Line: 120
ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011
Message: Module C:\inetpub\wwwroot\otrs/Kernel/Language/en_GB.pm.pm not found!
Traceback (3020):
Module: Kernel::Language::new (v1.77) Line: 168
Module: otrs.GenerateStats.pl (v1.3) Line: 120
ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011
Message: Sorry, can't load C:\inetpub\wwwroot\otrs::Kernel::Language::en_GB.pm!
Check the C:\inetpub\wwwroot\otrs::Kernel::Language::en_GB.pm (perl -cw)!
Traceback (3020):
Module: Kernel::Language::new (v1.77) Line: 169
Module: otrs.GenerateStats.pl (v1.3) Line: 120
ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011
Message: Module C:\inetpub\wwwroot\otrs/Kernel/Language/en_ITSMChangeManagement.pm.pm not found!
Traceback (3020):
Module: Kernel::Language::new (v1.77) Line: 168
Module: otrs.GenerateStats.pl (v1.3) Line: 120
ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011
Message: Sorry, can't load C:\inetpub\wwwroot\otrs::Kernel::Language::en_ITSMChangeManagement.pm! Check the C:\inetpub\wwwroot\otrs::Kernel::Language::en_ITSMChangeManagement.pm (perl -cw)!
Traceback (3020):
Module: Kernel::Language::new (v1.77) Line: 169
Module: otrs.GenerateStats.pl (v1.3) Line: 120
ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011
Message: Module C:\inetpub\wwwroot\otrs/Kernel/Language/en_ITSMConfigItem.pm.pm not found!
Traceback (3020):
Module: Kernel::Language::new (v1.77) Line: 168
Module: otrs.GenerateStats.pl (v1.3) Line: 120
ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011
Message: Sorry, can't load C:\inetpub\wwwroot\otrs::Kernel::Language::en_ITSMConfigItem.pm! Check the C:\inetpub\wwwroot\otrs::Kernel::Language::en_ITSMConfigItem.pm (perl -cw)!
Traceback (3020):
Module: Kernel::Language::new (v1.77) Line: 169
Module: otrs.GenerateStats.pl (v1.3) Line: 120
ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011
Message: StatNumber invalid!
Traceback (3020):
Module: Kernel::System::Stats::StatNumber2StatID (v1.100) Line: 1907
Module: otrs.GenerateStats.pl (v1.3) Line: 164
ERROR: No StatNumber: 10001
OTRS 3.1.10
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Automatic Generating & Emailing Stats
PDF::API2 needs to be installed.
That's not likely all of the issue, but it's part of it.
That's not likely all of the issue, but it's part of it.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: Automatic Generating & Emailing Stats
PDF::API2 is already installed version 2.0.19 something.
OTRS 3.1.10
-
- Znuny advanced
- Posts: 119
- Joined: 12 Jan 2011, 22:35
- Znuny Version: 4.x.x.x.x
- Company: Self-Employed
Re: Automatic Generating & Emailing Stats
Does such Stats Generator exist for v2.4?
if not, any idea how I could run stats automatically (schedule) ?? emailing them would be nice too but main goal is to run report on scheduler
if not, any idea how I could run stats automatically (schedule) ?? emailing them would be nice too but main goal is to run report on scheduler
OTRS 4.0.11
Ubuntu 15.04
MySQL Database, PHP5, Apache (LAMP server bundle)
Ubuntu 15.04
MySQL Database, PHP5, Apache (LAMP server bundle)
-
- Znuny advanced
- Posts: 119
- Joined: 12 Jan 2011, 22:35
- Znuny Version: 4.x.x.x.x
- Company: Self-Employed
Re: Automatic Generating & Emailing Stats
mkstats.pl seems to be it for 2.4 ... not much information though. If anyone is using ti to generate report and email them I'd appreciate more information on how to go about doing so
thanks everyone
thanks everyone
OTRS 4.0.11
Ubuntu 15.04
MySQL Database, PHP5, Apache (LAMP server bundle)
Ubuntu 15.04
MySQL Database, PHP5, Apache (LAMP server bundle)
Re: Automatic Generating & Emailing Stats
you'll find some documentation running the script with --help (or look into the code)
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com