Validations in dispatcher workflow

Help Studio
, , , ,
1

Hello all.
As a developer what are all the validations we have to do in dispatcher?
For example we will be checking the if the excel is empyy and throw exception/

Similarly what other validations we have to do?

If you have a dispatcher template please send it.

2

Hi @Dinesh_Babu_S ,
Have a lot of ways to validation
with your eg: check file excel empty
→ you can try read range file to get data table, validate by row count
if count > 0 → file not empty
else ->empty file

image
image673×809 20.3 KB

regards,

1 Like
3

Generally, you will have to do validations based on your projects requirements. Deciding whether to validate the transactions in dispatcher or performer is also something you would need to decide, but I’ve found that in most cases it’s simplest just to let most of the logic be within the Performer.

1 Like
4

Hi

Here are some other validations that you may want to do in a dispatcher:

Check for file existence:
Make sure that the input file or folder exists.
you can use the File Exists activity to check for file existence

Check for file format:
Make sure that the input file is in the correct format. For example, if you are expecting an Excel file, make sure that the file extension is .xlsx
the Get File Extension activity to check for file format

Check for data completeness: Make sure that the input file contains all of the required data. For example, if you are expecting a CSV file with customer data, make sure that the file contains all of the required columns, such as customer name, email address, and shipping address.
You can use the Read Excel activity to read the data from an Excel file and check for data completeness and validity

It is important to note that validation is a critical part of any automation process. By validating the input data, you can help to prevent errors and ensure that your automation process runs smoothly.

Here you go for a template on dispatcher process
I find this video more relative to your query

Hope this helps

Cheers @Dinesh_Babu_S

1 Like
5

@Dinesh_Babu_S

General check in dispatcher are as follows

  1. Check for file formats if it is as expected
  2. All required columsn are present or not
  3. Data is present or not
  4. If the data present is consistent or not

Hope this helps

Cheers

1 Like
6

Hope it’s clarified
@Dinesh_Babu_S

If yes would recommend to close the topic
If not we are open for discussion

Cheers

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.