UserName to be copied in CP field

[vivekrajan1]

Hi Team,

We are importing User details(FN,LN,Email etc) from HR systems, and Saviynt creates Username using UserNameGeneration Rule. At the same time I need to copy the generated UserName into user's CP15.

Is it possible to copy the username to CP15 field during user onboarding?

I was checking Enhanced Query Job, but it will not check USERS table.

Is this scenario possible using Preprocessor Query in ModifyUserDataJson? If yes, Could you please give me a example.

[NM]

@vivekrajan1 yes preprocessor should work .

Sample 

SET NEWUSERUSERDATA.CUSTOMPROPERTY15=NEWUSEDATA.username

[vivekrajan1]

Thank you I will test this out,

1 last question, UserName Generation Rule will trigger only for the New Users and I could use preprocessor query to Copy the value to CP15.

If I use Preprocessor query to create UserName, is it possible to copy Username to CP15?

Thanks,

Vivek

[NM]

@vivekrajan1 yes just have cp15 set afterwards.

[vivekrajan1]

* If I donot use USERNAME in COMPUTEDCOLUMNS, then UserImportJob fails with this message,

Error in Users Import - Error while processing data: Unknown column 'NW.USERNAME' in 'field list'

* If I use USERNAME in COMPUTEDCOLUMNS, then UserName field becomes blank and UserID is not creating. Because Username is generated via UserNameGeneration Rule and not by Preprocessor. How do I overcome this?

{
"ADDITIONALTABLES":
{
"USERS":"SELECT USERNAME,customproperty15,FIRSTNAME,LASTNAME,email from users"
},
"COMPUTEDCOLUMNS":
[
"EMPLOYEEID","USERNAME"
],
"PREPROCESSQUERIES":
[
"UPDATE NEWUSERDATA NW SET NW.EMPLOYEEID=NW.USERNAME"
]
}

[rushikeshvartak]

• How users are created ?

[vivekrajan1]

Users created through UserImport Job(REST Connector).

We create Username through UserNameGeneration Rule

[rushikeshvartak]

• what is business use case to copy username in cp

[vivekrajan1]

I want to copy Username and append with @domain.com in CP

[rushikeshvartak]

• You can use #CONST in rest connector mapping itself 

[vivekrajan1]

im not importing Username, but Im creating Username in Saviynt using UserNameGeneration Rule.

How do I use #CONST#method to copy UserNamevalue to a CP in ImportUserJSON? will it work?

[NM]

@vivekrajan1 try this 

"ADDITIONALTABLES":

{

"USERS":"SELECT USERNAME,customproperty15,FIRSTNAME,LASTNAME,email from users"

},

"COMPUTEDCOLUMNS":

[

"EMPLOYEEID"

],

"PREPROCESSQUERIES":

[

"UPDATE NEWUSERDATA NW SET NW.EMPLOYEEID=NW.USERNAME"

]

}

[vivekrajan1]

As mentioned, If I do not use "USERNAME" in "COMPUTEDCOLUMNS" im getting error.

If I use USERNAME in COMPUTEDCOLUMNS, then Username becomes blank, because I am not creating UserName in Preprocessor

@rushikeshvartak @NM  - is there a way to overcome this situation?

[rushikeshvartak]

• use technical rule use user update task and implement the logic

[vivekrajan1]

it means, i need to have CP15 mapping in ImportUserJson. And once user gets created, EIC will create a UpdateUser Task, then through WSRETRY job CP15 will be populated. 

Am I correct?

[rushikeshvartak]

Yes

[rushikeshvartak]

No