Bulk Award a badge to a set of users

[Aicnal_Liueic]

I have a question about how to give the user bulk award automately.
As a admin, I don’t wannt do it manually anytime.

[nathank (Nathan Kershaw)]

Hi Aicnal - welcome to Meta Discourse!

Have you read the original post of this topic? I find it works pretty well. Happy to help with any questions on top of that.

[Aicnal_Liueic]

@nathank

the original post of this topic

Yes, sir. Thanks for your help. And I have read it already.

@Roman_Rizzi

Select the badge you want to award and upload a CSV file containing a list of user emails or usernames (one per line)

But the posts says we should “upload a CSV file” to give the user bulk award. My question is that one time if the User Group changed and we should upload the file again.

Why can we just select a specific rule and if the user achieve the rule, the system will give the user bulk award automatically. Just like the achievement in games.

And I’m so sorry for my poor English!

[Moin]

You can

Enable Badge SQL

This guide explains how to enable Badge SQL in Discourse and discusses the associated security and performance risks. Required user level: Administrator Enabling Badge SQL can pose security and performance risks. To maintain security and performance integrity, as of Discourse 1.6, the ability for administrators to edit badge SQL directly is disabled by default. The two primary concerns around enabling Badge SQL are: Security: Allowing direct SQL…

Creating triggered custom badge queries

This guide explains how to create triggered custom badge queries in Discourse, including the types of badges, constraints for triggered badges, and an example query. Required user level: Administrator This feature is disabled by default. To enable it, follow this guide. When defining badges in Discourse, you’ll encounter a “Trigger” option with the following choices: Update daily When a user acts on a post When a user edits or creates a post Wh…

[Aicnal_Liueic]

That 's great. This is what I expected.

[gassim (Al-Gassim Sharaf Addin)]

Hi

Is there a way to also mention the badge reason when using the Bulk Award feature? I asked about this two years ago but never got a solution.

If there is a way using CSV, it’ll be very helpful because when we bulk award some of the badges they could be related to certain events topics. For instance, the badge “Academy Participant” is awarded to those who attended any of the academies, so when awarding this badge, our topic reason is the academy announcement. When a person attends several academies (or even only one), in their profile, they’ll have the badge “Academy Participant” as well as link to the specific ‘reason’ (Academy they attended) topic.

I hope my use case is understandable. Thanks!

[pfaffman (Jay Pfaffman)]

It doesn’t look like this will let you add a reason. If you have access to rails, you could do it there; if you can use badge sql, and there’s something in the database you can use to identify the people (e.g., all in a certain group), you could use badge SQL, oh, but that still won’t let you link a topic.

[gassim (Al-Gassim Sharaf Addin)]

Thanks! @pfaffman, normally I would rather use the API but that’s not an option unless I do it one by one such as have a Postman runner and the list of users.

[pfaffman (Jay Pfaffman)]

So this is a feature request.

I think your only short-term solution is rails.