xml to csv file

[Former Member]

I'm using a file to file scenario. In that case my output file is also xml.But i want to receive output file in csv format instead of xml.

The content of my output file is like this....

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

<ns0:outputmessage xmlns:ns0="urn:test:testrep">15</ns0:outputmessage></b>

I'm NFS as protocol

I don't know wat to write in FCC settings.

I've gone through weblogs but not found appropriate help or similar example as my output line contains only one element having attribute defined.

Please tell me the FCC settings and also what to write in record structure for this.

Regards,

Piyush

[Shabarish_Nair · Accepted solution]

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

<ns0:outputmessage xmlns:ns0="urn:test:testrep">15</ns0:outputmessage>

>>>>

you cannot write FCC for such a structure.

Maybe you can modify you DT, so that your output form something like;

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

<ns0:outputmessage xmlns:ns0="urn:test:testrep">

<root>

<value>15</value>

</root>

</ns0:outputmessage>

then you FCC becomes;

Recordset Structure: root

root.fieldSeparator 'nl'

root.endSeparator 'nl'

[Former Member]

HI,

Here is an example of how to convert content on the receiver side.

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

Regards,

Sudheer.

Message was edited by:

sudheer babu

[Former Member]

hi

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

if this blog does not help, you might develop Adapter Module Development. or you can use some coding in java proxy..

thanks

venjamin

null