anil bolishetty

anil bolishetty

  • NA
  • 2
  • 3.3k

extract data from xml dataset table format different

Feb 4 2013 8:25 AM
Report reportTimeStamp="2013-02-02T15:25:32.827+05:30"><HeaderData/>-<ReportData>-<ColumnHeaders><ColumnHeader localizedName="Order" name="orderName"/><ColumnHeader localizedName="Order ID" name="orderId"/><ColumnHeader localizedName="Trafficker" name="orderTrafficker"/><ColumnHeader localizedName="Order start date" name="orderStartDate"/><ColumnHeader localizedName="Order end date" name="orderEndDate"/><ColumnHeader localizedName="Ad server impressions" name="reservationImpressionsDelivered"/><ColumnHeader localizedName="Ad server CTR" name="reservationCtrDelivered"/><ColumnHeader localizedName="Ad server clicks" name="reservationClicksDelivered"/><ColumnHeader localizedName="Ad server average eCPM" name="reservationEcpmDelivered"/><ColumnHeader localizedName="Ad server CPM and CPC revenue" name="reservationPubCostDelivered"/></ColumnHeaders>-<DataSet>-<Row rowNum="1">+<Column name="orderName">-<Column name="orderId"><Val>126204860</Val></Column>-<Column name="orderTrafficker"><Val>Srikanth Gudipudi ([email protected])</Val></Column>-<Column name="orderStartDate"><Val>2012-12-31T16:03:00+05:30</Val></Column>-<Column name="orderEndDate"><Val>2013-01-31T23:59:00+05:30</Val></Column>-<Column name="reservationImpressionsDelivered"><Val>1,850</Val></Column>-<Column name="reservationCtrDelivered"><Val>0.00%</Val></Column>-<Column name="reservationClicksDelivered"><Val>0</Val></Column>-<Column name="reservationEcpmDelivered"><Val>Rs.250.00</Val></Column>-<Column name="reservationPubCostDelivered"><Val>Rs.462.50</Val></Column></Row>-<Total rowNum="2">-<Column name="orderName"><Val>1</Val></Column>-<Column name="orderId"><Val>1</Val></Column>-<Column name="orderTrafficker"><Val/></Column>-<Column name="orderStartDate"><Val/></Column>-<Column name="orderEndDate"><Val/></Column>-<Column name="reservationImpressionsDelivered"><Val>1,850</Val></Column>-<Column name="reservationCtrDelivered"><Val>0.00%</Val></Column>-<Column name="reservationClicksDelivered"><Val>0</Val></Column>-<Column name="reservationEcpmDelivered"><Val>Rs.250.00</Val></Column>-<Column name="reservationPubCostDelivered"><Val>Rs.462.50</Val></Column></Total></DataSet></ReportData></Report>