How we can update the existing cmdb data with out load data functionality

[kurella swamy]

Hi,
I have some custom fields on cmdb_ci table so I need to update those custom fields whenever Name,IP address and serial number matches with existing records in cmdb_ci table. Here we are giving excel templates to users it contains Name,Ip Address, serial number and custom fields and they fill all fields, but they don't have access to load data functionality to upload the excel file.Is there any alternative methods to user upload the excel file and run the transform map in back end data first loaded in staging table and then cmdb table.

Thanks in advance.

[Rohit Singh]

Hi @kurella swamy ,

It's better to have a service catalog in place for users to create a request and then that request should come to ServiceNow admins who can upload the data using transform map. This is the good practice rather giving access to users to run the transform map in staging or CMDB table.

If my response helped, please hit the Thumb Icon and accept the solution so that it benefits future readers.

Regards,
Rohit

[kurella swamy]

Hi @Rohit Singh, thanks for your quick response.

I need to provide users with the ability to upload Excel files, but I’m exploring different approaches beyond the load data functionality. Could you suggest alternative methods to achieve this?