Hi Andy,

The mass assignment feature does not rely on points_id or any points rule. It only assign points to the user.

As such, the points_id would be 0 in the points history table when users are mass assigned points.

It is not possible to integrate points_id into the mass assign feature currently.

Thanks Raymond... That's promising for what I have in mind. Two follow-on questions if you can help on these...

1) How does the system use and generate a points_id? Is it a direct link to a points rule. So 1 points_id number = 1 points rule?

2) Could I do a simple SQL to assign known UserIDs a number of points and make up a points_id that ES wouldn't be generating itself (for example alpha characters if that field allows) - so could I assign UserID 100 and UserID 150 a number of points and use the same points_id of ABTEST for example?

What I'm actually trying to do is find a way I can start allocating points by SQL but with some kind of common category code so that I can do other SQL statements to report on points allocated by these categories. I'm wondering if I can use 'points_id' field to do this.

OK that's wonderful. Thanks for all the help. I now understand and I can achieve what I want with this.

I need a few 'safe' numbers to use for my points_id but realise I can create 'dummy' points rules hopefully with criteria that would never trigger automatically (I will have to work something that works - I'll check ES points rule creation documentation) and then use their points_id numbers.

This will work because I'll be assigning by SQL rather than CSV upload actually.

Awesome.

Sorry just need one further bit of guidance... I'm looking at https://stackideas.com/docs/easysocial/developers/points/rule-file

Can you give me an example of a points file which wouldn't actually get triggered - it's just what to put on that 'application' line, 'extension' line, and 'state' line I think I need to understand....

Below is what I'm trying.. so (a) what goes in the command line? (b) is it safe to leave extension as "com_easysocial" and (c) state - is that just whether the points rule is active or not?

[
{
"title" : "PointsBySQL",
"alias" : "points-sql-rule1",
"description" : "Here are some points",
"command" : " ? what do I put here ?",
"extension" : "com_easysocial",
"state" : true,
"points" : 0
}
]

Hey Andy,

You can leave the extension as 'com_easysocial' and state as true. The state is just whether the points rule is published and active.

The command line is actually for developers to use in their function when they want to trigger the points from there.

Since you are only assigning points for your point rule via database manipulation, you can put anything in the command line.

Brilliant. Thanks for confirming!

You're most welcome Andy.

Regards.