[mapserver-users] JOIN SHP and CSV

[Stefan Schantz]

Hello,
although I 've read several informations (in this user list, mapserver 
documentation) about joining datas von a csv-file to a shp-file, I still 
get the error message "Content-type: application/vnd.ogc.se_xml 
msDBFJoinConnect(): Unable to access file. 
(../../../../daten/vektordaten/utm/studios/europa_sonnenstudio.csv)"
I 've tried already several things like putting csv-file at the same 
place as the mapfile, chmod 777 , but I always got the same message.
Any ideas? Thanks!

My mapfile looks like:
  LAYER
      NAME "europa"
      TYPE POLYGON
      STATUS ON
      DUMP TRUE
      DATA "europa"
 
      JOIN
        NAME "tab"
        TABLE 
"../../../../daten/vektordaten/utm/studios/europa_sonnenstudio.csv"
        FROM "NAME"
        TO "NAME"
        TYPE ONE-TO-ONE
      END
     
      PROJECTION
           "init=epsg:4326"
      END
      METADATA
            WMS_SRS "EPSG:25832 EPSG:4326 EPSG:32632 EPSG:31466 
EPSG:31467 EPSG:31468"
            WMS_TITLE "Sonnenstudio"
            WMS_ABSTRACT "blabla"
      END
      LABELITEM 'NAME'
     
      CLASS
     ...
      END  # CLASS
     
      CLASS
      ..
      END  # CLASS

      TEMPLATE "../templates/getFeature_sonnenstudio.html"
..

The path to the data is 
"/daten/vektordaten/utm/studios/europa_sonnenstudio.csv"
   303140 -rwxrwxrwx   1 ssh-m    gdi         2229 Sep 30 11:27 
europa_sonnenstudio.csv
path to the mapfile is "/data/umn/abc/map/studio.map"

The information of the csv-data is:
ogrinfo europa_sonnenstudio.csv europa_sonnenstudio -summary
INFO: Open of `europa_sonnenstudio.csv'
      using driver `CSV' successful.

Layer name: europa_sonnenstudio
Geometry: None
Feature Count: 54
Layer SRS WKT:
(unknown)
ID: String (0.0)
NAME: String (0.0)
TEXT: String (0.0)
DATUM: String (0.0)

The information of the shp-data is:
ogrinfo europa.shp europa -summary
INFO: Open of `europa.shp'
      using driver `ESRI Shapefile' successful.

Layer name: europa
Geometry: Polygon
Feature Count: 54
Extent: (-31.265747, 32.397476) - (69.070320, 81.857368)
Layer SRS WKT:
(unknown)
NAME: String (40.0)

Greetings from the Bavarian-Oktoberfest 

Stefan