This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Importing data from a csv file containing duplicates

Hello,

I'm importing users from a csv file into the UNSAccountB table. The file format is:

user,group,...

jdoe, groupA,..

jdoe,groupB,..

marry, groupA

....

I'm using a SynchronizationEditor project to perform this import but it is failing since jdoe came two in the file, complaining about dupes. Can anyone guide me how to handle these dupes in the sync project?

Thanks.

Parents
  • Just to add that I intend to define three mapping:

    - First to the UNSAccountB table, only loading users

    - Second to the UNSGroupB table, only loading groups from the same csv file

    - And lastly loading users and groups to the UNSAccountBInUNSGroupB table

    As I explained, first mapping is failing 'cause it has multiple records for the same user (but with diff groups)

Reply
  • Just to add that I intend to define three mapping:

    - First to the UNSAccountB table, only loading users

    - Second to the UNSGroupB table, only loading groups from the same csv file

    - And lastly loading users and groups to the UNSAccountBInUNSGroupB table

    As I explained, first mapping is failing 'cause it has multiple records for the same user (but with diff groups)

Children
No Data