Thanks was able to achieve it like below :
if(i_book == (inputcatalog.book.length-1))
{
outputroot[count_i_book+1] = {};
outputroot[count_i_book+1].description1 = "Number of Records :" +
count_i_book + ", " + "TotalPrice : " + Math.round(TotalPrice * 100) / 100;
}
With Regards,
Aditya
On Wed, Feb 21, 2018 at 5:45 PM, aditya shivankar <
[email protected]> wrote:
> Thanks that works....
>
> Could we also generate metadata in footer like below.
>
> *"total Price : 50.9" *
>
> which is addition of price details in above two records
>
>
> Expected output :
> -------------------------------------------
> author,id,title,genre,price,publish_date,description
> Gambardella Matthew,bk101,XML Developer's Guide,Computer,44.95,10/1/
> 2000,Epic1
> Ralls Kim,bk102,Midnight Rain,Fantasy,5.95,12/16/2000,Epic2
>
> *total Price = 50.9*
> ---------------------------------------------
>
> which is addition of price details in above two records.
> Please guide
>
> Thanks and Regards,
> Aditya
>
> On Wed, Feb 21, 2018 at 3:42 PM, Prabushi Samarakoon <[email protected]>
> wrote:
>
>> Hi Aditya,
>>
>> By default WSO2 Developer Studio generates the mapping javascript
>> function only to map input data to output data. Therefore, csv headers will
>> not be included in the mapping function. To retrieve csv headers at the
>> output, you can change the mapping function at xmlToCsv1.dmc file as
>> follows. Required headers were added as the first object of outputroot
>> array.
>>
>>
>> map_S_catalog_S_root = function(){
>> var outputroot={};
>>
>> var count_i_book = 1;
>> outputroot = [];
>>
>> outputroot[0] = {};
>> outputroot[0].Author = 'author';
>> outputroot[0].id = 'id';
>> outputroot[0].title = 'title';
>> outputroot[0].genre = 'genre';
>> outputroot[0].price = 'price';
>> outputroot[0].publish_date = 'publish_date';
>> outputroot[0].description = 'description';
>>
>> for(i_book in inputcatalog.book){
>> outputroot[count_i_book] = {};
>> outputroot[count_i_book].Author = inputcatalog.book[i_book].author;
>> outputroot[count_i_book].id = inputcatalog.book[i_book].attr_id;
>> outputroot[count_i_book].title = inputcatalog.book[i_book].title;
>> outputroot[count_i_book].genre = inputcatalog.book[i_book].genre;
>> outputroot[count_i_book].price = inputcatalog.book[i_book].price;
>> outputroot[count_i_book].publish_date = inputcatalog.book[i_book].publ
>> ish_date;
>> outputroot[count_i_book].description = inputcatalog.book[i_book].desc
>> ription;
>>
>> count_i_book++;
>> }
>> return outputroot;
>> };
>>
>>
>> Thanks,
>> Prabushi
>>
>> On Wed, Feb 21, 2018 at 2:53 PM, aditya shivankar <
>> [email protected]> wrote:
>>
>>> Hi Sir,
>>>
>>> My issue is first line in Expected Output which contains the keys(column
>>> headers):
>>> "author,id,title,genre,price,publish_date,description"
>>>
>>> is missing in current output file.
>>>
>>> Please guide.
>>>
>>> With Regards,
>>> Aditya
>>>
>>> On Wed, Feb 21, 2018 at 2:15 PM, aditya shivankar <
>>> [email protected]> wrote:
>>>
>>>> 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-0
>>>> 1,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:subst
>>>> ring-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">f
>>>> ile:///C:/Flatfile/input</parameter>
>>>> <parameter name="transport.vfs.ContentTyp
>>>> e">application/xml</parameter>
>>>> <parameter name="transport.vfs.ActionAfterProcess">MOVE</parameter>
>>>> <parameter name="transport.vfs.MoveAfterF
>>>> ailure">file:///C:/Flatfile/failure</parameter>
>>>> <parameter name="transport.vfs.ActionAfterFailure">MOVE</parameter>
>>>> <parameter name="transport.vfs.FileNamePattern">.*\.xml</parameter>
>>>> <parameter name="transport.vfs.MoveAfterP
>>>> rocess">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
>>>
>>>
>>
>>
>> --
>> *Prabushi Samarakoon*
>> Software Engineer
>> Mobile: +94715434580
>> Email: [email protected]
>>
>
>
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
