Group functionality - Joomla & Nextcloud - i dont get it

[tschombes]

Hi all,

i tried for hours, but i really dont understand how the group function does work.
I have the following:

2 Databases - One for Joomla and one for Nextcloud

User can login with their Joomla credentials into nextcloud, so this is fine.

What i want to do is - mapping the users Joomla Groups to Nextcloud Groups.
But i dont get it to work,

All i have is: I can see Joomla's groups available in NC, but no users are mapped into it.

This is my current config:

For explanation:

fqfv3_users is Joomla users table in the Joomla Database
fqfv3_viewlevel is Joomla groups table in the Joomla Database
oc_group_user is Nextcloud groups table in Nextcloud Database

And this what the user management looks like:

There you can see the Joomla Groups available, but no users are mapped.

What i am doing wrong? could anyone help?

Thanks.

[kainhofer]

The User group table needs to be the JOOMLA table that assigns the Joomla viewlevels to the individual Joomla users, not Nextcloud's table. At a quick glance I can't seem to find where Joomla stores the user <=> viewlevel mapping. You'd need to find that database table and use this table name together with its corresponding columns.

However, I'm wondering why you are using viewlevels and not usergroups? In that case the group table would be fqfv3_usergroups (columns GID is 'id', display name is 'title') and the user group table would be fqfv3_usergroup_map (columns UID=user_id, GID=group_id).

Also, in the user table, I would use the column mapping UID=id, Username=username, Email=email, Password=password, Display name=name, Disabled=block).