Author Topic: Postal Code Adder prevents listing (Read 995 times)

corster · December 14, 2010, 01:29:06 pm

Hello,

We have noticed that if there is a 4-didget adder in the address of an organization that it will not come up in the proximity search. Has anyone else noticed this? I searched here and came up with nothing.

Thanks,

Curtis

SandyEllingson · December 16, 2010, 01:26:01 pm

I am having the same issue, however, I have also tried doing an advanced search by state and come up with several records and then do a proximity search by state (without any zip code info) and it is also not returning the correct records.

Dave Greenberg · December 16, 2010, 04:47:49 pm

Best if you can recreate this on the public demo and then post back here with the exact steps and inputs you are using, the expected results and the actual results. The proximity search feature in advanced search is new to 3.3 so there might well be some issues with zip+4 addresses. If you have SQL skills, would be great if you could debug the query and see what's happening.

corster · December 28, 2010, 07:22:48 am

Hello Sandy,

We found our issue. Hopefully this helps you as well.

We were importing our contacts from an existing home-grown application. When we did this, the abbreviations for the state/province were not correct. Even though we had United States as the country, it was resolving the abbreviated state to the first match in the long (world-wide) list.

We could tell this was not working correctly because the contact record would not show the red map icon in the backend. If we simply edited the contact (individual or org) and saved it (without making changes) it would self correct and the red map icon would appear. (see attached image)

Any guidance from the core team on how we can do imports correctly so this is not an issue would be greatly appreciated. Or, if that is not possible, if there is a "save all" script that we can run against all contacts (after import) so that CiviCRM resolves the address correctly, that would very helpful.

Thanks,

Curtis

Dave Greenberg · December 28, 2010, 10:24:45 am

Curtis - There is a batch script which does geocoding and / or address parsing and I think this MIGHT fix your location records - but I'm not sure. The script is bin/UpdateAddress.php and you can pass in a number of parameters to control behavior, including:

start=N
end=Y

... use these to pass a range of contact ID's to process.

geocoding=true

... retrieves geocoding from your configured mapping provider and updates records

I would experiment by passing in a small range of contact id's that are currently misconfigured and see if it fixes them.

With regard to import - are you saying that the input data had valid abbreviations for the states, but they matched to wrong value in DB due to duplicate abbreviations in the state_province table (for state/province rows in different countries)? I recall seeing a bug report on that but can't find it now :-(

corster · December 28, 2010, 10:42:16 am

Hello Dave,

We found the issue here: http://forum.civicrm.org/index.php/topic,13200.0.html

Hope this helps explain it better. Thank you for the batch script. We'll test on a few ID's like you mentioned.

Curtis

CiviCRM Community Forums (archive)

News:

Author Topic: Postal Code Adder prevents listing (Read 995 times)

corster

Postal Code Adder prevents listing

SandyEllingson

Re: Postal Code Adder prevents listing

Dave Greenberg

Re: Postal Code Adder prevents listing

corster

Re: Postal Code Adder prevents listing

Dave Greenberg

Re: Postal Code Adder prevents listing

corster

Re: Postal Code Adder prevents listing