Hi,
We are starting an instance of SuiteCRM and I would like to import a set of Contacts from a different data source and have them mostly read only in SuiteCRM.
To do this I have set up security group that has the correct permissions and then I try to apply this security group to all the records.
This is a large number of Contacts, 20,000+. Only some of the records have the correct security group applied.
Is there any know problems with applying security groups to this many records?
Thanks.
Hi, thanks for moving this here.
There are some php.ini settings that will limit your resources, and possibly cause that long-running process to be interrupted. In this case you would find a message about it in your PHP error log (the one defined in the error_log entry in your php.ini).
These two especially:
Even so, for such a large number I wouldn’t recommend going through the UI, it’s very hard for a language like PHP to handle such a large request unless you made it a background-running process.
I would do it from the database, using phpMyAdmin or similar. A simple INSERT query into securitygroups_records table could do it in seconds.
Have a look here for a generic introduction, if you need it
There is an example there using that table, which you can have a look to see how the relationship to the other tables works.
Let me know if you need more help. Cheers