How to import multi-link from a table into XPSWMM
source: Innovyze Support Portal
XPSWMM has many ways to bring external data into the model. Most of them can be accessed through the Import/Export Data
For GIS files, most of the import/export tools can be accessed by right click the item in the layer tree panel.
What is Multi-link
Multi-link is XPSWMM specific feature no other software offers. Multi-link is used for two situations,
- parallel pipes between two nodes, a common one is dual drainage, a pipe and the street section that both convey storm water
- pumps, weir, orifice and other diversion structures
Multi-link presents a challenge when importing data from external sources, because in XPSWMM muli-link is treated as a group entity with multiple children, however, usually the data in the external source are not grouped. Therefore, importing multi-link from external sources will require a slightly different process.
Before getting into the steps of importing multi-link, modelers who are building dual drainage system might also want to check the dual drainage automation tool, which might be a more intuitive way of building drainage system.
Import/Export External Databases
To import/export multi-link data with external data, use the tool below.
Create a new connection to an excel table.
For a two way import/export, you can set it up like this,
The last step is to map the key columns in the table so that XPSWMM knows how to import each row. Make sure,
- Link Name is the multi-link name
- Channel/Conduit is the name of the individual pipe/channel
Next, set up the mapping for the values to be imported.
When the mapping is done, use the Import/Export button to get the data into or out of XPSWMM.
You can find the sample model on GitHub.
Figuring out the field mapping can be tricky, it will take some trial and error. Therefore, it is highly recommended started with a very simple model and a sample table with just a handful rows to test the mapping before working with the full dataset.