Export time series data to Excel or CSV format

  Product(s): WaterGEMS, WaterCAD, HAMMER, SewerGEMS, SewerCAD, StormCAD, CivilStorm
  Version(s): Varies
  Environment: N\A
  Area: Output and Reporting



This article applies to:

WaterGEMS, WaterCAD, HAMMER versions or later.

SewerGEMS, SewerCAD, StormCAD, CivilStorm 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.

Steps to Accomplish

1. Prepare the model.

  • Set the active scenario you want to export data from.
  • Make sure calculation options include the time and time steps you want.
  • Compute the model.
  • To specify the properties that are exported, create a custom FlexTable that only includes the properties you want exported. This needs to be done for each element type being exported. (See: Customizing FlexTables - moving, adding, and removing columns)
  • To only export data for some elements, of an element type, use the following methods:
  • Select the elements.
  • Create a Selection Set.
  • Set the element type's FlexTable filter.

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 export
This 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.

Select 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 Path
It 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.

If 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.

The 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.

Advanced Export Automation

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

See Also

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?

  Original Author: Craig Calvin