| 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.
|
