Solved

ETM Event Builder

  • 3 October 2022
  • 1 reply
  • 75 views

Userlevel 2
Badge +7

I am trying to create an ETM Channel to create new Event Builders at Item Level.

Fields Usage Type and Event Type are Integers. I tried with value “1” for both fields but it is failing.

Can anyone please help me in getting the Usage Type and Event Type values?

icon

Best answer by KevinM 21 October 2022, 10:51

View original

1 reply

Userlevel 3
Badge +8

Hi Manish

We created an event builder ETM channel - here are the values you need: 

Event Type - This is what type of Event the event builder is to be used in conjunction with. 

The options available are as follows:

  • 1 - Incident
  • 2 - Problem
  • 3 - Incident and Problem
  • 4 - Change
  • 5 - Service Request
  • 9 - Change and Request
  • 10 - Order

and 

Usage - This is for what the event builder will be used for. 

The options available are as follows: 

  • 0 - Assignment Only
  • 1 - Logging Only
  • 2 - Assignment and Logging

Below is the RAW code from our event builder channel - hopefully can be of some help as well :) 

{
"targetResource" : "eventBuilder",
"targetClass" : null,
"mapping" : [ {
"field" : "break",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "!inbound[\"Matches at\"];",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "self",
"searches" : [ {
"criteria" : [ {
"field" : "item",
"value" : null,
"csvLookup" : null,
"match" : null,
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"Item\"].toUpperCase();\t",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
}, {
"field" : "category",
"value" : null,
"csvLookup" : null,
"match" : null,
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"Category\"].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "eventBuilderType",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "inbound[\"Matches at\"];",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "item",
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"Item\"].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
}, {
"criteria" : [ {
"field" : "name",
"value" : "inbound[\"Item\"].toUpperCase();\t",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "eventType",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "inbound[\"Event Type\"];",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "category",
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"Category\"].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "usage",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "inbound['Usage'];",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "seriousness",
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"Impact\"].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "priority",
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"Urgency\"].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "sla",
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound[\"SLA\"].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "callbackReqd",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "true;",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "suggestedActions",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "inbound[\"Suggested Actions\"];",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "process",
"searches" : [ {
"criteria" : [ {
"field" : "shortCode",
"value" : "inbound['Process'].toUpperCase();",
"csvLookup" : null,
"match" : null,
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"noValueOrExactMatchResponse" : "USENULL"
} ],
"ignore" : null,
"errorIfSearchFails" : false,
"useCache" : true,
"skipAssystValidation" : false
} ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
}, {
"field" : "startProcess",
"searches" : [ ],
"defaultValue" : {
"shortCode" : null,
"csgShortCode" : null
},
"searchReturnFields" : [ ],
"searchReturnCollection" : false,
"value" : "inbound['Start Process'];",
"maxStringLength" : null,
"csvLookup" : null,
"match" : null,
"customFieldType" : null,
"noValueOrExactMatchResponse" : "USENULL",
"cacheOptions" : [ ],
"trackNoMatches" : false
} ],
"entityFields" : null,
"pre" : { },
"cacheOptions" : [ ],
"notes" : null
}

The import file is an xlsx file - with columns in the following order (from left to right) 

Matches Event Item Level

Item

CSG

Event Type

Category

Useage

Impact

Urgency

SLA

Call Back Required

Process

Start Process

Suggested Actions

 

Hope this helps 

Kev

Reply