Tech Tuesday: SmartConnect Email Task Feature
In today’s Tech Tuesday article, I am going to show you the email task feature within SmartConnect. The email task can be used on a map task that allows emails to be sent containing the details of map processing. This allows a user to get the status on a map, without having to log into SmartConnect to check.
The first thing you need to do is setup the E-mail Settings connector. To setup the Email Connector, open SmartConnect. Click on the Setup tab, then click the Setup icon. Next click on the E-mail Settings tab. You will need to enter the SMTP Server info, Port, Username and password fields.
Once you have setup the fields, you can click on the Test Email button. If you fill in a From and To email, you can test that an email was sent by clicking the Send Email button. Once the email has successfully arrived, you can click Ok to close the SmartConnect Setup window.
Once the E-mail Settings is complete you are now able to setup a task that sends you an email detailing the status of the map run. To do this, you will either need to open an existing map, or create a new map. Once you have your map setup, you can either click on the Tasks tab or Tasks icon towards the top of the Map Setup window.
Under the Maintain Tasks window you can choose the Task you want to setup. A common Task is the Map Post Task. This is a task that runs if the map fails. This will allow you to receive an email that includes certain error details about your map, if your map fails.
Select the Task you want to perform, then click on the Add New Task drop down menu. In my example I am selecting the Send Email task from the drop down menu.
On the Send Email window enter your To, From email along with your Subject. The Message body is used to describe what failure details you want in your email message. If you click on the Insert Variable button, you can select the variable detail that you would like to receive in your emails. You also see the option to select a Load Template. You can select the Load Template if the details of the email may be loaded from a predefined email template.
Since the example is for a post task map, you will notice that you are able to use the Include Validation Errors and Include Process Errors check boxes. Selecting the Include Validations Errors checkbox will cause any errors raised during the map data checks stage to be attached to the email as a csv file. This will list failed rows in the file, saving the user from having to reopen the map to figure out what went wrong.
Selecting the Include Process Errors checkbox will cause any errors raised during processing to be attached to the email as a csv file. This contains the failed records. With the failed records a user could run a new map, to re-upload just those failed records.
Once you have entered the valid information, you can click the Save button. You can then click Ok on the Maintain Tasks window.
If your map is using any global variables for the email task, you will need to add a pre-map script task to initialize the variables being used. For better performance, SmartConnect only initializes variables that are used in a script on the map. A sample script would look like this.
‘——– BEGIN SCRIPT —————–
Dim My_String as string
‘——– END SCRIPT —————–
Below is an example of the email you will receive regarding the failure details. This email allows you to get notification on your map progress, without having to access SmartConnect for those results.
Leave a Comment
Integrate & Automate without Any Code.
SmartList Data has Never Been Faster.
The Easiest Way to Report on GP Data.
What email should be used in the “SmartConnect Setup – E-mail Settings” window? Will that be the from email, or is it just used for this set up only. And then we set up the “from” email in global settings, right?
Elsa, the Email Settings item under SmartConnect setup is for rights to send emails within SmartConnect. The From Email on the task is what will show up on the email the user receives and can be entered in the From box or you can use the global variable
I want to use a string variable to compose my message in the email, how can I insert a new line?
Is there a way to change the font color and fond bold properties in the email body?
Is there a specific table where the email on these tasks is stored? We would like to do a mass update via SQL of all of our email tasks in our Smartconnect to replace an email address with a new one. Thank you.