CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Geocoding help needed
Pages: [1]

Author Topic: Geocoding help needed  (Read 860 times)

Erich

  • I post occasionally
  • **
  • Posts: 84
  • Karma: 1
Geocoding help needed
April 29, 2013, 09:35:13 pm
I recently upgraded my site to Joomla 2.5.11 and CiviCRM 4.3.1; both upgrades said they completed successfully.

I then generated a Google API key for server apps, specifying the IP address of my server, and specified this API key in both the Map Provider Key and Geo Provider Key fields of "Settings - Mapping and Geocoding Providers."  I didn't do anything with the API key for browser apps.

"SELECT count(*) FROM `civicrm_address` WHERE geo_code_1 IS NULL" tells me that I have 63 addresses with no geocoding info.

But, when I try to run the job manually, nothing happens.  From the job log:

Parameters raw (from db settings):
geocoding=1
parse=1
start=null
end=null
throttle=1

Parameters parsed (and passed to API method):
a:6:{s:7:"version";i:3;s:9:"geocoding";s:1:"1";s:5:"parse";s:1:"1";s:5:"start";s:4:"null";s:3:"end";s:4:"null";s:8:"throttle";s:1:"1";}

Full message:
Finished execution of Geocode and Parse Addresses with result: Success (Addresses Evaluated: 0
Addresses Geocoded: 0
Street Addresses Parsed: 0

)

Any ideas?

clarkac

  • Administrator
  • Ask me questions
  • *****
  • Posts: 399
  • Karma: 11
  • CiviCRM version: 4.4.11 & 4.5.5
  • CMS version: Drupal 7
  • MySQL version: 5.1.61-cll
  • PHP version: 5.3.27
Re: Geocoding help needed
May 25, 2013, 07:23:39 am
Similar story here, except that I when I specified the server API key when looking at the map for the one address I have geocoded, Google told me the key was incorrect.  So I used the browser API key instead and it worked and showed me the map.

But... then running the batch job results in the same result as above - 0 addresses evaluated and 0 addresses encoded. All but one of my addresses need to be evaluated and encoded.  I tried the 'throttle=1' parameter to no avail.
I'm using 4.3.3.    Ideas?
Andy Clark

clarkac

  • Administrator
  • Ask me questions
  • *****
  • Posts: 399
  • Karma: 11
  • CiviCRM version: 4.4.11 & 4.5.5
  • CMS version: Drupal 7
  • MySQL version: 5.1.61-cll
  • PHP version: 5.3.27
Re: Geocoding help needed
May 25, 2013, 09:31:40 am
Oops, this is embarrassing!  I spotted that country wasn't set on the imported input.  As soon as I added that geocoding worked.  Surprising though, I'd have thought that Google would have defaulted to the current country.
Andy Clark

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Geocoding help needed

This forum was archived on 2017-11-26.