Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    May 12, 2006 at 01:23 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 12, 2006 at 08:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded