I have a scenario where I have a CSV reader which reads in values of specific types. On occasion there is unexpected data in the input that does not match the type (such as a negative number where a UInt32 is expected, or character data where numeric is expected). The CSV reader generates a warning message and substitutes the offending value for missing or null, but I would prefer if it generated an error so I could terminate translation and look at the data myself to see if it is either bad data (which I need to fix) or if my input types are incorrect and need to be expanded.
Reviewing the logs every time is possible of course, but sometimes the processes are automated, and sometimes I need the workspace to terminate on error before it gets to the point where it writes the final data. In these cases using the logs to check warnings isn't great.
I can set the CSV reader to read in only string data, but I still want the type checking as a first data validation step. Ideally I would be able to have FME treat these sorts of type mismatches as errors instead of warnings but I don't see this option in Workbench. Is it possible somehow, or does anyone have other possible solutions I could try for validation of CSV input data?
