<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Consolas;
color:blue;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Courier New";}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-family:Consolas;color:blue">Hello all:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas;color:blue"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas;color:blue">I’m trying to use the XY tools but it bails me out when trying to load the table after choosing x – y columns.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas;color:blue">Any help will be appreciated.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas;color:blue"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas;color:blue">Here is the error message:<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:Consolas;color:red">An error has occurred while executing Python code:</span><span style="font-size:10.0pt;font-family:Consolas"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:9.0pt;margin-right:0in;margin-bottom:9.0pt;margin-left:0in">
<span style="font-size:8.0pt;font-family:Consolas">Traceback (most recent call last):<br>
File "C:/Users/isantiago/.qgis2/python/plugins\xytools\xytools.py", line 159, in excelOpen<br>
self.loadSheetAsLayer(provider)<br>
File "C:/Users/isantiago/.qgis2/python/plugins\xytools\xytools.py", line 206, in loadSheetAsLayer<br>
x=row[self.layerInfo[self.layer].xIdx]<br>
KeyError: None<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Consolas"><br>
Python version:<br>
2.7.4 (default, Apr 6 2013, 19:54:46) [MSC v.1500 32 bit (Intel)]<br>
<br>
<br>
QGIS version:<br>
2.4.0-Chugiak Chugiak, 8fdd08a<br>
<br>
Python path: ['C:/PROGRA~2/QGISCH~1/apps/qgis/./python/plugins\\processing', 'C:/PROGRA~2/QGISCH~1/apps/qgis/./python', u'C:/Users/isantiago/.qgis2/python', u'C:/Users/isantiago/.qgis2/python/plugins', 'C:/PROGRA~2/QGISCH~1/apps/qgis/./python/plugins', 'C:\\Program
Files (x86)\\ArcGIS\\bin', 'C:\\PROGRA~2\\QGISCH~1\\bin\\python27.zip', 'C:\\PROGRA~2\\QGISCH~1\\apps\\Python27\\DLLs', 'C:\\PROGRA~2\\QGISCH~1\\apps\\Python27\\lib', 'C:\\PROGRA~2\\QGISCH~1\\apps\\Python27\\lib\\plat-win', 'C:\\PROGRA~2\\QGISCH~1\\apps\\Python27\\lib\\lib-tk',
'C:\\PROGRA~2\\QGISCH~1\\bin', 'C:\\PROGRA~2\\QGISCH~1\\apps\\Python27', 'C:\\PROGRA~2\\QGISCH~1\\apps\\Python27\\lib\\site-packages', 'C:\\PROGRA~2\\QGISCH~1\\apps\\Python27\\lib\\site-packages\\GDAL-1.11.0-py2.7-win32.egg', 'C:\\PROGRA~2\\QGISCH~1\\apps\\Python27\\lib\\site-packages\\PIL',
'C:\\PROGRA~2\\QGISCH~1\\apps\\Python27\\lib\\site-packages\\jinja2-2.7.2-py2.7.egg', 'C:\\PROGRA~2\\QGISCH~1\\apps\\Python27\\lib\\site-packages\\markupsafe-0.23-py2.7-win32.egg', 'C:\\PROGRA~2\\QGISCH~1\\apps\\Python27\\lib\\site-packages\\python_dateutil-2.2-py2.7.egg',
'C:\\PROGRA~2\\QGISCH~1\\apps\\Python27\\lib\\site-packages\\pytz-2014.2-py2.7.egg', 'C:\\PROGRA~2\\QGISCH~1\\apps\\Python27\\lib\\site-packages\\win32', 'C:\\PROGRA~2\\QGISCH~1\\apps\\Python27\\lib\\site-packages\\win32\\lib', 'C:\\PROGRA~2\\QGISCH~1\\apps\\Python27\\lib\\site-packages\\Pythonwin',
'C:\\PROGRA~2\\QGISCH~1\\apps\\Python27\\lib\\site-packages\\Shapely-1.2.18-py2.7-win32.egg', 'C:\\PROGRA~2\\QGISCH~1\\apps\\Python27\\lib\\site-packages\\six-1.6.1-py2.7.egg', 'C:\\PROGRA~2\\QGISCH~1\\apps\\Python27\\lib\\site-packages\\wx-2.8-msw-unicode',
'C:\\PROGRA~2\\QGISCH~1\\apps\\qgis\\python\\plugins\\fTools\\tools']<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas;color:blue"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas;color:blue"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Consolas;color:blue">---------------------------<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Consolas;color:blue">Iván Santiago<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Consolas;color:blue">GIS Specialist<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Consolas;color:blue">Information Technologies<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Consolas;color:blue">Office of Management and Budget<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="PT-BR" style="font-size:10.0pt;font-family:Consolas;color:blue">787.725.9420 x 2378<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="PT-BR" style="font-size:10.0pt;font-family:Consolas;color:blue">Calle Cruz 254<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="PT-BR" style="font-size:10.0pt;font-family:Consolas;color:blue">PO Box 9023228<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES" style="font-size:10.0pt;font-family:Consolas;color:blue">San Juan, PR 00902-3228<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Consolas;color:blue"><a href="http://gis.pr.gov/"><span lang="ES">http://gis.pr.gov</span></a></span><span lang="ES" style="font-size:10.0pt;font-family:Consolas;color:blue"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES"><o:p> </o:p></span></p>
</div>
</body>
</html>