FREQUENTLY ASK QUESTIONS

  

Introduction

This manual details stting the functionality of automatic e-mailing using the MAIL function in REPORTING

Settings, SMTP

In order to send emails, it is necessary to install CAQservice and configure the service for SMTP.

Settings in the Reporting module

Start the Reporting module  in  designer mode. /APL/SQLreporting.exe and licenses for sending emails.
- Select the required reporting query, eg "SPC Surveys outside the tolerance field"-
- Go to the "Editor" tab and under "Settings" you will find the "Mail" tab.

Creating a module

It is necessary to define the module that will be processed when sending an email. Using the yellow "Modules" icon on the left. Name the module for example "SPC.outside.print"create one record TYPE TYPE "PRINT ASSEMBLY".

Then, under the "Modules" section of the print report module, define a print report that is generated in an attachment sent by email.

Email settings

Printscreen showing the settings of the MODULES section and the EMAIL tab.

• Fill in the individual items as follows (see fig.):
  • Addresses: (List of emails to which reporting should be sent)
  • AttachmentName: (What name should be sent for the email attachment)
  • AttachStyle: (What format should the reporting result be)
  • MailContent: (Fill in the content of the message so that the SPAM filter cannot be excluded)
  • MailSubject: (Subject of the message, fill in the filling so that the SPAM filter cannot be excluded)
  • SenderAddress: (Sender's email address)
  • ModuleName: (Define the name of the module to bind the print report)

Scheduler settings

In the "Scheduler" window

Active: must be set to TRUE

Triggers: click on the three dots icon at the end and the scheduler window will open. Here  the days, hours and start period are defined. Days are represented by the number when 1=Monday. The demo below will start Mon/ Fri at 9:00. it is advisable to set the task launcher in Windows to 9:15 (every hour)

 

Valid procedure from version 2021.xx.xxx

CAQservice takes care of regular distribution, which must be installed.

In addition, the "Scheduler" tab must be checked next to the "Mail" line in ./APL/CAQadmin.exe (System Administration)

 

Running scheduled tasks, this procedure is deprecated for versions up to 2020.xx.xxx

For the scheduler to operate in PALSTAT, it is necessary to run a script from scheduled tasks in Windows every hour in the SYSTEM account, eg hourly. Each time a script from the scheduler in Windows is run, it verifies that there is no time-ready task in Palstat.

/APL/modulerunner.exe scheduler/smmailreport

It is advisable to create a batch that will store the output in a file within the PALSTAT installation for later analysis in case of problems. This program will check every hour in PALSTAT whether any reporting has the Scheduler set and if YES it will start it. If the scheduler is set to 9:00 and Windows starts the task at 9:3, the email will be sent because the scheduler time is in the past.

Palstat CAQ is delivered together with the directory / PROCESS where the "scheduler.mail.bat.example" file, which is prepared for startup and logging can also be found.

Sample batch:
C:/PALSTAT/CONFIG/palstat.scheduller.smtp.bat

@ECHO OFF

C:
CD c:/PALSTAT/APL/

modulerunner.exe scheduler/smmailreport MailReportModule > c:/PALSTAT/tmp/reporting.email.txt

DEBUG:

For debugging, it is possibe to force the distrubution. CAUTION! It can be sent to a huge amount of people is set up "all", this can be replaced by the name of the report to be executed.

modulerunner.exe scheduler/smmailreport MailReportModule /force all