How to set model (category) on bulk asset upload?

[peterraeves]

I'm doing a bulk asset upload by using the simple Excel import functionality (read: not using any transform maps), with different types of assets (laptops, computers, cellphones, monitors, etc). All Model categories are in place, so the correct CIs will be created, but how I have a problem setting the Model Category. When uploading the excel sheet, it complains that 'Model category' is an unknown field. Why is it complaining? We all know it exists... I noticed I cannot change the model after insertion, so why can I not set the Model category?

Update: Manually entering data into the import rows works fine. But the model data just is not moved from the excel file to the import rows... Why...

[amaradiswamy]

Hi Peter,

Try with transform map functionality.

Regards,

Swamy

[peterraeves]

That's the weird part. The transform map that servicenow created contains the correct mapping for the model category. The problem happens before that, because it does not load this value into the staging table.

[Mouli8]

hi peter,

did you get any solution?

[peterraeves]

I don't remember correctly, but I think I solved it by just creating my own Transform Map. Even with a simple import, it still creates a staging table and transform map, so it's even less work to just create them yourself and make sure everything is correct. That way, it can also be reused if needed.