CiviCRM Community Forums (archive)

I recently added the mapping capability to my installation, and it's working fine for contact addresses, but I found that event locations I created and saved before are mapped in the wrong place.  If I put the location's postcode directly into Google it shows the marker in the correct place, but CiviCRM maps it a couple of miles away. I've tried just saving the location data again, but it doesn't update.  Can I trigger an update somehow? Or where is the location's lat-long stored? Maybe I can edit the numbers?

Thanks Lobo.  Saving again didn't work, but I used google maps to get the geocode x&y, and then manually edited the civicrm_address table. For others coming after, the event locations are in civicrm_address, they just have a NULL contact_id.

Thanks Dave, that gave me the clue to discover that my address settings were suppressing the lat & long display, which is why I couldn't interact with them directly.

Eileen, I may have been unduly optimistic when I wrote that. Originally it had been clear that the geocode hadn't worked propely, but I thought that was because the event location had been there before I set up the geocode capability. I used Google to get the correct lat-long, but I couldn't see the event lat-log fields so couldn't change them, and I couldn't trigger it to change itself... so I did it manually in the database table. After Dave's comment I found out how to make the lat-long display in the event location record (by fixing the address settings) and assumed that clearing those fields would have solved the problem.  BUT... since then I entered a new location and again it geocoded wrongly (just a mile or so out, oddly enough), so it wasn't that after all.  Yet the contact addresses seem to geocode ok. It didn't seem reasonable that it could be a software error, so I just parked it to come back to (like you we don't have a lot of  locations).  But if you are having trouble too, perhaps there is something deeper going on....?

P.S. The geocode error seems to be only in the decimal part of the lat and long - perhaps the sort of thing that might happen if a 'minute' figure was misinterpreted as a decimal of a degree, or vice versa?

I can't remember - I may have changed it via phpmyadmin although I think I found that if I kept tinkering with the address I eventually found one it would accept.

Can you replicate it on the sandbox?

it should be http://domain/sites/all/modules/civicrm/bin/UpdateAddress.php

if your code is in 'all'

When I try going to /sites/all/modules/civicrm/bin/UpdateAddress.php I get the following error:

Console_Getopt: Could not read cmd args (register_argc_argv=Off?)
Do I need to specify arguments somehow?

I'm using 3.3.1.

Thanks!
Colin

I got the same error today on the Drupal 6.22 and Civi 3.4.6, and I have PHP 5.2.16

After running at the command line, I found that the sample data were geocoded, but I hadn't checked beforehand, maybe they come that way.