What files are needed to open a model in an OpenFlows product?

Product(s): WaterGEMS, WaterCAD, Hammer, SewerCAD, SewerGEMS, StormCAD, CivilStorm, PondPack, Culvertmaster, Flowmaster
Version(s): CONNECT Edition, V8i
Area: General

Problem

There are a number of different files in the folder containing the model files. What are these files and which are required in order to open a model?

Solution

A number of different file types are created as the model is saved and computed. In order to open and compute a model in the standalone versions of the products, two files are needed. These are the starter file (see below for the file extension) and the database file, which is a SQLite file in later releases and .MDB files in older versions, as well as programs like PondPack, CulvertMaster, and FlowMaster. Backup files are created
as well. These will often have file extensions ending in the letter "k," such as .BAK. In addition, output files are created. Standard output files have a file extension of .OUT. Report files will be .RPC.

Other results files associated with a hydraulics and hydrology line of Bentley products are: .bin, .gut, .eqt, .hyg (hydrology output), .cul, .swm (SWMM data file). There is one set per scenario.

If you are running your program integrated with AutoCAD, ArcGIS, or MicroStation, other files types are necessary as well. For AutoCAD, you will have .DWG file with the same name as your model starter file. For
ArcGIS, you have a geodatabase (.MDB) and an .MDX file. For MicroStation, you will have a drawing file (.DGN).

For the standalone additions of the products, the following are the two files needed to run and compute a given model:

  • WaterCAD, WaterGEMS, HAMMER: .WTG and .WTG.SQLITE (.WTG and .WTG.MDB for older versions)
  • SewerGEMS, CivilStorm, SewerCAD, StormCAD: .STSW and .STSW.SQLITE (.STSW and .STSW.MDB for older versions)
  • Pondpack: .PPC and .PPC.MDB (.PPW for Pondpack V10 and earlier)
  • CulvertMaster: .CVM
  • FlowMaster: .FM8 and .FM8.MDB

Note: even older versions of the storm/sewer products prior to the V8i SELECTseries 3 release had different start files. SewerGEMS used .SWG files, CivilStorm used .CSD files, SewerCAD used .SWC files, and StormCAD used .STC files.)

The database files (.SQLITE or .MDB) are the most important file because it contains all modeling data, and includes everything needed to perform a calculation. This file is an open access database format file and can be viewed and
edited. The starter files contain data such as annotation and color-coding definitions.

The .DWH file is used by the Stand-Alone mode only, and contains information on the appearance of the drawing. This is a binary format file.

Save to Package

When you move a file, including sending it to Technical Support, you can compress all three of these files into a .ZIP file, which will greatly reduce file size. Starting with the CONNECT Edition Update 1 release of the water and storm/sewer products, a Save to Package feature was added, that allows you to quickly do this. The Save to Package feature enables you to bundle relevant files together and compress them into a zip file. This will make it simple for cases where you need to supply model files to a colleague, to a reviewer, or to technical support. By default, the models files (.wtg and .wtg.sqlite files), dwh, dwh.profiles are included in the package file, but you can also opt to include log, result, backup, background files as well. You can access this by going to File > Save as Package.


If your file becomes corrupted or you accidentally delete it, you can go back to the previous version by simply removing the .bak suffix from the file name and using that file (after deleting the corrupted file if necessary). You can usually delete the results files because they are regenerated by re-computing your model.

Recommended
Related