import data fix script

kevin_cunningha · ‎08-07-2017

I am looking for some resources to write a fix script that imports data and runs the corresponding transform map associated with the table. I have found resources about fix scripts and importing data but not of the two together.

Pradeep Sharma · ‎08-07-2017

Hello Kevin,

Thanks for the update. You can create one scheduled import set and for the additional import set(populate the parent field, set run as "After parent runs" and parent field to the first scheduled import set). This will ensure all additional import set will be executed as soon as parent scheduled import set is executed.

P.S: Do not schedule multiple imports at the same time. Running multiple imports concurrently may negatively impact performance or cause an instance outage.

View solution in original post

kevin_cunningha · ‎08-07-2017

Thank you Pradeep for your help, I understand how to write a script that will run the transform maps. I understand that I would have to use the scheduled imports to handle the import set records being deleted every 7 days.

Pradeep Sharma · ‎08-07-2017

Thanks for the update Kevin. I'm glad your issue is resolved now.

Pradeep Sharma · ‎08-07-2017

Hello Kevin,

To add you can also schedule the import process via scheduled import sets. Please refer below link for more info.

Scheduling Data Imports - ServiceNow Wiki

kevin_cunningha · ‎08-07-2017

Thank you Pradeep for this reference, my concern is that this only mentions create a schedule import for one set while I have multiple. It is unclear to me if I can schedule multiple imports with one schedule import or if I have to create a schedule import for each import set. I have read this article and it does not mention how to run multiple transform maps for each data set that is imported.

Kevin