How to set Model Category on Bulk Hardware Model Import?

[seanstev]

 

Good day,

I was trying to do a bulk hardware model import but it does not allow me to update the Model Category. I get the error:

"The following fields have been ignored, because they don't exist on the destination table: cmdb_model_category"

I made sure that the transform map (u_imp_tmpl_cmdb_hardware_product_model) has the u_cmdb_model_category field mapped to Model Category.

This is the excel file I am using with some test hardware models.

[seanstev · Accepted solution]

I was able to find a workaround using import sets. The file attached below details the steps on how to do this. If there is a straightforward solution to this by using the import button on the "hardware models" do let me know. Thank you.