Knowledge: Job Scheduler - Import LDAP attributes into Data Room (PeopleSearch)
Back
    Title*Job Scheduler - Import LDAP attributes into Data Room (PeopleSearch)
    ManualAdministration
    Manual Level TwoJob Scheduler
    Created11/08/2020
    Detail

    LDAP Import is often used to create a PeopleSearch type data room.  To set this up you need to create a data room with the attributes you want to expose for searching.  You then need to configure the XML to match Sysero fields to LDAP attributes, this XML is then set in the Job Action Properties.

    Notes:

    • Thunmbnail photos can be shown in search by enabling Data Room Feature - Documents: Cache Image Document Thumbnails (unsecured)
    • RepeaterPropertySemiColon type can be used to add multiple repeater rows, in this case the repeater has a dropdown showing name with username as value behind, so semi colon list in AD is in format of domain\user;domain\user2 etc.
    • GroupMember below is used to mark if a user is a Fee Earner or Partner etc. by whether or not they belond to a group.

    Config XML

    <LDAPImport>
     <LDAPPath>LDAP://dc=example,dc=com</LDAPPath>
            <LDAPFilter>CN=ADImport,OU=Groups,DC=example,DC=com</LDAPFilter>
            <PrimaryKey>
             <DataBaseField>TextField1</DataBaseField>
                    <LDAPProperty>mail</LDAPProperty>
            </PrimaryKey>
            <Mappings>
             <Mapping>
              <DataBaseField>ItemName</DataBaseField>
                     <LDAPProperty>cn</LDAPProperty>
                     <ImportRule>StandardProperty</ImportRule>
             </Mapping>
             <Mapping>
              <DataBaseField>TextField2</DataBaseField>
                     <LDAPProperty>sAMAccountName</LDAPProperty>
                    <ImportRule>StandardProperty</ImportRule>
             </Mapping>                        
         <Mapping>
              <DataBaseField>TextField6</DataBaseField>
                     <LDAPProperty>telephoneNumber</LDAPProperty>
                     <ImportRule>StandardProperty</ImportRule>
             </Mapping>
             <Mapping>
                     <DataBaseField>TextField3</DataBaseField>
                     <LDAPProperty>description</LDAPProperty>
                     <ImportRule>StandardProperty</ImportRule>
             </Mapping>
      <Mapping>
              <DataBaseField>TextField4</DataBaseField>
                     <LDAPProperty>department</LDAPProperty>
                     <ImportRule>StandardProperty</ImportRule>
             </Mapping> 
                    <Mapping>                                         
       <DataBaseField>BooleanField1</DataBaseField>
                            <LDAPProperty>CN=Partners,OU=Groups,DC=example,DC=com</LDAPProperty>
                            <ImportRule>GroupMember</ImportRule>
                    </Mapping>                 
                    <Mapping>
                            <DataBaseField>NA</DataBaseField>
                            <LDAPProperty>thumbnailPhoto</LDAPProperty>
                            <ImportRule>Document</ImportRule>
       <DocumentName>Photo.bmp</DocumentName>
                    </Mapping>
      <Mapping>
                     <DataBaseField>TextField5</DataBaseField>
                            <LDAPProperty>extensionAttribute2</LDAPProperty>
                            <ImportRule>RepeaterPropertySemiColon</ImportRule>
                    </Mapping>
     </Mappings>
    </LDAPImport>

    Privacy Policy
    Cookies help us to improve your user experience. By using this site you consent to cookies being stored on your device. Read more...
    View or hide all system messages