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 »
  • Using Import (Moderator: Yashodha Chaku) »
  • "Lookup mapping info during import?" has no effect
Pages: [1]

Author Topic: "Lookup mapping info during import?" has no effect  (Read 1521 times)

bwaindwain

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 1
"Lookup mapping info during import?" has no effect
February 18, 2010, 10:26:26 am
If "Lookup mapping info during import?" is unchecked, CiviCRM still fetches the geocode information. This drastically slows down import and, in my case with large # of records, causes it to crash (PEAR_Error, code 113 "No route to host"). The only way I can disable the geocode lookup on import is to disable it in global settings -> mapping and geocoding.

With my limited PHP skills I did a back-trace and found that the var $doGeocodeAddress is not being passed along or checked in the import process. It's there in /CRM/Import/Parser/Contact.php line 416, but it is not passed along when createContact is called in line 647. Eventually down the line the geocode function is eval'd. I don't know if this is helpful but I'll just throw it out there anyway :-\

I'm using CiviCRM 3.1.2 and Drupal 6.15.

I have verified this on drupal.demo.civicrm.org.

bwaindwain

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 1
Re: "Lookup mapping info during import?" has no effect
February 18, 2010, 10:35:59 am
BTW: I tried posting this in the 3.1 Release Testing forum but the forum wouldn't let me. Seems like it's set to read only.

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: "Lookup mapping info during import?" has no effect
February 18, 2010, 12:03:46 pm

can u file an issue for this and add this link to the comment section. we'll fix in a future release

thanx for investigating, makes things a lot easier!

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

bwaindwain

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 1
Re: "Lookup mapping info during import?" has no effect
February 18, 2010, 12:56:55 pm
Done. Posted at http://issues.civicrm.org/jira/browse/CRM-5854

Some more info...

When the import fails it usually gives the following unrecoverable error report:
Code: [Select]
    [code] => 113
    [message] => No route to host
    [mode] => 16
    [debug_info] =>
    [type] => PEAR_Error
Here's a backtrace:
Code: [Select]
/var/www/drupal/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 146
, handle,
/var/www/drupal/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 931
/var/www/drupal/sites/all/modules/civicrm/packages/PEAR.php, PEAR_Error, 566
/var/www/drupal/sites/all/modules/civicrm/packages/Net/Socket.php, raiseError, 156
/var/www/drupal/sites/all/modules/civicrm/packages/HTTP/Request.php, connect, 737
/var/www/drupal/sites/all/modules/civicrm/CRM/Utils/Geocode/Google.php, sendRequest, 127
/var/www/drupal/sites/all/modules/civicrm/CRM/Core/BAO/Address.php(285) : eval()'d code, format, 1
/var/www/drupal/sites/all/modules/civicrm/CRM/Core/BAO/Address.php, eval, 285
/var/www/drupal/sites/all/modules/civicrm/CRM/Core/BAO/Address.php, fixAddress, 139
/var/www/drupal/sites/all/modules/civicrm/CRM/Core/BAO/Address.php, add, 116
/var/www/drupal/sites/all/modules/civicrm/CRM/Core/BAO/Location.php, create, 76
/var/www/drupal/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php, create, 298
/var/www/drupal/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php, create, 1510
/var/www/drupal/sites/all/modules/civicrm/CRM/Import/Parser/Contact.php, createProfileContact, 1501
/var/www/drupal/sites/all/modules/civicrm/CRM/Import/Parser/Contact.php, createContact, 646
/var/www/drupal/sites/all/modules/civicrm/CRM/Import/Parser.php, import, 368
/var/www/drupal/sites/all/modules/civicrm/CRM/Import/ImportJob.php, run, 259
/var/www/drupal/sites/all/modules/civicrm/CRM/Import/Form/Preview.php, runImport, 230
/var/www/drupal/sites/all/modules/civicrm/CRM/Core/Form.php, postProcess, 249
/var/www/drupal/sites/all/modules/civicrm/CRM/Core/StateMachine.php, mainProcess, 166
/var/www/drupal/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
/var/www/drupal/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/var/www/drupal/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/var/www/drupal/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 249
/var/www/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 209
/var/www/drupal/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 335
, civicrm_invoke,
/var/www/drupal/includes/menu.inc, call_user_func_array, 348
/var/www/drupal/index.php, menu_execute_active_handler, 18[/code]
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • "Lookup mapping info during import?" has no effect

This forum was archived on 2017-11-26.