Create OLA using transform map

[Debasis Pati]

Hello Team,

I have an excel sheet of group record data.I want to create one one individual ola record for each group .
My group data is as follows

Name	Type	Line / Vendor Manager	Description	Group email	Vendors
FIT	incident, request, problem, change	Acer	FIT support group	fitdesk@test.com
IT SERVICE DESK	incident, request, problem, change	Adobe Systems	IT SERVICE DESK group	itservice-desk@test.com

the below is my ola conditions how it should be created

Title

Name

Duration Type

Duration

Schedule source

Schedule

Timezone Source

Target

Type

Table

Start

Pause

When to Resume

Stop

When to Cancel

Retroactive Start

Set Start to

Retroactive Pause

SLA Breakdown Config (Assignment Group and Assign to)

Resolution OLA

Team1-Fulfillment

User specified duration

Breached on 'Due Date'

SLA definition

8-6 weekdays

The caller's time zone

Resolution

OLA

sc_task

Active = true

State = Closed Complete

State = Closed Incomplete OR Closed Skipped

Yes

Created

N/A

TRUE

AND Assignment group  = Team1

AND Assignment group.Vendor is Empty

Now instead of Team1 it should replace the group name for example "FIT" is my group's name.
also in condition also it should build active true assignment group is fit like that.

I want to use transform map and create bulk ola records.
what approach i should do to get his done.

@Ankur Bawiskar any suggestions?

[Dr Atul G- LNG]

Hi @Debasis Pati 

So you want to change the condition at runtime? I think you may need to write a transform script for that. But why not just make the change in Excel and upload it instead?”

[Ankur Bawiskar]

@Debasis Pati 

in condition field you can give encoded query while mapping the field

what did you start and where are you stuck?

for which field map your transform map is failing?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Debasis Pati]

No i haven't started how to approch this first i should create a transform map and then load data and write script in transform map scripts?

[Ankur Bawiskar]

@Debasis Pati 

correct while you use field map, you can use the field map script and then manipulate the incoming data from excel and then return the final condition

like this

-> For setting target field condition, create a dummy sla/ola and give your condition

-> then go in XML of that record and grab the condition

-> then copy that condition and use in your field map script

answer = (function transformEntry(source) {

    // Add your code here
    var condition = 'active=true^assignment_group=b85d44954a3623120004689b2d5dd60a^EQ^';

    // if you know group sysId then use that or dot walk to name field

    //var condition = "active=true^assignment_group.name=FIT^EQ";
    return condition;

})(source);

I believe I shared all the details and you can take it from here based on your developer skills and customer requirement.

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