AppGini Community Forums

Is there a way to assign records I am importing on a schedule in mysql to groups based on the value in a column in the data I am importing?

Any ideas on this board?

I use the following in ini hook:

In my case I use a field called Group where I assign the Group Number and that number is used to assig the user records automatically
Anytime the Group is changed it is assigned to the new group.


sql("UPDATE membership_userrecords
left join Delivery
on YOURTABLE.ID = membership_userrecords.pkValue
set membership_userrecords.groupID = YOURTABLE.Group
where membership_userrecords.tableName = 'YOURTABLE' ",$eo);

You can go from here.

thanks AhmedBR, I am looking for a file called ini hook, but I don't have it? Do you know where this would go?

it is init (not ini, the t must have fallen) hook is a function in EVERY file (each table has one) in the HOOK folder.

Take a look at this tutorial about using hooks:
https://bigprof.com/appgini/help/advanc ... ename_init