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 h…

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" …

@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, the…

[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. Y…

@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…

[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 t…

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 '#{messa…

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 24, 2025, 10:37pm 6

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.).

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

Script for sending welcome message in background

Related topics