Author Topic: CiviCRM 4.2 geocoding not doing anything (Read 973 times)

Erich · October 03, 2012, 09:19:27 pm

I've specified a 32-character key in civicrm.settings.php, and I've enabled "Street Address Parsing" via Localization > Address Settings. I specified Google as both the Mapping Provider and Geocoding provider in System Settings > Mapping and Geocoding, and I've enabled the "Geocode and Parse Addresses" job via System Settings > Scheduled Jobs. Finally, I've specified the following command parameters:

geocoding=1
parse=1
start=1
end=null
throttle=1

But when I "Execute Now" from the Scheduled Jobs page I get:

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

I get the same result when I added "name=XXXXXXXX" and "pass=YYYYYYYY" and "key=ZZZZZZZZ" to the command parameters, with appropriate values for XXXXXXX, YYYYYYYY, and ZZZZZZZZ.

Next, I tried running via URL (this is for a Joomla site):

http://[SITEROOT]/administrator/components/com_civicrm/civicrm/bin/cron.php?job=geocode&geocoding=1&parse=1&start=1&end=null&throttle=1&name=XXXXXXXX&pass=YYYYYYYY&key=ZZZZZZZZ

but all I get is a blank screen.

What am I missing?

Erich · October 07, 2012, 06:02:16 pm

The person in http://forum.civicrm.org/index.php/topic,26045.msg110145.html reported that his error went away when he upgraded to CiviCRM 4.2.2, so I did so as well (hoping my problem was related and that this would also solve my problem).

Well, sort of... when I "Execute Now" from the Scheduled Jobs page I still get:

Quote

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

Parameters parsed (and passed to API method):
a:5:{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";}

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

but now when I point my browser to

http://[SITEROOT]/administrator/components/com_civicrm/civicrm/bin/cron.php?job=geocode&geocoding=1&parse=1&throttle=1&name=username&pass=password&key=site-key

I see that geocoding is occurring if I monitor the count of civicrm_address records where geo_code_1 is null.

So... any ideas why geocoding doesn't do anything when I "Execute Now"? Do the username/password/site-key need to be entered in the "Execute Now" command parameters field for the scheduled jobs? http://wiki.civicrm.org/confluence/display/CRMDOC42/Managing+Scheduled+Jobs only says that "If you are triggering jobs using the URL method, you must manually generate a site key, and then add it to your CiviCRM settings file" (i.e. nothing about triggering jobs via "Execute Now")

Erich · October 07, 2012, 06:24:17 pm

Hmm, spoke too soon, apparently... I'm down to 759 ungeocoded addresses, but now I get the following from the URL submission:

Fatal error: Wrong parameters for Exception([string $exception [, long $code [, Exception $previous = NULL]]]) in [SITEHOME]/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php on line 262

I started with ~3,775 ungeocoded addresses, so it is unclear to me why the URL method would suddenly stop working?

CiviCRM Community Forums (archive)

News:

Author Topic: CiviCRM 4.2 geocoding not doing anything (Read 973 times)

Erich

CiviCRM 4.2 geocoding not doing anything

Erich

Re: CiviCRM 4.2 geocoding not doing anything

Erich

Re: CiviCRM 4.2 geocoding not doing anything