This article applies to
WaterGEMS, WaterCAD, HAMMER versions 08.11.06.113 or later (including CONNECT Edition).
SewerGEMS, SewerCAD, StormCAD, CivilStorm 08.11.05.113 or later (including CONNECT Edition.
These versions 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. Note that these setting will persist for future exports.
Select the element types to export. This is done in the "Specify Properties to Export" section on the left side. The element types that are checked will be exported as separate tabs in the spreadsheet.
Specify hydraulic model elements to export
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 separately for each element type. You can create a new custom flextable (under "Hydraulic Model" to save it just in the current model, or "Shared" for it to be available in all models - see more here) to help reduce the amount of data exported.
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.
PropertiesThis shows the properties that are to be exported for that element type. As mentioned above, you can create and select a custom flextable with only the fields you need, to help reduce the exported data.
Specify result time steps to exportThis is a new feature available starting with CONNECT Edition Update 4 (10.04.00.XXX and greater). This enables you to filter calculated results for an EPS using a Constant output step, or a Variable output step. With the "variable" option, you can choose between No results, All results or a Constant output step, for multiple time ranges, just like the calculation option described here. Note that this feature applies a filter on top of the existing computed results, and the setting you choose is persisted across all models (be sure to adjust it for other models as needed). For example if you wish to only export hydraulic results for the last 24 hours of a one week simulation, you can use the "Variable" option and set the first 6 days to "None" and then use the "All" or "Constant" for the last 24 hours.
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. Note that the Excel (XLSX) format has a limit of 1,048,576 rows.
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
Problem: The following error occurs when attempting to export
Export to Excel failed.Exception from HRESULT: 0x800A03ECError code -2146827284
Solution: You may have exceeded the limit on the number of rows supported by the Excel format. Use the available filtering options (consider the time step filtering mentioned above) or consider choosing the CSV format using the dropdown in the bottom-left corner of the Excel Export dialog.
Problem: Another error that has been reported when attempting to export to Excel
This is a System message indicating that you should run a Repair on your "Microsoft 365 Apps" product.
Make sure you look for "Microsoft 365 Apps" in "Add or remove programs" and not for "Office", else you might repair the wrong office which will not resolve the problem.
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?