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?

[Debasis Pati]

in my upload excel sheet we do not have all the fields we only have name and in target field we have logic only to set those fields as you have explained.

what i should set without the source field match i can't save and can't create field maps.

[Ankur Bawiskar]

@Debasis Pati 

then have field map only for name

then handle every other field in onBefore transform script and set the target field

something like this

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

    // 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";
    target.setValue('start', condition);

})(source, map, log, target);

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