SugarCRM to Mozilla LDAP contact slurper

Seeing as SugarCRM is now truly Open Source, I decided to support them buy using SugarCRM as a contact database for a client.

This script extracts contact data from Sugar, and imports it into an LDAP tree, so that Thunderbird clients can use it as an address book.

It’s written for Sugar 5.0, and a suitable LDAP installation with the Mozilla Schema

A suitable VIEW for printing out a contact directory would look like:

51&q=CREATE&lr=lang_en">CREATE 5.1/en/non-typed-operators.html">OR 51&q=REPLACE&lr=lang_en">REPLACE 51&q=VIEW&lr=lang_en">VIEW sugarab 51&q=AS&lr=lang_en">AS
51&q=SELECT&lr=lang_en">SELECT, c.description, salutation, first_name, last_name, title, department,
do_not_call, phone_home, phone_mobile, phone_work, phone_other, c.phone_fax,
primary_address_street, primary_address_city, primary_address_state,
primary_address_postalcode, primary_address_country, alt_address_street,
alt_address_city, alt_address_state, alt_address_postalcode, alt_address_country,
assistant, assistant_phone, lead_source, birthdate, 51&q=AS&lr=lang_en">AS account_name,
e1.email_address 51&q=AS&lr=lang_en">AS primary_email, e2.email_address 51&q=AS&lr=lang_en">AS secondary_email
51&q=FROM&lr=lang_en">FROM contacts 51&q=AS&lr=lang_en">AS c
5.1/en/string-functions.html">LEFT 51&q=OUTER&lr=lang_en">OUTER 51&q=JOIN&lr=lang_en">JOIN accounts_contacts 51&q=AS&lr=lang_en">AS j 51&q=ON&lr=lang_en">ON ( = j.contact_id 5.1/en/non-typed-operators.html">AND j.deleted = 0)
5.1/en/string-functions.html">LEFT 51&q=OUTER&lr=lang_en">OUTER 51&q=JOIN&lr=lang_en">JOIN accounts 51&q=AS&lr=lang_en">AS a 51&q=ON&lr=lang_en">ON (j.account_id = 5.1/en/non-typed-operators.html">AND a.deleted = 0)
5.1/en/string-functions.html">LEFT 51&q=OUTER&lr=lang_en">OUTER 51&q=JOIN&lr=lang_en">JOIN email_addr_bean_rel 51&q=AS&lr=lang_en">as eb 51&q=ON&lr=lang_en">ON (eb.bean_id = 5.1/en/non-typed-operators.html">AND eb.deleted = 0)
5.1/en/string-functions.html">LEFT 51&q=OUTER&lr=lang_en">OUTER 51&q=JOIN&lr=lang_en">JOIN email_addresses 51&q=AS&lr=lang_en">as e1 51&q=ON&lr=lang_en">ON (eb.email_address_id = 5.1/en/non-typed-operators.html">AND eb.primary_address = 1 5.1/en/non-typed-operators.html">AND e1.deleted = 0)
5.1/en/string-functions.html">LEFT 51&q=OUTER&lr=lang_en">OUTER 51&q=JOIN&lr=lang_en">JOIN email_addresses 51&q=AS&lr=lang_en">as e2 51&q=ON&lr=lang_en">ON (eb.email_address_id = 5.1/en/non-typed-operators.html">AND != 5.1/en/non-typed-operators.html">AND e2.deleted = 0)
51&q=WHERE&lr=lang_en">WHERE c.deleted = 0;
AttachmentSize KB


Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Erk, there is already a plugin

Jonathan Carter has pointed out to me that there already is a Thunderbird Plugin for Sugar. Why the stupid idiots haven’t registered it on, I don’t know… I’ll have to try it out :-)

Fix for utf-8

# Connect to MySQL
db=MySQLdb.connect(user=MYSQL_USER, passwd=MYSQL_PASS, db=MYSQL_DB)
c = db.cursor()

# set utf-8 code
c.execute("""SET NAMES utf8;""")
c.execute("""SET CHARACTER SET utf8;""")

# Retrieve contacts

Problem with this script

I filled in ldap and mysql data, added mozilla.scheme to openldap, but when i run this script i get this error:

File "", line 174, in
l.add_s(dn, ldap.modlist.addModlist(entry))
File "/usr/lib/python2.5/site-packages/ldap/", line 185, in add_s
return self.result(msgid,all=1,timeout=self.timeout)
File "/usr/lib/python2.5/site-packages/ldap/", line 427, in result
res_type,res_data,res_msgid = self.result2(msgid,all,timeout)
File "/usr/lib/python2.5/site-packages/ldap/", line 431, in result2
res_type, res_data, res_msgid, srv_ctrls = self.result3(msgid,all,timeout)
File "/usr/lib/python2.5/site-packages/ldap/", line 437, in result3
ldap_result = self._ldap_call(self._l.result3,msgid,all,timeout)
File "/usr/lib/python2.5/site-packages/ldap/", line 96, in _ldap_call
result = func(*args,**kwargs)
ldap.INVALID_SYNTAX: {'info': 'c: value #0 invalid per syntax', 'desc': 'Invalid syntax'}

Any clues?
Thank you


Looks like it’s setting something as ‘c’ (Country) which it shouldn’t be.

Print out entry before storing it, and try to work out what’s going on.

I tweeked the script (removed

I tweeked the script (removed Mozilla scheme) and now i've managet to import data from Sugar to LDAP(phonebook).
Great stuff....thanks fro the code.

thanks for the code Stefano

awesome job!

This little snippet of python had us syncing SugarCRM contacts to eDirectory in a few hours. Really appreciate you giving this away for us to take advantage of.
I've tweaked your script somewhat to comply with eDirectory LDAP schema. Anyone too lazy to customise their own can contact us at for a copy of our version of this great bit of code.

thanks again


Bigger version of such task

We've made something closely related to such task.
We have published on sugarForge some python scripts using triggers from MySQL to detect sync needed between Sugar and an LDAP branch.
Theses scripts handle much more things (custom tables, fields and custom fields mappings, surgar users sync, etc.)
People reading this page might be interedted in such scripts.
Feedback welcome!

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
By submitting this form, you accept the Mollom privacy policy.