XML not working - can't see what's wrong

Gilbert · October 15, 2017

I copied and pasted a file from the w3 tutorial XML/AJAX application but changed just a couple of spots so it could read my own XML data file. It doesn't work - what am I missing, please. When I open the console in either google or IE it says xmlDoc is null or undefined - somehow I'm not 'reading' the file or something? can anybody explain it more. I've read over the toturials a couple of times and I think it should be working. I have also cleaned out the cach in the browser by hitting cntrl F5, which I learned from someone along the way.

		<!DOCTYPE html>
	
		<html>
	
		<head>
	
		    <meta charset="utf-8">
	
		    <title>S.C. Information</title>
	
		    <style>
	
		    table, th, td {
	
		       border: 1px solid green; 
	
		       border-collapse:collapse;
	
		    }
	
		    th, td {
	
		      padding: 5px; 
	
		    }
	
		    </style>
	
		</head>
	
		<body>
	
		    <button type="button" onclick="loadXMLDoc()">Get my S.C. Report</button>
	
		    <br><br>
	
		    <table id="demo"></table>
	
		    <script>
	
		        function loadXMLDoc() {
	
		            var xmlhttp = new XMLHttpRequest();
	
		            xmlhttp.onreadystatechange = function() {
	
		            if (this.readyState == 4 && this.status == 200) {
	
		              myFunction(this);
	
		            }
	
		            };
	
		            xmlhttp.open("GET", "scTotals.xml", true);
	
		            xmlhttp.send();
	
		        }
	
		        function myFunction(xml) {
	
		          var i;
	
		          var xmlDoc = xml.responseXML;
	
		          var table="<tr><th>Service Club</th><th>Seasonal Total</th></tr>";
	
		          var x = xmlDoc.getElementsByTagName("Totals");
	
		          for (i = 0; i <x.length; i++) { 
	
		            table += "<tr><td>" +
	
		            x.getElementsByTagName("ServClub")[0].childNodes[0].nodeValue +
	
		            "</td><td>" +
	
		            x.getElementsByTagName("TotalAmount")[0].childNodes[0].nodeValue +
	
		            "</td></tr>";
	
		           }
	
		          document.getElementById("demo").innerHTML = table;
	
		        }
	
		    </script>
	
		</body>
	
		</html> 
	
		Data File 'scTotals.xml' in same website folder.
	
				<?xml version='1.0' encoding='utf-8'?>
			
				<dataroot>
			
				    <Totals>
			
				        <ServClub>Beukendall Eastern Star</ServClub>
			
				        <TotalAmount>$ 447</TotalAmount>
			
				    </Totals>
			
				    <Totals>
			
				        <ServClub>Key Club</ServClub>
			
				        <TotalAmount>$ 363</TotalAmount>
			
				    </Totals>
			
				    <Totals>
			
				        <ServClub>S.I. Group</ServClub>
			
				        <TotalAmount>$ 201</TotalAmount>
			
				    </Totals>
			
				    <Totals>
			
				        <ServClub>Sarah Bilofsky & Friends</ServClub>
			
				        <TotalAmount>$ 182</TotalAmount>
			
				    </Totals>
			
				    <Totals>
			
				        <ServClub>Schenectady ARC</ServClub>
			
				        <TotalAmount>$ 1530</TotalAmount>
			
				    </Totals>    
			
				</dataroot>
			
				Any help would be appreciated.   Gil

dsonesuk · October 15, 2017

'&' on its own is not allowed in xml, use & instead, also to ref each item through loop you have to use

x[i]

as well

Edited October 15, 2017 by dsonesuk

Gilbert · October 22, 2017

Thank you so much for your reply. Sorry it took so long to get back to you - it seems I don't get an email when someone replies. Both of your answers worked out perfectly and I can now do the XML with no problems. Just for future reference, I don't know why the file I copied came out like triple spaced. I copied and pasted - is there a better way? And I don't see where to mark this question as answered. In other forums they usually have a button right here that says 'answered'. Thanx again dsonesuk!

dsonesuk · October 22, 2017

When inserting coding select '<>‘ above.

There has never been a marked as solved option, people sometimes add '[solved]' to original title.

Sign In

XML not working - can't see what's wrong

Recommended Posts

Gilbert

Link to comment

Share on other sites

dsonesuk

Link to comment

Share on other sites

Gilbert

Link to comment

Share on other sites

dsonesuk

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Browse

Activity