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


(Lisa Selk) #1

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?


(Jay Pfaffman) #2

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.


(Lisa Selk) #3

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:


(Jay Pfaffman) #4

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.


(Lisa Selk) #5

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: