Move Multiple Users at Once?

[evolution2]

I have a spreadsheet of emails that represent users I need to move to a particular usergroup of my forum and I don't know how to accomplish this without doing it one by one. Is there a way to accomplish this? I doesn't even seem I can search for more than one email address at a time. Thanks!

[Lynne]

If you go to Users > Prune/Move users, you may enter some criteria and it will make a list of users meeting that criteria along with their email. You may then just select the users with emails from your list and only move them.

[evolution2]

Thanks, I know that, but I have a list of email addresses and I can't search by multiple emails in the move/prune section so that doesn't help me accomplish what I need. I have about 20,000 emails so I can't do it manually.

[kh99]

There is no built in feature that would allow you to do that. It could be done with a php script if it could read your list of email addresses then modify the database.

[Lynne]

But if you did it via a php script, you would need to cover deleting stuff from several tables (user, usertextfield, post, thread, etc). It's better to use the built in script to delete users because they cover all the different tables.

[kh99]

That's true, but if you just wanted to move them from one primary usergroup to another and they are both just "normal" user groups, then I think it can be done just by changing the usergroup field in the user table. But I agree that it would be better to use the user data manager (in a script or through the adminCP).

[Macsee]

The user search function in vB is pretty powerful. You can search for users based on post count, IP, email address fragment/domain, registration date, etc etc. Brilliant.

In comparison, the prune option is very minimal and a big disappointment. Is there a reason why vB doesn't offer the same kind of functionality in Prune as it does in search? It would be very handy to be able to delete all the accounts using a particular .ru email address or all accounts signing up from a xxx.xxx IP.