FCC Record structure in Target Field

[Former Member]

Hi all,

I have a sender Xml content(File) as follows:

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_Sender xmlns:ns0="http://azias.firmenich.com">

<Sender>

<Header>

<F1>H1</F1>

<F2>H2</F2>

</Header>

<Segment>

<P10>

<P1>P10a</P1>

<P2>P10b</P2>

</P10>

<P20>

<P3>P20a</P3>

<P4>P20b</P4>

</P20>

<P30>

<P5>P30a</P5>

<P6>P30b</P6>

</P30>

</Segment>

<Segment>

<P10>

<P1>P10c</P1>

<P2>P10d</P2>

</P10>

<P30>

<P5>P30c</P5>

<P6>P30d</P6>

</P30>

</Segment>

<Trailer>

<T1>T1</T1>

<T2>T2</T2>

</Trailer>

</Sender>

</ns0:MT_Sender>

Now i am sending this data through a file adapter and target structre is a CSV file.

So in FCC parameter of Target Communication Channel how i should define record structure and FCC parameters?

[Former Member · Accepted solution]

In the content conversion parameters, you need to provide the details :

I see that Segment node is repeated more than once in your structure..

Documentname: (Message type)

Document Namespace: (Namespace)

Recordset structure: Sender,1,Header,1,Segment,*,Trailer,1

Recordset Sequence: Ascending/Decending (as per requirement)

You also have some additional parameter,

1. If you would like to fix the length of the field, you can use the

name.fieldFixedLangths

2. If you would like to differentiate the fields, you can use

name.endSeparator

3. For field separator, use

name.fieldSeperator

The below weblink will help to know the additional parameters.

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

I hope this will help you.....

[Former Member · Accepted solution]

Hi Hareen,

Mentioned below parameters are not required since he is using FCC at receiver side

Documentname: (Message type)

Document Namespace: (Namespace)

Recordset structure: Sender,1,Header,1,Segment,*,Trailer,1

Recordset Sequence: Ascending/Decending (as per requirement)

Regards,

Abid

[Former Member · Accepted solution]

Hi all,

Thanks for Your Reply.Finallly I have got the solution for it.

The Record Structure is:

Sender,Header,Segment,P10,P20,P30,Trailer

Segment.FieldNames:P10,P20,P30

P10.FieldNames:P1,P2

P20.fieldNames:P3,P4

P30.fieldNames:P5.P6

Rest of the parameters are the same mentioned by Abid.

Thanks ,

Yeshwanth

[Former Member · Accepted solution]

Hi all,

Closing the thread.

Thanks ,

Yeshwanth

Edited by: Yeshwanth R on Jul 6, 2010 12:43 PM

[Former Member]

Hi,

It should be like this:

RecordSet Structure: Sender,1,Header,1,Segment,*,Trailer,1

Sender.fieldSeparator: ,

Sender.endSeparator: 'nl'

Header.fieldSeparator: ,

Header.endSeparator: 'nl'

Segment.fieldSeparator: ,

Segment.endSeparator: 'nl'

Trailer.fieldSeparator: ,

Trailer.endSeparator: u2018nlu2019

Hope it helps you

For more refer:

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

Regards,

Abid