Validation

Validation

Data Validator

Description

Data Validator is a step in the Validation Plugin for Process Studio Workflows. Data Validator step validates data from the input stream against a set of validation rules on the data type and the data. An unlimited number of validation rules can be set. This ensures the quality of data from the input stream. Data validations can include a value range, a distinct list of values or data lengths etc.

Configurations

No.
Field Name
Description
1
Step name
Specify the name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow.
2
Report on all errors, not only the first
Enable checkbox to report on all errors.
3
Output one row, concatenate errors with separator
Output one row, concatenate errors with separator is enabled When Report on all errors, not only the first above is enabled. Enable this checkbox to concatenate all errors and specify the separator.

Validations:

4
Validation Description

5
Name of field to validate
Specify the name of the field to validate

Error code
Specify the error code to pass to error handling for this validation rule.
7
Error description
Specify the error description to pass to error handling for this validation rule.
8
Type

Verify data type? : Check this if you want to specify a certain data type to match.

Data type: Specify the data type of the data specified in this dialog or the data type to verify

Conversion mask: Specify the mask to use to convert the data specified in this validation rule

Decimal symbol: Specify the decimal symbol to use to convert the data specified in this validation rule
9
Data
This block of information contains the actual bulk of the validation rule

Null allowed?: Disable this option if you don't want to allow null values in the data for the selected field.

Max string length: Verify the length of the string-form of the data of the selected field, make sure it's shorter than or as long as the length specified here.

Min string length: Verify the length of the string-form of the data of the selected field, make sure it's longer than or as long as the length specified here.

Maximum value: Verify the data of the selected field and see if it's not higher than the maximum value specified here.

Minimum value: Verify the data of the selected field and see if it's not lower than the minimum value specified here.

Expected start string: the string value of the value we validate needs to start with this value (when specified)

Expected end string: : the string value of the value we validate needs to end with this value (when specified)

Regular expression expected to match : the string value of the value we validate needs to match this regular expression (when specified)

Regular expression not allowed to match : the string value of the value we validate is not allowed to match this regular expression (when specified)

Allowed values: Make sure that the data of the selected field is only one of the values in the list.
You can use the buttons to the right to add or remove values from the list.

Read allowed values from another step? : enable this option to source the data from another step in the workflow.
This effectively removes the need to hard code allowed values. You can now store them in a database table or a file somewhere.
You also need to specify the step and field to read from if this option is selected.
IMPORTANT: For every validation that sources data you need to specify a different step to read from.

Error Handling:

This step supports error handling. As such, it is possible to pass the rows that don't validate in this step to a separate step.

Mail Validator

Description

Mail is a step in the Validation Plugin for Process Studio Workflows. This step checks if an email address is valid or not. The Mail Validator step returns a result field (Boolean or String depending on your settings) and one additional field (String) containing errors string when email address is not valid. The step adds result fields to input stream.

Configurations

No.
Field Name
Description
1
Step name
Name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow.
2
email fieldname
Specify the name of the field that contains the email addresses to check. This field must be defined in a previous step. Dropdown the combo to select fieldname.
3
SMTP check?
By default, PROCESS STUDIO will only check email address structure (using regular expression). If you want to perform a SMTP check, please select this option and fill Email sender (see after). PROCESS STUDIO will extract domain name from the supplied email address (to check) and will try to get all exchangers from the domain name. Each exchanger will be queried.
4
Time out
In order to perform a SMTP check, PROCESS STUDIO will open a socket on the target SMTP host. Specify here the socket time out (by default 0).
5
Email sender
If you select "SMTP check?" option, this field is mandatory. PROCESS STUDIO will need sender email address to query SMTP host.
6
Default SMTP server
If you know which SMTP server to query, please specify it here, PROCESS STUDIO will then query only this one.
Note: Specifying SMTP host here will faster the process because PROCESS STUDIO will ask only this one and not fetching all the exchangers from the domain name.
7
dynamic default SMTP?
IF you want to pass default SMTP server in a dynamic way, check this option.
8
Default SMTP field
If you select the previous option, you must fill this field. This field must be defined in a previous step. Dropdown the combo to select fieldname.
9
Result fieldname
PROCESS STUDIO will store the result of the process in this field. The result will be Boolean (TRUE = the email address is valid, FALSE = the email address is unvalid) if "Result is a string" option is unchecked (see after).
Note: This field is mandatory and will be added to the input stream.
10
Result is a string
This option will turn the ouput field into a String and when the email address is valid the output will contains the "Email is valid" field (see after) otherwise it will contains the "Email is not valid" field (see after).
11
Email is valid
If you selected the previous option, you must fill this field
12
Email is not valid
If you selected the previous option, you must fill this field
13
Errors field
When an email is address is invalid, PROCESS STUDIO return the reason. If you want to add it in the input stream, please give the field a name, otherwhise leave this field blank.

