Import BEFDSS XML CCTV Dialog

This dialog is used when importing CCTV data from BEFDSS XML format files.

BEFDSS (Belgian Exchange Format for Drain and Sewer Systems) is a Belgian standard format used for files containing standardised CCTV Inspection Data.

The dialog is displayed when Import | Import CCTV survey data | Import BEFDSS XML CCTV data is selected from the Network menu.

Show me

Dialog description

Option	Description
Import	Select data to be imported: Browse for the XML 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. Check the Import images from file specified in PHOTO_REF field option to import CCTV survey images. InfoAsset Manager will accept an absolute path in the PHOTO_REF field of the BEFDSS XML file, or a relative path if the image is in the folder containing the XML file, or a sub-folder. Check the Update existing records by matching node 1 reference, node 2 reference and employers job reference. Create survey if match not found. option to merge survey data into existing surveys. If a match is not found, a new survey will be imported.
Generate IDs from	Set option for generating CCTV Survey IDs: StartNodeRef, Direction, Date and Time: if the generated ID is longer than 40 characters, the ID will be truncated. An index number will be added to the end of the ID to preserve uniqueness where appropriate. StartNodeRef, Direction and an index if needed: CCTV Survey IDs are generated from the StartNodeRef and Direction fields. An index is appended to duplicate IDs to preserve uniqueness. Generated IDs longer than 40 characters will be truncated with the index appended to the truncated ID. PIPELINE_IDNR: CCTV Survey IDs are generated from the PIPELINE_IDNR field. If the generated ID is longer than 40 characters, the ID will be truncated. An index number will be added to the end of the ID to preserve uniqueness where appropriate.
Duplicate IDs	Set an option for importing CCTV Surveys with duplicate IDs when using the StartNodeRef, Direction, Date and Time or PIPELINE_IDNR ID generation option: Do not import duplicate survey: surveys with duplicate IDs will not be imported. These surveys will be reported in the import log. Overwrite existing survey: surveys with duplicate IDs will overwrite existing surveys. When using the StartNodeRef, Direction and an index if needed ID generation option, surveys with duplicate IDs will be imported with a different suffix. Existing surveys will not be changed.

Option

Description

Import

Select data to be imported:

Browse for the XML 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.
Check the Import images from file specified in PHOTO_REF field option to import CCTV survey images.

InfoAsset Manager will accept an absolute path in the PHOTO_REF field of the BEFDSS XML file, or a relative path if the image is in the folder containing the XML file, or a sub-folder.

Check the Update existing records by matching node 1 reference, node 2 reference and employers job reference. Create survey if match not found. option to merge survey data into existing surveys. If a match is not found, a new survey will be imported.

Generate IDs from

Set option for generating CCTV Survey IDs:

StartNodeRef, Direction, Date and Time: if the generated ID is longer than 40 characters, the ID will be truncated. An index number will be added to the end of the ID to preserve uniqueness where appropriate.
StartNodeRef, Direction and an index if needed: CCTV Survey IDs are generated from the StartNodeRef and Direction fields. An index is appended to duplicate IDs to preserve uniqueness. Generated IDs longer than 40 characters will be truncated with the index appended to the truncated ID.
PIPELINE_IDNR: CCTV Survey IDs are generated from the PIPELINE_IDNR field. If the generated ID is longer than 40 characters, the ID will be truncated. An index number will be added to the end of the ID to preserve uniqueness where appropriate.

Duplicate IDs

Set an option for importing CCTV Surveys with duplicate IDs when using the StartNodeRef, Direction, Date and Time or PIPELINE_IDNR ID generation option:

Do not import duplicate survey: surveys with duplicate IDs will not be imported. These surveys will be reported in the import log.
Overwrite existing survey: surveys with duplicate IDs will overwrite existing surveys.

When using the StartNodeRef, Direction and an index if needed ID generation option, surveys with duplicate IDs will be imported with a different suffix. Existing surveys will not be changed.

Importing CCTV Survey Data