Import Dashboard - Import Issues

If errors or warnings occur during the import process, you can download the Download Import Issues report which contains only the assets where an error or warning was detected.

The Download Import Issues report is only available for imports containing errors and warnings.

- this appears when the import contains Errors or Warnings. Selecting it gives you the option Download Import Issues, this downloads a report with all the errors and warnings found with the import.

To download the report:

  1. On the Portfolio page, select the Import tab. The Import Dashboard appears.

  2. In the Import Dashboard find the import which has errors or warning.

  3. Select against the import and select Download Import Issues.

  4. The Issue Report is downloaded to your browser download folder.

The Issue Report is a .csv file which contains only the assets with errors or warnings. Each row in the report includes the following columns:

  • Type - whether the issue is an Error or Warning.

  • Asset External ID - the unique identifier of the affected asset.

  • Message - a description of the issue e.g. AssetCategory with ID Room not found in database. Please set it manually.

Error Handling

If any of the following problems occur, the effected row will not be imported:

  • A mandatory field value is missing i.e. the field is empty.

  • A field expecting an integer or decimal e.g. Quantity, Latitude, etc. has an invalid format.

  • A value exceeds the allowed maximum length for the text field.

  • The ‘Level’ value, for TM ALM 1.0, is outside the allowed range of 1-20.

Warning Handling

If a row has a warning, it is still imported, but informs you there are issues which must be corrected later manually.

  • An incorrect dependency warning applies to ID reference fields: AssetConditionId, AssetCategoryID, AssetSubCategoryID, PortfolioID.
    If the provided ID does not exist in the database, the system imports the row, but the field is set to null, and a warning is generated.

  • An enum warning applies to enumeration fields: AssetStatus, AssetType, AssetDecentIndicator, ComplianceStatus, Compliance Renewal Type.
    If an invalid value is provided from an enum field, the system imports the row, but the field is set to Unrecognized, and a warning is generated.