jxycms
2/2/2017 - 11:17 PM

read the xml file in javascript

read the xml file in javascript

function readXmlOffice(xmlFile, state, interest) {

    var xmlDoc;
    var xmlOfficeID;
    if (typeof window.DOMParser != "undefined") {
        xmlhttp = new XMLHttpRequest();
        xmlhttp.open("GET", xmlFile, false);
        if (xmlhttp.overrideMimeType) {
            xmlhttp.overrideMimeType('text/xml');
        }
        xmlhttp.send();
        xmlDoc = xmlhttp.responseXML;
    }
    else {
        xmlDoc = new ActiveXObject("Microsoft.XMLDOM");
        xmlDoc.async = "false";
        xmlDoc.load(xmlFile);
    }
    var tagObj = xmlDoc.getElementsByTagName("Table");
    for (var i = 0; i < tagObj.length; i++) {
        if (tagObj[i].getElementsByTagName("state")[0].childNodes[0].nodeValue == state && tagObj[i].getElementsByTagName("interest")[0].childNodes[0].nodeValue == interest) {
            xmlOfficeID = tagObj[i].getElementsByTagName("DefaultOffice")[0].childNodes[0].nodeValue;
        }
    }
    return xmlOfficeID;
}

and xml:

-<Table> 
<ItemID>1</ItemID> 
<ItemCreatedBy>53</ItemCreatedBy> 
<ItemCreatedWhen>2017-01-27T09:53:33+11:00</ItemCreatedWhen> 
<ItemModifiedBy>53</ItemModifiedBy> 
<ItemModifiedWhen>2017-02-02T21:42:21+11:00</ItemModifiedWhen> 
<ItemOrder>4</ItemOrder> 
<ItemGUID>ad296c0c-98eb-4404-b8e1-800b3061fa73</ItemGUID> 
<State>New South Wales</State> 
<Interest>Nursing positions</Interest> 
<Email>sam.kelly@nswbc.com.au</Email> 
<DefaultOffice>1</DefaultOffice> 
</Table>