<div>I created a CSV matrix table between two point layers, A to B, limited to 5 nearest points.</div>
<div>This worked and created a nice CSV table I could open in Excel.</div>
<div> </div>
<div>Then I created a CSV matrix table between the same layers, but in other direction B to A, limited to 3 nearest points (as suited the application)</div>
<div>But this second matrix was not recognised as SYLK by Excel and when it opened it did not mean anything</div>
<div>The data came out</div>
<div> </div>
<div>
<table style="WIDTH:192pt;BORDER-COLLAPSE:collapse" border="0" cellspacing="0" cellpadding="0" width="256">
<colgroup>
<col style="WIDTH:48pt" span="4" width="64">
<tbody>
<tr style="HEIGHT:12.75pt" height="17">
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;WIDTH:48pt;HEIGHT:12.75pt;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" height="17" width="64">
<div>ID</div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;WIDTH:48pt;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" width="64">
<div><strong>D83001</strong></div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;WIDTH:48pt;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" width="64">
<div>D83056</div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;WIDTH:48pt;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" width="64">
<div>D83037</div></td></tr>
<tr style="HEIGHT:12.75pt" height="17">
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;HEIGHT:12.75pt;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" height="17">
<div><strong>E01029870</strong></div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">
<div>3373.097</div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">
<div>10923.86</div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">
<div>12207.99</div></td></tr>
<tr style="HEIGHT:12.75pt" height="17">
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;HEIGHT:12.75pt;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" height="17">
<div>E01029871</div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">
<div>6618.189</div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">
<div>8032.665</div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">
<div>13911.12</div></td></tr>
<tr style="HEIGHT:12.75pt" height="17">
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;HEIGHT:12.75pt;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" height="17">
<div>E01029872</div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">
<div>4053.571</div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">
<div>9840.088</div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">
<div>12529.39</div></td></tr>
<tr style="HEIGHT:12.75pt" height="17">
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;HEIGHT:12.75pt;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" height="17">
<div>E01029873</div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">
<div>12615.9</div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">
<div>8837.422</div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">
<div>18598.75</div></td></tr>
<tr style="HEIGHT:12.75pt" height="17">
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;HEIGHT:12.75pt;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" height="17">
<div>E01029874</div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">
<div>16465.69</div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">
<div>13229.66</div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">
<div>23036.41</div></td></tr>
<tr style="HEIGHT:12.75pt" height="17">
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;HEIGHT:12.75pt;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" height="17">
<div>E01029875</div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">
<div>14305.8</div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">
<div>18204.42</div></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">
<div>6696.021</div></td></tr></tbody></colgroup></table></div>
<div> </div>
<div>when it should have come out something like:</div>
<div> </div>
<div>
<table style="WIDTH:166pt;BORDER-COLLAPSE:collapse" border="0" cellspacing="0" cellpadding="0" width="221">
<colgroup>
<col style="WIDTH:70pt" width="93">
<col style="WIDTH:48pt" span="2" width="64">
<tbody>
<tr style="HEIGHT:12.75pt" height="17">
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;WIDTH:70pt;HEIGHT:12.75pt;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" height="17" width="93">ID</td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;WIDTH:48pt;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" width="64">ID2</td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;WIDTH:48pt;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" width="64">Distance</td></tr>
<tr style="HEIGHT:12.75pt" height="17">
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;HEIGHT:12.75pt;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" height="17"><strong>E01029870</strong></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8"><strong>D83001</strong></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">460</td></tr>
<tr style="HEIGHT:12.75pt" height="17">
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;HEIGHT:12.75pt;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" height="17">E01029870</td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8">D83056</td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">546</td></tr>
<tr style="HEIGHT:12.75pt" height="17">
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;HEIGHT:12.75pt;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" height="17">E01029870</td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8">D83037</td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" align="right">345</td></tr>
<tr style="HEIGHT:12.75pt" height="17">
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;HEIGHT:12.75pt;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8" height="17">etc.</td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8"></td>
<td style="BORDER-BOTTOM:#ece9d8;BORDER-LEFT:#ece9d8;BACKGROUND-COLOR:transparent;BORDER-TOP:#ece9d8;BORDER-RIGHT:#ece9d8"></td></tr></tbody></colgroup></table></div>
<div> </div>
<div>The source and target codes are in bold and are unique identifiers in their respective tables.</div>
<div> </div>
<div>When I tried again with the limit on B to A set to 5 (same as for A to B), the plug-in failed with message below:</div>
<div> </div>
<div> </div>
<div>>>>>>>>>></div>
<div><span style="COLOR:#ff0000">An error has occured while executing Python code:</span></div>
<div><br><br>Traceback (most recent call last):<br>  File "C:\PROGRA~1\Quantum GIS Lisboa\apps\qgis\python\plugins\fTools\tools\doPointDistance.py", line 140, in accept<br>    self.compute(point1, point2, field1, field2, outPath, matType, nearest, self.progressBar)<br>
  File "C:\PROGRA~1\Quantum GIS Lisboa\apps\qgis\python\plugins\fTools\tools\doPointDistance.py", line 179, in compute<br>    f = open(unicode(outPath), "wb")<br>IOError: [Errno 13] Permission denied: u'C:/Documents and Settings/Roy/My Documents/Roys/EAC/CAMHS/Suffolk data/LSOA GP distances.csv'<br>
