Need to populate locations time zone in locations table

[Esha5]

Hi Team,

In my  location table having location name, city and time zones fields etc..

But all locations showing empty 'Time Zone' , How to set locations time zone.

please help me on this task.

Thanks in Advances.

[shloke04]

Hi,

What you can do here is since your customer is not ready to share the Time zone info and you are asked to fill based on city or country, you can follow below steps to achieve your requirement:

1) There is a article from ServiceNow itself on different Time zone which can be used. Refer the same below:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0594661

This link gives you timezone for different locations, so prepare a spreadsheet with say two columns i.e. one will be City or COuntry and Second column will be Timezone

You need to use this link below:

https://en.wikipedia.org/wiki/List_of_tz_database_time_zones

Now once this spreadsheet is prepared you can upload it in ServiceNow using Import Set functionality which is explained below:

Please follow the steps below to import and Transform it as shown below:

1) My Spreadsheet I am trying to upload shown below :

2) Navigate to the module "Load Data" as shown below:

3) Enter a Table Name here and choose your excel file here and click on Submit button:

4) Once you click on Submit then click on Create Transform Map as shown below:

5) Now give a Name to your Transform Map and select Target table as Incident as shown below:

In case you do not want Notification and other functionality to run make sure to uncheck Run Business Rule Flag to avoid any issues

6) Click on Auto  Map Field as shown below to map your fields. In case this does not map it then manually map it by clicking on the New button and select your Source and Target fields

Field Maps gets created as shown below:

If you see for Category it did not got created so I have to manuall click on new and create it as shown below:

Now , click on Transform button to transform to the Target Table:

Click on Transform button shown above

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[shloke04]

You can also look at below thread for more info on how you can achieve this using REST as well:

https://community.servicenow.com/community?id=community_question&sys_id=973f5c2cdbc0a410a08a1ea6689619a2

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke