Is there a way to update custom fields (or any field) in assets with information from a CVS file? We have assets already in our system and a making changes to their information, in a custom field. I do not see where I can have that information update; specific information for each device, specific to that device from the CVS file.
Solved
Update custom fields of assets in system with information from a spreadsheet (cvs file)
Best answer by EStapf_iiQ
Hi
Here is the KB guide for you to reference:
This includes custom fields:
My best piece of advice is to decide if you want to match on Asset Tag, Serial Number, or both. 🤗
Hope this helps!
+14Hi
Here is the KB guide for you to reference:
This includes custom fields:
My best piece of advice is to decide if you want to match on Asset Tag, Serial Number, or both. 🤗
Hope this helps!
will this just update the additional information for the fields, with not changing the asset tag or serial number?
+14will this just update the additional information for the fields, with not changing the asset tag or serial number?
That is correct. Only additional information will be updated. Just be careful that no fields (such as owner) are blank within the .CSV, as that would clear the data already contained in those fields.
Ok, just to confirm, if the CVS file has a column titled owner, and it is blank then it will remove the owner, but if it doesn’t have the column it will not adjust it?
+14Ok, just to confirm, if the CVS file has a column titled owner, and it is blank then it will remove the owner, but if it doesn’t have the column it will not adjust it?
That is correct.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
