CI Class is not updating through Integration HUB ETL

[hanwar2]

Hi All, I am trying to import 2 AIX server using Excel File and has Class mentioned as AIX Server but when integration is complete, the Class name is updated as "Configuration Item" instead of AIX Server. i have tried creating OnBefore Script (mentioned below) but still no go. Can someone help.

OnBefore Script I am using in Transform Map:

(

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

    // Check if the source has a class value

    if (source.class == 'AIX Server') {

        target.sys_class_name = 'cmdb_ci_aix_server'; // Set the class to AIX Server

    }

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

[Kieran Anson]

You've mentioned IntegrationHub ETL, but that doesn't use onBefore scripts. Are you using ETL or traditional transform maps

[hanwar2]

Hi Kieren,

I am using Integration Hub 

[Kieran Anson]

Are you using a data stream action on your data source? I think you might be confusing IntegrationHub as a means for importing data, and IntegrationHub ETL which is an alternative to transform maps

[monimishra]

If you are using any transform map, can you try adding the above script in run script section and check once. Please try first for one record only.