import data fix script

[kevin_cunningha]

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.

[antin_s]

Hi Kevin,

I am not sure If you really need Fix script here. You can achieve this using Import Set Table and Transform Map.

1. Upload your data (from excel/csv/xml) into the Import Set table - http://wiki.servicenow.com/index.php?title=Importing_Data_Using_Import_Sets

2. Create a Transform Map to map the fields from Import Set Table to Business Table and Run the Transform Map - http://wiki.servicenow.com/index.php?title=Creating_New_Transform_Maps#gsc.tab=0

Hope this helps. Mark the answer as correct/helpful based on impact.

Thanks

Antin

[kevin_cunningha]

Hi Antin,

The reason I was thinking of a fix script is because I want to import 15 data sets and run all of their corresponding transform maps without having to go through and do them all individually. I have all the import tables and transform maps built. The purpose is that the data needs to be loaded multiple times in the future. Thank you for the reply.

Kevin

[Pradeep Sharma · Accepted solution]

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.

[kevin_cunningha]

Thank you Pradeep this solves my problem of multiple import sets. Is there a way to write a script that will do multiple transform maps in a specific order? So if there are 10 imported data sets, I want to then run each transform map without having to go to each individual transform map and clicking transform data. Is this possible?

Kevin