How to create records using Import function to create Task Record.

[ervinpaul]

Hi everyone,

Just want to ask, is there a way to populate the catalog item form/record using import function that will also automatically create a task record? 

We have a requirement that the users will need to import 50+ records in ServiceNow then it will automatically create a record and populate the fields of a catalog item based on the import file field values. Once the data is imported, it will automatically create a task record for each of the imported data to track the progress of the records. 

[Mani A]

Did you try with import sets/ transform maps?

[ervinpaul]

The requirement is that the Users should be able to import records in the Catalog Item and it will automatically create catalog item records/request item for each of the records in the file. With the import set/transform maps yes we can do that, but does it automatically populate the fields in the catalog item, or does it trigger the creation of service catalog flow? 

[Mani A]

So user will attach excel sheet on catalog item and click on order now and it will create multiple RITMs based on excel data ? Is it the requirement ? Or 

User will use importset and upload the sheet and it will create just new catalog Items in sc_cat_item table...and you wanted to create RITM for this individual Item from transform map ???

[ervinpaul]

The 2nd statement is correct, users will import the record using the importset function then based on the imported records it will update the fields of the catalog item then it will create a RITM record for each of the records