on 02-23-2007 12:23 PM
Hi all,
I am doing file to file with content conversion. file (note pad) to File (xml)
this is my file(note pad)
1London20.04.2004
2DAR 11000000123456,0012345678901111SalesAcc
2WECHS 13000000123456,0012345678901111Collection
300000000001234565432,2200000000001234565432,33
here 1,2 and 3 are key fields. 1 and 3 are one time and 2 is for unbound.
The out put what i am getting is
-
<?xml version="1.0" encoding="UTF-8" ?>
- <ns0:convrecv_mt xmlns:ns0="URI:TEST/1">
- <recv>
- <header>
<h_fld1>London</h_fld1>
<h_fld2>20.04.2004</h_fld2>
</header>
- <body>
<b_fld1>DAR</b_fld1>
<b_fld2>1100</b_fld2>
<b_fld3>0000123456,00</b_fld3>
<b_fld4>1234567890</b_fld4>
<b_fld5>1111</b_fld5>
<b_fld6>SalesAcc</b_fld6>
</body>
- <footer>
<f_fld1>00000000001234565432,22</f_fld1>
<f_fld2>00000000001234565432,33</f_fld2>
</footer>
</recv>
</ns0:convrecv_mt>
-
but the out put should contain these also..
2WECHS 13000000123456,0012345678901111Collection
Like ........
<?xml version="1.0" encoding="UTF-8" ?>
- <ns0:convrecv_mt xmlns:ns0="URI:TEST/1">
- <recv>
- <header>
<h_fld1>London</h_fld1>
<h_fld2>20.04.2004</h_fld2>
</header>
- <body>
<b_fld1>DAR</b_fld1>
<b_fld2>1100</b_fld2>
<b_fld3>0000123456,00</b_fld3>
<b_fld4>1234567890</b_fld4>
<b_fld5>1111</b_fld5>
<b_fld6>SalesAcc</b_fld6>
</body>
- <body>
<b_fld1>WECHS</b_fld1>
<b_fld2>1300</b_fld2>
<b_fld3>0000123456,00</b_fld3>
<b_fld4>1234567890</b_fld4>
<b_fld5>1111</b_fld5>
<b_fld6>Collection</b_fld6>
</body>
- <footer>
<f_fld1>00000000001234565432,22</f_fld1>
<f_fld2>00000000001234565432,33</f_fld2>
</footer>
</recv>
</ns0:convrecv_mt>
I think the error is in data types where in occurence.
My data type what i have given is..
occurence
convsend_dt
record 1
header 1
ky 1
city 1
date 1
body 1..unbound
ky 1
product 1
contract 1
total 1
GP tot 1
GPaADvtot 1
Description 1
footer 1
ky 1
sum1 1
sum2 1
regards
manoj
Hi Manoj,
If your problem has been resolved, kindly mark this thread as answered and award SDN points.
Regards
Pushkar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Manoj,
in your sender comm channel you should write like
Recordset Structure = header,1,body,*,footer,1
It will work..:)
regards
pushkar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.