Import data from GIS in InfoAsset Manager

Any referenced datasets can be downloaded from "Module downloads" in the module overview.

Import data from GIS in InfoAsset Manager

Step-by-step guide

Network data can be imported into InfoAsset Manager from a range of sources, including InfoAsset Planner models, manhole survey data files, GIS files, and CSV files. While direct import from these sources is possible, it is more common to use the Open Data Import Centre (ODIC), which allows for data to be mapped automatically to the relevant object data table.

Begin with a new Collection Network created and opened on the GeoPlan.

To view and select from available import options:

  1. In the Network menu, select Import.
  2. Select Open Data Import Centre to open the ODIC.
    The Network menu expanded and Import selected, and, in the flyout, Open Data Import Center being selected and called out with a red arrow.

In this example, data is being imported from a GIS TAB file that contains information about manhole surveys.

  1. In the Open Data Import Center dialog, in the Table to Import Data Into drop-down, select Manhole Survey.
  2. In the Flag Behavior group, select any necessary flags for the imported data.
  3. Under Data Source, set the Source Type to MapInfo TAB File.
  4. Next to File, click Browse (…).
    In the Open Data Import Center dialog, settings configured for this example and highlighted in red, with Browse being selected and called out with a red arrow.
  5. In the Open dialog, locate and select the GIS TAB file.
  6. Click Open.
    The Open dialog, with the GIS TAB file selected and called out with a red arrow, and Open being selected and highlighted in red.

In some cases, a script can be used to more precisely control the import process.

  1. To identify a script file, in the Script File group, click Browse (…).
    In the Open Data Import Center dialog, under Script File, Browse being selected and called out with a red arrow.

In this case, the record values in the external GIS tables do not require conversion, so no script file is needed.

Next, use the field mapping grid to define how the external data should be imported into fields in the database. The external Import Fields should match the internal InfoAsset Manager Object Fields, or have Default Values specified, if necessary.

  1. To start, click Auto-Map to automatically map fields in the external data to fields in the database.
    The Open Data Import Center dialog, with Auto-Map highlighted in red.
  2. Use the grid table to manually map any remaining fields.
  3. Once all the fields have been mapped, click Import.
    In the ODIC, data fields mapped in the grid table and Import being selected and highlighted in red.

This imports the external data based on the settings in the ODIC.

A dialog reports the number of records created during the import of the external table and any errors that have occurred.

A dialog reporting the number of records created and any errors that occurred during the import.

  1. Click OK.
  2. In the ODIC dialog, click Close.

To transfer local data to the server and to make it available to all users of the InfoAsset Manager Database, the changes must be committed.

  1. From the File toolbar, click Commit changes to database.
    The File toolbar, with Commit changes to database called out with a red arrow.
  2. In the Commit change to server dialog, add a comment, such as “Imported Manhole Survey Data from GIS Layer”.
  3. Click OK.
    The Commit change to server dialog, with comments added and OK being selected, both highlighted in red.

Video quiz

In the ODIC, which of the following groups is used to define how external data should be imported into fields in the database?

(Select one)
Select an answer

1/1 questions left unanswered