First we need to get the spreadsheet set up. The Bulk updating works by pivoting around a unique field as the identifier (This is usually Serial Number or Barcode).
Once Spreadsheet is Ready
- Navigate to the asset window
- Select Import
Select the Spreadsheet to be imported
Now it is time to import
- Map the correct fields
- Important: Check Update Box next to the unique field being used
- Select Import File
If no errors occur, Select Apply Changes.
**If there is an error do not apply changes, correct information in spreadsheet and try again
0 Comments