Skip to content


Custom Validation

Rod asked 6 years ago
I need to import values from an excel file into GP tables. Before importing them, I need to validate each row against a complicated set of rules. 
How can I check each row in an excel file against values inside of a database table before running the rest of the smart connect map?
Part of the complicated set of rules will involve string manipulation on the values inside of excel. 
Patrick Roth Staff answered 6 years ago
If you want to do this before SmartConnect does anything, then you would need to create your own “tasks that run before the map”.
In it, you’d then have to write your own code to read the excel file directly and then iterate through the data yourself.
If you find an issue, you’d have to warn your users somehow and then return a “false” flag back to the task results so that the integration fails before it starts.
Your other option is that you could write a “before document” task in the SmartConnect map.  So let SC read the excel data and then try to create a document – and then before it gets submitted to the destination -your calculation could throw an error and cancel the specific document but not the rest that might be ok.
This one is a lot easier since you then don’t have to read the data yourself.
Rod replied 6 years ago

Thanks Patrick. I will have to think about this.

If you would like to submit an answer or comment, please sign in to the eOne portal.