CiviCRM Community Forums (archive)

Hi I'm using Google maps for geocoding; Civicrm v. 4.4.6.  Used to work fine but stopped at some point - not sure exactly when - and no new contacts are getting geocoded.  I have the following parameters for the scheduled job:
geocoding=1
parse=1
start=20000
end=31800
throttle=0

I get error message "Hit the over query limit on geocoder" no matter what, even when I do not believe I exceed the 25,000 request limit per day.
Looking on the google developer console, I have 0 requests so I don't believe the error message about over query limit is correct.
If I set throttle=1, the address geocoder job starts but never finishes - it just seems to run indefinitely.

Can anyone help?

Thanks!

Leslie

Hi Jon thanks for the reply!!!

To answer your questions:
* The limit is 2,500/day, not 25,000/day, which may be part of the confusion.
This is indeed confusing, because if you look on the google Developer APIs Console under Services it says for Google Maps JavaScript API v3, Courtesy limit: 25,000 requests/day • Max billable limit: 1,000,000 requests/day.  Is that referring to a different kind of mapping request than the CiviCRM geocoding requests?  Or do I not have the correct Service turned on for Geocoding?

* How long did you give it to time out with throttling?  It'll run for several hours a day in my experience until it hits the limit.
Not sure I understand this question?  You mean I need to let it run much longer when I have throttle=1, before I give up?  I don't know how to cancel it once it starts running but I think the longest I've waited before assuming it's failed is probably about an hour.   Not long enough maybe?

* Finally - while geocoding is running, are you checking to see if addresses are getting geocoded?  Could you please post before/after counts so we know if it's not working at all, or just working minimally?  You can get a count by using Search Builder - "Geo Code 1" "is not null".
Yes - I've actually checked in the backend using MySql query (not sure Geo code is a field option in Search Builder in my version?).  Doesn't look like anything is getting geocoded.

I'm going to set throttle=1 and let job run for several hours now and see what I get.  Maybe I'm just not giving it enough time...

Thanks again for your help!!!

Leslie

Hi Jon - Thanks!  That worked!  I took out the API key and now it seems that my geocodes are gradually getting generated, with throttle=1.

Not sure why the API key would have cause a problem.  I had tried it with both with the original key I've been using all along, and when that failed, a newly regenerated key on the Google developer site, which also apparently didn't work (copy and paste, so no typos).  Not sure why the key caused a failure, but without the key it seems to be running, and my sql queries are indicating that the number of records with geo_code_1=null is decreasing so problem seems to be solved.

Thanks so much for help!  Really appreciated it.

Leslie