XSD Validator

Description

XSD Validator is a step in the Validation Plugin for Process Studio Workflows. This step validates XML source (file or input field) against XSD (XML Schema Definition). You need to specify the XSD source that describes how XML file should look like and the XML you want to validate for layout.

Configurations

No.
Field Name
Description
1
Step name
Specify the name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow.

XML Source:

2
XML source is a file
Enable this checkbox if the XML file is defined as a filename in the XML field
3
XML field
Enable this checkbox if the field to read that contains the XML filename or the XML content itself.

Output fields:

4
Result fieldname
Specify the name of the result field
5
Output String field
Enable this checkbox if you want to specify specific messages after validation:

Display if XML is valid : the message if the XML was valid

Display if XML is not valid : the message if the XML wasn't valid
6
Add validation msg in output
Enable this check box if you want to add a validation message in the output
7
Validation msg field
Specify the name of the validation message field

XML schema definition:

Verify data type? : Check this if you want to specify a certain data type to match.

Data type: Specify the data type of the data specified in this dialog or the data type to verify

Conversion mask: Specify the mask to use to convert the data specified in this validation rule

Decimal symbol: Specify the decimal symbol to use to convert the data specified in this validation rule
8
XSD source
Select one of these options:
The XSD source is a file, let me specify the filename (specify below in the XSD filename field)
The XSD source is a file, defined in a field (specify below in the XSD filename field)
The XSD source is defined inside the source XML
9
XSD Filename
Specify the filename if option 1 is chosen above.
Click Browse button to search the file.
10
XSD Filename Field
Specify the field containing the file if option 2 is chosen as XSD source above.

Links to better reach

AutomationEdge Training Portal

Bot Store

EPD

No.	Field Name	Description
1	Step name	Specify the name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow.
2	Report on all errors, not only the first	Enable checkbox to report on all errors.
3	Output one row, concatenate errors with separator	Output one row, concatenate errors with separator is enabled When Report on all errors, not only the first above is enabled. Enable this checkbox to concatenate all errors and specify the separator.
	Validations:
4	Validation Description
5	Name of field to validate	Specify the name of the field to validate
	Error code	Specify the error code to pass to error handling for this validation rule.
7	Error description	Specify the error description to pass to error handling for this validation rule.
8	Type	Verify data type? : Check this if you want to specify a certain data type to match. Data type: Specify the data type of the data specified in this dialog or the data type to verify Conversion mask: Specify the mask to use to convert the data specified in this validation rule Decimal symbol: Specify the decimal symbol to use to convert the data specified in this validation rule
9	Data	This block of information contains the actual bulk of the validation rule Null allowed?: Disable this option if you don't want to allow null values in the data for the selected field. Max string length: Verify the length of the string-form of the data of the selected field, make sure it's shorter than or as long as the length specified here. Min string length: Verify the length of the string-form of the data of the selected field, make sure it's longer than or as long as the length specified here. Maximum value: Verify the data of the selected field and see if it's not higher than the maximum value specified here. Minimum value: Verify the data of the selected field and see if it's not lower than the minimum value specified here. Expected start string: the string value of the value we validate needs to start with this value (when specified) Expected end string: : the string value of the value we validate needs to end with this value (when specified) Regular expression expected to match : the string value of the value we validate needs to match this regular expression (when specified) Regular expression not allowed to match : the string value of the value we validate is not allowed to match this regular expression (when specified) Allowed values: Make sure that the data of the selected field is only one of the values in the list. You can use the buttons to the right to add or remove values from the list. Read allowed values from another step? : enable this option to source the data from another step in the workflow. This effectively removes the need to hard code allowed values. You can now store them in a database table or a file somewhere. You also need to specify the step and field to read from if this option is selected. IMPORTANT: For every validation that sources data you need to specify a different step to read from.