How do you upload SLA's from excel along with conditions into servicenow?

[AmulyaPallapot]

Hi All,

I have a requirement to upload SLA's along with their conditions into ServiceNow. We have all data in EXCEL sheets.

What is the way to import from excel? If yes , please specify the steps to achieve this.

Thanks in advance,

Amulya P

[Jaap]

Hi @Amulya,
Yes this is possible. You can do it via a import set, which is extensively described in the ServiceNow documentation:
https://docs.servicenow.com/bundle/washingtondc-integrate-applications/page/administer/import-sets/c...

Are you aware of this method? Can you provide details of the SLA's in terms of attributes you want to import?
You can view the SLA definition form in ServiceNow and see what options are there.
Regards,
Jaap

[AmulyaPallapot]

Hi Jaap,

Thanks for your response , Yes Jaap I have tried to export the data from the excel by creating a staging table and with the help of transform map able to import few fields but not the "Duration" field .

Please refer the screenshot of excel of fields which I have created for your reference .

All the above fields except the "Duration" Field is not imported into the contract_sla table.

I tried with many formats for the duration field but no luck on that , also tried with the transform map script by adding this line of below code but no luck

target.duration.setDateNumericValue(source.u_duration*1000);

Is there any other solution please for this to get the Duration filed too ?

Thanks for the help in advance,

Amulya P 

[AmulyaPallapot]

Hi Jaap,

I tried with transform map , but no luck on getting the Duration field , Please help me to get that.

Thanks,

Amulya P

[Jaap]

Hi,

Try using date format HH:MM.
Regards,
Jaap