question Issue with user import transform for time zone in Developer forum

Issue with user import transform for time zone

Baggies — Mon, 25 Apr 2016 23:35:21 GMT

We have a scheduled import, that imports user data from AD, whose source is SAP. The user timezone in the source, is set to MST, CST, EST etc. But this is causing us some issues with the time displayed for users and the records they create.

I would like to add a Transform Scrip to the Import to convert the Time Zones like below. Also, I havent tried this in the script below, but if the source is empty, can I use a javascript to set it to the system default?

Am I going about this the right way, or is there an easier alternative such as a BR? I appreciate (as always) any feedback.

Mark S.

--------------------------------------------------------------------------------------------------------------------------------

Header 1
//convert time zones if (source.u_timezone == "MST"){ target.setDisplayValue('time_zone',"Canada/Mountain"); } if (source.u_timezone == "EST"){ target.setDisplayValue('time_zone',"Canada/Eastern"); } if (source.u_timezone == "PST"){ target.setDisplayValue('time_zone',"Canada/Pacific"); } if (source.u_timezone == "CET"){ target.setDisplayValue('time_zone',"Canada/Pacific"); } else if (source.u_timezone == ""){ ignore = true; }

Header 1

//convert time zones

if (source.u_timezone == "MST"){

target.setDisplayValue('time_zone',"Canada/Mountain");

} if (source.u_timezone == "EST"){

target.setDisplayValue('time_zone',"Canada/Eastern");

} if (source.u_timezone == "PST"){

target.setDisplayValue('time_zone',"Canada/Pacific");

} if (source.u_timezone == "CET"){

target.setDisplayValue('time_zone',"Canada/Pacific");

} else if (source.u_timezone == ""){

ignore = true;

}

Re: Issue with user import transform for time zone

Michael Fry1 — Tue, 26 Apr 2016 02:07:23 GMT

Your going the right way but doing it in the Transform Map. But you can just set the value, versus using setDisplayValue.

if (source.u_timezone == "MST"){

target.setDisplayValue('time_zone',"Canada/Mountain");

should just be

if (source.u_timezone == "MST"){

target.time_zone == "Canada/Mountain");

Re: Issue with user import transform for time zone

Baggies — Tue, 26 Apr 2016 03:41:44 GMT

Hello Michael, thanks for the reply. I think there may be a missing bracket from your solution. So to clarify, would:

if (source.u_timezone == "MST"){

target.setDisplayValue('time_zone',"Canada/Mountain");

become

if (source.u_timezone == "MST"){

target.time_zone == "Canada/Mountain";

or (as in your response) which has a closing ' ) ' , but no opening ' ( '.

if (source.u_timezone == "MST"){

target.time_zone == "Canada/Mountain");

Cheers, Mark S

Re: Issue with user import transform for time zone

Michael Fry1 — Tue, 26 Apr 2016 12:09:43 GMT

Yes, I did have a missing ( - thanks!

Re: Issue with user import transform for time zone

Michael Fry1 — Tue, 26 Apr 2016 12:10:36 GMT

Where? This one isn't mark anything yet, but moderators can help if needed.

Re: Issue with user import transform for time zone

Baggies — Tue, 26 Apr 2016 15:10:58 GMT

Thanks MIchael, I think it was a lag in my browser last night causing me issues. Appreciate your help, have a good one. I'll post my results too.

Mark S.

Re: Issue with user import transform for time zone

Baggies — Thu, 28 Apr 2016 16:08:17 GMT

Thanks MIchael, I marked you answer correct, I ended up using:

//convert time zones.

if (source.u_timezone == "MST"){

target.time_zone = "Canada/Mountain";

} if (source.u_timezone == "PST"){

target.time_zone ="Canada/Pacific";

}if (source.u_timezone == "EST"){

target.time_zone = "Canada/Eastern";

}if (source.u_timezone == "NST"){

target.time_zone = "Canada/Atlantic";

} else if (source.u_timezone == ""){

ignore = true;

}