Share
 
 

Importing CCTV Survey Data

CCTV survey data can be imported into the network from a number of data formats.

Always import data that matches the CCTV standard selected for the current database. Importing data that matches another standard will result in data fields that will not match those for the currently selected standard, and any defect scoring will be wrong.

Note: If the current database is set up for a different CCTV data standard to that associated with the selected data format a warning will be displayed.

The following CCTV data formats can be imported:

Examiner

To import Examiner CCTV data into a network:

  1. Open the network to be updated.
  2. Select ImportImport CCTV survey dataImport Examiner CCTV data from the Network menu. The Import Examiner CCTV dialog is displayed.
  3. In this dialog:
    • Browse to find the data file. A standard Open dialog will be displayed. Multiple files may be selected by using the CTRL and SHIFT keys.
    • Choose a flag to apply to all the imported data if required.
    • Check the User Units option to import values as being in the current display units.
    • Set the options for generating CCTV Survey IDs and handling duplicate IDs
  4. Click Import to complete the import process.

Sewer

To import CCTV data in Sewer.dat format into a network:

  1. Open the network to be updated.
  2. Select ImportImport CCTV survey dataImport Sewer.dat CCTV data from the Network menu. The Import sewer.dat CCTV dialog is displayed.
  3. In this dialog:
    • Browse to find the data file. A standard Open dialog will be displayed. Multiple files may be selected by using the CTRL and SHIFT keys.
    • Choose a flag to apply to all the imported data if required.
    • Check the User Units option to import values as being in the current display units.
    • Set the options for generating CCTV Survey IDs and handling duplicate IDs
  4. Click Import to complete the import process.
Note: Defect Percentage and Intrusion values are defined in the same field in a sewer.dat file. When importing sewer.dat files, both fields in the CCTV defects grid will be populated.

EU CCTV

To import EU CCTV data into a network from XML files and CSV files:

  1. Open the network to be updated.
  2. Select ImportImport CCTV survey dataImport EU CCTV data from the Network menu. The Import CCTV from EU XML / CSV dialog is displayed.
  3. In this dialog :
    • Browse to find the data file. A standard Open dialog will be displayed. Multiple files may be selected by using the CTRL and SHIFT keys.
    • Choose a flag to apply to all the imported data if required.
    • Set the options for generating CCTV Survey IDs and handling duplicate IDs.
  4. Click Import to complete the import process.

PACP/LACP

CCTV data can be imported into a network from a selection of PACP/LACP files.

Data from PACP/LACP files attached to selected CCTV surveys may also be imported.

To import PACP and/or LACP CCTV data into a network:

  1. Open the network to be updated.
  2. Select ImportImport CCTV survey dataImport PACP/LACP CCTV data from the Network menu. The PACP/LACP Import dialog is displayed.
  3. In this dialog:
    • Browse to find the data file. A standard Open dialog will be displayed. Multiple files may be selected by using the CTRL and SHIFT keys.
    • Choose a flag to apply to all the imported data if required.
    • Check the Import PACP box to import data from the following PACP database tables:
      • PACP_Inspections
      • PACP_Conditions
      • PACP_Media_Inspections
      • PACP_Media_Conditions
      • PACP_Custom_Fields
    • Check the Import LACP box to import data from the following LACP database tables:
      • LACP_Inspections
      • LACP_Conditions
      • LACP_Media_Inspections
      • LACP_Media_Conditions
      • LACP_Custom_Fields
    • Optionally check the option to Import Images.
    • Set the options for generating CCTV Survey IDs and handling duplicate IDs.
  4. Click Import to complete the import process.
Note: If a PACP/LACP text value is imported to a choice list field, which has no corresponding choice list record, (because the wrong standard is selected or the choice lists have been edited), the full text will appear in the CCTV Survey Grid instead of a choice list code.

To import CCTV data from survey attachments:

  1. Open the network to be updated.
  2. Select the CCTV surveys with attachments containing data to be imported.
  3. Select Import | Import CCTV survey data | Import PACP/LAPC from attachments in selected surveys from the Network menu. The Import PACP/LAPC from attachments in selected surveys dialog is displayed.
  4. In the import dialog, set options as required.
  5. To complete the import process, click Import.

For each selected survey, InfoAsset Manager will check all attachments for PACP/LAPC files. Surveys will be imported according to the options set in the import dialog.

