Hi Michael,
Yes, I have tried that for one user and it seems to work, but as you said that is a lot of work to do.
I have created an account called “Global Address Book” and shared that, but that will require a lot of work to do it one user at a time.
I have been playing around with creating a table in MySql called contacts, but for some reason the data is not showing up up.
This part of the sogo.conf file.
{
displayName = “Global Address Book”;
type = sql;
id = global_address_book;
“mysql://sogo:bOLhJMp8AsFabEpnVJFePmnTKSH6x24J@127.0.0.1:3306/sogo/contacts”;
canAuthenticate = NO;
isAddressBook = YES;
listRequiresDot = NO;
SOGoEnableDomainBasedUID = YES;
DomainFieldName = “domain”;
},
I have created a new view and renamed a couple of the column names to match the ‘users’ view and that seems to work, although there is only a couple of columns.
This has lead me to believe that for me to get this to work, the columns need to have very specific names.
Are you able to tell me what those column ( attribute) names should be?
By doing it this way we can then create a php web page on the internal customer portal, so a the users will be able to edit/update their own details, and only administrators can add new accounts, or even create a Db trigger to add a new account to the contacts table, then as part of the onboarding the user and update the rest of their details.
I understand that this will only be read only, but it will solve 80% of the problem ( and 80:20 rule is good)
Thanks for all you help so far, greatly appriciated.