How to import sc_req_item?

[johnnyw]

I need to import some requested items data from a legacy system into ServiceNow so that we have a central place to store this data.  I have the data in an excel spreadsheet and can format the data as I need.  The data needs to just come over and be stored as a closed Request/Requested Item/Task.  The catalog item is already created in SN and when imported, the tasks as part of that items workflow doesn't need to be performed.

Has anyone ever done this?  What's the "best practice" way to do this?  I'm thinking it's more complex than just creating an Import Set Table and Transform Map since it would need to create records in the sc_request, sc_req_item and sc_task tables (and possibly more)..

Please let me know your experience or ideas.

Thanks,

Johnny

[Allen Andreas]

Hi,

Actually that would be the way (or the most common) to do that.

See: https://docs.servicenow.com/bundle/london-platform-administration/page/administer/import-sets/concep...

Please mark reply as Helpful/Correct, if applicable. Thanks!

[johnnyw]

Thanks for your response.

I might be thinking it's more complex than it actually is, but here's what I'm thinking.  Since I need to load a RITM, I should also have a REQ and TASK associated with it.  So how do I load to all 3 tables with parent/child relation between them? 

Also, the RITM's I'm loading have variables I need to also load.  Since the variables are not on the sc_req_item table, how do I load the variable values?  I just tried creating a transform map to the sc_req_item and I definitely can't map to specific variables.

Thanks,

Johnny

[sachin_namjoshi]

You can configure data source, transform map to import RITM data alongwith sc_request and sc_task data.

You can configure transform script to use cart API to create requests based on your spreadsheet data.

You should have catalog items configured before using cart API.

https://docs.servicenow.com/bundle/london-application-development/page/script/server-scripting/reference/r_ServiceCatalogScriptAPI.html

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

Regards,

Sachin

[johnnyw]

Thanks.  I will look into this.

Regards,

Johnny