Hammer Download/Save Results of Multiple/All Nodes

Shiqing, can you clarify what you mean by "save"? Are you saying that you want to export the time-series transient results to an external format like Excel? The following article explains some limited options: Exporting Transient Results for Multiple Elements

In general, the time history data in the Transient Results Viewer is extracted from the text Output Files which you can find in the folder where the model is saved. You can also access the Transient Analysis Detailed Report from the Report menu. Scrolling through the file, you can see the results in text format. There may be a way to extract this information in an external application depending on what you need to do with it.

If you have advanced programming experience and your organization is a Bentley Developer Network member, you could potentially use the Waterobjects.NET API to extract the data. See more here: Waterobjects.NET - Extending the capabilities of your OpenFlows product

Please let us know why you want to export all time series data for all elements - if you provide more details on what you ultimately need to accomplish, we may be able to offer an alternative solution to help you achieve what you need.

Hi Jesse,

Yes I mean export the time-series transient simulation results(mostly pressure) of multiple nodes (maybe all the nodes, 1000+ in my network) to an easy-to-read/edit format like excel or csv, and the data would be used for further analysis in Matlab.

The first option you suggested (the "exporting transient results for multiple elements" link) is not suitable for export data for thousands of nodes. For the second option, I looked for the folder and there are many unfamiliar file type (HMR, HOF, HUT, OUT, etc.), which is not readable by common software like Excel Notepad or Word. I don't know which file have the time history simulation data.

I can find the time-series data in Detailed Report, but it shows flow, head & volume data. Is there any way to customize what to display in the detailed report? I would need pressure data only at this time. 

Thank you very much.

Shiqing

Shiqing Liu said:

the data would be used for further analysis in Matlab.

Why do you need to analyze the data in Matlab? What specifically do you need to accomplish? Maybe there is a workflow we can suggest without the need to export and process the data in an external application.

Shiqing Liu said:

I can find the time-series data in Detailed Report, but it shows flow, head & volume data. Is there any way to customize what to display in the detailed report? I would need pressure data only at this time. 

I believe only the Head is stored in the output file and the pressure is derived from the Head result in conjunction with the elevation of the end node. Perhaps you can extract the node elevations and derive the pressure by subtracting the elevation from the head (and then convert to a pressure unit like Kpa as needed)

Beyond this, you would need to use WaterObjects.NET.

Hi Jesse,

Basically I run the simulation with a sharp pressure change at one point in the network and I want to know the how the transient propagate in the network. The time-series pressure data in each node at the first few seconds after the transient arrival is needed, especially the gradient and magnitude of the wave front. That's the reason I need external application like Matlab. 

I run the simulation in a network with 4000+ nodes for 6000 timesteps (record data every 4 time steps), and the detailed report is very slow even just scrolling up and down. The .rpt file I found in the folder (I believe this is the detailed report file) is 1.8 GB, and it doesn't allow me to save it, probably due to size. So the whole detailed report doesn't work for me. 

However I found that in Custom Report I can import a simple .rptx file with multiple node&pipe's numbers, and generate the report with selected node, and then save it as .csv file. Considering the simulation's size, I think that is my best solution for now.

Thank you very much for your help.

Shiqing

Shiqing Liu said:

Basically I run the simulation with a sharp pressure change at one point in the network and I want to know the how the transient propagate in the network. The time-series pressure data in each node at the first few seconds after the transient arrival is needed, especially the gradient and magnitude of the wave front. That's the reason I need external application like Matlab. 

You could animate the transient profiles in the Transient Results Viewer to see how the transient propagates through the network. See: Using Transient Results Viewer animations for visualizing a transient simulation