File-Sender: Verification of file content during file content conversion

[Former Member]

Hello,

I have a question regarding „file verification“ when using the file-sender adapter.

I got a flat file (.csv) that I convert into XML with the file-sender adapter and file-content-conversion.

In the file there is a column “RecTyp” that is my KeyFieldValue. Possible values for RecTyp are “B”, “D”, “U”, “T”.

So far so good. All this works perfectly.

If (due to an error) there is another value in RecTyp than the 4 mentioned above (B;D;U;T) the file adapter ignores this row today. And here begins my issue:

I want to change this behavior. That means in detail, I want to check if there is another value in my KeyFieldValue “RecTyp” than specified. If this is the case an exception should be thrown. The whole message should not be delivered.

We had the idea to use the module-processor for this verification….

But may be there are other suggestions. Or may be some one can provide an appropriate module that is already written, etc….

Does anyone have an idea?

Kind regards,

Tobias

[moorthy]

Hi,

It is better to pick the file in generic way i.e Row by Row and then go with the validation with the help of Adapter Modules or in the Mapping.

For more-

/people/sravya.talanki2/blog/2005/08/16/configuring-generic-sender-file-cc-adapter

Thanks,

Moorthy

[Former Member]

Hi Tobias,

In file adapter if you don't have a record by these key fields then it gives an error but it does not give an error if there are additional records.

We had the same issue and we picked up the data row by row and checked in the module.

Regards

Vijaya