Fix Inspections Not Linked to Assets

Inspections must be linked to their assets before they can appear on the map or be used to calculate condition scores.

The system links CCTV inspections to pipe assets by matching the Upstream Manhole ID and Downstream Manhole ID on the inspection to the corresponding IDs in the pipe asset table. If either ID is missing, misspelled, or does not match the asset data, the inspection cannot be linked.

Unlinked inspections are excluded from condition assessments and map views, which can result in incomplete or inaccurate condition data for your sewer or storm network.

You can edit the inspection details and save your changes.

Tip: To find inspections that are not correctly linked to assets, filter the inspections list using the Linked Asset column.

Permissions

You can edit inspection details only when the inspection is not in an approved status.

• Users with full access can edit any inspection.
• Field inspectors can edit only inspections they uploaded.

Fix a single inspection

If you only need to fix a few inspections:

1. Open the inspection details page.
2. Find the Upstream Manhole ID and Downstream Manhole ID fields.
3. Enter the correct manhole IDs.
4. Save your changes.

Note: Saving changes does not submit the inspection or change its status.

After you save:

• A note is added to the inspection history.
• The system checks the associated asset and updates the asset link if needed.

Fix multiple inspections at once

If you have many unlinked inspections, you can fix them faster in a CSV file and upload the changes together. Select Fix Issues in the unlinked inspections banner.

1. Export unlinked inspections:
   1. Click Fix Issues, then select Export Unlinked to CSV.
   2. Download the CSV file.
2. Update the CSV file:
   1. Open the CSV file in Excel or another spreadsheet application.
   2. Update the Upstream MH and Downstream MH columns with the correct manhole IDs.
   3. Save the file.
3. Upload your corrections:
   1. Click Fix Issues, then select Upload Corrections.
   2. Select the updated CSV file and upload it.

What happens next?

After the file is uploaded, the system automatically starts the re-linking process. Any inspection whose upstream and downstream manhole IDs match a pipe in the GIS is linked to the corresponding asset.

Once an inspection is linked, it can be used in condition assessments and appears on the map.