Open Data Import Centre

The Open Data Import Centre (ODIC) can be used to import network data from several different data sources:

Data Source

Description

MapInfo Tab File (.tab)

MapInfo Tab File format.

This option is only available if using MapXtreme as the current map control in the GeoPlan Window.

GeoPlan Layer

GIS data currently loaded as an additional layer on the GeoPlan.

CSV

A text file with the fields separated by commas.

Tab Separated Data

A text file with the fields separated by TAB characters.

Access Database

An Access (.mdb) database.

Note

Access tables and Access queries can be imported into InfoWorks ICM.

Oracle

Use this option to import from Oracle databases.

Note

The minimum version of Oracle supported for import without spatial data is Oracle 8i. To import spatial data a minimum version of Oracle 9.2 is required.

SQL server

Use this option to import from SQL server databases.

Note

The Microsoft OLE DB Provider for SQL Server must be installed in order to import from SQL Server databases.

GeoDatabase

A format for storing GIS data developed by ESRI.

Use this option to import data from GeoDatabases. This option can also be used to import ESRI shapefiles.

Note

This option requires a licenced copy of ArcGIS™ installed on the computer on which the import is being performed.

Raw Shape File

Data in the ESRI shapefile format.

Imports shape files directly instead of using any map control.

XML

A text file formatted in the eXtensible Markup Language.

Data can be imported into an existing network. Data is imported for one network object type at a time.

To import network data using the Open Data Import Centre:

  1. Open the network to be updated
  2. Select Import | Open Data Import Centre from the Network menu. This displays the Open Data Import Centre dialog.
  3. Select the table to be imported into. Only data from one object type at a time can be imported
  4. If the selected object has got related subtable/ array data (e.g. hyperlinks) that are to be imported, select the desired subtable/ array data in the Subtable combo box, otherwise leave it blank
  5. Select the data source. The possible options are listed at the top of this topic.
  6. If you selected a file based data source, choose the file using the Browse button, or simply enter the filename and path in the File box. For some data types, you need to select the feature type to import from the dropdown list in the Feature box
  7. Decide whether to import flags from the external data source. You can also select flags to be used to mark imported data without flags, and fields set to default values specified in the Assignment Grid.
  8. You may want to specify a script file. Scripts can be used to refine the import process. This is an advanced option. Contact Innovyze Support for further information.
  9. Specify the units used in the external data. They can be InfoWorks ICM Native units, User units, or a custom definition for this import.
  10. In the Assignment Grid, choose how external data fields map onto fields in the master database and specify default values if required.
  11. If the names of external fields match those used when exporting from InfoWorks ICM, you can use the Auto-Map Fields button to link up as many fields as possible. The Clear Assignments button clears current field mappings.
  12. Link up fields manually using the dropdown lists.
  13. If you have chosen Custom units, set the units used for each field in the imported data.
  14. Choose updating options. The option chosen is irrelevant when importing into a blank network. Be careful using the Overwrite option when importing into a network that already contains objects of this type.
  15. Start the import by clicking the Import button.
  16. Repeat above steps for every object type you want to import.
  17. Click Exit when you have finished.
Warning

When updating link objects using Object ID, the Link Suffix field of the object is used (in addition to the connected node IDs), to check for duplicate links. If connected node IDs match those of an existing link, but a link suffix is not provided, the Open Data Import Centre will create a new link object by incrementing the link suffix.

Full details of all the available options can be found in the Open Data Import Centre Dialog topic.

See Open Data Import Centre - Advanced Features topic for further information on import of objects via the Open Data Import Centre.

Saving and Reloading Configurations

You can save and reload the settings in the Assignment Grid.

Only the settings for the grid are saved. You will need to set the other dialog options to appropriate values (such as the Select Table to Import into field) before the saved configuration can be sensibly used.

Open Data Import Centre - Advanced Features

Importing Oracle Spatial Data

Open Data Import Centre Dialog