Import set comments

[swethaa]

Hi all,

There are few records were ignored with these comments " No field values changed " and "row transform ignored by on before script " after importing data for a custom table.

Please any guide me on this issue.

Thanks,

Sujith

[jarodm]

These mean exactly what they say:

No field values changed

It found a target record (via the coalesce settings), but all of the mapped fields were already set (source fields == target fields) so no update was made.

Row transform ignored by on before script

There's a onBefore script configured (different tab on the t-map). It's checking for some conditions and setting an "ignore = true". If that happens the whole record gets skipped.

[swethaa]

Hi

Thanks for your reply.

for this comment "Row transform ignored by on before script" -- do i need to modify anything in thing in the transform script?

please clarify me?

Thanks,

sujitha

[jarodm]

It all depends on your requirements.

There's usually a reason the previous developer set that to be ignored. There are many reasons to do it. Some of my top reasons I use that command:

• I'm running multiple transform maps on the same import table and I only want one of them to run
• Would require an insert to a reference field. Ignore it this time, and wait for another import to populate the reference field table. The next import will have the value it needs and will not be ignored.
• Doing some fancy correlation scripting (e.g. looking up a CMDB_CI to link it to) and don't want to insert a record with an empty CMDB reference field.

Hope it helps you, and anyone else reading this in the future.

JarodM