• State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 94 subscribers
  • Views 5481 views
  • Users 0 members are here
Options
Related
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

IDM Engineer
over 9 years ago

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
  • 0 over 9 years ago

    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
  • 0 over 9 years ago

    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