• State Suggested Answer
  • Replies 17 replies
  • Answers 2 answers
  • Subscribers 96 subscribers
  • Views 4343 views
  • Users 0 members are here
Options
Related

CSV Synchronization Project with duplicate entries in Import file

jroberto moreno
over 3 years ago

I want to synchronize, for example, locations from a csv file to D1IM.

For this purpose i create a synchronization project with an object matching rule for AccountNumber(D1IM) <-> ProfitCenterID(CSVFile). 

However i have occasional entries where locality appears more than once in your csv file.

ProfitCenterID,localityName
loc1,locNameA
loc2,locNameB
loc2,locNameC

For loc2 the processing is cancelled completely with the following error message:

Warning The object matching rule (AccountNumber <-> ProfitCenterID)
supplied the following 2 objects with the same key
(00000010). These objects were ignored.


I need to have the loc2 entry not skipped completely, but inserted and updated. 

Is it possible?

A greets

Parents Reply Children
  • 0 over 3 years ago in reply to jroberto moreno

    If your only key is the ProfitCenterID, I am unable to see why you need to take both lines and not just the last one.

    And no, it is not possible to handle the duplicate items, as either INSERT or UPDATE.

  • 0 over 3 years ago in reply to Markus Weiss-Ehlers
    Hello Markus,
     
    I receive employee information from the External System and may have two records for the same employee because each record is for each department in which the employee works. I want to keep these records under the same identity since they belong to the same employee.
    A greeting
  • 0 over 3 years ago in reply to jroberto moreno

    But where do you store information then when you want to have it for the same employee?

  • 0 over 3 years ago in reply to Markus Weiss-Ehlers

    I explain.

    I have a SAP HR of employees. I can have a employee what he have two records in SAP  because he works for tow societies of the same company. Now, SAP send a CSV with the information of the employees and this employee have two records. If I want have a identity in One Identity for this employee, how can save the information of the two records?

  • 0 over 3 years ago in reply to jroberto moreno

    I think you need to decide what these SAP records should represent in your system. Should they be handled as sub-identities? In that case, each ProfitCenterID / LocalityName combination would be the key to identify the subidentities. Or, if you want to have just to location entries for the same employee, you need to import the location assignments to the M:N table PersonInLocality instead of the primary location assignment via Person.UID_Locality.

    It is your choice.

  • 0 over 3 years ago in reply to Markus Weiss-Ehlers

    Pardon, the example can be confusing.

    I have the fields Nºpers what represents the records of SAP and Employee identifier (NIF/NIE in my case).

    Nº pers.

    Nif/Nie         

    00058661

    14581030S       

    00047935

    14581030S       

    00047934

    49786116K       

    As you can see, there are records with the same Nif / Nie. Would you have to create that M: N table?

    I want the field "Central Account" of One Identity is the field Nif/Nie and  can save the two values  of the field "Nºpers".

    A greets.

  • 0 over 3 years ago in reply to jroberto moreno

    Each combination of personnell number and Nif/Nie would be a different person for me. So the key for the file would be the combination of both fields.

    00058661

    14581030S       

    00047935

    14581030S       
  • 0 over 3 years ago in reply to Markus Weiss-Ehlers

    I need that is the same person.

    Could I create a extended table relationed with Person? In this table,  Each combination of personnell number and Nif/Nie would be a different register and then, create a custom process for I create the Person or update if it exist

    As you see?

  • 0 over 3 years ago in reply to jroberto moreno

    Yes, you can create additional tables and relations to the person table if that is what you want. I do not know if that is the right choice here but, again this is up to you and your use-case.

  • 0 10 months ago in reply to Markus Weiss-Ehlers

    Hello Markus,

    I have a similar issue. I would like to have the primary key of my CSV file as the combinatioin of two fields. If I mark both fields as key columns, the connector has a weird behavior. For example I have this CSV:

    Application

    Access Right      

    Application 1

    Access Right 1       

    Application 2

    Access Right 1

    Application 1

    Access Right 2      

    Application 1

    Access Right 1

    The expected result is that:
    - Access Right 1 is inserted as group of target system Application 1
    - Access Right 1 is inserted as group of target system Application 2
    - Access Right 2 is inserted as group of target system Application 1
    The last row must be ignored. 

    In summary, I would like that the combination of field Application-Access Right is the primary key.


    Instead, I get that the connector reads just the first row. It seems like both fields are considered to be unique and not just the combination of them.

    The version of OneIM I'm using is the 9.1.

    Can you help me?
    Thank you in advance,

    Lucrezia