Populate SugarCRM with bunch of LDAP users to make them existing without having to log-in first

We have just the solution! Runs as a scheduler, adds users. Adjust active/inactive based upon LDAP. Contact me on Monday for more info

jeff.bickart@Ticomix.com

I have a script using the v10 web API

http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.6/API/Web_Services/Examples/v10/

I add the records using the create record API

http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.6/API/Web_Services/Examples/v10/module…

My script is in python rather than PHP, but that is just a personal preference. I use the python LDAP module to get the records from LDAP then populate the record array and make the API call to the Users module.

Rob

Alright thanks Rob Dancer , we are already familiar with the v10 API for many other synching needs between SugarCRM and others system it won't be a problem. Have you met some issues while developing this specific bridge between LDAP and the Users module? Any special advice or warning to give to me?

I used an "external" (locally hosted) Linux system to run the script as we have an on-demand SugarCRM. The python implementation of LDAP is straight-forward, but if you are using SSL certificates, either ldaps or STARTTLS, then you may have some problems with accepting the certificate because the configuration of root certificate storage is dependent on Linux versions and if you have a root certificate chain on your ldap server. The easiest way to test is to not use certificates. Once you have that working then use certificates but set the LDAP flag in your program to not check the certificate. Once that works, figure out how to check the root certificate. The Linux command line "ldapsearch" is very useful for debugging LDAP connection problems.

Rob

I used an "external" (locally hosted) Linux system to run the script as we have an on-demand SugarCRM. The python implementation of LDAP is straight-forward, but if you are using SSL certificates, either ldaps or STARTTLS, then you may have some problems with accepting the certificate because the configuration of root certificate storage is dependent on Linux versions and if you have a root certificate chain on your ldap server. The easiest way to test is to not use certificates. Once you have that working then use certificates but set the LDAP flag in your program to not check the certificate. Once that works, figure out how to check the root certificate. The Linux command line "ldapsearch" is very useful for debugging LDAP connection problems.

Rob

Thanks a lot Rob for the hint, much appreciated, we'll keep that in mind!

Jeff

Hi Rob Dancer,

can you provide that script? I think many community members would find it useful.

Greets

Mark

That's a bit tricky because the code is part of a bigger application that hooks into the HubSpot marketing system and the RT ticketing system, and there are a lot of custom fields that only mean something to us. However, I'll see if I can extract some code as an example and put it in github.

Rob