This requires Data Admin privileges for setup and implementation.
The Send Email Transformation Task was introduced into Data Hub in v10.3 with several other tasks, a total of 27 Data Hub Tasks, as of v11.0 we are now up to 30 Data Hub Tasks! It can be found under the Miscellaneous category directly below Data.
Please Note: If you do not have the correct privileges to access Data Hub you will receive the following upon your login attempt. If you get this message and think it is an error please see your organization's iDashboards Administrator for assistance as Support is unable to give you access.
Say you have data attached to the Send Email task, either: click on the gear on the left, or double click to configure it.
The following Send Email box will appear
In the Send Email box is a drop down for the Recipients*: From List, From User Groups, From Incoming
- From List - The addresses that will receive the email are manually entered. Click the button next to the dropdown to open the recipient list editor (same as the BBC and Reply To fields.).
The simplest way to enter an email address into one of the email list editors is to type it into the text box and press the ENTER key.
If the entered text is a valid email address, it will be added to the list below the text box. Otherwise, an error message will be displayed. Instead of pressing the enter key, the + button to the right of the text box may also be clicked. Clicking the Save button at the bottom of the dialog will also add the email to the list just before the dialog is closed. An entered email address may be enclosed in angle brackets:
An email address may have the address owner's name associated with it. The name will appear along with the email address (or in some cases, instead of the email address) in most email applications. To enter an email address with a name associated with it, type the name first, followed by the email address, and press ENTER:
James Smith firstname.lastname@example.org
James Smith <email@example.com>
Smith, James firstname.lastname@example.org
Multiple email addresses can be entered through an editor's textbox in a single operation. Typically, this is done by pasting a list of entries copied from elsewhere. The entries must conform to the format described above, and be delimited by semicolons (;) or line breaks:
James Smith email@example.com;Betsy Ramos <firstname.lastname@example.org
- From User Groups - The members of selected iDashboards user groups will receive the email, if their user account has an email address configured.
- From Incoming Data - The email addresses that will receive the email are contained in a column of the incoming data set. This configuration is notable in that an an individual email is sent for each row in the incoming data set. The text of the emails, and the subject, may be individualized for each recipient, by embedding other data values from the data row associated with the email.
Selecting Edit next to Email message, an Email message (text editor) box appears!
To Include File Attachment of Incoming Data Rows click the box next to it, selecting Edit next to that box, the Attach Incoming Data Rows box appears, where you can make the ZIP File Name anything you would like, there are a few Macros should you choose to use them.
To Enable Task, I would keep it Fully Enabled to ensure you receive the data.
So you may have followed this article exactly as it is, and found the following Error upon running the ETL Job. So we will take a look a the job we have to get more information on the issue. So we have Extract, Load Data Into Table so we can use it, and Send Email. Task 3 is the Send Email Task.
So then we use the binoculars by clicking on them to see if the Load Data into Table and Extract Data tasks are working as they should. I always work backwards because often times the issue is with a task in the middle of a job. I saw that the data is coming through those tasks as they should.
Once you have verified the rest of the job is working correctly, go to the System menu at the top and select Logs. In the log file you will see the following errors about this:
[ERROR][2021-07-15 17:33:35,574][REQ-ID:220][GeneralErrorPage_jsp] _jspService(): The request to the server was invalid. Please see the system logs for more information.
[WARN][2021-07-15 17:34:07,711][REQ-ID:279][ds_jsp] _jspService(): Skipping idbdata.css
[ERROR][2021-07-15 17:34:17,010][REQ-ID:267][JDBCDataSourceFactory] testConnection(): STACKTRACE:
java.sql.SQLException: Operation timed out. Failed to connect after 10 seconds.
[ERROR][2021-07-16 09:15:36,515][REQ-ID:208][EtlJobProcessor] runEtlJob():RUNNING JOB: Sarah_Test(121) at Task 3 failed for the following reasons: Outgoing email is not enabled on this server.
Settings, then on the left menu select SMTP Settings. Fill them all out with your SMTP server information. For Google SMTP settings please see: Alerts: Sending Notifications to Gmail.
Once you are finished with setting those settings, on the left menu select Notification Email Settings and fill those out. Once both settings tabs have been completed, open your ETL job, and run it.
Once you have run the job you will see the following message popup. TEST_Sarah is the job name, so it will be different based on what you named your jobs.
For More Information:
- iDashboards Data Hub Manual 8. Extract, Transform and Load
- 05/14/2020: v10.3 Enterprise Release Notes
- 02/17/2021: v11.0 Enterprise Release Notes
If the above is unable to resolve the issue, then please contact iDashboards Support for further assistance.