FCC to Proxy issue

[Former Member]

Hi Gurus,

From source i m getting data as below (H,M,N,N,N,M,N,N,N)

379500280 10 H 611 1 01/08/2012 01/08/2012 12:25:34

379500280 10 M 1 1 1 89692899 89692899 261390

379500280 10 N 1 50 r7310078

379500280 10 N 1 51 1

379500280 10 N 1 53 118532261

379500280 10 M 2 1 1 86419192 86419192 238036

379500280 10 N 2 50 r7310079

379500280 10 N 2 51 1

379500280 10 N 2 53 118532261

I want to sort it out in the below format (H,M,M, N,N,N,N,N,N)

379500280 10 H 611 1 01/08/2012 01/08/2012 12:25:34

379500280 10 M 1 1 1 89692899 89692899 261390

379500280 10 M 2 1 1 86419192 86419192 238036

379500280 10 N 1 50 r7310078

379500280 10 N 1 51 1

379500280 10 N 1 53 118532261

379500280 10 N 2 50 r7310079

379500280 10 N 2 51 1

379500280 10 N 2 53 118532261

SENDER CC

RECORE SET NAME -

---

Order_Row

RECORD SET STRUCTURE -

---

Header,1,Merchandise,* ,Line_Note, *

KEY FIELD NAME -

---

RECORD_TYPE

Header.keyFieldValue H

Header.fieldSeparator '0x09'

Header.fieldSeparator IF_ENTRY_NO,INTERFACE_CONTROL_FLAG,RECORD_TYPE,STORE_NO,........

Header.endSeparator 'nl'

Merchandise.keyFieldValue M

Merchandise.fieldSeparator '0x09'

Merchandise.fieldSeparator I F_ENTRY_NO,INTERFACE_CONTROL_FLAG,RECORD_TYPE,STORE_NO,........

Merchandise.endSeparator 'nl'

Line_Note.keyFieldValue N

Line_Note.fieldSeparator '0x09'

Line_Note.fieldSeparator IF_ENTRY_NO,INTERFACE_CONTROL_FLAG,RECORD_TYPE,STORE_NO,........

Line_Note.endSeparator 'nl'

But still i am getting

<order-row>

H

M

N

N

N

</Order_row>

<order-row>

M

N

N

N

</Order_row>

But i need in the below format

<Order_row>

H

M

M

N

N

N

N

N

N

</Order-row>

Please help me to sort it out

Thanks & Regards,

Tanuja

[former_member184681 · Accepted solution]

Hi,

In the Message Type & Data Type for your sender Service Interface, define the input structure like that:

Order_Row
    Header            occurrence: 1..1
        field 1
        ...
    Merchandise   occurrence: 1..unbounded
        ...
    Line_Note        occurrence: 1..unbounded
        ...

Hope this helps,

Greg

[Former Member]

Thanks for your response.

Issue solved

I changed in communication channael

RECORD SET STRUCTURE -

---

Header,1,Merchandise,* ,Line_Note, * ,Merchandise,,Line_Note,

SEQUENCE --- variable

[Former Member]

With FCC this is not possible. FCC always will create the structure of your message like it is defined in your configuration. As your control values and key values indicate, you will receive this result:

<order-row>
H
M
N
N
N
</Order_row>
<order-row>
M
N
N
N
</Order_row>

You will need an XSLT or an Message Mapping to get your segments into the right order. Within the Operation Mapping you select the the first (sorting) mapping and then the mapping you wanted to create.

As you need a 1:1 relationship between your segments the message mapping would look quite easy:

[Header; context above order-row] -> [H]
[Merchandise; context above order-row] -> [Ms]
[Line Notes; context above order-row] -> [Ns]
 

[Former Member]

Could anyone reply to this post . Thanks!

[Former Member]

still facing the same problem Greg

[Former Member]

Hi Greg,

Thanks for your reply. I m also using the same data type and message type.

[former_member184681]

And how about the occurence of Order_Row? I did not mention it earlier, but it should also be set to 1..1.