3 Replies Latest reply on Jun 13, 2017 11:24 AM by yannick1

    link objects via business rules

    wernerbj Apprentice

      Hi,

       

      I extend the BO "OrgUnit" with a custom field "SAPId", because this is our Business Primary key given by an Import file.

      I also extend the BO "Employee" with a custom field "SAPId" validated by the OrgUnit Entries.

       

      Now have to implemented two file importer (csv):

      * The first has to Import (and update) all OrgUnits. The Primary key in the Import file is the "SAPId"

      * The second has to Import (and update) all employees. In the Import file is given the OrgUnit.SAPId. So I have to find out the OrgUnit.RecId by OrgUnit.SAPId and link the OrgUnit via Employee.OrgUnitLink

       

      What is the best way to link the correct OrgUnit on updating Employee.SAPId?

       

      best regards

      Björn