Import CCTV from EU XML / CSV Dialog

Select data to be imported:

• Browse for the XML or CSV file to be imported. A standard Open dialog will be displayed. Multiple files may be selected by using the CTRL and SHIFT keys.
• The flag selected in the Flag for imported fields dropdown will be used to flag fields containing data brought in by the importer.

Set option for generating CCTV Survey IDs:

• Generate IDs from: select a method for generating survey IDs. Survey IDs may be generated from:

  • AAB (Start node ref), AAK (Direction), ABF (Date) and ABG (time): CCTV Survey IDs are generated from the Start Node, Direction, Date and Time data.

  • AAB (Start node ref), AAK (Direction) and an index if needed: CCTV Survey IDs are generated from the Node ref at the upstream end of the survey and the Direction field. An index is appended to duplicate IDs to preserve uniqueness.

Set an option 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.