|
Table to Import Data Into
|
Choose the database table into which you want to import data. You can only import data one table at a time.
|
| Subtable
|
Used to import subtable / array data (e.g. hyperlinks) for the database table selected in the Table to Import Data Into field above. Select the desired subtable / array in the Subtable combo box. Leave this field blank to import data into the main table.
|
|
Flag Behaviour
|
Select the flags to be set on imported data:
|
Option
|
Description
|
|---|
|
Import flags from data source
|
If checked, an additional Flag Fields column is displayed in the Assignment Grid. This allows flag fields in the external data to be mapped onto flag fields in the selected table.
|
|
Otherwise, set flag on imported fields to:
|
Select a flag from the list. The flag will be applied to all fields imported from the selected Data Source, that can be flagged. If Import flags from data source is checked, the flag will only be applied to imported fields that do not have an imported flag.
|
|
Flag when Default Value is used:
|
Select a flag from the list to apply that flag to all fields in which the value has been set from the Default Values column of the Assignment Grid.
|
|
|
Data Source
|
Select the type of data you want to import here. Once you have done so, you will need to enter other information, such as a filename, or GeoPlan layer name. You may also need to choose a data type or database table containing the data you want to import.
|
Field
|
Description
|
|---|
|
Source Type
|
Choose the type of data to import from the list. Only valid data types are listed.
(See the
Open Data Import Centre topic for data type details.)
|
|
File
|
For certain types of data you will need to specify a filename. Click Browse to find the file.
When importing from an Oracle database, this displays the
Select Oracle Data
dialog.
When importing from an SQL Server database, this displays the
Select SQL Server Data
dialog.
|
|
Feature
|
For certain types of data you will need to specify the feature. Select the feature from the list:
- When importing from an Oracle database, only tables for which the user has been granted the appropriate read permissions in Oracle will be available for selection.
- When importing from an Access database, queries as well as tables will be available for selection.
|
|
|
Script File (optional)
|
You can use a script to control the import process more precisely. Use this box to browse for the script file.
Note: Scripts are an advanced feature and not recommended for anyone without experience of programming in a scripting language.
To help you with writing your own scripts, you can use Reload to load the latest version of your selected script after making changes in an external editor such as Notepad. This allows you to adjust the script and test the changes without closing and re-opening the dialog.
Contact
Innovyze for further information on using a script to control import.
|
|
Units Behaviour
|
Use the options in this dropdown list to specify how units are handled during the import process. The options are:
- InfoWorks ICM - the external data uses
InfoWorks ICM Native units.
- User - the external data uses the currently defined User Units for the network.
- Custom - you can set the units used for each field in the imported data yourself. When you select Custom, an extra Units column is added to the Assignment Grid. Select the correct units from the options in the list for each field.
|
|
Assignment Grid
|
Use this grid to define exactly how the external data should be imported into fields in the database.
|
Column
|
Description
|
|---|
|
Object Fields
|
This column lists all the fields for the current
InfoWorks ICM object type, as selected in the Select Table to Import into box.
Any field shown in red type is required for import. You must map at least these required fields.
You cannot change any of the fields in this column.
|
|
Import Fields
|
This column allows you to map fields in the external data to the
InfoWorks ICMfields listed in the Object Fields column.
- You can map the fields manually by choosing an external field in the dropdown list for each
InfoWorks ICM field in the Object Fields column. You must map the required fields before you can import data
- You can try to map fields automatically. Click the Auto-Map Fields button.
InfoWorks ICM will attempt to map the fields. The mapping is based on the names used for fields when data is exported to GIS from
InfoWorks ICM.
- When importing data from an Oracle database, to import spatial data, map the Oracle spatial data field to the Geometry Object field (highlighted in blue) in the Object Fields column.
|
|
Default Values
|
This column allows you to set values of fields directly as well as from external data.
On import:
- If an external data fields has not been mapped, the field for which the default value has been set will be assigned the value entered in the Default Values column.
- If both an external data field has been mapped and a default value has been entered, the external data will be used where available. Where the external data contains a Null value or a blank, the default value will be used instead.
|
|
Flag Fields
|
This column is only displayed if Import Flags from GIS is checked.
Cells in this column are greyed out for data that cannot have a flag.
|
|
Units
|
This column is only displayed if you have chosen the Custom option for units behaviour.
Choose the units for each field in the dropdown lists. Fields which do not require units information are greyed out.
|
|
|
Updating and Delete Options
|
The updating options allow you to decide how to handle duplicate objects in the external data.
The action to be followed by
InfoWorks ICM when it encounters an object in the external data with the same name as an object already in the model is set by the following options:
|
Option
|
Description
|
|---|
|
Prompt
|
You will be asked if you want to overwrite the current object or not every time a duplicate object is found in the external data
|
|
Merge
|
Fill in any blank fields in the existing object with data from the imported object. Do not change any existing data
|
|
Overwrite
|
Replace data in the existing object with data from the imported object. (If the imported object does not contain data for a field, the existing data in that field will not be changed.)
|
|
Ignore
|
Ignore the imported object if it is a duplicate
|
Note:
When importing arrays e.g.
Channel Shape: Channel Profile
data, existing array data will be overwritten unless the Merge option is selected, in which case data will be appended to the existing array.
Further update and delete options can be selected from the following:
|
Option
|
Description
|
|---|
|
Update Based on Asset ID
|
If checked,
InfoWorks ICM will look for duplicate objects using the Asset ID field and not the usual object identifier.
Note: 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.
|
|
Only update existing objects
|
If checked,
InfoWorks ICM will only update existing objects. No new objects will be created on import.
|
|
Delete missing objects
|
If checked,
InfoWorks ICM will search for missing objects of the relevant type and delete them at the end of the import process. (A missing object is an object that is in the
InfoWorks ICM Table to Import Data Into but is NOT in the external Data source table.)
If Update Based on Asset ID is checked, the Asset ID field will be used to search for missing objects and not the usual object identifier.
All missing objects found will be listed and a prompt for confirmation of deletion will be displayed before any objects are deleted.
|
| Don't update geometry
|
Check this box when you are updating ArcGIS, Oracle, or SQL Server.
If checked, existing objects will not have their geometry changed, even if the geometry has changed in the imported GIS data.
|
|
|
Use auto-name option for generated nodes
|
If checked, the
Automatic Node Name Generation functionality will be used for naming nodes that are generated when importing disconnected links. (See
Open Data Import Centre - Advanced Features for more information.)
This option will only be enabled when automatic naming is switched on and an object for which nodes may be generated has been selected from the Table to Import Data Into section.
|
| Import multi-parts
|
The Open Data Import Centre provides limited support for the import of polygons with multi-parts and complex shapes.
The Import multi-parts polygon option is only enabled when a polygon type table is selected and the data source selected is a GIS layer (from a file or from the GeoPlan).
Polygons will be imported in the following way:
|
GIS multi-part polygon
|
|
Do not import multi-parts: Imported as one polygon
|
|
Import multi-parts: Imported as three separate polygons
|
|
GIS polygon with hole
|
|
Do not import multi-parts: Imported as one polygon
|
|
Import multi-parts: Imported as polygon with umbilical cord between two shapes
|
When importing multi-part polygons, the ID and Area of the polygons will be generated automatically, regardless of the mappings entered in the Assignment Grid.
A maximum of 10 fields may be mapped in the Assignment grid when using the Import multi-parts option.
|
|
Buttons
|
|
Button
|
Description
|
|---|
|
Load Config
|
Load in a previously saved configuration (CFG) file. The file only contains details of the settings in the Assignment Grid. You need to set the other options on the dialog, such as the Select Table to Import into field, to match those used when the configuration file was saved.
|
|
Save Config
|
You can save all the settings in the Assignment Grid to a file (suffix CFG). These settings can then be reused for future imports.
|
|
Clear Config
|
Clears all previous field mappings.
|
|
Auto-Map
|
Automatically attempt to map fields in the external data to fields in the database. Make sure you have chosen the appropriate table in the Select Table to Import into box before using this button.
InfoWorks ICM uses the standard field names used when exporting from
InfoWorks ICM to try to link the fields up.
|
|
Import
|
Import data based on the current settings.
|
|
Close
|
Quit the importer.
|
|
Open Data Import Centre is selected from the Network menu.
