Report Mailer
Emails or Prints reports based on commands parameters.
| Schedule Parameter | Description |
|---|---|
| SchdType | Can be Daily, Shift or Table. Daily sends at a specified time each day, Shift sends at the end of a shift and Table sends based on a table |
| When | Used by Daily option for time to send |
| MtoF | Used by Daily and Shift. Will send on between Monday and Friday but not on the weekend |
| MtoS | Used by Daily and Shift. Will send on between Monday and Saturday but not Sunday |
| PrevDay | Used by Daily. Will send the previous day to the report for the range |
| Delay | Used by Shift. Time in minutes to wait after a shift is complete before sending |
| TableName | Used by Table. Name of table pulled in from DBRead. Look at the Report table format section bellow for details |
| Parameter | Description |
|---|---|
| ReportID | ID of report to be mailed |
| ReportName | Used in the subject when sending email |
| FileName | Change the default Filename available in DGS.net V 1.01.48 |
| Excel | Will send Excel file instead of PDF DGS.net V 1.01.48 |
| P2 | Parameter 2 or {2} in the reports |
| P3 | Parameter 3 or {3} in the reports |
| P4 | Parameter 4 or {4} in the reports |
| P5 | Parameter 5 or {5} in the reports |
| P6 | Parameter 6 or {6} in the reports |
| P7 | Parameter 7 or {7} in the reports |
| P8 | Parameter 8 or {8} in the reports |
| P9 | Parameter 9 or {9} in the reports |
| Email Parameter | Description |
|---|---|
| From | Email that will appear as the sender of the report |
| To | List of users that will be receiving the email coma delimited |
| SmtpServer | The IP or URL of the SMTP Server that DGS should use to send out the messages |
| Port | The port DGS should use to connect to the SMTP Server |
| Username | If SMTP Server requires a login to send messages this should be filled in |
| Password | If SMTP Server requires a login to send messages this should be filled in |
| UseSSL | Will use SSL when connecting to the SMTP server |
If passing in a table here is a list of columns that DGS will look at to send. Will have to bring in all columns if wanting to track success of sent email as DGS will write back null in missing columns. DBWrite is used to update database.