title: Parsing XML Data that I receive from UrlFetch
body: <p>I want to parse the data I get from UrlFetch into a spreadsheet, but all I'm getting is undefined can someone show me what i'm doing wrong </p>
  
  <p>The xml is at the address <a href="https://dl.dropbox.com/u/11787731/Minecraft/bans.xml" rel="nofollow">https://dl.dropbox.com/u/11787731/Minecraft/bans.xml</a></p>
  
  <pre><code>function runevery15mins() {
   var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("MC Bans");
   sheet.clearContents();
   var banURL = "https://dl.dropbox.com/u/11787731/Minecraft/bans.xml";
  
   var banXML = UrlFetchApp.fetch(banURL).getContentText();
   var banDOC = Xml.parse(banXML, false);
   var mcuser = banDOC.bans;
  
   var x = 0;
   for(var c=0; c&gt;mcuser.length;c++){
     var name = mcuser.getElement("username")[c].getText();
     var date = mcuser.getElement("date")[c].getText();
     var reason = mcuser.getElement("reason")[c].getText();
     var duration = mcuser.getElement("duration")[c].getText();
  
  
  
   } 
   sheet.appendRow([name, date, reason, duration]);
  }
  </code></pre>