source.sys_import_state_comment display empty

[CKJ-BeOS]

Hi,

On Transorm Map into an "OnAfter" script, i use the "source.sys_import_state_comment" to display information about the action, but in result Import set the information is empty.

It is working or not into onAfter script ?

Regards,

Cédric

[RaghavSh]

Your question is not clear, OOB import set rows shows the state of each row in import set like error, insert, update.

what extra information you require.

[MPD Odijk]

The order for operations in an Import set (for a single record) is:

1) onBefore script

2) field mapping (scripts) for Coalesce fields

3) other field mapping (scripts) 

4) main transform map script

5) Database Update

6) onAfter script.

It seems that you are trying to update the source (the import set row record) in the onAfter, and I don't think that will work without something like "source.update()". Instead you could tyr to do this in the transform map script that becomes visible when you select "Run script" on the Transform map.

[mattiem · Accepted solution]

---

@CKJ-BeOS wrote:

Hi,

On Transorm Map into an "OnAfter" script, i use the "source.sys_import_state_comment" to display information about the action, but in result Import set the information is empty.

It is working or not into onAfter script ?

Regards,

Cédric

---

No, the `sys_import_state_comment` field is not intended to be used within an `onAfter` script. This field is part of the import set table and is populated by the system to track the outcome of the import row's processing, such as if it was inserted, updated, or ignored. The `onAfter` transform script runs *after* the system has already processed and written to this field, so any attempt to modify it at this point will not work as expected and the information will appear empty.