Originally posted by: Zaiduddin

Hi All,

I need a help here. I have a requirement wherein all error of input file to be reported at a single time.

Let me quote a example here.

Suppose I have an input type tree with 10 fields and field no 3 is defined as numeric, field 5 as date, Field 8 is defined with value include restriction list.

Now if my input file has field 3 as alphanumeric, field 5 as incorrect date format, and field 8 has value which is not in restriction list. For such input the map will surely fail but I need to report all three errors in a single file to customer and does not want to go back to customer for each error multiple times.

Do let me know if any additional information is needed.

Thanks

Originally posted by: PaulBrett

You would need to implement your input Typetree very loosely, then define your input validation criteria as output rules.  For each test your would increment a failure counter by 1 if there was a failure, as well as appending the details to an error report.  Finally you would FAIL() the map, if the failure counter >0.

Thank you.

Paul

Follow me on Twitter

Originally posted by: Laurent(Satisco)

Hi,

except when the data is "too wrong" (when a record isn't recognized as a record), Data Audit is your friend there.

It would not tell your customer field X is a string when a numeric but that the field has a presentation issue.

For other errors (size, restriction list, missing mandatory component) it would tell them all they need to know.

Originally posted by: Laurent(Satisco)

I had a few minutes to kill in the train, the attached sample shows what I mean with a dummy type tree and some data.

In this case, the key is "identificability", which is why I've put a specific record type at the beginning of the record, with some limited values in a component rule, and and identifier attribute.

Without this, the data audit may be unable to report details on errors.

(note the sample was developped in 9002)

Attachment(s)

DemoDataAudit.zip   2 KB 1 version