Writing Controlled Data Policy errors

CloverDX Platform
1

I’m reading a .csv file using the UniversalDataReader component with quoted strings=true and data policy=Controlled.

This is connected to two output ports:

  1. Port 0 (output) for good records
  2. Port 1 (logs) for the bad records, using the Error Metadata.

The input records contain some embedded quotes (e.g. [“123”,“John ““Long John”” Silver”,“Pirate”] which cause a “Parsing error: Bad quote format” to appear in the Console output. However, no corresponding records are coming out of Port 1.

Am I doing something wrong or is that the expected behavior? I would really like to have the bad records be saved to a separate file for further processing.

2

Hi, I do not see a problem and Clover could properly parse the record. Attached you can find the graph that I used to replicate the problem.

3

Couldn’t run the graph - “Can’t read metadata definition file \n File test:meta/controlled.fmt does not exist”.

Could you attach the metadata file?