I recently migrated a phpBB forum with about 1400 users to Discourse. Other than a handful of accounts, all of the digests seem to be sent starting at 8 AM. Is there some way to assign the users a random time between 00:00 and 23:00? – Geoff

[صورة] Jay Pfaffman: psql discourse Thank you very much for the pointers. I decided that doing it from Rails was too much of a learning curve, so I figured out how to do it via postgres. Here was my solution: ./launcher enter app su - postgres psql discourse UPDATE user_stats SET digest_a…

I don’t know but I was told (by AI): https://ask.discourse.com/discourse-ai/ai-bot/shared-ai-conversations/wisnZ2lMtzSY1ji_QM8BiA Click saver: no, if AI knew and wasn’t hallucinating.

I think that you could modify user_stats.digest_attempted_at for all of your users with a random value. Maybe you’d add 0-24 hours to their current user_stats.digest_attempted_at value.

This is what I kind of guessed that I would have to do. However, I’m used to shared-server environments where there’s a database server that I can remotely connect to. I’m very good at SQL, but I’m lost as how to connect to the database on a DigitalOcean droplet. Any pointers would be greatly app…

You want to do it from Rails rather than modify the database directly. But you could ./launcher enter app su - postgres psql discourse and have at it. You can look at Administrative Bulk Operations and, I think, find some examples that look like users=User.where(something) users.each do |user|…

Looks right to me. I think for this it’s safe enough. I understand the go-with-what-you-know approach but Rails gives you lots of protections (making sure stuff gets enforced and tables stay connected and so on). Glad you got it sorted!

Checking the email logs, everything is now spread out evenly. Thanks for your help!

تعيين وقت ملخص عشوائي للمستخدمين؟

الدعم

GeoffSchultz (Geoff Schultz) 12 سبتمبر 2024، 2:34م 8

بالتحقق من سجلات البريد الإلكتروني، أصبح كل شيء الآن موزّعًا بالتساوي. شكرًا لمساعدتك!

الموضوع		الردود	مرات العرض
Feature Request: Make the Digest Job "Sending Time Window" Configurable Feature activity-summary	5	621	7 ديسمبر 2020
Optimize Discourse digest period Support activity-summary	11	884	22 مارس 2020
Possible to change joined date? Support	6	3433	23 يوليو 2015
Configure time of the Daily Summary Feature pr-welcome	12	2073	7 أكتوبر 2019
Change user registration date (created_at) via API Development rest-api	7	1469	28 يوليو 2021

تعيين وقت ملخص عشوائي للمستخدمين؟

الموضوعات ذات الصلة