Answers.Body: <p>I don't think there's a way in the user interface but if you're comfortable with directly accessing the database and don't need to update any timelines/activities you can do something like:</p>
  
  <pre><code>UPDATE civicrm_case SET case_type_id = CONCAT(CHAR(1), '8', CHAR(1)) WHERE case_type_id = CONCAT(CHAR(1), '1', CHAR(1));
  </code></pre>
  
  <p>This would take the ones who have case type 1 and convert them to 8. You'd have to look and see what the existing numbers are:</p>
  
  <pre><code>select ov.label, ov.value from civicrm_option_group og inner join civicrm_option_value ov on (ov.option_group_id = og.id and og.name = 'case_type');
  </code></pre>
  
  <p>And of course do this on a test site first, and make a backup.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-11T01:14:36.870Z
Answers.Text: Sounds reasonable.
Answers.UserDisplayName: Leslie
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-11T01:15:42.650Z
Answers.Text: If I use PHPMyAdmin, where to I plug in the above script? Or do I use another program?
Answers.UserDisplayName: Leslie
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-11T10:12:27.553Z
Answers.Text: You can do this with any program that allows you to access the MySQL database (including the command terminal) but certainly with PHPMyAdmin!
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-10T23:38:59.347Z
Answers.LastActivityDate: 2016-03-10T23:38:59.347Z
Answers.UserDisplayName: Demerit
Body: <p>I would like to consolidate the case types that I have created for CiviCase. </p>
  
  <p>Is there a way to merge two or more case types into a broader category so that the cases once assigned to these more narrow case types can assume the new, broader case type?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-03-10T22:35:14.923Z
Comments.Text: How many cases are we talking about converting?
Comments.UserDisplayName: Coleman
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-03-10T23:21:40.903Z
Comments.Text: We currently have 21 case types. We want to reduce this number to 9 by deleting a few and combining the rest. Some of the new case types we want to create may incorporate up to 3 existing case types.
Comments.UserDisplayName: Leslie
Tags: <civicase>
Title: Merging case types in CiviCase
ThreadText: # Merging case types in CiviCase
  
  (Asked by: username_0 on 2016-03-10)
  
  I would like to consolidate the case types that I have created for CiviCase.
  
  Is there a way to merge two or more case types into a broader category so that the cases once assigned to these more narrow case types can assume the new, broader case type?
  
  **Tags:** civicase
  
  > **Comments:**
  > **username_1**: How many cases are we talking about converting?  
  > **username_0**: We currently have 21 case types. We want to reduce this number to 9 by deleting a few and combining the rest. Some of the new case types we want to create may incorporate up to 3 existing case types.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2016-03-10. Score: 3
  
  I don't think there's a way in the user interface but if you're comfortable with directly accessing the database and don't need to update any timelines/activities you can do something like:
  UPDATE civicrm_case SET case_type_id = CONCAT(CHAR(1), '8', CHAR(1)) WHERE case_type_id = CONCAT(CHAR(1), '1', CHAR(1));
  
  This would take the ones who have case type 1 and convert them to 8. You'd have to look and see what the existing numbers are:
  select ov.label, ov.value from civicrm_option_group og inner join civicrm_option_value ov on (ov.option_group_id = og.id and og.name = 'case_type');
  
  And of course do this on a test site first, and make a backup.
  
  > **Comments:**
  > **username_0**: Sounds reasonable.  
  > **username_0**: If I use PHPMyAdmin, where to I plug in the above script? Or do I use another program?  
  > **username_3**: You can do this with any program that allows you to access the MySQL database (including the command terminal) but certainly with PHPMyAdmin!  
  
  ---
  
  