Import Sets: How to check ignored records?

[felixs]

Hello all,

New admin here, one of my first projects is to import some data into one of our databases and update a particular field. Pretty straight forward. Running through it in our Test instance before moving to Dev. Ive successfully created an import set with no errors. However there were 3 ignored records. I understand there could be lots of reasons for this. However, for now, Id just like to know:

1. A way to check which records were ignored specifically

2. Any log record stating why or give a clue as to why it was ignored.

3. If there is nothing that is done automatically baseline. Is there a way I can attach a script to the import set in order to process a log or a debug message as to what record failed/ignored?

I tried checking the Import Log (from the "Next steps..." section) but it really didnt give me any info that would help me. Even checked the related link of "Show Log Entries" and nothing useful there (from what I could decipher).

Any help would be greatly appreciated!

[felixs]

Hello again Vinoth,

One thing that may help, and I strongly suggest you test this in a development or test instance before moving it to your main instance, is to write a Transform Script.

While you're running a coalesce on the data, Using the Coalesce Field - ServiceNow Wiki , you could run an Explicit Script or maybe an onBefore() script, Transform Map Scripts - ServiceNow Wiki   , and use the following condition:

if (action == 'ignore'){

//write your code here to ensure it gets updated

target.fieldA = source.fieldB; //something of this sort

}

This way, once the record is to be ignored because there is no change in the data, you can make it update via script. I hope this at least points you in the right direction and, again, please make sure to test this in a Dev instance. Thanks and good luck!

[vinothkumar]

Hello Nestor,

Thanks for the update, will try it and let you know if I face any issues

[dgreene16]

This helped me. I was loading asset contract data and trying to tie them together. The thing is some serial numbers had more than one contract and i think it was causing some issues and I was getting that no field values changed message and I believe this will help me get beyond it. Thanks!

[felixs]

You are very welcome!