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
  • 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
  • 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