CiviCRM Community Forums (archive)

OK - here's the deal as best as I know:

Google doesn't ban you permanently, as a rule. (They do offer an "Enterprise" package that allows unlimited mapping, but don't ask how much it costs!)

All the versions of the UpdateAddress.php I've tried from here give a result of "Addresses Evaluated: 0 Addresses Geocoded : 0" when run from the browser. When the script is run from the command line using wget, I get the following result and nothing happens:

Resolving www.domain.com... XX.XXX.XX.XXX
Connecting to www.domain.com|XX.XXX.XX.XXX|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 40 [text/html]
Saving to: `UpdateAddress.php?name=admin.6'

100%[================================================================>] 40          --.-K/s   in 0s     

21:53:10 (3.62 MB/s) - `UpdateAddress.php?name=admin.6' saved [40/40]

It may be that when the daily geocode allocation is exceeded, Google writes a 0 into the geocode, which CiviCRM "sees" (correctly) as being different from NULL, which is what UpdateAddress.php requires to see a "blank" geocode field. I had thought, then, that it would be necessary to perform an SQL command to change all geocode 0 values to NULL and try running the script again.

But...

I've noted that when a record with 0,0 geocode values is edited and saved, the location is calculated and the mapping then works fine. No values need to be changed for the contact. A simple save does the trick.

So... all I really would need to do is to find a way to re-save each contact with any geocode value of 0.

With over 18,000 unmapped contacts, this is obviously impractical - is there a command to do this? I would think that other people would be running into the same problem if trying to use CiviCRM to manage voter lists and a simple solution would be most welcome - and suggestions?

Thanks, as always, for taking the time. I'm hoping this is the last major problem I'll have here...

That's probably a good idea anyway (except for the fish that may be living at 0,0), but unfortunately, there's no change. Running the script via wget produces the same result as in previous post (which does not look right at all) and running the script from a browser (FF) seems to do something for about a minute and then it asks you whether you want to download the UpdateAddress.php file.

The downloaded file contains no data.

Considering what's happened before, I'm reticent to try running the script again.

The result I get from running the script using wget looks odd - is there a clue there? This is maddening. Thanks, as always...