Asset import set issue

amber_martin
Kilo Contributor

Hello.   I am having issues with my import sets when using importing assets. Hopefully someone can please give me insight.   My version of SN is Helsinki. The models were already created before import. I imported some laptops using transform map and mapped my fields. After import I checked my data and the Company, Model, and Class were not recognized.   Those fields were blank therefore the Display Name was not created correctly so they did not go to the already created model. The class was populated as Product Model instead of what I specified as Hardware Model.   I believe those fields didn't import correctly because they are referenced fields. Is there a way to import those fields without scripting or is there something else I am missing?

7 REPLIES 7

So the mapping is correct - your data from the source needs to include the Dell Inc. value in front of the Precision Tower 5810 model value.   Like you said the display name is a combination of Manuf and Model Name - so the data coming in from the source needs to be the same.



Or you will need to go into that specific mapping - and do a script and combine the two fields into one value.



-Akash


mechamberlain
Mega Expert

Amber,



This is how I load assets successfully, including their models.   I hope this helps!   Below are screen captures of some sample data (spreadsheet), as well as the transform map used for importing them.   The key re: model is to insure that the "Model" field in the import data exactly matches the full display name of a hardware model that you have already set up.   For example "Hewlett-Packard EliteDesk 800 G1".



Marty


LOAD Data.JPG



LOAD Transform Map.JPG



LOAD Model.JPG


sorry for responding to a 5yr old post but havent found a straightforward solution to this question: 

if you have multiple models of the same name that truly are different (not duplicates) due to being different configs/model number etc, then how do you match up the correct Model when importing assets?