Hello, I’m interested in sending a welcome message to our large user base as a background process, so: Create the message Queue users Send message to each user, one at a time, one per second until the full list is done Also would like to organize the send by most recent login/visit Does anyone have any idea how to do this, or if someone can write a script to do this?

ask.discourse.org output a good starting point, as a rails script: MAX_MESSAGES = 1000 # Optional limit for testing SECONDS_BETWEEN_MESSAGES = 3 # 3 second interval Rails.logger.info "Starting bulk message script..." # Define the content of your message message_title = "Welcome to Our Community" message_body = "Hello! We're so excited to have you here. Let us know if you have any questions!" # Fetch users ordered by last seen users = User.where(active: true) .where.not(staged: true) # Exclude staged users .order(last_seen_at: :desc) .limit(MAX_MESSAGES) Rails.logger.info "Found #{users.count} active users to message." users.each_with_index do |user, index| begin Rails.logger.info "Queuing message for #{user.username} (#{index + 1}/#{users.count})..." PostCreator.create!( Discourse.system_user, title: message_title, raw: message_body, archetype: Archetype.private_message, target_usernames: user.username, skip_validations: true ) Rails.logger.info "Message successfully queued for #{user.username}." # Wait for the specified interval before processing the next user sleep(SECONDS_BETWEEN_MESSAGES) rescue => e Rails.logger.error "Failed to send message to #{user.username}: #{e.message}" end end Rails.logger.info "Bulk message script completed!" I didn’t do any modification, and the user system sent the MP to all my users in my test instance: [The image shows a messaging system with an inbox section containing a single email thread labeled "Welcome to Our Community" with multiple perspective icons and timestamps. (Captioned by AI)] [The image is a screenshot of a community welcome message along with an option to add or remove a camera overlay filter, with 1 view and a timestamp of 3 minutes. (Captioned by AI)] How many users do you have?

@Canapin first that’s an amazing handle…but your response is even more amazing! This is really right along the lines of what we want to do. Some more detail. We have 3.5 million users. We do not plan to send to all of them at once, the idea would be to run this script, maybe for batches of 10k, then stop for a few days, see what kinda of activity we have, check email reputation, and then start again, and so on. We would like to send this though from an admin with a profile rather than ‘system’, I assume that’s possible? Again, thanks so much, very very helpful.

[image] Jacob Peebles: We would like to send this though from an admin with a profile rather than ‘system’, I assume that’s possible? Yes, just replace system with the desired username in the script. Sorry, I skimmed the code, there is no system to replace, so it must be done another way. You’ll probably want to use a session manager like screen or tmux so your script can run in the background. I assume you’ll also want to be able stop the script when desired and restart it later from the user it stopped at. Since I’m not a programmer (I mean, besides printing hello world…), I’ll let others give advice on how to set up this feature properly, as well as safely managing the sending to millions of users :smile:

@Canapin All sensible, and thanks. Yes I am thinking there is a way to just do some sort of count of records the system would run through, so basically it would just stop itself, but understood on the other options. If anyone else has any ideas on how to make this more automated (run for batches of 10k users for example) that would be great.

[image] Jacob Peebles: Yes I am thinking there is a way to just do some sort of count of records the system would run through, so basically it would just stop itself Yeah. If I were to create this kind of script, I’d set up something that would allow me to restart from the last user in case the script is forcibly interrupted by something (server restart, crash…, etc.).

Here’s the updated script with the sender username: MAX_MESSAGES = 1000 # Optional limit for testing SECONDS_BETWEEN_MESSAGES = 3 # 3 second interval SENDER_USERNAME = "coco" message_sender = User.find_by(username: SENDER_USERNAME) if message_sender.nil? Rails.logger.error "Sender user '#{message_sender_username}' not found!" exit end Rails.logger.info "Starting bulk message script..." # Define the content of your message message_title = "Welcome to Our Community" message_body = "Hello! We're so excited to have you here. Let us know if you have any questions!" # Fetch users ordered by last seen users = User.where(active: true) .where.not(staged: true) # Exclude staged users .order(last_seen_at: :desc) .limit(MAX_MESSAGES) Rails.logger.info "Found #{users.count} active users to message." users.each_with_index do |user, index| begin Rails.logger.info "Queuing message for #{user.username} (#{index + 1}/#{users.count})..." PostCreator.create!( message_sender, title: message_title, raw: message_body, archetype: Archetype.private_message, target_usernames: user.username, skip_validations: true ) Rails.logger.info "Message successfully queued for #{user.username}." # Wait for the specified interval before processing the next user sleep(SECONDS_BETWEEN_MESSAGES) rescue => e Rails.logger.error "Failed to send message to #{user.username}: #{e.message}" end end Rails.logger.info "Bulk message script completed!"

That is bonus @Canapin - we will run this likely tomorrow, if we adjust further we will post back here with updates… CC: @Abdelrahman_MoHamed

[image] Jacob Peebles: I assume that’s possible? Likely, you’ll need to edit this line: [image] Coconut Flavored Quark: Discourse.system_user

[image] Nate Dhaliwal: Likely, you’ll need to edit this line: [image] Canapin: Discourse.system_user My last reply already contains the needed changes.

Another question here. Does anyone have any idea how to keep track of where the script is in the process? For example we send 10k emails and stop. Then want to start again, how would we know which record to start with?

Script for sending welcome message in background

Product Support

Canapin (Coin-coin le Canapin) January 25, 2025, 12:21pm 10

My last reply already contains the needed changes.

Topic		Replies	Views
Send a message to Trust Level 0 (only) users Product Support	2	166	February 9, 2025
Send password reset emails in bulk? Product Support	12	831	January 9, 2025
Scripting to trigger "Welcome" email to new users Product Support	10	2046	January 13, 2016
Ruby script to send automatic welcome message to new users Development	1	1550	February 9, 2021
Email drip campaign Feature	14	3110	March 22, 2020

Script for sending welcome message in background

Related topics