Glad to hear that you were successful. Return types can keep us on our toes, can't they?
/dps On Thursday, March 5, 2015 at 3:30:02 PM UTC-8, Grzegorz Dzień wrote: > > Found it, it was that values I was importing were tuples, it works given I > access "first tuple item" e.g.: > first_name=user[1]['givenName'][0] > > On Wednesday, March 4, 2015 at 8:59:32 PM UTC+1, Grzegorz Dzień wrote: >> >> I have tried doing it this way: >> >> def showthemall(): >> # LDAP connection settings >> LDAP_SERVER = "ldap://ad.superhost"; >> BIND_DN = "superuser@ad.superhost" >> BIND_PASS = "mysupersecretpassword" >> # Connect to LDAP >> con = ldap.initialize(LDAP_SERVER) >> # Authenticate in LDAP >> con.simple_bind_s(BIND_DN, BIND_PASS) >> # We don't want disabled users, so we use some magic LDAP-Active >> Directory filers for it >> ldapfilter = >> '(&(&(objectclass=person)( >> objectcategory=person))(!(userAccountControl:1.2.840.113556.1.4.803:=2)))' >> # What user attributes do we want list in link: >> # >> http://www.manageengine.com/products/ad-manager/help/csv-import-management/active-directory-ldap-attributes.html >> attrs = ['displayName', 'givenName', 'sn', 'mail', 'mailNickname', >> 'department'] >> # Get all users from ldap >> base_dn = 'ou=<OU>,dc=<DC>,dc=<DC>' >> ad_users = con.search_s( base_dn, ldap.SCOPE_SUBTREE, ldapfilter, >> attrs ) >> >> for user in ad_users: >> # get 2nd value separated by comma >> ouvar=user[0].split(',')[1] >> # if ouvar valude is not Generic >> if ouvar != 'OU=Generic': >> # add user to the auth_user table >> required_fields = set([ 'sn', 'givenName', 'mail', >> 'department', 'mailNickname' ]) >> if required_fields.issubset(set(user[1])): >> db.auth_user.insert(first_name=user[1]['givenName'], >> last_name=user[1]['sn'], >> email=user[1]['mail'], >> username=user[1]['mailNickname'], >> password=None, >> >> registration_id=user[1]['mailNickname']) >> >> >> >> It is importing contact as (I mean every value in the DB is enveloped in >> vertical bar): >> >> |Grzegorz||Dzien||gdzien@domai...|gdzien|None|gdzien| >> >> >> By the way - is there a way to re-use web2py's AD connector's connection? >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
