This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Is there a way to export all the Unidirectional Flushing results and event elements?

I have created a UDF program with multiple studies, areas, and events and I am looking for a convenient  way to export all the event elements (pipe runs, closed valves, hydrants flowed) as well as the results (min pressure, travel time, volume). Currently I can only export the results by area and the event elements by individual event. I have large number of events and am looking for a quicker method.

The end goal is a spread sheet that has each event in a row and with closed valves, hydrant, flow, pipe runs, flushing time etc. in the columns.

Any thoughts or Ideas to save some time would be great.

Thanks,

Ryan Stackpole

Parents
  • Hello Ryan,

    Most likely you are aware of it, but 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. We'd be interested in any feedback you have on that report - was it missing something you needed? Or, are you wanting to export to Excel for other reason?

    Some other thoughts:

    1) The aforementioned reports can be exported to Excel. With the report open, click the Save button in the top right corner > Excel File. Of course, this might not be formatted exactly the way you need. 

    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 quite advanced, but you could in theory 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 scenario
    Flushing Event - label, flushing type, notes, report views
    Flushing study - label, notes
    Flushing 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

    Let us know if these suggestions help and we'll document it as a Support Solution. I can also pass your feedback along for consideration in a future release.


    Regards,

    Jesse Dringoli
    Technical Support Manager, OpenFlows
    Bentley Communities Site Administrator
    Bentley Systems, Inc.

    Answer Verified By: Sushma Choure 

  • Thanks for the response Jesse,

    The excel file will eventually be used with a clients GIS provider to create steps and reports in their online viewer similar to the ones in WaterGems. By giving each pipe segment, hydrant, and valve a unique identifier we can set the spreadsheet up so that it will include ordered steps for opening/closing valves as well as the flow hydrant, required flow and flow duration. The online form will also require the operator to check that each step has been followed and fill out the report after the flush is completed.

    I should be able to use these steps you went over and modify the spreadsheet to get what i need. Thanks for the help!

    Ryan
Reply
  • Thanks for the response Jesse,

    The excel file will eventually be used with a clients GIS provider to create steps and reports in their online viewer similar to the ones in WaterGems. By giving each pipe segment, hydrant, and valve a unique identifier we can set the spreadsheet up so that it will include ordered steps for opening/closing valves as well as the flow hydrant, required flow and flow duration. The online form will also require the operator to check that each step has been followed and fill out the report after the flush is completed.

    I should be able to use these steps you went over and modify the spreadsheet to get what i need. Thanks for the help!

    Ryan
Children