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 (Moderator: Dave Greenberg) »
  • Proximity Search Not Working on Imported Records
Pages: [1]

Author Topic: Proximity Search Not Working on Imported Records  (Read 988 times)

SandyEllingson

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 1
  • I want to make a difference!
    • Sandy Social Strategist
Proximity Search Not Working on Imported Records
December 23, 2010, 02:54:03 pm
I have imported a large number of records into Civicrm. Upon import we did not have it do the geo mapping as it was recommended we not do this.  When I try to use the proximity search, only items that were hand entered into the system are returned.  If I go into a record of an imported contact and do nothing more than just save the record and exit, then this record will show. 

Is there an indexing that I missed or is this something to do with the gmap feature?  How can I correct this without going inot 16,000 records manually.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Proximity Search Not Working on Imported Records
December 23, 2010, 06:02:58 pm

You'll need to run bin/UpdateAddress.php and batch geocode the other locations.

check:

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

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

SandyEllingson

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 1
  • I want to make a difference!
    • Sandy Social Strategist
Re: Proximity Search Not Working on Imported Records
December 27, 2010, 07:21:39 am
We have followed the instructions in this post however, now we receive no results on the proximity search where before we were receiving the names of those that had been manually entered.  Before I could go into a record that had been imported and re-save the record and they would then show up. I tried this after running the script and it no longer works.  Thoughts?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Proximity Search Not Working on Imported Records
December 27, 2010, 09:57:13 am

sorry, no idea what is happening on your site and why. You might want to consider asking someone familiar with php/mysql to investigate and figure out whats happening and why

Please report back the solution when u have figured it out

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

SandyEllingson

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 1
  • I want to make a difference!
    • Sandy Social Strategist
Re: Proximity Search Not Working on Imported Records
December 27, 2010, 10:25:44 am
thank you. i will let you know.

SandyEllingson

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 1
  • I want to make a difference!
    • Sandy Social Strategist
Re: Proximity Search Not Working on Imported Records
December 28, 2010, 12:34:07 pm
I was able to speak with the DB who ran this for us and the script actually appeared to work that evening when ran but the next morning when users began to run it we received the error. He reran the script and everything is working properly. We are not sure what caused the issue except that there were several chron jobs that ran that night so maybe that had something to do with it but for now we are happy and consider it resolved. Thanks for always being so great to respond. This is an awesome community to be a part of.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Proximity Search Not Working on Imported Records
December 28, 2010, 02:48:26 pm

cool, glad it worked out for you.

you can pay it forward and help improve civicrm by getting your org to contribute to one of our make it happen initiatives here:

http://civicrm.org/contribute

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Proximity Search Not Working on Imported Records

This forum was archived on 2017-11-26.