Because privately branded partners is becoming a bigger part of our software business we have separated the Users from Entourage. Before if you create a user in EDOnline that user can be used on our EDO website and on partner privately branded websites. We have added the option to separate the users by specifying the PARTNERS table that the user_mgmt_syste = ‘SEPARATE’
To migrate a privately branded partner, you can use the following SQL to update the database. The field ‘partner_privatE_url_2’ is a development URL so we can test changes before moving to production. Just make sure to update the partner_id
update partners set partner_private_url_2 = 'mymidshipman.entourageyearbooks.com', user_mgmt_system = 'SEPARATE' where partner_id = 26201
The following SQL statement can be used to migrate the users from overlapping with entourage to updating those users to be only for the specified partner account.
update members set partner_id = 26201 where partner_id = 0 AND member_id in ( select map.member_id from yearbooks y, yearbook_member_map map where y.partner_id = 26201 and y.yearbook_id = map.yearbook_id )
That is all you need to do to migrate a PRIVATELY BRANDED partner’s users to a SEPARATE user management system.
