PACP/LACP Import Dialog

This dialog is used when importing CCTV data from PACP and/or LACP format files.

It is displayed when the following option is selected from the Network menu:

ClosedShow me

PACP/LACP Import dialog

Dialog description

Option group

Description

Import

Options for selecting the data to be imported.

File

For entering or browsing to the MDB file(s) to be imported.

Click Browse to display a standard Windows Open dialog for selecting one or more files.

Flag for imported fields

The flag selected here will be used to flag fields containing data brought in by the importer.

Import PACP

If checked, imports data from the following PACP database tables:

  • PACP_Inspections
  • PACP_Conditions
  • PACP_Media_Inspections
  • PACP_Media_Conditions
  • PACP_Custom_Fields
Import LACP

If checked, imports data from the following LCAP database tables:

  • LACP_Inspections
  • LACP_Conditions
  • LACP_Media_Inspections
  • LACP_Media_Conditions
  • LACP_Custom_Fields
Import images

If checked, imports CCTV survey images.

Mark imported surveys as completed If checked, forces the importer to mark all surveys it has imported as "completed". This sets the completion date to be a duplicate of the “When Surveyed” field.

Generate IDs from

 Options for generating CCTV Survey IDs.

Generate IDs from

For selecting a method for generating survey IDs.

Survey IDs may be generated from:

  • Upstream_MH, Direction, Date and Time - CCTV survey IDs are generated from the Upstream manhole, Direction, Date and Time values
  • Upstream_MH, Direction and an index if needed for uniqueness - CCTV survey IDs are generated from the Upstream manhole and Direction values. An index is appended to duplicate IDs to preserve uniqueness.
  • the InspectionID field
  • any of the custom fields
If blank, use InspectionID instead

Enabled when generating IDs from custom fields.

If checked, uses the Inspection ID if the custom field does not contain a value.

Duplicate IDs

Options for importing CCTV Surveys with duplicate IDs.

Do not import duplicate survey Surveys with duplicate IDs will not be imported. These surveys will be reported in the import log.
Update existing survey Surveys with duplicate IDs will be updated with the current survey data.

There is a special case for duplicate handling: an upstream and downstream survey with the same ID may exist if a pipe has been surveyed in both directions. In the case where upstream and downstream manholes are the same, but direction is different, the ID of the upstream survey will be suffixed with a U to prevent a duplicate occurring.

Importing CCTV Survey Data