Importing relationship details

[SarahG (FountainTribe)]

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?

[Donald Lobo]

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

[petednz]

HI Sarah - just wonder if you did any work on this or just sidestepped as i suspect we will

[SarahG (FountainTribe)]

I did not make any progress on this.

[Erik Hommel]

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 :-)

[erwindeclerck]

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

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)]

My solution to this issue is to use SQL INSERT syntax to create the relationship records in the table "civicrm_relationship"