How to display new module in ACL Roles?
To display the new module that you have created to show in the ACL Roles you have to run one SQL query against the Sugar database. This query will insert module details in the “acl_actions” table. I would suggest to take the dump of the existing “acl_actions table” using phpMyAdmin or from the MySQL command: mysqldump
This will give the structure of the query that you need to run as to display the new module. Now you can change the query according to the new module. There are seven this type of queries. This is the sample dump that I’ve taken from the acl_actions table.
INSERT INTO `acl_actions` VALUES (’6h620bee-de5d-74c7-2773-43c4d3bd289a’, ’2006-01-11 09:44:44′, ’2006-01-11 09:44:44′, ’1′, NULL, ‘access’, ‘Leads’, ‘module’, 89, 0);
Now just replace the “Leads” with your new module name and the id. Your new query should look like this:
INSERT INTO `acl_actions` VALUES (’7h620bee-de5d-74c7-2773-43c4d3bd289a’, ’2006-01-11 09:44:44′, ’2006-01-11 09:44:44′, ’1′, NULL, ‘access’, ‘New Module’, ‘module’, 89, 0);
Prepare all the seven queries and run them against the Sugar database.
