Key field value in outbound/sender file adapter

[Former Member]

Hi,

I have a flat file coming in PI. The structre for the same is

1. Detail record line ocurs n number of time

2.Summary record line occurs only once at the end

I have defined a datatype as follows

<DT>

<Recordset>

<Detail>

All the detail fields

</Detail>

<Summary>

All the summary fields

</Summary>

</Recordset>

</DT>

Now the number of detail record is not know. But there is only one summary record.

In the sender file adapter do we need to configure the keyfield paramter? If the number of detail record is * .

The problem is the input file does not has any key field to parse/identify the detail or sumary record.

Any alternative?

Thanks

[former_member184619]

Hi Sachin,

The key field Specify the value of the key field for the structure. This entry is mandatory if the key field name is set. Otherwise, the entry is ignored.

check these blog:

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

Regards,

Sachin

[Former Member]

Hi,

We cannot ignore the key field when any of the substructure has * .

Its a mandatory paramter.

Sachin

[Former Member]

Hi Sachin,

Check out this blog..would be helpful..

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/482aae19-0301-0010-3485-8efd6188...

Let us know if you need more details.

Nilesh

[Former Member]

if u don't have any keyField value in the sender file,then don't mention it at all in the FCC parameters.

also have a look at the below blog,even he has unbounded structure and hez not using keyField parameter

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

Thanx

Aamir

[Former Member]

Hi ,

He has only one substrucutre... I have two substructure detail & Summary

Sachin

Message was edited by:

SACHIN KAGLIWAL

[Former Member]

hi ,

if you have two structures so do like this:

Recordset strucrure detail,summary*

detail.fieldFixedlength : 10,20

detail.fieldNames : xxx,yyy

summary.fieldFixedlength : 10,20

summary.fieldNames : www,vvv

rest configuration will be same.

hope this will help.

regards

HONEY