B.4 Validating a Spreadsheet

Before you submit the Bulk Import spreadsheet, clear the contents in the Validation Status cell for each machine that you want to validate for import (or re-import).

The Validate tool displays the following states for machines and adds the information to the Validation Status column of the Results spreadsheet:

  • Ready for Import: The row contains valid information.

    The Validate tool found no errors in the data submitted for the machine. All values are valid options and in the expected format. All required and dependent values are present.

  • Invalid: The row contains invalid information.

    The Validate tool found one or more errors in the data submitted for this machine. The cell also includes messages about the type and location of the errors.

  • Imported: The row was successfully imported or re-imported.

    On import, PTM creates (or modifies) the original and proposed workloads for this machine in the specified project. If you have edited the proposed workload by using the Web Interface, a re-import modifies data only for the original workload.

  • Ignored: The row was previously imported for a workload that has already been submitted for transformation.

    You can use the Workload dialog to withdraw the machine from transformation to make it eligible again for re-import.