Skip to Content
author's profile photo Former Member
Former Member

FCC Record structure in Target Field

Hi all,

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

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

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 05, 2010 at 07:08 AM

    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.....

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 02, 2010 at 01:46 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.