Skip to Content
avatar image
Former Member

Sender Adapter - Content Conversion Key Field Query

Hi,

I have a flat file of the following structure I am attempting to convert to XML using a file sender adatper:

H1,H2,H3,H4

D1,D2,D3,D4,D5,D6

D1,D2,D3,D4,D5,D6

D1,D2,D3,D4,D5,D6

.

.

.

.

T1,T2,T3,T4

Within the Content Conversion tab I have a Recordset Structure of:

Header,1,Detail,*,Trailer,1

i.e one header record, multiple detail records and one trailer as per the above example.

It would seem that according to errors generated via Communication Channel Monitoring that this sort of Recordset Structure requires the Key Field Name to be set. I have searched around the forum and looked at the help.sap.com site and I'm struggling to understand what is required here.

Anyone help ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 09, 2011 at 02:00 PM

    >>It would seem that according to errors generated via Communication Channel Monitoring that this sort of Recordset Structure requires the Key Field Name to be set. I have searched around the forum and looked at the help.sap.com site and I'm struggling to understand what is required here.

    Yes you need to set key field value for your Header, Detail and Trailer

    Example:
    
    Header.keyFieldValue    H1
    Detail.keyFieldValue     D1
    Trailer.keyFieldValue   T1

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 09, 2011 at 01:27 PM

    yes. you will need a key field name to be set in your case, H1, D1 and T1

    Sample FCC refer:

    /people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

    Add comment
    10|10000 characters needed characters exceeded