Answers.Body: <p>I can heartily recommend Eileen's (obviously) Excellent &quot;CSV API Importer&quot; extension
  <a href="https://i.sstatic.net/9gvJY.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/9gvJY.png" alt="import screenshot- relationship options" /></a></p>
  <p><a href="https://github.com/eileenmcnaughton/nz.co.fuzion.csvimport/blob/master/README" rel="nofollow noreferrer">https://github.com/eileenmcnaughton/nz.co.fuzion.csvimport/blob/master/README</a></p>
  <p>Don't have relationship custom data on our set up so can't answer that aspect- but most other relationship fields are there</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-05-11T12:17:39.160Z
Answers.Text: Thanks Craig, this is helpful-ish as it assumes we know the (civi or external) contact ID of the two contacts, which means its a lot of manual work to use this.
Answers.UserDisplayName: artfulrobot
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-05-11T13:24:46.623Z
Answers.Text: I guess with any import where you're bringing in different entities you'd have to break it into stages
  1)import contacts with ext id
  2) import relationships
Answers.UserDisplayName: Craig Almond
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-05-12T08:35:22.300Z
Answers.Text: Yes, that's a very likely expectation for a clever tech person like youself. And I don't doubt it's true. But from a user point of view, it's terrible! (1) split spreadsheet into separate sheets and make unique lists of contacts. (2) import each list of contacts separately (3) obtain their CiviCRM IDs somehow and merge back in to spreadsheet manually or risking a hideous VLOOKUP (4) Import the relationships (5) import the ... (activities/contributions/...).
Answers.UserDisplayName: artfulrobot
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-05-12T12:44:20.180Z
Answers.Text: Oh absolutely, it's a massive ball ache.   To use my highly developed clever tech person language.
  
  And I hate and avoid imports for this very reason.
Answers.UserDisplayName: Craig Almond
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-05-10T18:05:45.860Z
Answers.LastActivityDate: 2022-05-10T18:05:45.860Z
Answers.UserDisplayName: Craig Almond
Body: <p>I can see that I can import relationships as part of the <strong>Contacts » Import</strong> form, but it only seems to let me say that Contact A <em>is &lt;predicate&gt; of</em> Contact B.</p>
  <p>Relationships have: start, end dates, current status (&quot;is active&quot;), note, title + possibly custom fields (I think). Is it possible to populate any of those via an import? Are there extensions that provide this functionality?</p>
  
Tags: <import><relationships>
Title: How to import relationships with metadata
ThreadText: # How to import relationships with metadata
  
  (Asked by: username_0 on 2022-05-04)
  
  I can see that I can import relationships as part of the **Contacts » Import** form, but it only seems to let me say that Contact A *is  of* Contact B.
  
  Relationships have: start, end dates, current status ("is active"), note, title + possibly custom fields (I think). Is it possible to populate any of those via an import? Are there extensions that provide this functionality?
  
  **Tags:** import, relationships
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-05-10. Score: 2 | Accepted answer
  
  I can heartily recommend Eileen's (obviously) Excellent "CSV API Importer" extension
  [![import screenshot- relationship options](https://i.sstatic.net/9gvJY.png)](https://i.sstatic.net/9gvJY.png)
  
  <https://github.com/eileenmcnaughton/nz.co.fuzion.csvimport/blob/master/README>
  
  Don't have relationship custom data on our set up so can't answer that aspect- but most other relationship fields are there
  
  > **Comments:**
  > **username_0**: Thanks Craig, this is helpful-ish as it assumes we know the (civi or external) contact ID of the two contacts, which means its a lot of manual work to use this.  
  > **username_1**: I guess with any import where you're bringing in different entities you'd have to break it into stages 1)import contacts with ext id 2) import relationships  
  > **username_0**: Yes, that's a very likely expectation for a clever tech person like youself. And I don't doubt it's true. But from a user point of view, it's terrible! (1) split spreadsheet into separate sheets and make unique lists of contacts. (2) import each list of contacts separately (3) obtain their CiviCRM IDs somehow and merge back in to spreadsheet manually or risking a hideous VLOOKUP (4) Import the relationships (5) import the ... (activities/contributions/...).  
  > **username_1**: Oh absolutely, it's a massive ball ache.   To use my highly developed clever tech person language.  And I hate and avoid imports for this very reason.  
  
  ---
  
  