// TDM Yahoo Group
// Nicola Zordan, February 19 2008

// NAZ Calendar Data to Excel SpreadSheet for Expenses

var TDMowners='http://groups.yahoo.com/group/TierraDelMar/database?exportData=1&tbl=1';

function LoadTDMownersText() {
  var txt=TEXTload (TDMowners);
  if(txt.charAt(0)!='"') {
    txt='';
    alert('To load the TDM owners list \nyou must login to the Yahoo group \n http://groups.yahoo.com/group/TierraDelMar/');
  };
  return txt;
};

function TDMowners2CSV (ownersTextIn) {
  var ownersText='';
  ownersText=ownersTextIn.replace(/"/g,'');
  ownersText=ownersText.replace(/\r/g,'');
  var ownersLines=ownersText.split('\n');
//alert(ownersLines.length);
  var oName=0;
  var oEMail=1;
  var oAddress=2;
  var oCity=3;
  var oState=4;
  var oZip=5;
  //var oCountry=6;
  var oTel=6;
  var oCell=7;
  var oNote=8;
  var oUnit=9;
  var o,oLine;
  var owners=[];
  for (var i=1;i<ownersLines.length-1;i++) {
    oLine=ownersLines[i];
//if (!confirm(oLine)) break;
    o=oLine.split(',');
//if (confirm(""+o)) break;
    owners[owners.length]=[
      o[oName],
      o[oAddress],
      o[oCity],
      o[oState],
      o[oZip],
      '', // no country
      o[oTel]+'  '+o[oCell],
      o[oEMail],
      'Unit: '+o[oUnit]+' '+o[oNote]
    ];
  };
  var txt='';
  for (var i=0;i<owners.length;i++) {
    o=owners[i]
    txt=txt+o[0]+',';
    txt=txt+o[1]+',';
    txt=txt+o[2]+',';
    txt=txt+o[3]+',';
    txt=txt+o[4]+',';
    txt=txt+o[5]+',';
    txt=txt+o[6]+',';
    txt=txt+o[7]+',';
    txt=txt+o[8];
    txt=txt+'\n';
  };
  return txt;
};