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

CSV connector multiple lines to one Person

Hi,

I have an csv-file containing users and title. Each user can appear more than once in the file with a different title. I want to create a mapping in the Synchronization Editor that combines the lines in a way that the user can have more than one title, separated by comma. If one line is missing from the file in the next import, this title should be removed. I have tried to explain the input file and result below. In v6 we have a powershell-script that creates a new file with one line for each user and all titles in comma separated form. In v8 we want to import the original file directly in the Synchronization Editor. Is this possible to achieve in the mapping tool?

Input file:

UID_1;Title1
UID_2;Title2
UID_3;Title1
UID_1;Title2
UID_3;Title2

Desired Result in Person-table:

SAMAccountName;PersonalTitle
UID_1;Title1,Title2
UID_2;Title2
UID_3;Title1,Title2

Parents Reply Children
No Data