Bulk Upload from a catalog form to cmdb_ci table

[prasannah]

Hi 
I need help to create a bulk upload , so my requirement is if after submitting the catalog form with excel that data needs to be created in cmdb_ci table. I have created an custom table to use it as a staging table, and a data source and transform map for that data source.
can anyone give script or how I need to load and transform the records into target table. 

[Ankur Bawiskar · Accepted solution]

@prasannah 

I created blog for something similar, you can refer that and enhance

Data load and transform via Catalog Item 

refer this blog for something similar using flow

Transform Attachments with Flow Designer 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[prasannah]

sorry I didn't understood the meaning on data source on the fly, can you please elaborate ?

[prasannah]

Hi 
Sry I didn't understood the meaning of the data source on the fly. could you please elaborate how I need to do for the 2-3 request at the same time, Currently I did it in flow designer and it is working fine with one request at a time. 

[prasannah]

Hi @Ankur Bawiskar ,
How to get the all rows of excel is updated or inserted in the target table and print it somewhere or bulk upload completed/success or failure? if failed I can create a catalog task for the same.

[Ankur Bawiskar]

@prasannah 

you will have to somehow have linkage between the import set record and the RITM

This will help you determine if import was success/failure

[Me Being Mustaq · Accepted solution]

Hi @prasannah,

 

To move bulk uploaded data from your custom staging table into the cmdb_ci table in ServiceNow after importing from Excel, you need to configure your Transform Map correctly and use either field maps for direct mapping or a transform script for custom logic. 

Best Practices and Pitfalls

• Use coalesce on a unique field like serial_number to prevent duplicates when importing.​

• Ensure mandatory fields in cmdb_ci or its subclasses are populated; otherwise, records may fail to insert or violate data integrity rules.​

• Always test with a small data batch before full-scale upload, and validate transformation via Import Set errors/logs.

• If dealing with multiple CI classes, you may need separate transform maps for each class or handle sys_class_name dynamically as illustrated above.​

This scripting and mapping method is a proven best practice for CMDB bulk data uploads using import sets and transform maps in ServiceNow

If it is helpful, please hit the thumbs button and accept the correct solution by referring to this solution in the future it will be helpful to them.

Thanks & Regards,

Mohammed Mustaq Shaik