How to Create a Script to "Bulk Remove" from a Group?

AI-generated summary

The discussion revolves around creating a script to bulk remove and add users to a Discourse group, particularly for syncing with Active Directory (AD) accounts. Selk68 seeks a solution to automate daily updates of a ‘Members Only’ group based on active AD users, currently exporting a CSV of active members. pfaffman suggests using Discourse’s API directly from the AD system instead of relying on CSV exports, emphasizing that the AD system should trigger API calls to update Discourse. Selk68 appreciates the advice and plans to explore implementation. Vishal.Kshirsagar also inquires about bulk user removal and AD integration, with pfaffman recommending the Administrative Bulk Operations guide and cautioning against AD integration unless deeply committed to it.

Continuing the discussion from Bulk add to Group:

@Falco and all, this is something that I would like to be able to do on the forum that I help run.

We have one category for “Members Only” - that is restricted to only our paid/active members - that I am able to import a list of users who currently have active accounts in our Active Directory through the Web Interface; however, there is no easy way to do a bulk remove of members who are no longer active from the group using the Web Interface.

I do have access to the server side and one of our admins already has a script to export the active accounts to a CSV file that includes the e-mail addresses of all currently active members; however, I do not know how to create a script that would remove all members from the restricted group on our forum, then add only the currently active members back to it (which sounds like basically what you are doing…). This is something that I would like to have done daily, as mentioned in the post quoted above.

Can you give me any pointers, please?

I think that what you want to do is have your developer use API calls to update Discourse when changes are made to the accounts rather than export a CSV daily. I’ve written one for the Wordpress MemberMouse plugin (I think that’s what it was).

Failing that, you might want a list of users to delete and a list of those to add, and then do something to check that both lists are actually in sync.

Thanks for taking the time to help, @pfaffman!

The reason we export the CVS daily is because we do not have our forum tied directly into our AD accounts. It was setup like that to allow anyone to register for an account on our forum. Even though we do not have our discourse instance tied into Active Directory authentication, will the API be able to pull the information from AD? (I was previously advised by some who do most of the developing for our forum that it would be best to have the active accounts exported from AD, then imported into the custom group… I am open to other options though.).

Thanks again!
:smiley:

Unless the computer managing the AD accounts is not connected to the internet, then it could update Discourse when changes are made to those accounts.

No. The AD server will be generating the API calls.

I think my point is that whatever code is generating the CSV file could just as easily generate the API calls necessary to do the updates.

Awesome! That’s great to know!!

I’ll ask around the 'Space (our makerspace, that is…) to see if someone can help me learn how to configure it!

Thanks again, I really appreciate it!! :smiley:

Hi @Selk68 @pfaffman Hi, I am looking for a solution to remove bulk users. I understand this can be done by scripting. Can you please share more details on how to run the script on the platform? Or this is something that can be done by a developer only.

Also, I read about AD. Can you please share how it works and how we can sync AD with Discourse?
Thank you.

You can have a look at Administrative Bulk Operations. That should have some clues.

If AD means windows active directory, i would avoid it unless you are already deeply committed to it. I think there might be some thing that will let you use it as sso, but you’d have to pay me lots I money to find out about it.

Hi @pfaffman Thank you for your time and response. I will explore the administrative bulk operation with the command line.