Using iDMS to Send Emails Via PA+

This page details how iDMS and iMIS’s Process Automation+ (PA+) can be used in tandem to send emails after an iDMS task is run. This involves creating a panel, using the panel in a PA+ task, and modifying iDMS tasks to update the panel. The PA+ task will then send an email based on the updated panel.

In this example, PA+ will be used to send an email to users who have had their accounts recently unlocked.

Complexity

Intermediate

EMS Compatible

Yes

iMIS 2017 Compatible

Yes

Actions

Insert, Insert w/ Matching Help, Insert / Update

Creating the Panel

For more information on creating panels, see Creating panels.

Do the following to create a panel:

  1. Go to Rise > Panel Designer > Panel definitions, select Add panel definition.

  2. Create the panel such that it will display the information required for the task to execute properly. This may require some creativity. In this example, the panel must contain the iMIS ID of those whose accounts are unlocked and the date they were unlocked on.

  3. Add the Unlocking Date by creating a source then adding a property with type Date.

Note: There are no special characters (e.g. spaces) allowed in the source name.

Creating the IQA query

Do the following to create the IQA query using the Panel as the source:

  1. Use the “Unlock_Date” (or similarly named property) being “Greater Equal” than @date to select all “Unlock_Date” dates that are the current date (e.g. if today is June 28th, the query will return all Unlock Dates that are from today).

Creating the PA+ Task

Do the following to create the PA+ task:

  1. Go to RiSE > Process Automation and select Add new task.

  2. Add a trigger for the schedule of the task. In this example, for how the IQA query is set up, it should run daily. The time it runs at should be after the workday is over, otherwise any accounts unlocked after the scheduled time will not have an email sent to them. Make sure to ensure the task is enabled in order for it to run.

  3. Select the Query.

  4. Under Actions, select Add action. Then, select IQA as the recipient data source and New communication to create the email that will be sent.

  5. Click Save & Exit.

Running the iDMS Task

When running the iDMS Task perform all normal mappings. Include two extra mappings for the panel. Map the iMIS ID to the iMIS ID and use the current date for the Unlock Date. This will update the panel, which will update in the IQA query, which will be used in the PA task to send an email to these IDs.