Just reporting back on what we wound up doing here, in case it’s of use to others. In short, we’re exporting to Excel, getting Excel to work out who fits our ‘AND’ criteria, then bulk adding those users into a group.
We had our tech assistant look into a custom plug-in to do the same thing, but it looks like it’s proving a little tricksy, so for the moment we’re staying with Excel.
More details:
- Export whole user database.
- Import to Excel. Use ISNUMBER and SEARCH to extract users in a specific group in the first sheet to a second sheet.
- Use ISNUMBER and SEARCH again to extract users in the second specific group to a third sheet.
- Bulk add those users into their appropriate groups.
I imagine there’s a cleaner way to achieve the same outcome, however now that it’s in place, it’s just a question of pasting the exported data each time, and then importing the results, without needing to think about it on the way through.
We’re using this system to reward tl3 ‘regular’ users with additional privileges and early access to things, and it’s having the desired effect of encouraging higher quality and higher quantity usage. So, success, albeit a bit clunky and un-automated. We have our ‘this group AND that group’ function.