Model Builder wizard

The Model Builder wizard is used to update the network and control using data in a pre-defined schema in the SQL Server. This wizard also allows you to allocate customer points to locations in the network. Also, this process makes it easier for you to import multiple tables at once, instead of importing them one at a time when using the Open Data Import Center.

This dialog is displayed when you select Update Using Model Builder from the context menu of a network.

Item	Description
Connect to SQL Server	Opens the Select SQL Server Data dialog, which allows you to connect to a Microsoft SQL Server database, via the OLE DB Driver for SQL Server.
Control	A control dropped into this box will be updated using data in the pre-defined schema in the SQL Server.
Demand Diagram	Optional field When a demand diagram is dropped into this box, it will be updated from the SQL Server.
Updating and Delete Options	The updating options allow you to decide how to handle duplicate objects in the external data. Prompt These options set the action to be followed when an object is encountered in the external data with the same name as an object already in the model. Note: When importing arrays (for example, Reservoir: Depth Volume data), existing array data will be overwritten unless the Merge option is selected, in which case data will be appended to the existing array. You will be asked whether or not you want to overwrite the current object every time a duplicate object is found in the external data. Merge Fills in any blank fields in the existing object with data from the imported object. Does not change any existing data. Overwrite Replaces 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 Ignores the imported object if it is a duplicate. Replace Replaces the object. Update based on asset ID If this option is checked, InfoWorks WS Pro 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. Update multiple objects This option is enabled when Update based on asset ID is selected. If this option is checked, multiple matching objects will be updated based on the asset ID. If this option is not selected and you have multiple matching objects, InfoWorks WS Pro will display an error. Note: Matching objects must have the same Asset ID value. Only update existing objects If this option is checked, InfoWorks WS Pro will only update existing objects. No new objects will be created on import. Delete missing objects If this option is checked, InfoWorks WS Pro 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 WS Pro Table to Import Data Into but is NOT in the external Data Source table.) If the Update Based on Asset ID option 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.
Units Behaviour	You can use the options in this drop-down list to specify how units are handled during the import process. The options are: InfoWorks The external data uses InfoWorks WS Pro 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. An extra Units column is added to the Assignment Grid. You can then select the correct units from the options available in the drop-down list for each field.
Set Flags	Any field set by the model builder will have this flag. The flag will be applied to all fields that can be flagged.
Connect float valves to reservoirs	You will get a validation error if float valves are not connected to reservoir.
Next	This button becomes available when you are connected to the SQL server by clicking the Connect to SQL Server button. Opens the Expand Short Links dialog.
Cancel	Cancels the operation and closes the window.
Help	Opens the help page.