Skip to main content

Validation Rules And Notifications

Validation Rules and Email Configuration​

Validation Rules in DPL Studio are used to prevent invalid or bad data from being exported or uploaded. A Validation Rule consists of one or more queries such as:Standard Query, Advanced Query, Aggregate Query, Transform Query. These queries are executed in a specified order during validation.

How Validation Rules Work​

If a validation query returns one or more rows, the validation is considered Failed.

Example​

A validation query can be created to: Show all records where Customer ID is missing

a. If the query returns records, it indicates that invalid or incomplete data exists.
b. If no rows are returned, the validation passes successfully.

Validation Rules can be applied during the export process to ensure only valid data is exported.

Email Configuration​

Email configuration is required to send email notifications for: Export Success, Export Failure

These notifications are triggered when configured in the Export Template settings.

Steps to Configure Mail Settings​

  1. Open DPL Studio.
  2. Navigate to: Settings → Configuration → Mail Settings
  3. Enter the required mail configuration details: Mail Server, Port, Return Address
  4. Enter the authentication details: Username, Password
  5. Save the configuration settings.

Once configured, DPL Studio can automatically send email notifications based on export results and validation status.Email configuration is required to send email notification on export success or failure if specified in the export template.