File to File Scenario

[Former Member]

Hi Experts,

My scenario is File to file.

TEST DATA:

H12345kk 1100211002WholesaleCoInc

L123450001C5686000000 0001CSE.

L123450002C5688000000 0001CSE.

H98765OR 7284272842WM Wall n Son L987650001C5686000000 0001CSE.

L987650002C5688000000 0001CSE.

I have defined the structure as

DT_orders

Header 1-1

Item 1-N

At the receiver i am getting

H12345kk 1100211002WholesaleCoInc

L123450001C5686000000 0001CSE.

L123450002C5688000000 0001CSE.

The file is picking multiple header as well as multiple line items but at the receiver its only giving single header with multiple line items . Can you please suggest me where i am going wrong.

Regards

Santosh

[former_member187339 · Accepted solution]

Hi Santosh,

1. Paste the XML structure which you are getting in SXMB_MONI (after the File content conversion). I feel there is a problem in this XML structure itself

2. Is your target structure as shown below?

DT_orders

Header 1-1

Item 1-N

if yes then it shodul be modified as

DT_orders

-Details 1..N

---Header 1-1

---Item 1-N

Regards

Suraj

[Former Member]

Answered.

[Former Member]

As per your incoming data you have to modify your current data type. As suggested above add the root node with occurrence 0...unbound

After doing the change in IR, modify your FCC accordingly.

[Former Member]

Hi SoumenDas/S.R.Suraj/Venkataramesh/Sarvesh Singh

Thanks for the quick response . I am able to fix the issue and changed the FCC details to Header,* and the scenariio is working fine. Points awarded.

Regards

Santosh

[Former Member]

Post deleted...

[Former Member]

Hi Santosh,

> I have defined the structure as

> DT_orders

> Header 1-1

> Item 1-N

For single occurance it is ok, but in this case you need multiple occurances, so change the structure like this.

DT_Orders

orders_recordset 1..unbound

..Header 1.1

..Item 1..n

Then your structure repeat multiple times.

After done this changes finally do the changes in the communication channel (Content parameters).

> At the receiver i am getting

> H12345kk 1100211002WholesaleCoInc

> L123450001C5686000000 0001CSE.

> L123450002C5688000000 0001CSE.

If you use the above structure then you will get the output like

>H12345kk 1100211002WholesaleCoInc

>L123450001C5686000000 0001CSE.

>L123450002C5688000000 0001CSE.

>H98765OR 7284272842WM Wall n Son L987650001C5686000000 0001CSE.

>L987650002C5688000000 0001CSE.

Regards

Ramesh

[Former Member]

I have defined the structure as
DT_orders
Header 1-1
Item 1-N

Use a root node...

Make it this way and it will run fine :

DT_orders

..Orders 1...n

....Header 1-1

....Item 1-n