Transform OnBefore Script to compare source and target fields

[jiral]

I am trying to create an OnBefore transform script to compare fields of the source and target. I have the following script but it is not working

if (source.active == target.active && source.u_ad_samaccountname != target.user_name){
target.u_userid = target.user_name;
target.update();
target.user_name='';
target.update(); 
}

1. Considering both active fields in source and target are equals to 'true', If source.u_ad_samaccountname is not equals to target.user_name then copy the value of target.user_name field then paste it in target.u_userid field.

2. After 1. is completed it then delete the value of target.user_name field.

Thank you.

[Chris M3]

First thing, on a before script, like a before BR, you should not be doing a .update();   I'm not sure if this is your issue.

Add some log statements to check the values going in/being tested.

change lines 2-5 to just

target.u_userid = target.user_name + '';

target.user_name = '';

If those don't resolve it for you, can you provide some more details about what is not working?

[sajan0192]

Hi Jeffiral,

Please try to add logs and check whether your if condition is getting satisfied or not. If values are correct please write if condition like below and no need to write target.update() two times.

1. if ((source.active == target.active) && (source.u_ad_samaccountname != target.user_name)){  
2. target.u_userid = target.user_name;  
3. target.user_name='';  
4. target.update();    
5. }  

Regards,
Sajan

[jiral]

I tried both of the scripts provided above and they both resulted to this error: "Error during update of sys_user". The issue identified was that the target.user_name had users user_name switched. The soure.u_ad_samaccountname has the correct value but it couldn't update the user_name field as it already has a value in it which was incorrect. That's basically the very problem I am trying to fix, hence, the need to clear out the user_name field.chrismartinsajan0192

[Chris M3]

I feel like there's gotta be something on the sys_user table preventing the update.   If you go to the sys_user table and manually change a user_name, do you get any errors there?