• 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

    HI Syeda,

    I don't have time to do a full write up right now, but very quickly, create a virtual property as a join property that combines the fields together with a separator, like jdoe|groupA,jDoe,groupB.  Make the virtual property the key.  Then use the M:N property mapper to map the group membership.

    I'll do a full writeup when I get some time.

    G

Reply
  • 0 over 9 years ago

    HI Syeda,

    I don't have time to do a full write up right now, but very quickly, create a virtual property as a join property that combines the fields together with a separator, like jdoe|groupA,jDoe,groupB.  Make the virtual property the key.  Then use the M:N property mapper to map the group membership.

    I'll do a full writeup when I get some time.

    G

Children
No Data