A user, Andro, successfully imported 20 years of mbox archives into Discourse, creating over 6,500 staged users. These users cannot log in or activate their accounts directly, leading to the question of how to activate them at scale. Canapin explains that staged accounts are placeholder accounts created for email integration and cannot be activated via standard means. They suggest using Rails console commands to unstage users, referencing a guide for bulk activation, but this requires technical expertise and carries risks. Andro expresses concern that this still requires manual work. Gerhard offers an alternative solution: users should sign up with their email addresses, which will convert their staged accounts into regular ones, and any duplicates can be manually merged using Discourse’s user merge feature.
So I succeeded in importing 20 years of mbox archives of an existing mailing list thanks to the good instructions on this list. Over the time period in question there are more than 6.5K unique users. They have been created as staged users, not yet activated.
My question is, for current users of that list, how do they activate their accounts? As far as I can see they cannot log in and so they can’t activate. Do I have to manually activate hundreds of individual users? What to do?
Hi Andrew 
I’m not very familiar with staged accounts. Fortunately, here’s a good explanation:
If you want to “unstage” thousands of staged users, I think you can follow these steps (they should be tweaked a bit for your case):
This may also interest you:
Rails commands are always potentially harmful, do it only if you understand what you’re doing and always do a backup of your site before
That looks to me exactly like having to do it individually for hundreds of users. Not the answer I was looking for. I may as well go through the last couple of years of posts in the web interface and manually activate.
What do other people do regarding large mbox archive imports then?
Your users need to sign-up at your new Discourse site with the same email address they used on the mailing list. Their staged user will be converted into a regular user during the sign-up.
20 years is a long time, so I assume some of your users might have used a bunch of different email addresses in all those years. I suggest they sign up with their current email address and you can manually merge the other staged users into that account.