<br>Python version:<br>2.7.2 (default, Jun 12 2011, 15:08:59) [MSC v.1500 32 bit (Intel)]<br><br><br>QGIS version:<br>1.8.0-Lisboa Lisboa, 6416f38<br><br>Python path: ['C:/PROGRA~1/Quantum GIS Lisboa/apps/qgis/./python', 'C:/Documents and Settings/Roy/.qgis//python', 'C:/Documents and Settings/Roy/.qgis//python/plugins', 'C:/PROGRA~1/Quantum GIS Lisboa/apps/qgis/./python/plugins', 'C:\\PROGRA~1\\Quantum GIS Lisboa\\bin\\python27.zip', 'C:\\PROGRA~1\\Quantum GIS Lisboa\\apps\\Python27\\DLLs', 'C:\\PROGRA~1\\Quantum GIS Lisboa\\apps\\Python27\\lib', 'C:\\PROGRA~1\\Quantum GIS Lisboa\\apps\\Python27\\lib\\plat-win', 'C:\\PROGRA~1\\Quantum GIS Lisboa\\apps\\Python27\\lib\\lib-tk', 'C:\\PROGRA~1\\Quantum GIS Lisboa\\apps\\qgis\\bin', 'C:\\PROGRA~1\\Quantum GIS Lisboa\\apps\\Python27', 'C:\\PROGRA~1\\Quantum GIS Lisboa\\apps\\Python27\\lib\\site-packages', 'C:\\PROGRA~1\\Quantum GIS Lisboa\\apps\\Python27\\lib\\site-packages\\PIL', 'C:\\PROGRA~1\\Quantum GIS Lisboa\\apps\\Python27\\lib\\site-packages\\win32', 'C:\\PROGRA~1\\Quantum GIS Lisboa\\apps\\Python27\\lib\\site-packages\\win32\\lib', 'C:\\PROGRA~1\\Quantum GIS Lisboa\\apps\\Python27\\lib\\site-packages\\Pythonwin', 'C:\\PROGRA~1\\Quantum GIS Lisboa\\apps\\Python27\\lib\\site-packages\\wx-2.8-msw-unicode', 'C:\\Documents and Settings\\Roy\\.qgis\\python\\plugins\\QuickMultiAttributeEdit/forms', 'C:\\PROGRA~1\\Quantum GIS Lisboa\\apps\\qgis\\python\\plugins\\fTools\\tools', 'C:/Program Files/Quantum GIS Lisboa']</div>

<div> </div>
<div> </div>
<div><<<<<<<<<<</div>