|
SugarCRM 5.0 Community Edition's Portal Support |
|
|
|
Written by Paul Winkeler
|
|
Tuesday, 08 January 2008 |
With the 4.5 edition of SugarCRM's Community edition it was possible to activate the portal feature in the Administration System Settings panel and subsequently assign contacts their portal names on the Contact editing form. However, with the 5.0 release this ability to edit the portal related attributes of a contact has been removed from the community edition and, to make matters worse, the upgrade process has some logic to explicitly disable portal access for all contacts! Here I provide a few simple SQL statements you can use to restore portal access to contacts who used to have it, and also to add this feature to new contacts.
The portal attributes for a contact are kept with the contacts table:
- portal_name
- portal_active
- portal_app
Here is the SQL statement to restore portal access:
UPDATE contacts SET portal_active = 1
WHERE (deleted = 0) AND portal_name IS NOT NULL;
Similarly a contact can be activated for portal access by a SQL statement of the form:
UPDATE contacts SET portal_name = 'user', portal_active = 1
WHERE (deleted = 0) AND last_name = 'USER';
Let me know if this doesn't work for you. |
|
Last Updated ( Tuesday, 08 January 2008 )
|
