how to convert xml file into csv file in javascript -
<?xml version="1.0" encoding="utf-8"?> <current>    <city id="1259229" name="pune">       <coord lon="73.86" lat="18.52" />       <country>in</country>       <sun rise="2016-01-07t01:38:29" set="2016-01-07t12:42:53" />    </city>    <temperature value="27.49" min="27.49" max="27.49" unit="metric" />    <humidity value="43" unit="%" />    <pressure value="955.13" unit="hpa" />    <wind>       <speed value="2.65" name="light breeze" />       <gusts />       <direction value="113.502" code="ese" name="east-southeast" />    </wind>    <clouds value="36" name="scattered clouds" />    <visibility />    <precipitation mode="no" />    <weather number="802" value="scattered clouds" icon="03d" />    <lastupdate value="2016-01-07t06:25:45" /> </current>   i trying convert xml csv have tried thing not getting logic convert data csv format
       try {             var file : file = new file(dw.io.file.impex + '/src/weather.csv');             var filewriter : filewriter = new filewriter(file, 'utf-8');             var csw : csvstreamwriter = new csvstreamwriter(filewriter);             csw.writenext(//here want array of string data );             csw.writeenddocument();             csw.close();             filewriter.close();         }         catch(e) {             return pipelet_error;         }   but don't know how can convert xml data strings of array
as you're using server-side javascript, demandwarescript, check xmlstreamreader class , e4x syntax. https://en.m.wikipedia.org/wiki/ecmascript_for_xml e4x ecmascript xml, proprietary syntax used xml dom access in demandware. need 1 more file object reading xml file.
also xml file not "flat", need define xml elements go in csv.
Comments
Post a Comment