CiviCRM Community Forums (archive)

Hi there,

I'm trying to batch update all my records that do not have longitude and latitude with geocoding data.

I have google maps set up and for those records that do have longitude and latitude it all works fine.

Now I'm seeking to batch update the rest of them.

Running AdressUpdate doesn't seem to result in addresses being updated. I suspect that I've configured the script rather than run it!

I've followed these instructions to provide the site with a key:

http://wiki.civicrm.org/confluence/display/CRMDOC/Command-line+Script+Configuration

and I've run this script (obviously replacing the tags for actual values):

'http://<base_url>/sites/all/modules/civicrm/bin/UpdateAddress.php?name=<admin_user_name>&pass=<password>key=<site_key>'

Resolving <domain>... <domain ip>
Connecting to <domain>|<domain>|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 48 [text/html]

100%[====================================>] 48            --.--K/s             

05:47:15 (8.26 MB/s) - `UpdateAddress.php?name=<admin_username>&pass=<password>key=<site_key>' saved [48/48]

I don't seem to have an error, so I'm guessing that I've just misunderstood what I'm doing -

rather than running the script have I just configured it and need to set up cron to run it?

Yep - If I put in counties it works.

That is not how we use the system, since we never send land-mail and we all know our local counties, or rather no-one cares about them!

Next steps:

Either - see if google will still map against an even smaller data set;

Or - Set up something to shove in county even if the user doesn't

Then we only have the problem if the county is not a unitary authority and the user is lazy!

Thanks for that - really useful - both the code and the warning.

I've found that the other current requirement of the mapping script is that street names are strictly streets - no flats. I can run routines to fill in county / country - but that's the sticker - easy enough, but somehow no-one likes to do things frack to bont

Anyhow, things are working well enough for now, this will be something we work out through practice and compromise.