You are currently reviewing an older revision of this page.
I've conducted a Flushing study and would like to export various results like pipe runs, closed valves, hydrants flowed, min pressure, travel time, volume, across all flushing studies, areas and events. The data needs to be in a standard format like Excel that can be used to create reports for an online form used by the field operations crew.
Enhancement # 364867 has been filed, for the ability to directly export flushing results to a standard file format.
In the meantime, there are a few possible workarounds. First, if you are not already aware of it, there is a button at the top of the Flushing manager to generate a Flushing Report. These reports have been designed so that they can be printed out and provided to the field operations crew.
1) The aforementioned reports can be exported to Excel. With the report open, click the Save button in the top right corner > Excel File.
2) The Flushing Results Browser (Analysis > Flushing Results Browser) lists each event and some details like the length of pipe that met target, min pressure, travel time, volume, etc. You can also export this to Excel.
3) This one is advanced, but you could also export the components of the Flushing studies to spreadsheet by setting up a Modelbuilder connection (Tools > ModelBuilder. You would set up the spreadsheet ahead of time with tables that have column headers but no rows, then configure the table types and field mappings in Modelbuilder, then "sync out" to the spreadsheet. Here's a rundown of the various Table Types related to flushing, and some notable fields that can be mapped:
Area - label, notes, flushing study, representative scenario, output scenarioFlushing Event - label, flushing type, notes, report viewsFlushing Study - label, notesFlushing Report View - label, flushing area, flushing event, notes, Is Primary View?Flushing Event, Flushing Events Collection - Element label, element type, flow, status, notes
You can find more information on Modelbuilder in the Help and in this article:
Building A Model Using ModelBuilder
Is there a way to export all the Unidirectional Flushing results and event elements?