Question

Photo of Kelley Langkamp

0

Changing Group Type

So we've run into a few times where groups get entered as the wrong group type either by accident or because the admin was given the wrong information. We've had to make a new group with the correct group type then do a bulk update to move everyone from the original group to the correct group. I could just change it through SQL but have been reluctant to do so partly as a training issue and partly because I would really prefer not to mess with our production database unless absolutely necessary.

All that being said, it looks like there are going to be a few times where doing it through SQL might be my best option so as to not lose attendance history. In theory, it seems like it shouldn't be a big deal to update just that one field. Am I missing any problems that might be caused by this?

  • Photo of Arran France

    0

    You're absolutely fine to just change that one GroupTypeId in order to keep Attendence History, I've done this. If I remember correctly I had to restart Rock afterwards but that could be poor recollection on my part -- I think I shared my experience elsewhere in the Q&A so may want to try and track that down.

  • Photo of Jim Michael

    0

    Are your group types in a hierarchy? Pretty sure if you "re-parent" a group of one type under a parent of a different type, it will inherit the parent's grouptype. I'm not sure if changing a group from one type to another won't cause problems with things like group type attributes, though.