Change Dictionary names of CMDB table fields

[Bhavna3]

Urgent !

Hi,

I need to change the dictionary names of about 300 fields in different custom tables (also the field types). Since we cannot change the dictionary names and it is also not recommended, I wanted to look for options on how can we rename the dictionary names without deleting the old fields and creating duplicate ones.

This is required as the response key that we receive from an external source have changed and we need to map the data in our custom tables according to new field names present in the Response.

[xease]

Hi,

Instead of trying to rename fields in the custom table, you could create a staging table which will contain information about which response field should be mapped to which field of your custom table. You can refer the staging table before updating or inserting records to the custom table to make sure values are getting set correctly.

Sample Staging table record(suppose custom table field is u_name and response key is new_name):

Column Name                 Value

Custom Table name         table_name

Response Key                 new_name

Custom Field Name         u_name 

This approach should help you tackle scenarios in future when the response key changes again for some reason. You just update the staging table.

Please mark as correct or helpful if it solved your problem.

[Bhavna3]

Thank you for the quick response, can you please help me to understand how will we map the Response key and Custom field name since there are 300 fields that we have to change, so there has to be 300 mappings.

[xease]

Hi,

One approach I can think of is, you can export the list of field names of the custom table table in an excel and then manually input the corresponding response keys.

Finally, use an import set to import the excel in the staging table.

Since there are 300 fields, there will definitely be some manual effort needed to create the staging data set.