You may also import survey data, specifically NASSCO MACP format CCTV data, to InfoAsset Planner's manhole facility type.

  1. From the InfoAsset Planner menu, select Import Manhole Survey Data or navigate to the Manhole Operation Center window, right-click, and select New.

  2. Notice that for manholes, there is only one survey standard template available in InfoAsset Planner.

  3. After giving the survey import an ID and description and identifying the data scope and source data (note that these options are very similar to pipe survey options), click Next to open the three panel Import Manhole Survey Data window.

  4. This window is similar to other survey and facility import data windows.  Tables to import to are specified on the left, the data source and import options are specified in the middle panel, and field mapping is specified on the right.  The difference is that for manholes, additional tables to import to are specified within the left panel.  Inspection and Conditions tables are still available, but also Connections tables.  These Connections tables operate similarly to Conditions tables; they are observations which must be tied to a unique inspection.

  5. Other items to pay special attention to while importing manhole CCTV data include:

    • Be sure to map the Manhole Component ID field in the Conditions table even though it is not technically required.  Each manhole defect should occur in a particular part of the manhole.  Each part of the manhole has a different component ID; Wall Exterior = WE, CMI = Chimney Interior.  Sometimes this field may be named simply 'Component' in the client data.

    • If Connections and Conditions are identified within that same source data table, users may simply reference the same data and break it up into InfoAsset Planner's Connections and Conditions table template.

    • The Manhole Number field in the Inspections table must match the manhole facility ID in GIS.  This is how InfoAsset Planner ties manhole survey imports inspections to manholes.

    • Date and Time are the fields used to reindex unique inspections.  All manhole inspections with non-unique dates and times will be considered individual inspections; duplicates will be removed.

  6. Once everything is set as desired, click Import and review any messages or errors.