I am experimenting with using the CSV import in Synchronization editor for importing users into 1ID (9.0 LTS). This is going fine, but I also want to make sub-identities which reference a main identity. At the moment, I have the following CSV file format:
FirstName,LastName,email,Master Identity,External,subCompany
CSV,Users,csv.user@test.com,,True,SeleneB2B
CSV,SubIdentity,csv.subidentity@test.com,SeleneB2B1,True,SeleneB2B
In the mapping of the CSV synchronization, I am setting the Personel Number to be concatenation of the SubCompany and the row number of the CSV to make a unique reference. This is why on the second line, the Master Identity field is pointing to the first (SeleneB2B + Row number (1)). I will look at making this more unique later but this is for testing.
In the synchronisation, I have Person Record, and on the right I have the schema for the CSV.
What I am wanting to do is set the Master Identity Reference to the lookup of the Person record where the Personel Number is what the Master Identity field in the CSV is referencing.
I thought I might be able to do this with Key by reference, but I cannot figure this out.
Is this possible, or am I going about this the wrong way?
