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) »
  • Importing relationship details
Pages: [1]

Author Topic: Importing relationship details  (Read 2735 times)

SarahG (FountainTribe)

  • Ask me questions
  • ****
  • Posts: 782
  • Karma: 29
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 6, Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Importing relationship details
January 20, 2010, 09:09:54 pm
I have a CSV file that I am able to use to import relationships. Now I am trying to import the start date for the relationship, and other custom fields for this relationship type.  How can I do this?
Did I help you? Please donate to the Civi-Make-It-Happen campaign  CiviCRM for mobile devices! 

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: Importing relationship details
January 20, 2010, 09:20:53 pm

you'll need to write a custom import script for relationships. the current import for relationships is pretty limited and basically just creates a simple relationship

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

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: Importing relationship details
April 06, 2010, 03:06:39 am
HI Sarah - just wonder if you did any work on this or just sidestepped as i suspect we will
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

SarahG (FountainTribe)

  • Ask me questions
  • ****
  • Posts: 782
  • Karma: 29
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 6, Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Importing relationship details
April 06, 2010, 09:11:18 am
I did not make any progress on this.
Did I help you? Please donate to the Civi-Make-It-Happen campaign  CiviCRM for mobile devices! 

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Importing relationship details
April 07, 2010, 09:20:27 am
Let me know if you need any assistance? I have developed a few imports into CiviCRM. There is an example on the Wiki using API's:
http://wiki.civicrm.org/confluence/display/CRMDOC/Using+CiviCRM+APIs+-+Code+Snippets#UsingCiviCRMAPIs-CodeSnippets-ExampleofconversionusingAPI%27s%28contact%2Cgroup%2Ctag%2Clocation%2Crelationship%29

although I could have handled the code better, it gives an impression :-)
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

erwindeclerck

  • I’m new here
  • *
  • Posts: 12
  • Karma: 0
  • CiviCRM version: 4.4.9 + 4.5.2 + 4.5.4 + 4.5.5
  • CMS version: 7
  • MySQL version: 5.5.40
  • PHP version: 5.3.10-1ubuntu3.15
Re: Importing relationship details
March 03, 2015, 11:39:07 pm
Hi Erik,

I know this is an old post but I'm desperately seeking for a solution to import start and end date for relationships.
The api, nor the import mapper provides this possibility.
You once posted this snippet, but it isn't online anymore.
Could you give me a hint on how to start? (I have installed the https://github.com/eileenmcnaughton/nz.co.fuzion.csvimport extension)

Kind regards,
Erwin


Quote from: Erik Hommel on April 07, 2010, 09:20:27 am
Let me know if you need any assistance? I have developed a few imports into CiviCRM. There is an example on the Wiki using API's:
http://wiki.civicrm.org/confluence/display/CRMDOC/Using+CiviCRM+APIs+-+Code+Snippets#UsingCiviCRMAPIs-CodeSnippets-ExampleofconversionusingAPI%27s%28contact%2Cgroup%2Ctag%2Clocation%2Crelationship%29

although I could have handled the code better, it gives an impression :-)

SarahG (FountainTribe)

  • Ask me questions
  • ****
  • Posts: 782
  • Karma: 29
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 6, Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Importing relationship details
March 04, 2015, 02:55:01 am
My solution to this issue is to use SQL INSERT syntax to create the relationship records in the table "civicrm_relationship"
Did I help you? Please donate to the Civi-Make-It-Happen campaign  CiviCRM for mobile devices! 
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Importing relationship details

This forum was archived on 2017-11-26.