Hi Sir,
I am using Datamapper for transformation of input request(xml) to output
format(csv) . But in the output format(csv) the column headers are missing
. Please guide how to generate those in output file.
Sample Input :
<?xml version="1.0"?>
<catalog>
<book id="bk101">
<author>Gambardella Matthew</author>
<title>XML Developer's Guide</title>
<genre>Computer</genre>
<price>44.95</price>
<publish_date>2000-10-01</publish_date>
<description>Epic1</description>
</book>
<book id="bk102">
<author>Ralls Kim</author>
<title>Midnight Rain</title>
<genre>Fantasy</genre>
<price>5.95</price>
<publish_date>2000-12-16</publish_date>
<description>Epic2</description>
</book>
</catalog>
Expected Output :
author,id,title,genre,price,publish_date,description
Gambardella Matthew,bk101,XML Developer's
Guide,Computer,44.95,2000-10-01,Epic1
Ralls Kim,bk102,Midnight Rain,Fantasy,5.95,2000-12-16,Epic2
Current Output :
Gambardella, Matthew,bk101,XML Developer's
Guide,Computer,44.95,2000-10-01,Epic1
Ralls, Kim,bk102,Midnight Rain,Fantasy,5.95,2000-12-16,Epic2
proxy service :
<?xml version="1.0" encoding="UTF-8"?>
<proxy name="StockQuoteProxy" startOnLoad="true" transports="vfs" xmlns="
http://ws.apache.org/ns/synapse";>
<target>
<inSequence>
<log level="full">
<property name="property_name" value="Read from file
-----------------------"/>
</log>
<datamapper config="gov:datamapper/xmlToCsv1.dmc"
inputSchema="gov:datamapper/xmlToCsv1_inputSchema.json" inputType="XML"
outputSchema="gov:datamapper/xmlToCsv1_outputSchema.json" outputType="CSV"/>
<log level="full">
<property name="property_name" value="after enrich
-----------------------"/>
</log>
<property
expression="fn:concat(fn:substring-after(get-property('MessageID'),
'urn:uuid:'), '.csv')" name="transport.vfs.ReplyFileName" scope="transport"
type="STRING"/>
<property name="OUT_ONLY" scope="default" type="STRING"
value="true"/>
<property name="messageType" scope="axis2" type="STRING"
value="application/csv"/>
<send>
<endpoint>
<address uri="vfs:file:///C:/Flatfile/output"/>
</endpoint>
</send>
</inSequence>
<outSequence/>
<faultSequence/>
</target>
<parameter name="transport.PollInterval">15</parameter>
<parameter
name="transport.vfs.FileURI">file:///C:/Flatfile/input</parameter>
<parameter name="transport.vfs.ContentType">application/xml</parameter>
<parameter name="transport.vfs.ActionAfterProcess">MOVE</parameter>
<parameter
name="transport.vfs.MoveAfterFailure">file:///C:/Flatfile/failure</parameter>
<parameter name="transport.vfs.ActionAfterFailure">MOVE</parameter>
<parameter name="transport.vfs.FileNamePattern">.*\.xml</parameter>
<parameter
name="transport.vfs.MoveAfterProcess">file:///C:/Flatfile/orgFilesProcessedSuccessfully</parameter>
</proxy>
Please find attachments for datamapper.
Please guide.
Thanks and Regards,
Aditya
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
