Using the open data import centre
Data can be imported into an existing network or to a new network using the open data import centre.
Note: When using the open data import centre to import customer points, use the Demand Allocation wizard to validate allocation of customer points to nodes.
- Right-click a model group.
- From the context menu, choose Import | Network using Open Data Import Centre.
- In the New Name - Network dialog, enter a name for the new network.
- Click OK.
- Complete the Open Data Import Center dialog. For help on completing the dialog, press F1.
- Click Import.
- Open the network.
- From the Network menu, choose Open Data Import Centre.
- Complete the Open Data Import Center dialog. For help on completing the dialog, press F1.
- Click Import.
You can import or update live data configuration and baseline objects from CSV files using the open data import centre. This applies to data in the Live Data Logon view, the Live Data Feed view and the Live Data Lookup view, and to data on the Fields page and the Verification page for the baseline.
- In the Model Group window, check out the live data configuration or the baseline of interest.
- Right-click the live data configuration or baseline.
- From the context menu, choose
Update | From Open Data Import Centre.
Note: If there are scenarios in the network, the Select Scenario dialog will appear. Select the scenario that you want to update from the drop-down menu and then click OK. - Complete the Open Data Import Center dialog. For help on completing the dialog, press F1.
- Click Import.
You may have a file containing point data that is represented as links in InfoWorks WS Pro. It is possible to import this point data as links via the open data import centre.
- From the Network menu, select Open Data Import Centre.
- 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 (press F1 for help), then click 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.
When importing a file containing link data via the open data import centre, the connecting nodes can also be generated on import.
- From the Network menu, select Open Data Import Centre .
- 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.
- To use automatic node name generation, check the Use auto-name option for generated nodes box.
Generated node names will be created using the option selected in the Node Name Generation page of the Network Options dialog.
- Select other options as required (press F1 for help), then click Import.
On import, InfoWorks WS Pro 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.