Robust transform map not importing rows??

[Rahman4]

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.

The sample Excel file is like below:

Name	Manufacturer	Operating System	Asset tag	Model ID	Assigned to	Class	Install Status	Location
vmelpwbak02	HP	Windows 2016 Standard	VMELPWBAK02	HP ProLiant DL380p Gen8	domian\admin	Windows Server	Installed	Melbourne Data Centre
ltequ3267	HP	Windows 10 Enterprise	LTEQU3267	HP HP Elite Dragonfly 13.5 inch G3 Notebook PC	domian\rahman	Computer	In Stock	Melbourne
ltequ3291	HP	Windows 10 Enterprise	LTEQU3291	HP HP Elite Dragonfly 13.5 inch G3 Notebook PC	domian\abel.tutor	Computer	In Stock	Melbourne
ltequ3293	HP	Windows 10 Enterprise	LTEQU3293	HP HP Elite Dragonfly 13.5 inch G3 Notebook PC	domian\aileen.mottern	Computer	In Stock	Melbourne
ltequ3061	HP	Windows 10 Enterprise	LTEQU3061	HP HP Elite Dragonfly 13.5 inch G3 Notebook PC	domian\abraham.lincoln	Computer	Installed	Melbourne
acanpwclust01	HP	Windows Server 2016 Standard	ACANPWCLUST01	HP ProLiant DL380p Gen8	domian\allan.schwantd	Windows Server	Installed	Fyshwick Data Centre
acanpiesx02	HP	ESX		HP ProLiant DL380 Gen9	domian\alyssa.biasotti	ESX Server	Installed	Fyshwick Data Centre
acanpiesxdmz02	HP	ESX		HP ProLiant DL380 Gen9	domian\allyson.gillispie	ESX Server	Installed	Fyshwick Data Centre
acanpiesxdmz01	HP	ESX		HP ProLiant DL380 Gen9	domian\admin	ESX Server	Installed	Fyshwick Data Centre

[Abhay Kumar1]

@Rahman4 please check point-4 in below article if it helps.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0750386#mcetoc_1f0e7mcn5c4

[Rahman4]

Hi Abhay, 

Thanks for the response.

Thanks that doesn't help. These are all New CIs and should be inserted e.g. 

"4.1# No Matches Found (=0) If no matches found then the payload is reserved for creating/insertion of a new CI."

But it is not working and that is exactly my question.

thanks

[hverma2705]

Hi @Rahman4 , Did you find any solution for this issue? I am also running into same issue in Dynatrace ServiceNow integration?

[Rahman4]

Hi,

You basically need to install IntegrationHub ETL plugin and create the Transform Map via that. If you are creating the Transform Map via the backend it won't work. I was creating the Transform Map via the back-end.

Hope this helps.

Rahman