Easy Import from Excel not populating the Model field for some models


Description

An Easy Import for the hardware table is not consistently populating the Model Name field for a specific model (Hewlett-Packard HP EliteBook 8540w). Similar devices are created successfully, but any attempt to create a device with this model results in record created with a blank Model Name.

Cause

Model name (Hewlett-Packard HP EliteBook 8540w) is larger than the 32 characters set for the field in the staging table field (u_imp_tmpl_alm_hardware) field (u_model). Because of this, the value stored in the staging table is truncated to (Hewlett-Packard HP EliteBook 85) which doesn't match any of the accepted models and thus the model is left blank when the rest of the data for this item is imported into the hardware table.

Resolution

Increase this field length to 64 characters for the (u_model) field. This can be done from the table definition for (u_imp_tmpl_alm_hardware). If you think you might need more than 64 characters for the model names in the future, you can increase the value up to 128, but we don't recommend increasing it beyond 255 at max. This will prevent this issue from occurring again in the future during an Easy Import.