Need to do validations for csv file (Incoming)

[former_member751869]

Hello All,

How to do validations for incoming CSV file, if file header is missing or incorrect format and mandatory filed validation failed then email should send so they will resend file with correct details. ( email should be customize where it tells which field or what is the reason for failure in CPI.)

Can you help with any groovy code please.

Thanks,

Chaitanya

[daviddasilva]

Hi,

I don't have a way to do this with groovy script but this could easily be achieved with a message mapping step!

Just transform you CSV into an XML and then use a message mapping step to check each field for the desired inputs (or lack thereof!).

Kind regards,

David

[abhinavsingh04]

Hi David, could you please tell how it can be done with message mapping