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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Importing Indivs, relationships on External ID
Pages: [1]

Author Topic: Importing Indivs, relationships on External ID  (Read 1709 times)

lcdweb

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1620
  • Karma: 116
    • www.lcdservices.biz
  • CiviCRM version: many versions...
  • CMS version: Joomla/Drupal
  • MySQL version: 5.1+
  • PHP version: 5.2+
Importing Indivs, relationships on External ID
March 17, 2008, 08:24:06 am
I'm in the process of doing a large data import. My data is very clean and normalized, so I had hoped to import the individuals and build relationships to their parent organizations using the external id field. But it's not working -- the import works, but the relationship isn't built. If I do the same import and user org name for the relationship identifier, it works perfectly. I'm just wondering if anyone else has tried importing with external id and if they've had any problems.

I'm using 2.0. My data is clean enough, it shouldn't be a problem importing/relating on org name. But I would feel more comfortable with the external id field as it was a unique key field in the prior db.

-Brian
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih

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: Importing Indivs, relationships on External ID
March 17, 2008, 09:17:46 am
Brian:

If its working for Organization, it should also work for Household (Both use kind of same code). If you are able to replicate it on demo, please file an issue in jira and  attach sample import file.

kurund
Found this reply helpful? Support CiviCRM

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: Importing Indivs, relationships on External ID
March 19, 2008, 05:19:33 am
Brian:

We found an issue with importing relationship contacts using external identifier. Fix will be part of CiviCRM v2.0.2.
You can also check: http://biryani.osuosl.org:8181/browse/CiviCRM/branches/v2.0/CRM/Import/Parser/Contact.php?r1=13652&r2=13709

thanx,

kurund
Found this reply helpful? Support CiviCRM

lcdweb

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1620
  • Karma: 116
    • www.lcdservices.biz
  • CiviCRM version: many versions...
  • CMS version: Joomla/Drupal
  • MySQL version: 5.1+
  • PHP version: 5.2+
Re: Importing Indivs, relationships on External ID
March 19, 2008, 05:54:31 am
Kurund,
I sent you a PM requesting Joomla sandbox access (I was going to run test data through on this issue), as my old user/id isn't working anymore. Can you send me that anyway, even though this issue is resolved, as I test thing on the sandbox fairly regularly.
thx,
-Brian
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Importing Indivs, relationships on External ID
March 24, 2008, 10:51:56 am
(I've taken care of this for Brian - fyi).
Protect your investment in CiviCRM by  becoming a Member!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Importing Indivs, relationships on External ID

This forum was archived on 2017-11-26.