Transform Script to Change value for specific users

[David Casper]

I have a scheduled data import, using a transform map, to import our users no a daily basis. One of the included fields is 'Enabled' (source) to update the 'Active' (target) field in ServiceNow.

The need is to have a script that looks for a handful of users and changes the Enabled or Active value for them, but only them. I'm a beginner when it comes to programming and have found that this could be done with a onBefore script or maybe a source script.

Latest test is with an onBefore which is allowing the transform to run, but the value is not changing. 

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

if(source.login == 'nhesgz');
target.active = false;

})(source, map, log, target);

Looking for the best way to do this. Any and all suggestions are welcome. 

[David Casper]

I don't follow on not needing operators. My if statement  if(source.u_login == 'nhesgz')  is only specifying one user at the moment. I need to specify multiple users. 

I tried this, f(source.u_login,'IN','nhesgz,teccmm,jpfdjg,CCSRLB,tecrlc,mhhsgx,nrslkz,teckll,teckxb,tecldl,tecdlc') and it actually deactivated move of the users and messed up the user list layout. Very odd. I activated all the users again using the admin account so seem to be good there. Luckily this is DEV 🙂 

Could you provide an example of how I should update the script to accommodate multiple users.

Thanks

[Shishir Srivast]

you can have user_name field set as coalesce in Field Maps and have just this script in transform map and try. I believe this should help.

(function transformRow(source, target, map, log, isUpdate) {
target.active = false;
})(source, target, map, log, action==="update");

[Shishir Srivast]

Like this, 

[David Casper]

I do have user_name set as the coalesce field, but I don't want all the names to be set to inactive (false). I want to specify more than the one I did in testing. 

As I mentioned I tried the 'IN' operator but that really messed things up. I have not tried the || (OR) operator yet. 

[SanjivMeher]

I think this is what you need.

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {


gs.log('++++++++source.login+++++++++++'+source.u_login);

// Store the user list in a variable
var myuserlist = 'nhesgz,teccmm,jpfdjg,CCSRLB,tecrlc,mhhsgx,nrslkz,teckll,teckxb,tecldl,tecdlc';

if(myuserlist.indexOf(source.u_login)>-1)

{
target.active = false;

}

})(source, map, log, target);