Need to be XML file to CSV file through XI

[Former Member]

Hi Team,

i have recently started XI , i have done the file to file scenario . But i have a requirement like as follows:

XML file is a source structure and converted into CSV file target structure.

I have done the mapping it running fine.

What is require setting in integration directory to convert XML file into CSV. Could you please suggest me in details.

Thanks.

Puneet.

[Former Member · Accepted solution]

Specify row.addHeaderLine - 3

refer

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

[Former Member]

Hi team,

Thanks for given me solutions :

i have doubt regarding Header(Field Name) in CSV file.

`i have make it structure lilke as follows:

<?xml version="1.0" encoding="UTF-8"?>

<ns0:mt_emp_in xmlns:ns0="urn:
a119352_xml_to_csv.com">

<record>

<row>

<emp_number>2528</emp_number>

<full_name>puneet ji pokharna</full_name>

<net_salary>2579</net_salary>

<role>Team Lead</role>

</row>

</record>

</ns0:mt_emp_in>

and also i have done the reciver side setting like as follows:

Recordset Structure* record,row

row.fieldSeparator ,

record.headerLine emp_number,full_name,net_salary,role

record.fieldSeparator 'nl'

row.addHeaderLine 1

row.endSeparator 'nl'

ignoreRecordsetName 'true'

but didn't come header in csv file could you please suggest me how retrive the header.Is there any way to retrive Header into CSV file.

Thanks in Advance.

Puneet.

[Former Member]

Hi,

i have tried out but it's not working . i think i am going wrong setting in receiver end.

My XML file ( Source side) is as follows:

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MT_emp_det xmlns:ns0="URN:
employeedetail.com">

<Employee_number>2528</Employee_number>

<First_Name>Puneet</First_Name>

<Middle_Name />

<Last_Name>Pokharna</Last_Name>

- <Salary>

<Basic>2000</Basic>

<HRA>1000</HRA>

<LTA>2000</LTA>

<Tax>1000</Tax>

</Salary>

<Grade>2</Grade>

</ns0:MT_emp_det>

Could you please suggest me what parameter i have to use in "Content Conversion Parameter".Which is convert into CSV file.

Thanks in Advance.

Puneet.

[former_member192295]

HI,

Follow below configuration it will work

Target file name give any name with extension .CSV

Recordset Structure rec,*

rec.fieldNames Employee_number,First_Name, Middle_Name, Last_Name, Basic, HRA, LTA, Tax

rec.fieldFixedLengths X,X,X,X,X,X,X,X

rec.endSeparator 'nl'

ignoreRecordsetName 'true'

[Former Member]

Hello,

Use Message Protocol as "File Content Conversion" at the receiver end.

As you need to generate the CSV file, Use following properties :

RecordSet Structure : Your Rool XML tag name , Let say "Root"

than define

Root.fieldSeperator

Root.fieldNames

Root.endSeparator

This will create CSV file.

Thanks & Regards,

Dijesh Tanna.

[former_member192295]

HI,

No specific setting for CSV format in ID. Select File Content Conversion protocol in receiver file channel and configure according to your requirement, it will work.

For more information on FCC find below link

http://help.sap.com/saphelp_nw70/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

[former_member183906]

Pls refer below links-

Receiver FCC no need of Endseparator

Receiver-

[Former Member]

Hi,

Check these on How to Covert the XMl File into CSV File using File Content Conversion

Regards

Seshagiri

[Former Member]

hi,

Regards,

Jayasimha Jangam