How do I update fields in current assets using import?

Many of our laptops recently went off lease and we are purchasing them FMV.  I downloaded the asset template and added the serial numbers, purchase date and warranty (required field).  When I run the import it says the serial numbers already exist.  I am not trying to add new assets, but want to add information into current assets.  Is this an option?  Or does the import only work for new assets?  This is important because I want to know which ones we purchased, and which ones are still on a lease contract.  I am surely hoping I don't have to do this one asset at a time.

  • warranty (required field) is an Asset Custom field of type date?

  • The option to enter from a drop down is "1 Year"

  • Ok, tested with just one Asset on my test system and it appends it fine, no new Asset entries so should work fine.

  • Sync based on Serial Number.  It asks for Client Key.  Drop down choice is User Name.  Ignore Blank Fields checked.  File type Microsoft Excel.  Template has Serial Number, Purchase Date, and Year 1 for warranty. Returns the following error:

    Line 2: Asset No. is already taken.
    {'10RDMT2', '', '', '', '', '', '', '', '', '', '', '', '11/1/22', '', '', '', '', '', '', '', '', '1 Year', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''}

    Line 3: Asset No. is already taken.
    {'13XRMT2', '', '', '', '', '', '', '', '', '', '', '', '11/1/22', '', '', '', '', '', '', '', '', '1 Year', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''}

    Line 4: Asset No. is already taken.
    {'17RDMT2', '', '', '', '', '', '', '', '', '', '', '', '11/1/22', '', '', '', '', '', '', '', '', '1 Year', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''}

    Line 5: Asset No. is already taken.
    {'17RQNT2', '', '', '', '', '', '', '', '', '', '', '', '11/1/22', '', '', '', '', '', '', '', '', '1 Year', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''}

    Line 6: Asset No. is already taken.
    {'1BRQNT2', '', '', '', '', '', '', '', '', '', '', '', '11/1/22', '', '', '', '', '', '', '', '', '1 Year', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''}

  • Line 2: Asset No. is already taken.
    {'10RDMT2', '', '', '', '', '', '', '', '', '', '', '', '11/1/22', '', '', '', '', '', '', '', '', '1 Year', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''}

    Line 3: Asset No. is already taken.
    {'13XRMT2', '', '', '', '', '', '', '', '', '', '', '', '11/1/22', '', '', '', '', '', '', '', '', '1 Year', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''}

    Line 4: Asset No. is already taken.
    {'17RDMT2', '', '', '', '', '', '', '', '', '', '', '', '11/1/22', '', '', '', '', '', '', '', '', '1 Year', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''}

    Line 5: Asset No. is already taken.
    {'17RQNT2', '', '', '', '', '', '', '', '', '', '', '', '11/1/22', '', '', '', '', '', '', '', '', '1 Year', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''}

    Line 6: Asset No. is already taken.
    {'1BRQNT2', '', '', '', '', '', '', '', '', '', '', '', '11/1/22', '', '', '', '', '', '', '', '', '1 Year', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''}

  • I was doing Sync Based on Asset number rather than Serial number