on 01-07-2010 11:10 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Answered.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.