How to include model category with hardware model import?

[cuong2]

How would I include the Model categories info when I import asset hardware models from an Excel file?  Even though the cmdb_hardware_product_model table has the Model categories column, this column is neither included in the (insert/update) import Excel template file nor recognized by the import set table.  After the hardware model records are imported, I have to take an extra step to manually update their model categories.

[Akash4]

Hi Cuong,

If this 'model category' exist (a separate column) in the excel sheet that you are importing, you can create a field in the target table to map the same at transform maps.

In the above statement I guess you are importing hardware model records but the model categories exist in another table(not the target table you have used in the transform maps). In this case you can write a background script if you have security_admin role and you can update all the records at once with this category field to be filled in the target table.

Let me know if I am interpreting this correct and I can share you the code to update in bulk. Also provide me the table names and field names with screenshots so as to do this neat and clean.

Regards, Akash

[cuong2]

Hi Akash,

Thank you for your reply.  I was using the easy import method (right-click on the list heading).  Somehow the Model categories field wasn't recognized even though it exists in the target table.  After posting the question, I went back to the standard import process, using import set and transform map, and I was able to load all the hardware model records fine.

Cuong