cancel
Showing results for 
Search instead for 
Did you mean: 

File Content Conversion (.txt to Xml)

Former Member
0 Kudos

Hi,

I am new to XI, can any one help me out for file content conversion on the following senario. what should be the

RecordSet

RecordStructure

Parameters

Sender File: .txt

sender file

========

1234,IT,Kannan,test,Ramasamy,33/A,test,Bangalore,Karnataka,India,12345,918012345,918012345,+918012345

Receiver File : XML

File:

===

<EmployeeDetails>

<Employee>

<E_No></E_No>

<E_Dept></E_Dept>

<E_Name>

<First_Name></First_Name> <Middle_Name></Middle_Name> <Last_Name></Last_Name>

</E_Name>

<E_Address> <Line1></Line1> <Line2></Line2> <City></City> <State></State> <Country></Country> <Pin></Pin>

</E_Address>

<E_Phone> <Direct></Direct> <Mobile></Mobile> <Home></Home>

</E_Phone>

</Employee>

</EmployeeDetails>

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

Use the following.

RecordSet: EmployeeDetails

RecordStructure: Employee,*

Employee.fieldNames:E_No,E_Dep and so on

Employee.fieldSeparator:,

Refer the bleow link:

http://help.sap.com/saphelp_nw04/helpdata/en/e3/94007075cae04f930cc4c034e411e1/frameset.htm

chirag

Former Member
0 Kudos

Hi,

Check this

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

Regards

Seshagiri

Former Member
0 Kudos

Hi,

this should be helpful:

/people/sap.user72/blog/2005/01/06/how-to-process-csv-data-with-xi-file-adapter

Regards

Patrick