<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style>
<!--
@font-face
{font-family:Calibri}
@font-face
{font-family:Tahoma}
@font-face
{font-family:Consolas}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
p
{margin-right:0cm;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif"}
pre
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New"}
span.HTMLVorformatiertZchn
{font-family:Consolas}
span.E-MailFormatvorlage20
{font-family:Consolas;
color:blue}
p.HTMLPreformatted, li.HTMLPreformatted, div.HTMLPreformatted
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
span.HTMLPreformattedChar
{font-family:"Courier New"}
span.E-MailFormatvorlage23
{font-family:"Calibri","sans-serif";
color:#1F497D}
.MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:72.0pt 72.0pt 72.0pt 72.0pt}
div.WordSection1
{}
-->
</style>
</head>
<body lang="DE" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Hello Iván,</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">I had the same problem this morning.</span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">After trying around, it works if there is now other layer loaded (an empty qgis project) and the CRS of the qgis-project is set to the CRS of the x/y-data of the table.
</span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">(The CRS of the loaded data will be set to the CRS of the project.)</span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Greetings and good luck</span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Asmus Harder</span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<div>
<div style="border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">Von:</span></b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif""> qgis-user-bounces@lists.osgeo.org [mailto:qgis-user-bounces@lists.osgeo.org]
<b>Im Auftrag von </b>Ivan Santiago<br>
<b>Gesendet:</b> Donnerstag, 11. September 2014 23:15<br>
<b>An:</b> qgis-user@lists.osgeo.org<br>
<b>Betreff:</b> [Qgis-user] XY Tools error</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Consolas; color:blue">Hello all:</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Consolas; color:blue"> </span></p>
<p class="MsoNormal"><span lang="EN-US" 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.</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Consolas; color:blue">Any help will be appreciated.
</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Consolas; color:blue"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Consolas; color:blue">Here is the error message:</span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="EN-US" style="font-size:10.0pt; font-family:Consolas; color:red">An error has occurred while executing Python code:</span><span lang="EN-US" style="font-size:10.0pt; font-family:Consolas"></span></p>
<p class="MsoNormal" style="margin-right:0cm; margin-bottom:9.0pt; margin-left:0cm">
<span lang="EN-US" 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</span></p>
<p class="MsoNormal"><span lang="EN-US" 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)<a href="file:///\\ArcGIS\bin">\\ArcGIS\\bin</a>', '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']</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt; font-family:Consolas"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Consolas; color:blue"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Consolas; color:blue"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt; font-family:Consolas; color:blue">---------------------------</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt; font-family:Consolas; color:blue">Iván Santiago</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt; font-family:Consolas; color:blue">GIS Specialist</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt; font-family:Consolas; color:blue">Information Technologies</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt; font-family:Consolas; color:blue">Office of Management and Budget</span></p>
<p class="MsoNormal"><span lang="PT-BR" style="font-size:10.0pt; font-family:Consolas; color:blue">787.725.9420 x 2378</span></p>
<p class="MsoNormal"><span lang="PT-BR" style="font-size:10.0pt; font-family:Consolas; color:blue">Calle Cruz 254</span></p>
<p class="MsoNormal"><span lang="PT-BR" style="font-size:10.0pt; font-family:Consolas; color:blue">PO Box 9023228</span></p>
<p class="MsoNormal"><span lang="ES" style="font-size:10.0pt; font-family:Consolas; color:blue">San Juan, PR 00902-3228</span></p>
<p class="MsoNormal"><span lang="EN-US" 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"></span></p>
<p class="MsoNormal"><span lang="ES"> </span></p>
</div>
<p style="font-size:10pt; font-family:Arial,sans-serif">Ihr LEHMANN+PARTNER Team als Teil der
<a href="http://groupvectra.com/die-gruppe?L=7">VECTRA-Gruppe.</a></p>
<br>
<p style="font-size:10pt; font-family:Arial,sans-serif">Unsere Erfassungstechnologie in der ARD-Sendung „[W] wie Wissen“:<br>
<b>Hightech gegen Straßenschäden:</b><br>
<a href="http://www.daserste.de/information/wissen-kultur/w-wie-wissen/sendung/schlaglochdetektor-100.html">http://www.daserste.de/information/wissen-kultur/w-wie-wissen/sendung/schlaglochdetektor-100.html
</a></p>
<p style="font-size:10pt; font-family:Arial,sans-serif"><b>Besuchen Sie uns - wir stellen aus</b></p>
<p style="font-size:8pt; font-family:Arial,sans-serif"><a href="http://www.intergeo.de">Intergeo am 7. - 9. Oktober 2014 in Berlin</a></p>
<br>
<p style="margin-bottom:-10px"></p>
<div><a href="http://www.lehmann-partner.de"><img src="http://www.lehmann-partner.de/logo-vectra-germany.png"></a><br>
<span style="font-size:7.5pt; font-family:"Arial","sans-serif"; color:black"><br>
<br>
LEHMANN + PARTNER GmbH, Schwerborner Straße 1, D-99086 Erfurt<br>
Telefon: +49 (0) 361 51804 300 Fax: +49 (0) 361 51804 399</span><span style="font-size:7.5pt; font-family:"Arial","sans-serif""><br>
E-Mail: <a href="mailto:info@lehmann-partner.de">info@lehmann-partner.de</a> Internet:
<a href="http://www.die-strassengutachter.de">http://www.die-strassengutachter.de</a><br>
Geschäftsführer: Dr. Dirk Ebersbach, Jens Morawietz<br>
Amtsgericht: Jena HRB 100220 USt-IdNr.: DE 160 115 425</span><span style="font-size:10.0pt; font-family:"Arial","sans-serif""></span>
<p></p>
</div>
<p></p>
</body>
</html>