Import and update data from CSV in InfoAsset Manager

Step-by-step guide

By importing network data into InfoAsset Manager, existing network objects can be updated or deleted, and new objects can be added. This allows the most recent asset and survey data to be included, helping to ensure model accuracy.

In this example, subtable data from a manhole survey must be imported from CSV files. The actual manhole survey table has already been imported as a GIS file, and the incoming and outgoing pipes now need to be updated using the CSV data.

1. From the Network menu, select Import.
2. Select Open Data Import Centre to open the ODIC.
   
3. In the Open Data Import Center dialog, expand the Table to Import Data Into drop-down and select Manhole Survey.
4. In the Subtable drop-down, select Manhole survey : Incoming pipes.
   
5. Under Data Source, for Source Type, select CSV.
6. Next to File, click Browse (…).
   
7. In the Open dialog, locate and select the IncomingPipes.csv file.
8. Click Open.
   

For the Field Mapping Configuration, a previously saved configuration (CFG) file that contains details of the settings in the assignment grid can be loaded to save time.

9. Click Load Config.
   
10. In the Open dialog, locate and select the saved .cfg file.
11. Click Open.
    

The mapping table automatically updates with the saved information.

12. Click Import to import the incoming pipe data.
    

A summary popup shows no new objects imported and 52 existing objects updated.

13. Click OK.
14. Repeat the import process with the Manhole survey : Outgoing pipes subtable, making sure to select the OutgoingPipes.csv file and load the same saved config file.
    

Now, commit the changes.

15. From the File toolbar, select Commit changes to database.
    
16. Add a comment, such as “Imported Manhole Survey Incoming/Outgoing Pipe Data from CSV File”.
17. Click OK.