question Scripting to Map a Field in Transform Map in Developer forum

Scripting to Map a Field in Transform Map

Vamsi43 — Sun, 02 Jul 2023 15:07:03 GMT

I have 2 fields on table build a transform map to load the data into table.

I want to map the "Service" Field using script.
Can you please help me on this:

If the Service is not empty, map each value of the Excel with the right Service to Target.

I wrote the below script which is not working

answer = (function transformEntry(source) { if (target.u_delivery_time.nil()) { target.u_delivery_time = source.u_delivery_time; } })(source);

Thanks

Re: Scripting to Map a Field in Transform Map

MahaAgineo — Sun, 02 Jul 2023 17:07:43 GMT

Hello @Vamsi43 ,

I think you need to return the value in you script, because you don't have access to the target object. Here what you script need to look like:

answer = (function transformEntry(source) { if (target.u_delivery_time.nil()) { return source.u_delivery_time; } })(source);

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Re: Scripting to Map a Field in Transform Map

Vamsi43 — Tue, 04 Jul 2023 16:47:46 GMT

Hello @MahaAgineo

I want to check both the conditions on the script

1. If the Service is not empty, map each value of the Excel with the right Service to Target.

2. If Service is empty, then set the Delivery time with the value of the Catalog Item.

I wrote the below script which is not working.

answer = (function transformEntry(source) { if (target.u_delivery_time.nil()) { var delivery; var catalogItemGR = new GlidRecord("sc_cat_item"); catalogItemGR.addNullQuery('delivery_time'); catalogItemGR.query(); while (catalogItemGR.next()) { delivery = source.delivery_time; } return delivery; // return the value to be put into the target field } else { return source.u_delivery_time; } })(source);

Re: Scripting to Map a Field in Transform Map

MahaAgineo — Wed, 05 Jul 2023 08:02:45 GMT

Hello @Vamsi43,

You don't have access to the target object, so you need to use a transform map script (set run Script to true see Screenshot), and use this code:

(function transformRow(source, target, map, log, isUpdate) { if (target.u_delivery_time.nil()) { var delivery; var catalogItemGR = new GlidRecord("sc_cat_item"); catalogItemGR.addNullQuery('delivery_time'); catalogItemGR.query(); while (catalogItemGR.next()) { delivery = source.delivery_time; } target.u_delivery_time = delivery; // return the value to be put into the target field } else { target.u_delivery_time = source.u_delivery_time; } })(source, target, map, log, action === "update");

And I don't think you need the else because the field will be by default mapped to the source, with the normal field field mapping (without script)

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Re: Scripting to Map a Field in Transform Map

Vamsi43 — Wed, 05 Jul 2023 09:26:03 GMT

Then what about the Field Maps script i need erase it all and map direct like this?

Re: Scripting to Map a Field in Transform Map

MahaAgineo — Wed, 05 Jul 2023 09:32:12 GMT

@Vamsi43 Yes I think so, try it and tell me, and sorry I saw a mistake in my script, it should look like this, whitout (

(function transformRow(source, target, map, log, isUpdate) {

)

you need to put only this:

if (target.u_delivery_time.nil()) {
        var delivery;
        var catalogItemGR = new GlidRecord("sc_cat_item");
        catalogItemGR.addNullQuery('delivery_time');
        catalogItemGR.query();
        while (catalogItemGR.next()) {
            delivery = source.delivery_time;
        }
        target.u_delivery_time = delivery; // return the value to be put into the target field
    } else {
       target.u_delivery_time  = source.u_delivery_time;
    }

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Re: Scripting to Map a Field in Transform Map

Vamsi43 — Wed, 05 Jul 2023 09:45:01 GMT

Hello @MahaAgineo

Like Below i defined the script and Map fields.

When I Loaded the below data

It not written the Adobe Acrobat Pro catalog item "Delivery time = 2days ".

Re: Scripting to Map a Field in Transform Map

MahaAgineo — Wed, 05 Jul 2023 09:46:50 GMT

@Vamsi43 Upadate the script without first and last line

Re: Scripting to Map a Field in Transform Map

Vamsi43 — Wed, 05 Jul 2023 09:55:55 GMT

But still not working

Delivery Time on Catalog item is "Duration" type but Variable on Table is "String" field. Do you think we suppose update the script ?

Re: Scripting to Map a Field in Transform Map

MahaAgineo — Wed, 05 Jul 2023 10:02:02 GMT

@Vamsi43 Yes you need to convert String to Duration field

Re: Scripting to Map a Field in Transform Map

MahaAgineo — Wed, 05 Jul 2023 10:12:33 GMT

Ok: so in the field script use this (I assume you only have days):

var delivery_time = source.u_delivery_time ;//source.u_delivery_time var day_split = delivery_time.split(' '); var day = day_split[0]; var result= new GlideDuration(day +' 00:00:00'); return result;

and in the run script use this:

if (target.u_delivery_time.nil()) { var delivery; var catalogItemGR = new GlidRecord("sc_cat_item"); catalogItemGR.addNullQuery('delivery_time'); catalogItemGR.query(); while (catalogItemGR.next()) { delivery = source.delivery_time; } target.u_delivery_time = delivery;

Re: Scripting to Map a Field in Transform Map

Vamsi43 — Wed, 05 Jul 2023 11:43:22 GMT

I got the values like this into the table.