Hello!
Before anything else, I'd like to mention that I'm following the
following Mapserver wiki as my guide:
http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?JoinDatasources
Here is our online mapping site I'm trying to redo using external csv
files: http://gis.pids.gov.ph/
Now for the replies for your suggestions. I really appreciate all your ideas:
From Manfred:
Hi,thanks for the informations. I'm only guessing: In the > "TO" line in your
mapfile you have the number "1". Is this ok?
It's the column number of the common field of the shapefile and csv
I'm trying to join ("PLACE_ID"). I'm actually following the convention
of the online guide I said above. But I did try using the field name,
but with the same results.
Hi, one last guess: your table name "lgu_DB_DACCESS_PROV.csv" has not path.
Is it possible that mapserver does not find that table?
The csv file is located on the same path as the mapfile. Even if I use
the absolute path of the file
("/home/yronald/htdocs/maps/test_map/lgu_DB_DACCESS_PROV.csv"), the
result is the same.
From Steve:
Cris: JOINs exist within LAYERs but don't contain CLASSes. A
one-to-many
join can have a TEMPLATE defined. E.g.
JOIN
NAME 'test'
TYPE ONE-TO-MANY
CONNECTIONTYPE CSV
TABLE 'test.csv'
FROM 'id'
TO '1'
TEMPLATE 'test.html'
Yes that is true. I'm trying on a one-to-one connection, that is one
csv is to be used by a shapefile for a JOIN at a time. As I read it,
the default type is one-to-one and a template could be added
explicitly but not really necessary right? Either way, there's no
change in the result.
I'll follow up on this later.
Maricris
