Is there a way to automate the extraction of time-series scenario results from InfoSWMM to external files (e.g., Excel, CVS, database)? We have a standard set of outputs (results) that we extract and analyze for each of the scenarios that we run. This is a tedious and repetitive task that takes quite a while. It would be great if I could programmatically extract these data (results) instead of using copy/paste from the Report Manager. Below is an outline of steps that we apply that I would like to automate. Is this possible? If so how?


  • Select Scenario
  • Select Domain (e.g., desired pumps, storage nodes, junctions, conduits)
  • Open Report Manager
  • Select New
  • Select Graph Report
    • Select Desired Output
      • Junction Group Graph (Head)
      • Outfall Group Graph (Depth, Total Inflow)
      • Conduit Group Graph (Velocity, Flow)
      • Pump Group Graph (Flow, Head Gain)

  • Select Settings
    • Domain
      • From = Start of simulation
      • To = End of simulation

  • Open
  • Select Report
  • Copy Report Table Data (rows=time-series; columns=individual component)
  • Paste to Excel or Database
  • Repeat for each desired output for each scenario


Thanks, Jason