Product(s):	SewerGEMS, StormCAD, CivilStorm, PondPack
Version(s):	08.11.XX.XX 10.00.XX.XX
Area:	Layout and Data Input

Problem

This article discusses how to import IDF curve equation storm data using ModelBuilder.

Solution

1. Create a spreadsheet containing information for importing the storm data labels.
The following formatting and fields should be used.

The units for Equation Duration and Equation Intensity should be entered using the corresponding values below.

Equation Duration Unit			Equation Intensity Unit
ms	328		cm/day	21
sec	234		cm/h	22
min	195		cm/min	23
hours	99		in/day	109
days	55		in/h	110
years	274		in/min	111
			mm/day	189
			mm/h	190
			mm/min	191

2. Create a spreadsheet (or worksheet in the same spreadsheet) containing information for importing the storm data details.
The following formatting and fields should be used.

Note: the "Storm Identifier" field must contain a unique GUID (Globally Unique Identifier) for each row. They are only important internally on the OpenFlows product side, so when preparing the spreadsheet, the exact GUIDs you enter do not matter. If your data does not have GUIDs, seek a generator tool to generate a list of GUIDs to populate the "Identifier" column. If you cannot local a suitable GUID generator from an internet search, contact technical support.

3. Use ModelBuilder to import the Storm Data labels.

a. Open ModelBuilder from the Tools menu.
b. Set the data source type to Excel 2013/2010/2007 (12.0)
c. Browse to and select the Excel file created in step 1.
d. Select the sheet created in step 1
e. Click Next four times until you reach the page to specify field mappings for each table.
f. Set the Table type to "Storm Data"
g. Enter the Key Fields (Label) and map the spreadsheet fields to the corresponding property. The names of the columns seen above are the names of the fields to map to. Click next.
h. Select Yes to build the model now and click Finish.

4. Use ModelBuilder to import the Storm Data details.

a. Open ModelBuilder from the Tools menu.
b. Set the data source type to Excel 2013/2010/2007 (12.0)
c. Browse to and select the Excel file created in step 2.
d. Select the sheet created in step 2.
e. Click Next four times until you reach the page to specify field mappings for each table.
f. Set the Table type to "Storm Data, Storm Event"
g. Map the spreadsheet fields to the corresponding property. The names of the columns seen above are the names of the fields to map to. Click next.
h. Select Yes to build the model now and click Finish.

See Also

What is the expected text file format for IDF import?

How do I import a return event for a dimensionless curve from the engineering libraries?