Modifying an existing Transform Map

jesusemelendezm · ‎09-08-2014

Hi everyone,

I need to modify a transform map used for LDAP user import. I need to add "user account expiry date" from active directory into the user form of ServiceNow. I have done the following:

1) create a new field "u_expirydate" of date type and added to the user form.

2) from Table Transform Map I created a new field map and select the source field "u_accountexpires" to "u_expirydate"

3) run the scheduled ldap import.

I can't get this field "Expiry date" updated? is there anything else that I need to do additionally?

Thanks,

Jesus E.

chadlockwood · ‎09-09-2014

Go into System LDAP > LDAP Servers > <your ldap server>

Click Browse under Related Links

Enter the distinguishedName of a user that has an expiration date and click Search

See if the accountexpires field appears

What I think you will find is this:

While you see a date/time in ADUC, this field is actually a 64-bit number representing the number of "ticks" since 12:00 AM January 1, 1601. If the accountexpires field is being pulled, it will likely not allow you to shoehorn it into the date field you created on your import table. You will have to change that data type and handle the conversion to a date in your transform map. There is some information about this here:

https://community.servicenow.com/message/652592#652592

View solution in original post

chadlockwood · ‎09-09-2014

Right. so i believe that you need to add accountexpires to the end of that list to pull that data for your user records. Then it will appear in your import set and be transformed with the rest of the data in your transform map.

Let me know if that helps

Chad

Vladi1 · ‎09-09-2014

I think that you have to load all users from LDAP, to include this new attribute, and then ran transform.

randrews · ‎09-09-2014

remember on an import and transform the data is first moved into the import table... THEN to the real table..

so anytime you add a field to your table you need to add the field to the import table also.

jesusemelendezm · ‎09-09-2014

Very strange. I have done the above.

1) add new field to table

2) Modified the attributes

3) Map from field map u_accountexpires to target field u_expiry_date

4) Load schedule import again

Nothing is coming up yet.

randrews · ‎09-09-2014

did you try adding the field to imp_user table? i think if you look at your data import set you will find you import to imp_user and it then transfers from imp_user to sys_user so if you don't add the field to imp_user you can't transform it.