How do I update an existing list of assets via a bulk import?

[Kerry M Kennedy]

I have an existing list of asset objects (~250) that have attributes which need to be updated. I would like to do this in a bulk import manner if possible. I attempted an import but the imported items were treated as brand new assets which essentially caused duplicates and thus ~500 objects. How do I tell the import to only update the existing attributes for each asset object?

[Mark Higgins]

Hi Kerry,

Do you have a column in the input file that contains the 'key', and the name in the input file, need to match what your assets are, otherwise, you end up with duplicates.

For example:

If you asset has a key of ITSM-1, then your csv file, needs to contain the column ITSM-1.

If it doesn't you end up with duplicates.

Hope this helps.

Mark

[Kerry M Kennedy]

Thanks Mark. Yes, my CSV import file contains a column that is named exactly the same as my assets key column. I'm thinking once the new (duplicate) assets were created, that I might should have tried moving the new objects into the old ones? I've never even seen this done so purely speculating. I see under the "gear symbol" on my scheme page, there options for bulk operations.

[Mark Higgins]

Hi Kerry,

Just a thought, are all the column names in your file, matching the names in your assets.

If you have a colum called office phone and the asset is AD Phone, then that may cause duplicates.

M