Bulk Equipment Update

If you need to update scannable ID values (such as barcodes) for many pieces of equipment, you can edit the data in a spreadsheet and import it.

To update multiple scannable ID values:

  1. Point to the Setup & Admin tab and click Bulk Equipment Update.
  2. Click Create Equipment File. The software displays controls for running an equipment report. This report will be the basis for your edits.
  3. Select the Site and Area where the equipment resides. For multiple locations, select All Areas within a site or All Sites.
  4. Filter the report to eliminate equipment records that you do not need. Select the appropriate check boxes to exclude equipment records that do not have a barcode, RFID, or NFC. For example, if you only need to update RFID codes, then select the No Barcode listed and No NFC listed check boxes.
  5. Click Run Report.
  6. Click Export to Excel.
  7. Open the report in Microsoft Excel and make your edits. Save and close the report.

    Important: Do not edit values in the Internal ID column!

  8. In LINK360 software, scroll back to the top of the Bulk Equipment Update page and click Select File to Upload.
  9. Click Choose File, then navigate to and select the edited report. Click OK.
  10. If the software indicates that errors were found, scroll through the preview to find any error messages. Edit the report to fix the errors, and again select the file to upload.
  11. If you want the software to generate a barcode for any pieces of equipment that do not already have one, select the Generate barcode if none check box.
  12. Click Import. The software displays statistics about the update (number of IDs changed, unchanged, and so on).