Create REQ, RITM and Task off Import & Transform

[symantecchris]

I would like a Request (REQ), Requested Item (RITM) and Task generated for each line item in a spreadsheet.

A Hardware Refresh Catalog Item would be generated for a line item containing the value of Hardware Refresh and a Hardware Recovery Catalog Item would be generated if the line item contained a value of Hardware Recovery. Both of those Catalog Items have been configured in our instance.

I am looking to solution having the data loaded into ServiceNow, likely through an import set and transform map (unless a more preferred method exists), for potentially hundreds of line items in the spreadsheet / import. I am not sure how to use the transform map to map all of the inbound fields and values to the REQ, RITM and TASK as it looks like those are values and not fields. It is possible this is done via an onBefore transform script similar to what is shown here:

http://www.servicenowelite.com/blog/2014/2/6/request-generation-methods

The other difficulty is how to relate the parent to the child of each Request as each would assumingly be created at the same time upon transform (REQ -> RITM -> TASK) and how I would incorporate and execute the proper workflow. I may need to have a unique identifier for each line item and add that field to the REQ, RITM and TASK upon creation and have them reference to one another that way.

Anyone here every solution a method to create multiple Requests and cascaded RITMS and Tasks off of the Request via an import & transform? Any other ways to look into doing this?

Thanks.

[PeterWiles]

Off the top of my head, you could set the transform map to create the request (REQ).

Then on the transform map, create an onAfter rule to run which in turn creates the request item and the task.

Transform Map Scripts - ServiceNow Wiki

Pete