Answers.Body: <p>Okay, so this is a bit of a workaround but it does the job.</p>
  <ol>
  <li><p>In Drupal 7 Views or SearchKit, you can build a table that shows all case relationship that are active for a specific case manager (filter by case type and/or case relationship if needed). The columns you want are: case_id, contact a (the client), contact b (the old case manager), relationship type a-to-b, case start date, and case end date. You will want to export this list on a spreadsheet.</p>
  </li>
  <li><p>Next, assign an &quot;End Date&quot; to all the cases. This step will disable the active relationships and put an case &quot;end date&quot;. If you are doing this in Drupal Views, get the &quot;Views Bulk Operations VBO&quot; module so you can modify the entities. Set active relationship = 0 and specify case end date.</p>
  </li>
  <li><p>Lastly, use the spreadsheet you downloaded to create a CSV import to CiviCRM. The columns should be something like: civicrm_relationship_type, case_id, contact_id_a, contact_id_b, and case_start_date. This allows you to make a new relationship for the client (client_id_a), for a specific case (case_id), to a new staff (contact_id_b) with a case start date (case_start_date).</p>
  </li>
  </ol>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-09-21T19:34:43.153Z
Answers.LastActivityDate: 2022-09-21T19:34:43.153Z
Answers.UserDisplayName: Kristine
Body: <p>What is the best way to reassign a case manger for multiple cases in CiviCase? For example, a case manager is leaving the organization and we need to reassign these cases to a new person. I can go to each case and reassign the case role, but I'm wondering if there's another way this can be done in a bulk process.</p>
  <p>I'm thinking maybe one possibility is to place all the cases into a group and then adding a &quot;new relationship&quot; through Manage Groups. Then I guess disabling the previous relationships manually through the person's contact record.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-05-07T04:56:03.050Z
Comments.Text: Actually... "Add relationship" only applies to adding relationships to contacts and not case roles..
Comments.UserDisplayName: Kristine
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-07-21T13:04:55.343Z
Comments.Text: I would also appreciate the possibility to change a role/person for multiple cases. Any idea how to do that?
Comments.UserDisplayName: Karel Hennhofer
Tags: <civicase><roles>
Title: Reassign Role in Multiple Cases
ThreadText: # Reassign Role in Multiple Cases
  
  (Asked by: username_0 on 2022-05-02)
  
  What is the best way to reassign a case manger for multiple cases in CiviCase? For example, a case manager is leaving the organization and we need to reassign these cases to a new person. I can go to each case and reassign the case role, but I'm wondering if there's another way this can be done in a bulk process.
  
  I'm thinking maybe one possibility is to place all the cases into a group and then adding a "new relationship" through Manage Groups. Then I guess disabling the previous relationships manually through the person's contact record.
  
  **Tags:** civicase, roles
  
  > **Comments:**
  > **username_0**: Actually... "Add relationship" only applies to adding relationships to contacts and not case roles..  
  > **username_1**: I would also appreciate the possibility to change a role/person for multiple cases. Any idea how to do that?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2022-09-21. Score: 3 | Accepted answer
  
  Okay, so this is a bit of a workaround but it does the job.
  
  1. In Drupal 7 Views or SearchKit, you can build a table that shows all case relationship that are active for a specific case manager (filter by case type and/or case relationship if needed). The columns you want are: case\_id, contact a (the client), contact b (the old case manager), relationship type a-to-b, case start date, and case end date. You will want to export this list on a spreadsheet.
  2. Next, assign an "End Date" to all the cases. This step will disable the active relationships and put an case "end date". If you are doing this in Drupal Views, get the "Views Bulk Operations VBO" module so you can modify the entities. Set active relationship = 0 and specify case end date.
  3. Lastly, use the spreadsheet you downloaded to create a CSV import to CiviCRM. The columns should be something like: civicrm\_relationship\_type, case\_id, contact\_id\_a, contact\_id\_b, and case\_start\_date. This allows you to make a new relationship for the client (client\_id\_a), for a specific case (case\_id), to a new staff (contact\_id\_b) with a case start date (case\_start\_date).
  
  
  ---
  
  