A log will be displayed providing a summary of surveys imported and reasons for any failures.

MSCC XML

CCTV data can be imported into a network from a selection of MSCC XML format files.

Data from MSCC XML files attached to selected CCTV surveys may also be imported.

To import CCTV data in MSCC XML format into a network:

  1. Open the network to be updated.
  2. Select ImportImport CCTV survey dataImport MSCC XML CCTV data from the Network menu. The Import MSCC XML dialog is displayed.
  3. In this dialog:
    • Browse to find the data file. A standard Open dialog will be displayed. Multiple files may be selected by using the CTRL and SHIFT keys.
    • Optionally check the box to import images.
    • Choose a flag to apply to all the imported data if required.
    • Optionally check the box to mark imported surveys as completed.
    • Set the options for generating CCTV Survey IDs and handling duplicate IDs.
  4. Click Import to complete the import process.

To import CCTV data from survey attachments:

  1. Open the network to be updated.
  2. Select the CCTV surveys with attachments containing data to be imported.
  3. Select ImportImport CCTV survey dataImport MSCC XML from attachments in selected surveys from the Network menu. The Import MSCC XML from attachments in selected surveys dialog is displayed.
  4. In this dialog:
    • Choose a flag to apply to all the imported data if required
    • Optionally check the box to mark imported surveys as completed.
    • Set the options for generating CCTV Survey IDs and handling duplicate IDS
  5. Click Import to complete the import process.

For each selected survey, InfoAsset Manager will check all attachments for XML files that are in MSCC format. Surveys will be imported according to the options set in the import dialog.

A log will be displayed providing a summary of surveys imported and reasons for any failures.

BEFDSS XML

To import CCTV data in BEFDSS XML format into a network:

  1. Open the network to be updated.
  2. Select Import Import CCTV survey dataImport BEFDSS XML CCTV data from the Network menu. The Import BEFDSS XML CCTV dialog is displayed.
  3. In this dialog:
    • Browse to find the data file. A standard Open dialog will be displayed. Multiple files may be selected by using the CTRL and SHIFT keys.
    • Optionally check the box to import images.
    • Optionally check the Update existing records by matching node reference and employers job reference option to merge survey data into existing surveys. If a matching survey is not found, a new survey will be imported.
    • Choose a flag to apply to all the imported data if required.
    • Set the options for generating CCTV Survey IDs and handling duplicate IDs.
  4. Click Import to complete the import process.

CleanFlow

To import CCTV data from a CleanFlow database into a network:

  1. Open the network to be updated.
  2. Select ImportImport CCTV survey dataImport CleanFlow CCTV data from the Network menu. A standard Open dialog is displayed.
  3. Select the CleanFlow database to be imported.
  4. Click Open to complete the import process.

Only one data file can be selected at a time. If the CCTV data is contained in several files, the import process must be repeated.

CCTV images

CCTV image files can be imported and associated with points along CCTV surveys.

See Importing CCTV Images for more details.

SUFRIB

CCTV survey data can be imported from SUFRIB format data files.

Please refer to Importing CCTV and Manhole Survey Data from SUFRIB Format Files for more details.

WSA transfer format

To import CCTV data in WSA transfer format into a network:

  1. Open the network to be updated.
  2. Select ImportImport CCTV survey dataImport CCTV data from WSA transfer format from the Network menu. The Import WSA Data dialog is displayed.
  3. In this dialog:
    • Browse to find the data file. A standard Open dialog will be displayed. Multiple files may be selected by using the CTRL and SHIFT keys.
    • Choose a flag to apply to all the imported data if required.
    • Set the options for generating CCTV Survey IDs and handling duplicate IDs.
  4. Click Import to complete the import process.

ISYBAU CCTV

To import ISYBAU CCTV data into a network from XML files:

  1. Open the network to be updated.
  2. Select ImportImport CCTV survey dataImport ISYBAU XML CCTV data from the Network menu. The Import CCTV Surveys from ISYBAU XML dialog is displayed.
  3. In this dialog:
    • Browse to find the data file. A standard Open dialog will be displayed. Multiple files may be selected by using the CTRL and SHIFT keys.
    • Choose a flag to apply to all the imported data if required.
    • Set the options for generating CCTV Survey IDs and handling duplicate IDs.
  4. To complete the import process, click Import.
Topics in this section
Parent topic: Importing Network Data

Related Information

Was this information helpful?