Add transform errors to Import Set Row Error table

[Mahira]

Is it possible to add transform errors to the OOB import set row error table. At present all log.info or log.error messages are added to the System Logs.

I would like to do this , so that its easier to isolate and consolidate import set errors and take necessary action to correct the errors.

Any pointers will be most helpful.

~Mahira

[Raju Koyagura]

Try this way, write insert Business Rule on Log (syslog) table by applying filter conditions to check those logs only related to Transform/Import Set errors and then insert those records into target table by creating GlideRecord object of the table, where you want to show them.

[Deepak Ingale1]

Hi Mahira,

You can write onBefore script while records are getting transformed and put error comments in OOB field of import row table like below

source.sys_import_state_comment = ' this is a custom error message ' // sys_import_state_comment is OOB field on import row table available.

[Mahira]

Hi Deepak,

Thank you . The source.sys_import_state_comment logs the comment in the import set row table .

Thank you for setting me in the right direction.

My aim is to set the error code/error message field in the import_set_row_error table. DO you have any pointers for that?

Thanks a lot!

~Mahira

[adarsh-homepage]

Hi All,

I am working on to set-up a script to create a record if any import set row gives error. This needs to be implemented on SCCM data sources.Any thoughts on the script.

Thanks