Inventory Upload Validation Errors Page

This page gives further details to help pinpoint the source of errors in the import of inventory spreadsheets (including CSV files). It applies to errors in both:

• One-off uploads of inventory spreadsheets through the web interface of IT Asset Management

• Scheduled (repeatable) uploads of inventory spreadsheets through an inventory beacon.

To identify and correct errors in inventory spreadsheets:

1. Use the columns described below to better understand the location of the validation problem.

   For example:

   • Affected item identifies the spreadsheet containing the problem.

   • Error type and Error summary clarify what the problem is.

2. Re-open your original spreadsheet, and correct the problem(s) identified.

3. For a scheduled import of the inventory spreadsheet through an inventory beacon, either:

   • Wait for the next scheduled upload to remediate the problem

   • In the FlexNet Beacon interface, in the Inventory systems page, select the connection that includes the modified spreadsheet file, and click Execute Now.

4. For a one-off import through the web interface:

   1. Go to the Data Imports page. Select the Inventory Data tab.

   2. Identify in the list the connection that includes the modified spreadsheet, and below the Input details, click Delete connection.

      note

      It is critical that you remove any previous one-off upload data before uploading a new one.

   3. Click One-off upload, and once again define your upload (see Inventory Data One-Off Upload Page for details).

   4. Click Start processing to repeat the upload/import/processing.

   5. Check in the Last 5 uploads list that the errors are not repeated for this latest upload.

The following columns are available to help analyze the validation errors in your imported inventory spreadsheets:

Column	Details
Affected item	The type of a spreadsheet template that caused an error. It is linked to one of the 9 types of inventory data you uploaded to IT Asset Management from the Inventory Data One-Off Upload page. For example, if you used the Computers and VMs field, the upload error, if any, would read ConsolidatedComputer.
Error summary	This includes: A description of the inventory upload error The object affected by the error (note that the problem may be with a sub-object of the affected item, such as a virtual machine which is a sub-object of a computer) The name of the spreadsheet column containing the issue The row number containing the error.
Error type	The type of an error that occurred during the inventory data upload. Data import errors can occur for a variety of reasons. The following is a list of common error messages and possible reasons (all error-specific details are displayed in Error summary column). Duplicate key. A duplicate record exists in the spreadsheet. If a duplicate row is identified, only a single entry is created. Identification is based on matching the values in key columns. For example, if the keys match, but some of the other data is different, the first row of the two is kept, while all duplicate rows that follow are discarded. Invalid column. The spreadsheet file contains an invalid column: the row that includes the invalid column's cell is uploaded only partially. For example, if an uploaded Computer.*xls* spreadsheet contains an incorrect field for a virtual machine, then the virtual machine's record is not created. However, any other data that the spreadsheet contains (related to computers or users, and so on) gets imported when that row is processed. Invalid object. Indicates that a mandatory column value was not provided, or the incorrect type of spreadsheet template was used.
Occurred on	The date an inventory upload error occurred.
Procedure	Indicates one of the procedures performed by the system importer against an uploaded spreadsheet file.
Skipped	Indicates whether the associated error was so severe that the entire row of the spreadsheet file was ignored. If so, Yes is displayed.
Step	Indicates the inventory import step during which an error occurred.