CODEWITHSUNDEEP
javascriptjquery
Rajasekhar
Rajasekhar

Reputation: 2455

Converting table data to the xml structure format?

I stuck with xml string preparation. Basically I have one table, contains some rows. If I click on submit we need to show the xml formated string like below 

<OrderSummaryIDs>
<Count>2</Count>
<Row>
    <StartDate>08/01/2015</StartDate>
    <EndDate>12/01/2015</EndDate>
    <remark/>Test1</remark>
</Row>
</OrderSummaryIDs>

I tried with below code, it doesnt return xml structure format,

Here is my code 

var xmlStart =  "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\"?>";
var xml = xmlStart;
var xmlFirstRowSet = "<OrderSummaryIDs>";
var xmlLast="</OrderSummaryIDs>";

xmlFirstRowSet = xmlFirstRowSet;
var headerRowSet='';
var bodyRowSet ='';

var elements = $(".mutliple tr");
var size = elements.size();
    bodyRowSet = bodyRowSet + "<Count>" + size + "</Count>";

bodyRowSet = bodyRowSet + "<Row>";   
elements.each(function() {    
        var tdValue1 = $td.closest('table').find('td:first-child').html();        
        bodyRowSet = bodyRowSet + "<StartDate>";          
        bodyRowSet = bodyRowSet +  tdValue1;
        bodyRowSet = bodyRowSet + "</StartDate>";

        /*var tdValue2 = $td.closest('table').find('td:eq(1)').html();
        bodyRowSet = bodyRowSet + "<EndDate>";          
        bodyRowSet = bodyRowSet +  tdValue2;
        bodyRowSet = bodyRowSet + "</EndDate>";

        var tdValue3 = $td.closest('table').find('td:last-child').html();
        bodyRowSet = bodyRowSet + "<remark>";          
        bodyRowSet = bodyRowSet +  tdValue3;
        bodyRowSet = bodyRowSet + "</remark>";*/
});

bodyRowSet = bodyRowSet + "</Row>";
    xml = xmlStart + xmlFirstRowSet + bodyRowSet+xmlLast;
alert(xml);

Fiddle

Upvotes: 0

Views: 27

Answers (1)

Vegeta
Vegeta

Reputation: 1317

Try this:

var elements = $(".mutliple tr");
var xml =  "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\"?>";
xml += '<OrderSummaryIDs><Count>' + elements.length + '</Count>';
elements.each(function() {    
    var tdValue1 = $(this).find('td:first-child').html();        
    xml += "<row><StartDate>" + tdValue1 + "</StartDate>";
    //
    //
    //
    xml += '</row>';
}
xml += '</OrderSummaryIDs>';
alert(xml);

Upvotes: 1

Related Questions