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.
   

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

3. In the Open Data Import Center dialog, in the Table to Import Data Into drop-down, select Manhole Survey.
4. In the Flag Behavior group, select any necessary flags for the imported data.
5. Under Data Source, set the Source Type to MapInfo TAB File.
6. Next to File, click Browse (…).
   
7. In the Open dialog, locate and select the GIS TAB file.
8. Click Open.
   

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

9. To identify a script file, in the Script File group, click Browse (…).
   

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.

10. To start, click Auto-Map to automatically map fields in the external data to fields in the database.
    
11. Use the grid table to manually map any remaining fields.
12. Once all the fields have been mapped, click Import.
    

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.

13. Click OK.
14. 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.

15. From the File toolbar, click Commit changes to database.
    
16. In the Commit change to server dialog, add a comment, such as “Imported Manhole Survey Data from GIS Layer”.
17. Click OK.