This article applies to:
WaterGEMS, WaterCAD, HAMMER versions 08.11.06.113 or later.
SewerGEMS, SewerCAD, StormCAD, CivilStorm 08.11.05.113 or later.
These releases are the first to include the ability to export time series data for multiple elements and element types to Excel or CSV format.
1. Prepare the model.
2. Go to File > Export > Export to Excel
3. Set the export options.
Select the element types to export. This is done in the "Specify Properties to Export" section. The element types that are checked will be exported.
Specify hydraulic model elements to exportThis can be se to export All Elements, a Selection, or a Selection Set.If the "Publish a subset of elements based on the Flex Table filters" box is checked, only those elements that are in the filtered flex table will be included in the spreadsheet. If the "Exclude topologically inactive elements" box is checked, only active elements (Is active? = True) are included in the spreadsheet.
Table/PropertiesSelect an element type and choose to export all properties or just the properties included in an existing FlexTable. This can be selected from the dropdown list or by clicking the ellipses "…" button. This needs to be done for each element.
Table PathIt is possible to have multiple FlexTables with the same name. This field shows if the FlexTable selected is Shared, Predefined, or if it is only contained in the Hydraulic Model.
FilterIf the selected FlexTable is filtered, the filter is displayed in the Filter field and in the left pane, the Is Filtered column is set to True for that element type.
PropertiesThe properties that are to be exported for that element type.
4. After all settings are established for all element types, click OK.
5. Specify the format (Excel or CSV) and the location to save to, then click OK.
For information on a more advanced, automated approach to data export, see: Automatic processing of results (or other) data using an extensible data exchange framework
Customizing FlexTables - moving, adding, and removing columns
Can I easily export my results to an Excel spreadsheet?
What’s new in StormCAD, SewerCAD, SewerGEMS and CivilStorm V8i SELECTseries 5 with CONNECT Integration?
What's new in WaterCAD, WaterGEMS and HAMMER V8i SELECTseries 6 with CONNECT Integration?