cancel
Showing results for 
Search instead for 
Did you mean: 

sender file content conversion problem

Former Member
0 Kudos

hi Masters,

I have sender side structure like this...below..

emp_row unbounded.

empid

name

city

country.

actually i had given few id with names and other details which i stored in txt file .

like

001, ram, newyork, usa.

002 ,john,london,uk.

003, smit,tokyo,japan.

but if i see in reciever side then i wil get xml file where only 001,ram,newyork,usa. is mentioned ... and remaining records are not there..

wht is the fault and how to rectify tht fault please help me ..

Thanks in Advance ,

jp.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

recordset structure -- emp_row

emp_row.fieldSeparator - ','

emp_row.endSeparator - 'nl'

if you have "." at the end of each record in your file then remove it and change it to new line -- "nl" -- by hitting the enter key on your keyborad at the end of each record Or if you want to use "." only then replace 'nl' in the above endSeparator parameter list with '.'

PS: Share u r current content conversion parameter settings also

Cheer's

Former Member
0 Kudos

also share the XML structure which you get after the mapping step from SXMB_MONI

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

check out your Receiver file adapter has the following credentials,

Recordset name = emp_row

Recordset structure = emp_row,*

emp_row.fieldSeparator = ,

emp_row.endSeparator = 'nl'

Regards,

yuva

Former Member
0 Kudos

For sender content conversion mention recordset structure as emp_row,*

so that it take multiple records