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) »
  • Help with relationship import
Pages: [1]

Author Topic: Help with relationship import  (Read 768 times)

lesley

  • I post occasionally
  • **
  • Posts: 64
  • Karma: 1
Help with relationship import
April 22, 2012, 10:11:02 pm
Sorry I've read the docs and the manual but just can't figure out the mapping for relationship import.
I have relationship treasurer(individual) of organisation (organisation) so "treasurer of" and "treasurer is" respectively
All records already in civi with unique external ids.
import file fields are currently
individualname, individual_externalID, orgname, org_externalID  (but could use others)

My brain (and pride!) are hurting  trying to figure out the mapping ??? and whether to import as individual or org or 2 rounds?

Thanks folks




petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Help with relationship import
April 23, 2012, 12:13:26 pm
so if you import them as Individuals just using your Ext ID - then on the column for Org Ext Id scroll right to the bottom of the options and you should find a whole bunch of Relationships including the one you created.
Pick the Treasurer one, that will then give you another field with options where you should find External ID

hope that helps
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

lesley

  • I post occasionally
  • **
  • Posts: 64
  • Karma: 1
Re: Help with relationship import
April 23, 2012, 10:35:24 pm
Bewdyful! easy if u know how ;D

Thanks Pete

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Help with relationship import

This forum was archived on 2017-11-26.