I have inherited the following functionality:-
1. A non-Drupal table containing UK locations with addresses including post codes.
2. A requirement to display these locations on a Google Map.
The current solution is to "pre-process" the data from the non-Drupal table into CCK nodes and geocode the post codes into lat/lon in the location table. From there, everything works ok.
However, the issue really is that when changes are made to the non-Drupal table, these changes have to be reflected all the way through the manually-invoked pre-processing. Even automating this process isn't ideal, so I am thinking in terms of defining a content type based on the non-Drupal table.
Any ideas how gmap will cope with using a non-standard node type? I guess the location table will still need to be populated with latitudes/longitudes (which we don't have yet).
Any advice or alternative approaches?
Thanks
Terry
