Answers.Body: <p>This is possible in one of two ways:</p>
  
  <ul>
  <li>Use the <a href="https://civicrm.org/extensions/api-csv-import-gui" rel="noreferrer">API CSV Import GUI extension</a>.  This will allow you to import relationships with start/end dates.  As a matter of workflow, you'll probably end up exporting existing relationships and reimporting via the extension.</li>
  <li>Make the changes directly in SQL, in the <code>civicrm_relationship</code> table.</li>
  </ul>
  
  <p>There's actions to add relationships between contacts and a household/organization in the search action menu, but what you're describing doesn't exist out of the box.  I certainly think it's a good candidate for a <a href="https://civicrm.org/paid-issue-queue" rel="noreferrer">sponsored improvement</a> though.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-06-12T07:02:31.437Z
Answers.Text: I'm trying to update the current relationships in CiviCRM through the import process.
  There is no field for set active/inactive the current relationship in basic import process of CiviCRM.
  Then I saw your solution, installed the extension and tried to inactive the current relationships.
  I use contact_id_a and contact_id_b and relationship_type id and set the is_active to 0 in csv file. But this extension gives me an error "Error with entity "create"! (Duplicate Relationship)". I'm going to update this relationship but this extension tries to create a relationship and fails because this relatio
Answers.UserDisplayName: Mehrnoosh
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-08T18:33:34.213Z
Answers.LastActivityDate: 2015-07-08T18:33:34.213Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>With SearchKit, probably from version 5.43, it will be possible to do in-place edits of relationship fields as start and end dates, is active and custom fields. <a href="https://github.com/civicrm/civicrm-core/pull/21533" rel="nofollow noreferrer">https://github.com/civicrm/civicrm-core/pull/21533</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-09-19T19:08:25.190Z
Answers.LastActivityDate: 2021-09-19T19:08:25.190Z
Answers.UserDisplayName: Francesc Bassas i Bullich
Body: <p>Is there a way to batch update relationships, specifically the type of relationship along with the start and end date? </p>
  
  <p>I don't see the fields to add to a profile to do a batch update. I also don't see a way on import to add a start and end date to the relationship mapping. </p>
  
Tags: <relationships>
Title: Batch Update Relationships
ThreadText: # Batch Update Relationships
  
  (Asked by: username_0 on 2015-07-08)
  
  Is there a way to batch update relationships, specifically the type of relationship along with the start and end date?
  
  I don't see the fields to add to a profile to do a batch update. I also don't see a way on import to add a start and end date to the relationship mapping.
  
  **Tags:** relationships
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2015-07-08. Score: 5
  
  This is possible in one of two ways:
  
  * Use the [API CSV Import GUI extension](https://civicrm.org/extensions/api-csv-import-gui). This will allow you to import relationships with start/end dates. As a matter of workflow, you'll probably end up exporting existing relationships and reimporting via the extension.
  * Make the changes directly in SQL, in the `civicrm_relationship` table.
  
  There's actions to add relationships between contacts and a household/organization in the search action menu, but what you're describing doesn't exist out of the box. I certainly think it's a good candidate for a [sponsored improvement](https://civicrm.org/paid-issue-queue) though.
  
  > **Comments:**
  > **username_2**: I'm trying to update the current relationships in CiviCRM through the import process. There is no field for set active/inactive the current relationship in basic import process of CiviCRM. Then I saw your solution, installed the extension and tried to inactive the current relationships. I use contact_id_a and contact_id_b and relationship_type id and set the is_active to 0 in csv file. But this extension gives me an error "Error with entity "create"! (Duplicate Relationship)". I'm going to update this relationship but this extension tries to create a relationship and fails because this relatio  
  
  ---
  
  ### Answer by username_3 on 2021-09-19. Score: 1
  
  With SearchKit, probably from version 5.43, it will be possible to do in-place edits of relationship fields as start and end dates, is active and custom fields. <https://github.com/civicrm/civicrm-core/pull/21533>
  
  
  ---
  
  