[Qgis-user] Vector Analysis / Distance Matrix - did not work in both directions

[Roy Marsh]

I created a CSV matrix table between two point layers, A to B, limited to 5
nearest points.
This worked and created a nice CSV table I could open in Excel.

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)
But this second matrix was not recognised as SYLK by Excel and when it
opened it did not mean anything
The data came out

    ID
 *D83001*
 D83056
 D83037
 *E01029870*
 3373.097
 10923.86
 12207.99
 E01029871
 6618.189
 8032.665
 13911.12
 E01029872
 4053.571
 9840.088
 12529.39
 E01029873
 12615.9
 8837.422
 18598.75
 E01029874
 16465.69
 13229.66
 23036.41
 E01029875
 14305.8
 18204.42
 6696.021

when it should have come out something like:

    ID ID2 Distance *E01029870* *D83001* 460 E01029870 D83056 546 E01029870
D83037 345 etc.

The source and target codes are in bold and are unique identifiers in their
respective tables.

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:


>>>>>>>>>
An error has occured while executing Python code:


Traceback (most recent call last):
  File "C:\PROGRA~1\Quantum GIS
Lisboa\apps\qgis\python\plugins\fTools\tools\doPointDistance.py", line 140,
in accept
    self.compute(point1, point2, field1, field2, outPath, matType, nearest,
self.progressBar)
  File "C:\PROGRA~1\Quantum GIS
Lisboa\apps\qgis\python\plugins\fTools\tools\doPointDistance.py", line 179,
in compute
    f = open(unicode(outPath), "wb")
IOError: [Errno 13] Permission denied: u'C:/Documents and Settings/Roy/My
Documents/Roys/EAC/CAMHS/Suffolk data/LSOA GP distances.csv'

Python version:
2.7.2 (default, Jun 12 2011, 15:08:59) [MSC v.1500 32 bit (Intel)]


QGIS version:
1.8.0-Lisboa Lisboa, 6416f38

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']


<<<<<<<<<<
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20120905/216fd98e/attachment.html>