Assigning usergroup based on CB field value

This is doing my head in! What do I have to do to get this to work?

My Example:

-- I have a CB Field, lets call it [cb_modulescompleted], the values are [level1], [level2], [level3] & [level4] using checkboxes.
-- I have users all in one usergroup (Registered)
-- I have 4 usergroups made up called Level1, Level2, Level3 & Level4
-- Now I want all the users with their checkbox values moved into their equivalent usergroups.

Easy you say! but here is the problem, I need to do it all in one hit because I am having all the problems mentioned in this post, I have split the 7,000 users into smaller temp usergroups about 1500 in each (e.g. registered 1500, registered2 1500 etc.), I have done this so I don't crash it when I run the process.

In the CB Auto Actions: Auto Action > Global > Access - I select the usergroup 'Registered' and the conditions are set to move anything with the value [level1] to the Level1 usergroup, all good so far. But some of the [level1] value users also have a [level2] value to them and these users will not be added to the Level2 usergroup because the next time I run the process the users that have a [level1] & [level2] have already been moved out of the registered usergroup I was sourcing it from :pinch:

Is there a way to move all level values to equivalent usergroups in one foul swoop?

You can batch process usergroups. Within CB > User Management expand Search Tools. Next select cb_modulescompleted for "- Select Field -" and set "- Select Operator" to "Contains" then input [level1]. Now select "Registered" for "- Select Group -" and hit Search. This should filter your users down to level1 users that don't have the level1 usergroup. Now select all their checkboxes and under Batch Tools select the usergroup under "- Select Groups -" you want to assign them.

If you still want to use CB Auto Actions for this then you just need to set your access properly for your usage. To do that set the access as follows for your actions.

level1
Usergroups: Registered, level2, level3, level4

level2
Usergroups: Registered, level1, level3, level4

level3
Usergroups: Registered, level1, level2, level4

level4
Usergroups: Registered, level1, level2, level3

This means level1 won't run again for users that already have level1, etc..

It doesn't matter which tool you use though. The fact is you're trying to batch store a large amount of users at once. It's going to crash. CB > User Management gives you the best chance to avoid this because you can set the page limit to something like 500 and do it in 500 user batches.