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 is also used to import ESRI shapefiles. Note: This option requires a licensed 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. |
|
File GeoDatabase |
A format for storing GIS data developed by ESRI. Use this option to import data from File GeoDatabases. This option imports ESRI shapefile (SHP) folders. Note: This option is only available for 64 bit versions of
InfoWorks ICM.
|
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
- Open the network to be updated.
- Select Import
Open Data Import Centre from the Network menu. This displays the
Open Data Import Centre
dialog.
- Select the table to be imported into. Only data from one object type at a time can be imported.
- 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.
- Select the data source. The possible options are listed at the top of this topic.
- 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.
- 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.
- You may want to specify a script file. Scripts can be used to refine the import process. This is an advanced option. Contact us for further information.
- Specify the units used in the external data. They can be InfoWorks ICM Native units, User units, or a custom definition for this import.
- In the Assignment Grid, choose how external data fields map onto fields in the database and specify default values if required.
- 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.
- Link up fields manually using the dropdown lists.
- If you have chosen Custom units, set the units used for each field in the imported data.
- 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.
- Start the import by clicking Import.
- Repeat above steps for every object type you want to import.
- Click Exit when you have finished.
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.
- Click Save Config to save the grid settings to a configuration (CFG) file.
- Click Load Config to reload the grid settings.
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.