Automatic quality check of received files

If received files are formally faulty, i.e.

• do not meet the format specification,

• have semantically necessary values (mandatory fields) missing,

• contain implausible values or value combinations,

their error-free processing is not possible.

The goal of the automation for this case is to recognise faulty input files in advance and separate them from the error-free files.

• The error-free files can be handled by the automatic processing.

• The defective files can either be sent back to the sender or be dealt with manually.

If the files additionally have a unique ID, you can also automatically send a confirmation to the sender that contains the IDs of the error-free files, the IDs of the incorrect files, and the exact description of the errors.

Automation of this check and feedback requires, however, that the specification of the file format is not too complex and not too extensive. It is ideal if the format specification itself contains rules on how to confirm the test.

These two requirements are fulfilled for input format X12 and therefore we have decided to develop a test concept for X12 input files.

For other file formats, there are so far no special concepts for a prior test. However, since error-free files are converted and sent to the target system and faulty files are displayed in the error overview of the Control Center, you already have an implicit check. In addition, specific data quality checks are possible in every profile.

• Definition of mandatory fields.

• Min/Max for the number of allowed repetitions of a node.

• Checks with functions.

In this case, however, it is not an automatic error handling. A decision of the operator is always necessary.