Skip to Content
avatar image
Former Member

xml to csv file

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Nov 22, 2006 at 05:00 AM

    <?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'

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 22, 2006 at 04:56 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 22, 2006 at 05:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded