Viewing Validation Errors for Uploaded Inventory Spreadsheets

IT Asset Management (Cloud)

Diagnose the source of any spreadsheet validation errors.

A page is available that analyzes validation errors in all uploaded inventory spreadsheets (both one-off through the web interface, and scheduled through an inventory beacon). This page is not directly available through the menus, but you can reach it in either of the following ways.

To review upload validation errors:

  1. To access through the Inventory Data One-Off Upload page (Data Collection > IT Assets Inventory Tasks > Data Imports > Inventory Data > One-off upload):
    1. Scroll to the bottom to the Last 5 uploads list.
    2. If necessary, click the + expander in the Task/Step column to reveal individual steps in the processing until the error is revealed.
    3. In the Summary column, click the Validation errors hyperlink.
      The Inventory Upload Validation Errors page displays.
  2. To access through the Data Imports page:
    1. Go to the Data Imports page (Data Collection > IT Assets Inventory Tasks > Data Imports).
    2. Click the Inventory Data tab.
    3. Identify the connection for your inventory spreadsheet import, and click the expander arrow on its far right.
      The Last completed import section shows the count of validation errors. You may click the count (if it is more than zero).
    4. If necessary, click on Show/hide task status and history to expose the matching panel.
    5. In the Summary column, click the Validation errors hyperlink.
      The Inventory Upload Validation Errors page displays.
  3. Use the diagnostic information to locate and fix the problem. (See the online help for this page for further details.)
  4. Repeat the upload using the modified spreadsheet(s).
    Important: For a one-off upload, remember that you must delete the connection for your previous upload before attempting another.

IT Asset Management (Cloud)

Current