Hi All,Hope you are doing well in these hard times.I have a requirement here to Sync Manager data from AD to Maximo Supervisor field.As I can see, AD is storing the value in the form of 'Person Name' and Maximo stores Supervisor data in the form of 'Person ID', So I thought of creating a new field to store the Manager name and then write a automation script to get the ID and insert it into the Supervisor field.Here, to make this happen, I added the manager field in the 'VMMSYNC' 'UserMapping' xml and bind it to the newly created attribute to store the manager name.But, the problem we facing is that manager data is in the form of Identifier:<wim:manager externalName="CN=Ekwere G. Itang,OU=PHRC,DC=CHQ,DC=NNPCGroup,DC=local"repositoryId="LDAP" uniqueId="933e78ace9c027438c475f664a26a855" uniqueName="CN=Ekwere G. Itang,OU=PHRC,DC=CHQ,DC=NNPCGroup,DC=local"/>
(Got the above from the debug log of VMMSYNC).Is there any way to extract the uniqueName or PersonID of the Manager from the above format?
I added the LDAP and Maximo field in the userMapping XML too.
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE ldapsync SYSTEM "ldapuser.dtd">
<ldapsync>
<user>
<basedn>DC=CHQ,DC=NNPCGroup,DC=local</basedn>
<filter>PersonAccount </filter>
<scope>subtree</scope>
<attributes>
<attribute>uid</attribute>
<attribute>givenName</attribute>
<attribute>sn</attribute>
<attribute>displayName</attribute>
<attribute>street</attribute>
<attribute>telephoneNumber</attribute>
<attribute>mail</attribute>
<attribute>st</attribute>
<attribute>postalCode</attribute>
<attribute>c</attribute>
<attribute>l</attribute>
<attribute>description</attribute>
<attribute>physicalDeliveryOfficeName</attribute>
<attribute>homePhone</attribute>
<attribute>mobile</attribute>
<attribute>title</attribute>
<attribute>department</attribute>
<attribute>company</attribute>
<attribute>sAMAccountName</attribute>
<attribute>manager</attribute>
</attributes>
<datamap>
<table name="MAXUSER">
<keycolumn name="USERID" type="UPPER">uid</keycolumn>
<column name="LOGINID" type="ALN">uid</column>
<column name="PERSONID" type="UPPER">uid</column>
</table>
<table name="PERSON">
<keycolumn name="PERSONID" type="UPPER">sAMAccountName</keycolumn>
<column name="FIRSTNAME" type="ALN">givenName</column>
<column name="LASTNAME" type="ALN">sn</column>
<column name="DISPLAYNAME" type="ALN">displayName</column>
<column name="ADDRESSLINE1" type="ALN">street</column>
<column name="STATEPROVINCE" type="ALN">st</column>
<column name="CITY" type="ALN">l</column>
<column name="POSTALCODE" type="ALN">postalCode</column>
<column name="DESCRIPTION" type="ALN">description</column>
<column name="COUNTRY" type="ALN">c</column>
<column name="OFFICE" type="ALN">physicalDeliveryOfficeName</column>
<column name="HOMEPHONE" type="ALN">homePhone</column>
<column name="MOBILE" type="ALN">mobile</column>
<column name="TITLE" type="ALN">title</column>
<column name="DEPARTMENT" type="ALN">department</column>
<column name="COMPANY" type="ALN">company</column>
<column name="MANAGERNAME" type="ALN">manager</column>
<column name="STATUSDATE" type="ALN">{:sysdate}</column>
</table>
<table allowdelete="true" name="PHONE">
<keycolumn name="PERSONID" type="UPPER">uid</keycolumn>
<keycolumn name="TYPE" type="UPPER">{WORK}</keycolumn>
<keycolumn name="ISPRIMARY" type="YORN">{1}</keycolumn>
<column name="PHONENUM" required="true" type="ALN">telephoneNumber</column>
</table>
<table allowdelete="true" name="PHONE">
<keycolumn name="PERSONID" type="UPPER">uid</keycolumn>
<keycolumn name="TYPE" type="UPPER">{HOME}</keycolumn>
<keycolumn name="ISPRIMARY" type="YORN">{0}</keycolumn>
<column name="PHONENUM" required="true" type="ALN">telephoneNumber</column>
</table>
<table allowdelete="true" name="EMAIL">
<keycolumn name="PERSONID" type="UPPER">uid</keycolumn>
<keycolumn name="TYPE" type="UPPER">{WORK}</keycolumn>
<keycolumn name="ISPRIMARY" type="YORN">{1}</keycolumn>
<column name="EMAILADDRESS" required="true" type="ALN">mail</column>
</table>
</datamap>
</user>
</ldapsync>
#Customizations------------------------------
Harshavardhan Kamepalli
Eidiko System Integrators
------------------------------