data upload state set to ignore
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2023 12:58 AM
Hi Team ,
Can someone please help me why state showing as ignore ??
just need clarification ...
Many thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2023 01:06 AM
Hi @pramn ,
It is getting ignored because of on before transform map script.
Could you check the transform map script written ?
Regards,
Harshal
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2023 01:46 AM - edited 06-07-2023 01:56 AM
Not sure why its written for
(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {
// Add your code here
if (action == "insert") {
ignore = true;
}
if (action == "update") {
ignore = true;
}
})(source, map, log, target);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2023 02:21 AM
@pramn - this script will ignore it no matter what, since this script does not have any logic associated to it, please check why was it created in the first place - if there's no reason, you can remove it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2023 02:01 AM
Dear @pramn
In ServiceNow, when importing data using an Import Set, the "Ignored State" field on the Import Set Row record indicates whether the state of the imported row is being ignored during the import process.
The "Ignored State" field can have the following values:
-
false
: The state of the import set row is considered during the import process. If the state of the row is set to ignore or skip, it will be excluded from further processing, and no corresponding records will be created or updated in the target table. -
true
: The state of the import set row is ignored, and the row will be processed regardless of its state. This means that even if the state of the row is set to ignore or skip, the import process will still create or update records in the target table based on the data provided in the import set row.
By setting the "Ignored State" field to true
, you can enforce the import process to create or update records in the target table regardless of the state of the import set row. This can be useful in situations where you want to override the state of the imported data and ensure that the data is processed.
☑️ Please mark responses as HELPFUL or ACCEPT SOLUTION to assist future users in finding the right solution....