[SOLVED] Auto action recipe for connecting users ?

Ok it works with [gid] but not [gids] so user's that belong to multiple groups are not assigned. (maybe they will be assigned to the first group, but the groupJive groups are not all created.)

Also, I have 250 groupjive's groups to create (there's 250 J! groups...) so it means 250 triggers...
Well, is there a better way ?
Or an automated way to create GJ groups based on J§ groups ?
I guess no...

Thanks !

Ok it works with [gid] but not [gids] so user's that belong to multiple groups are not assigned. (maybe they will be assigned to the first group, but the groupJive groups are not all created.)

Ensure you're using the Contains operator as Equal To won't properly match for gids.

Also, I have 250 groupjive's groups to create (there's 250 J! groups...) so it means 250 triggers...
Well, is there a better way ?
Or an automated way to create GJ groups based on J§ groups ?
I guess no...

Your guess is correct. You'd need 250 autos to automate creation and/or joining. I suppose you could create a database query and insert the groups into database using phpmyadmin that pulls information from the usergroup table. Once done run GJ tools so it can run some fixes (creates owners, etc..). That'd definitely speed up the process, but is going to take some good SQL experience. Below is an example of how this'd work.

stackoverflow.com/questions/10007990/mysql-while-loop-select-and-insert

What's that for? CB Query Field? If CB Query Field it only shows the result of 1 row. You'd need to set "Output" to "Multiple Rows". As explained above you don't need this for the CB Auto Actions though.

CB Query field, I wanted to use that for GJ, but also needed for some other use...Multiple rows returns nothing !

I've seted up the 3 fields:
[gid]
[gids]
[usertype]
With Does contain, and it's not functionning for multiple groups
In fact, I can't add multiple conditions, if I do that, it does not join anything.
I may have only [gid] working, for a user that belongs to one group only.

This is really anoying... :woohoo:

EDIT : silly me ! Seems to work perfectly with "smple" users, it does not work with super users that have multiple groups...
I may see all groups, but I can't be added automaticaly...

Multiple rows returns nothing !

You need to configure the row display. Example as follows.
Mode: Internal
Output: Multiple Rows
Row: [column_group_name]

I've no idea why [gids] isn't working. You may want to try the below instead.

[cb:if gids includes "8"]1[/cb:if] Equal To 1

The above trys to check that the user is a Super User (adjust as necessary).

Ok for super user thing, I'll test on monday...
It works perfectly for the query !
But how do I separate values with a coma for instance ?
I guess it's with the header and footer field, but I don't get how it works...

Big thanks !

Below will give you a comma seperated list.
Mode: Internal
Output: Single Row