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]

@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! 🙏

[Connectmustaq]

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