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) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • Problem in Geocode updation for UpdateAddress.php
Pages: [1]

Author Topic: Problem in Geocode updation for UpdateAddress.php  (Read 902 times)

sriraman.v

  • I’m new here
  • *
  • Posts: 19
  • Karma: 0
  • CiviCRM version: 3.2.3
  • CMS version: Drupal
  • MySQL version: 5.5.8
  • PHP version: 5.2.9
Problem in Geocode updation for UpdateAddress.php
December 27, 2011, 03:19:07 am
i have used the UpdateAddress.php and Cli.php based on the below patches because  i m using the multisite architecture.

http://issues.civicrm.org/jira/browse/CRM-8566
http://issues.civicrm.org/jira/browse/CRM-8565

a) wget Method
As Mentioned , i have done the updation of Geo code by running the below URL in the Browser.

modules/civicrm/bin/UpdateAddress.php?name=name&pass=pass&key=key&start=s&end=e

Problem Facing:
As i m having around 15 lakhs records in my db with geocode NULL,by using the above URL i can able to update only first 10 thousand records.when i tried to run the  records from the last 5 lakh record,the above URL keeps on loading and couldn't find the contacts are updated.

b) Cli Method

So i tried the updation based on the Cli.php by passing the below command

php UpdateAddress.php -u username -p password -s sitename -g key -b begincontactid -e endcontactid

i couldn't able to load the civicrm settings files and config objects


Can any one advice how to handle both a) and b) so that i can update the geo code for 15 lakh Contacts

Regards,
Sriraman.v
« Last Edit: December 27, 2011, 04:52:18 am by sriraman.v »

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Problem in Geocode updation for UpdateAddress.php
December 29, 2011, 05:32:13 am
Quote
http://issues.civicrm.org/jira/browse/CRM-8566
http://issues.civicrm.org/jira/browse/CRM-8565

These patches are not integrated please check the comment on above issues. So you will have to debug if it does not work.
Alternatively you can try upgrading to beta1 and check if it works via new interface.

Hth
Kurund
Found this reply helpful? Support CiviCRM

sriraman.v

  • I’m new here
  • *
  • Posts: 19
  • Karma: 0
  • CiviCRM version: 3.2.3
  • CMS version: Drupal
  • MySQL version: 5.5.8
  • PHP version: 5.2.9
Re: Problem in Geocode updation for UpdateAddress.php
January 01, 2012, 08:45:02 am

Hi Kurund,

For the Cli Method  for what i mentioned above ,i have debugged the code and fixed in such a way the file can load the civicrm.settings file  and Civicrm Objects.

Then  i faces the below error

PHP Fatal error:  Cannot redeclare _pear_call_destructors() (previously declared in /usr/local/lib/php/PEAR.php:773) in /var/www/html/crmdev/sites/test.kk.org/modules/civicrm/packages/PEAR.php on line 811

For this, pear class need to be removed from civicrm or from php library files .
 :)
Can you please advice on this  ?

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Problem in Geocode updation for UpdateAddress.php
January 03, 2012, 08:30:42 am
Quote
For this, pear class need to be removed from civicrm or from php library files .

In this case for CiviCRM to work properly you will need to remove pear lib from php library files.

Kurund
Found this reply helpful? Support CiviCRM

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • Problem in Geocode updation for UpdateAddress.php

This forum was archived on 2017-11-26.