Scheduled import set all records are ignored

[layla]

Hello experts,

Actually I'm facing an issue in my scheduled import.

For some reasons i need to run my transform map manually, when i proceed with that for a set of 20 user records i get as a resulat 20 records ignored

I want to force update of these records even they are not chaned

Do you have any idea about this issue?

[nishailame]

https://community.servicenow.com/message/988890#988890

https://community.servicenow.com/message/731488#731488

Thanks.

PS: Hit like, Helpful, Correct and Endorse, if it answers your question.

[layla]

Thanks Nisha for the links.

In fact I have already tried the suggested solution; i have created a new column "last import time" in the user table and in my tranform map i have mapped this field to the source created on field but records are still ignored

dont know if i have an issue somewhere, I'm investigating

[layla · Accepted solution]

Thank you all for your help.

In fact as per some internal requirements we want to update records even if they are not changed.

The problem is solved now, it was due to date format differences; The two field i have mapped (source created on field) and (target last import time) have different date format.

Thank you all

[Ankur Bawiskar]

Hi Layla,

records are ignored if no field values are changed while loading or you have written ignore= true explicitly in your onBefore transform script.

This is the expected behavior so what is exactly required.

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.

Thanks

Ankur