What is the expected text file format for IDF import?


Applies To 
Product(s):StormCAD, CivilStorm, SewerGEMS
Version(s):CONNECT Edition, V8i
Area: Layout and Data Input
Original Author:Jesse Dringoli, Bentley Technical Support Group

Problem

What is the format of text file import for storm data?

In the "storm data" window, what format does the .txt/.csv IDF data need to be in, when clicking the import button?



Problem Number 31419

Solution

When importing an ASCII text file, the following format is assumed: The very first line of the imported text file contains the return periods. The first entry in each succeeding line of the file contains the storm duration, assumed to be in the duration display units in the model. All other entries represent rainfall intensities, which are assumed to be in the current display unit.

 2,5,10  - Storm Frequency

                                                                      The values after the comma are the intensities for each frequency
Storm Duration is the first value in each column  -  0.083   ,               4.2,4.9,5.5 
                                                                                       0.250   ,               2 .7,3.2,3.5
                                                                                       0.500   ,               1.8,2.2,2.4
                                                                                       1.00     ,               1.1, 1.4, 1.6

It's important to make sure there are no spaces between your data values. For example:

2,5,10
0.083,4.2,4.9,5.5
0.250,2 .7,3.2,3.5
0.500,1.8,2.2,2.4
1.00,1.1, 1.4, 1.6

Here is the resulting IDF storm event group:

Step:

1) Setup your data in the format above.

2)  Create a new user defined IDF table

3)  Click the import button

4) Choose the file and click