Any succesful bulk SLA Import?

[_zg_r T_rker]

I need to import over 4000 SLA definitions via Import Set. Problem is on Condition fields . (Start, stop, Pause Condition)

Other fields can be imported easily, but I cannot find any method to import Condition fields. I export "contract_sla" table and use same format for the import set. However after successful import the Condition fields are empty. When I look at the contract_sla table I cannot see any difference in format with imported new data and out of box Conditions.

Any suggestions?

Below is an example for the Start Condition of my Import Set

"Company = Tab Gida .and. Business service = Ag Izleme Hizmetleri Yönetimi .and. Priority = 1 - Critical .and. State = Accepted"

Thanks in Advance,

Ozgur

[yoed_b · Accepted solution]

Hey Ozgur,

After a battle here, seems we're winning:

instead of a phrase as "State = Closed .or. Assignment Group != System_admins"

try this syntax in the excel:

state=7^ORassignment_group!=a10a15266000120052b24c8fc10c5354^EQ

[Lukop]

Additional info: Syntax is using Filters and queries operators. Other than ^OR operators can be found here: Operators available for filters and queries (servicenow.com)

[rajdan]

Hi

May I know, how data/input from excel sheet is taken and how it is mapped to a fields in contract_sla table. Can you please share the sample excel you have prepared and the transform scripts related to it.

[trinadhgottipat]

Hi Ozgur,

I'm trying to import the sla's table ,but the start,stop,pause and duration fields are emptily imported.Could you please provide a sample excel file to fill the fields like Start condition,stop condition,pause and duration.

Thanks in Advance,

Trinadh Gottipati.