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:

Import | Import CCTV survey data | Import PACP/LAPC CCTV data

Show me

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