How do I create specific catalog item records from Excel sheet (~700 records)

[Brian Hatt]

I created a new catalog item named "Student Loaner Program", that contains a dozen custom fields. I have an Excel spreadsheet with about 700 rows that I need to import into ServiceNow, resulting in 700 newly inserted records of the Student Loaner Program item.

The spreadsheet has 30+ columns of data. I was hoping to be able to load that data into ServiceNow, then somehow use a transform map to map 12 of the columns from the spreadsheet to the 12 fields on my Student Loaner Program requested item, then have it transformed and insert 700 records.

It's easy to do this for the Incident or User tables since those are single tables you can directly map to, but how do I go about mapping source data to fields on a specific catalog item on the Requested Item table? Is this possible? Is there a better way to accomplish my end goal of creating 700 inserted records of a specific catalog item with the dozen values I need for each one? I need these to be newly inserted records so that the workflow runs for each.

I appreciate any assistance. We're on Paris patch 4.

Brian

[Kevin Dugger · Accepted solution]

Good Afternoon Mayor,

If I am understanding your ask correctly, you are have an existing catalog item and you would like to create a request for each row of your spreadsheet.  It has been a while since I've needed to do this, however, I believe you can script the transform in order to accomplish this.  These cannot be directly mapped like a normal transform because of the way data is stored for catalog variables.  What I would do is to import the data you have into an import table, then create a transform map, and use a transform script to create the catalog items. 

Review the Service Catalog Script API for details on how to script this.  This should allow you to create a catalog request for each row of your data. 

Details of how to script this can be found in the Transform Map Script API documentation.

I hope this helps you get started.

Thanks,

Kevin

[Brian Hatt]

Thank you!

[sachin_namjoshi]

Below blog has solution to load data from spreadsheet for catalog items

https://community.servicenow.com/community?id=community_blog&sys_id=d3dc8911db285490190dfb243996199a

Regards,

Sachin