Import SewerBatt Survey Data Dialog

This dialog is used when importing acoustic survey data from SewerBatt XML format files.

SewerBatt is a British standard format developed by Acoustic Sensing Technology (UK) that is used for files containing Acoustic Inspection Data.

The dialog is displayed when Import | Import SewerBatt survey data is selected from the Network menu.

Show me

Dialog description

Option	Description
Import	Select data to be imported: Browse for the SewerBatt XML file to be imported. A standard Open dialog will be displayed. Multiple files may be selected by using the CTRL and SHIFT keys. Check the Import images from file specified in column 16 of defect records option to import survey images. The flag selected in the Flag for imported fields dropdown will be used to flag fields containing data brought in by the importer.
Generate IDs From	Set option for generating Acoustic Survey IDs: start_manhole, end_manhole, TEST_DATE_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. An example of acoustic survey id is AB12345678_AB55555555_20150114_1459. start_manhole, end_manhole and an index if needed for uniqueness - Acoustic survey IDs are generated from the Start Manhole and End Manhole fields. An index is appended to duplicate IDs to preserve uniqueness (e.g. AB12345678AB123456791) Generated IDs longer than 40 characters will be truncated with the index appended to the truncated ID.
Duplicate IDs	Set an option for importing Surveys with duplicate IDs when using the Start Manhole, End Manhole, Date and Time 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 start_manhole, end_manhole, and an index if needed for uniqueness 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 SewerBatt XML file to be imported. A standard Open dialog will be displayed. Multiple files may be selected by using the CTRL and SHIFT keys.
Check the Import images from file specified in column 16 of defect records option to import survey images.
The flag selected in the Flag for imported fields dropdown will be used to flag fields containing data brought in by the importer.

Generate IDs From

Set option for generating Acoustic Survey IDs:

start_manhole, end_manhole, TEST_DATE_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. An example of acoustic survey id is AB12345678_AB55555555_20150114_1459.
start_manhole, end_manhole and an index if needed for uniqueness - Acoustic survey IDs are generated from the Start Manhole and End Manhole fields. An index is appended to duplicate IDs to preserve uniqueness (e.g. AB12345678AB123456791) Generated IDs longer than 40 characters will be truncated with the index appended to the truncated ID.

Duplicate IDs

Set an option for importing Surveys with duplicate IDs when using the Start Manhole, End Manhole, Date and Time 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 start_manhole, end_manhole, and an index if needed for uniqueness ID generation option, surveys with duplicate IDs will be imported with a different suffix. Existing surveys will not be changed.

See Importing SewerBatt Acoustic Survey Data for more information.

Importing SewerBatt Acoustic Survey Data

Acoustic Surveys