Skip to main content
  • EN

In my scenario, I have an FME script that performs data validation. If the data is valid, it updates the database. However, if any records contain errors, I want to capture those records in an Excel file for users to review before uploading the data. In this error case, no data will be updated to database. 

So, the logic I'm aiming for is as follows:

  1. Validate the data.
  2. After validating all data, capture all invalid records to an Excel file. Then, terminate the FME script without uploading the data to the database.
  3. If all data is valid, proceed to upload it to the database.

I've attempted to create a flow with a terminator, but the Excel writer doesn't have a connector. Connecting the terminator to the output port of the TestFilter after validation would terminate the writing of the error Excel file as well.

Can anyone provide suggestions to solve this issue?

Classic writers have no output ports but FeatureWriters have. When I discovered FeatureReaders and FeatureWriters, I switched and never used classic readers / writers anymore.

If I need a validation workflow it looks like this:

Sample workspace attached.

Reply


Community Stats

30,353
Posts
115,357
Replies
38,088
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.