Open Data Import Centre - Advanced Features
This topic contains information on some advanced uses of the Open Data Import Centre. The sections in this topic are:
- Importing Links from Point Data: importing point data as links with connecting nodes.
- Importing Disconnected Links: importing disconnected links as links with connecting nodes
Importing Links from Point Data
You may have a file containing point data that is represented as links in InfoWorks ICM. It is possible to import this point data as links via the Open Data Import Centre.
To import point data as links:
- Open the network to be updated
- Select Import | Open Data Import Centre from the Network menu. This displays the Open Data Import Centre dialog.
- On the Open Data Import Centre dialog:
- select the links table into which the data is to be imported
- select the data source containing point data to be imported
- Map the Import Fields to the Object Fields as required:
- map the us_node_id field of the links table to a suitable key field in the import file
- leave the ds_node_id field blank
- map the Geometry Object field (when importing from Oracle spatial data)
- Select other options as required and Import.
Links of zero length connected to two nodes will be created from the imported point data. The link will be named from the value in the field of the imported file that was mapped to the us_node_id.
The connecting nodes will be named as the link, but with an X and a Y appended to the name.
Node Generation when Importing Disconnected
Links
When importing a file containing link data via the Open Data Import Centre, the connecting nodes can also be generated on import.
To generate connecting nodes when importing links:
- Open the network to be updated
- Select Import | Open Data Import Centre from the Network menu. This displays the Open Data Import Centre dialog.
- On the Open Data Import Centre dialog:
- select the links table into which the data is to be imported
- select the data source containing the link data to be imported
- When mapping Import Fields to Object Fields, do NOT map the us_node_id or ds_node_id fields.
- Select other options as required and Import.
On import, InfoWorks ICM will generate nodes at the ends of the imported links, or if there are existing nodes, connect the links to the existing nodes. If a link already exists between connecting nodes, the link suffix of the imported object is incremented to create a unique link ID. A warning message will be displayed in the log that multiple link objects have been imported.
By default, generated nodes will be named XXXX0001, XXXX002, etc.
Check the Use auto-name option for generated nodes box to use the Automatic Node Name Generation functionality for naming nodes that are generated when importing disconnected links. Generated node names will be created using the option selected in the Name Generation Dialog.
