Skip to Content
0
Former Member
Feb 23, 2007 at 12:23 PM

File content conversion

12 Views

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