Skip to Main Content
Autodesk

Allow InfoWater to export simulation results in CSV format instead of DBF

The option to "Export simulation results for external application" in InfoWater would be more useful if the results were exported as CSV files instead of DBF files. We regularly need to compare the results from multiple model scenarios. Microsoft PowerBI or Excel PowerQuery are great tools for importing and comparing large amounts of data and could streamline this process significantly. However, neither support importing directly from DBF files.
  • Attach files
      Drop here to upload
    • Robert Dickinson
      Oct 26, 2023

      There are multiple Excel macros on the internet for converting DBF to CSV - they work well and can convert entire directories.

    • Admin
      Nathan Gerdts
      Jun 22, 2023

      We have been discussing a number of ways to make results openly accessible for reporting after simulations and this is a good simple option. Thanks for the suggestion and votes. We'll update once work is underway.

    3 MERGED

    InfoWater results export improvements

    The EXT_APP_FILTER option is useful for automatically exporting results for use in other programs. However, the results are exported as DBF files with an identically named MDX file (for example, JUNCTOUT.DBF and JUNCTOUT.MDX). The presence of the ...
    Colin Ricks over 3 years ago in InfoWater Pro 0 Launched