Robust transform map not importing rows??

Rahman4
Tera Guru

‎06-16-2023 06:09 PM

Hi all,

 

Trying to get my head around why Robust Transform map not importing the rows. There are no errors, the transform completes, however it ignores all the rows. The Excel file has 9 rows of computers to be imported into cmdb_ci_computer. The comment field is showing "IRE Payload is empty. There are no records to insert or update".

 

The Class field is trnslated based on name via a RTE Entity Operation as below:

 

(function(batch, output) {
    for (var i = 0; i < batch.length; i++) {
        var importClass = batch[i].input; //Value of the source field. 
        var ci_class = 'cmdb_ci_computer';

		if(importClass == "Windows Server"){
			ci_class = "cmdb_ci_server";
		}else if(importClass == "ESX Server"){
			ci_class = "cmdb_ci_esx_server";
		}

        //step3: set the output for each elements
        output[i] = ci_class;
    }
})(batch, output);

 

Any comments will be appreciated.

 

Rahman4_1-1686963818036.png

 

The sample Excel file is like below:

 

NameManufacturerOperating SystemAsset tagModel IDAssigned toClassInstall StatusLocation
vmelpwbak02HPWindows 2016 StandardVMELPWBAK02HP ProLiant DL380p Gen8domian\adminWindows ServerInstalledMelbourne Data Centre
ltequ3267HPWindows 10 EnterpriseLTEQU3267HP HP Elite Dragonfly 13.5 inch G3 Notebook PCdomian\rahmanComputerIn StockMelbourne
ltequ3291HPWindows 10 EnterpriseLTEQU3291HP HP Elite Dragonfly 13.5 inch G3 Notebook PCdomian\abel.tutorComputerIn StockMelbourne
ltequ3293HPWindows 10 EnterpriseLTEQU3293HP HP Elite Dragonfly 13.5 inch G3 Notebook PCdomian\aileen.motternComputerIn StockMelbourne
ltequ3061HPWindows 10 EnterpriseLTEQU3061HP HP Elite Dragonfly 13.5 inch G3 Notebook PCdomian\abraham.lincolnComputerInstalledMelbourne
acanpwclust01HPWindows Server 2016 StandardACANPWCLUST01HP ProLiant DL380p Gen8domian\allan.schwantdWindows ServerInstalledFyshwick Data Centre
acanpiesx02HPESX HP ProLiant DL380 Gen9domian\alyssa.biasottiESX ServerInstalledFyshwick Data Centre
acanpiesxdmz02HPESX HP ProLiant DL380 Gen9domian\allyson.gillispieESX ServerInstalledFyshwick Data Centre
acanpiesxdmz01HPESX HP ProLiant DL380 Gen9domian\adminESX ServerInstalledFyshwick Data Centre

 

 

0 Helpfuls
  • 2,039 Views
5 REPLIES 5

hverma2705
Tera Contributor

‎09-11-2023 02:25 AM

Hi Rahman, Did you find a solution for this issue? I am also running into same while doing Dynatrace integration.

 

Regards

Himanshu

0 Helpfuls